Jump to content


Inventory software


  • You cannot reply to this topic
32 replies to this topic

#21 Rob McKee

Rob McKee

    MCM Ohana

  • Members
  • PipPipPipPipPipPip
  • 846 posts
  • Location:Coquitlam BC
  • Full Name:Rob McKee

Posted 14 September 2012 - 06:13 AM

Thanks everyone for all of the tips.

It sounds like Excel would be the best solution.

#22 mopar68

mopar68

    MCM Avid Poster

  • Members
  • PipPipPipPipPip
  • 321 posts
  • Location:Tas, the state down under Downunder
  • Full Name:Zac Millington

Posted 14 September 2012 - 06:31 AM

You might already be aware, but if you do use Excel, a template might make it easier :)
http://www.gcflearnf.../excel2007/14.2

#23 my66s55

my66s55

    MCM Ohana

  • Members
  • PipPipPipPipPipPip
  • 507 posts
  • Location:DeBary, Florida

Posted 14 September 2012 - 09:59 AM

That's an interesting program Clay. Now if only someone would do one in OpenSource or OfficeLibre.

You want to use LibreOffice? It's simple. Just make your own. If you want to add pictures, just drag and drop. Here's mine:

Attached Files



#24 moparmagiclives

moparmagiclives

    MCM Ohana

  • Members
  • PipPipPipPipPipPip
  • 1,410 posts
  • Location:Moses Lake Wa.
  • Full Name:Shane Moore

Posted 15 September 2012 - 06:41 AM

I guess I never though about having enough to need to Inventory, you guys are pretty intense !! Cool info !

#25 kataranga

kataranga

    MCM Ohana

  • Members
  • PipPipPipPipPipPip
  • 1,295 posts
  • Location:Saint John, NB
  • Full Name:Chris Martin

Posted 15 September 2012 - 05:00 PM

I keep an inventory of my kits in Excel. So far I only have for columns manufacturer, kit number (easier to track reissues), series (ex. Streetburner), title (## stock car), make, model, and year. I do like your system, my66s55, of keeping track of what condition its in, missing parts, etc. I think an overhaul of my inventory may be in order... :)

#26 darquewanderer

darquewanderer

    MCM Friend

  • Members
  • PipPipPipPip
  • 228 posts
  • Location:RoastingMyButtIn, Florida
  • Full Name:James

Posted 15 September 2012 - 11:04 PM

Right now I've got my inventories in M$ Works 2003 .wdb. Been trying to convert to OpenSource .odb for a while, but so far no luck.

#27 Gregg

Gregg

    da Big Kahuna

  • Root Admin
  • PipPipPipPipPipPip
  • 12,427 posts
  • Location:Honolulu, Hawaii
  • Full Name:Gregg Hutchings

Posted 16 September 2012 - 09:03 PM

I was trying to work with a couple of companies to develop this for us modelers.
So far, it's a no go
But, I did find Delicious Library for the Mac, which will let me scan in the bar codes, and it does find most of the kits, through a Google/Amazon search.
it's not perfect, but it is the only one so far that does what I want it to, somewhat.
For those unfortunate few who still use a PC, can't help you there.

I have worked on the MySQL behind IntelliScanner's software, but that's a story for another day.

#28 martinfan5

martinfan5

    MCM Ohana

  • Members
  • PipPipPipPipPipPip
  • 9,208 posts
  • Location:Los Santos, San Andreas
  • Full Name:Jonathan Stephens

Posted 16 September 2012 - 09:27 PM

Doing a quick check on download.cnet , here are some free ones that are showing up.

http://download.cnet...4-10772674.html
http://download.cnet...4-75176782.html
http://download.cnet...4-75567337.html

#29 Aaronw

Aaronw

    MCM Ohana

  • Members
  • PipPipPipPipPipPip
  • 2,477 posts
  • Location:North Coast of California
  • Full Name:Aaron

Posted 16 September 2012 - 10:08 PM

Sounds like it would be a good smart phone app. That way you would always have it handy at the hobby shop, vender table etc.

I made an Excel spread sheet for my paints after I found myself with 15 bottles of flat black. A little duplication isn't bad, but paint isn't cheap and I thought that was a bit excessive. It works fine shopping on line, but I don't have it when shopping at a hobby shop.

#30 tabsscale1

tabsscale1

    MCM Ohana

  • Members
  • PipPipPipPipPipPip
  • 617 posts
  • Location:Delphos, Kansas
  • Full Name:Todd Buckles

Posted 17 September 2012 - 05:14 AM

Used to be a guy that sold one on ebay it was perfect for models and diecast cars

#31 Rob McKee

Rob McKee

    MCM Ohana

  • Members
  • PipPipPipPipPipPip
  • 846 posts
  • Location:Coquitlam BC
  • Full Name:Rob McKee

Posted 18 September 2012 - 04:49 AM

Sounds like it would be a good smart phone app. That way you would always have it handy at the hobby shop, vender table etc.

I made an Excel spread sheet for my paints after I found myself with 15 bottles of flat black. A little duplication isn't bad, but paint isn't cheap and I thought that was a bit excessive. It works fine shopping on line, but I don't have it when shopping at a hobby shop.


That is a great idea to be able to check your stock on a smart phone. I know what you mean when it comes to multiples of paints.

#32 daveparker

daveparker

    MCM Member

  • Members
  • PipPip
  • 21 posts
  • Location:Tracy, California. USA
  • Full Name:Dave Parker

Posted 20 September 2012 - 07:33 AM

Filemaker would be cool too, you could include a photo with each record an also host the db on the web quite easily if desired. Not free, but easy to create cool databases.

#33 Junkman

Junkman

    MCM Ohana

  • Members
  • PipPipPipPipPipPip
  • 3,226 posts
  • Location:England
  • Full Name:Christian Pamp

Posted 21 September 2012 - 02:39 PM

Excel sheet. I have one for my Märklin railways.

Edited by Junkman, 21 September 2012 - 02:40 PM.