Jump to content


Inventory software


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

#1 Rob McKee

Rob McKee

    MCM Ohana

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

Posted 12 September 2012 - 02:13 PM

I think it is time for me to get a little more organized. Cleaning out my model room today I came across many duplicate kits stashed away in the back of my storage cabinets. So I decided it is time to get all of this information onto my computer so I can track what I have better.

Has anyone come across a good free inventory program designed to manage model inventories?

I have been searching the net and found a few but I thought I would seek the advice from those who are using something today.

Thanks in advance.

#2 Dr. Cranky

Dr. Cranky

    MCM Ohana

  • Members
  • PipPipPipPipPipPip
  • 15,414 posts
  • Location:Transylvania, Florida
  • Full Name:Virgil "Doctor Cranky" Suarez

Posted 12 September 2012 - 02:20 PM

Wow, Rob, how many kits do you have that you need "tracking" software? :D

#3 martinfan5

martinfan5

    MCM Ohana

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

Posted 12 September 2012 - 02:22 PM

Rob, I have been thinking about this is as well, but with less the 20 kits, I can use a napkin :lol: , but to answer your question, I think one program you could use would be a spread sheet I think. I do know there are a lot of members on here that use computer programs do keep an inventory

#4 Rob McKee

Rob McKee

    MCM Ohana

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

Posted 12 September 2012 - 02:26 PM

Wow, Rob, how many kits do you have that you need "tracking" software? :D


I knew that question would come up. Honestly I really don't know how many I have at this point. I boxed up 100 kits today and moved them to the basement for storage. Even that didn't make a dent in my collection.

I think I need to join plastic anonymous or something. :blink:

#5 oldnslow

oldnslow

    MCM Avid Poster

  • Members
  • PipPipPipPipPip
  • 291 posts
  • Location:Jacksonville, Fla
  • Full Name:Robert Lightsey

Posted 12 September 2012 - 02:27 PM

My daughter's after me to do the same thing, using a word document, haven't started yet. I've got the inventory sheets, everything is in boxes, but there's 78 pages and I just can't bring myself to start that project yet.

#6 Rob McKee

Rob McKee

    MCM Ohana

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

Posted 12 September 2012 - 02:28 PM

Rob, I have been thinking about this is as well, but with less the 20 kits, I can use a napkin :lol: , but to answer your question, I think one program you could use would be a spread sheet I think. I do know there are a lot of members on here that use computer programs do keep an inventory


I thought of a spreadsheet as well Jonathan but I think there are some good programs out there that would make it a little easier to search.

#7 martinfan5

martinfan5

    MCM Ohana

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

Posted 12 September 2012 - 02:36 PM

I thought of a spreadsheet as well Jonathan but I think there are some good programs out there that would make it a little easier to search.


I am sure you are right, that was the first thing I thought of

#8 Manic Mechanic

Manic Mechanic

    MCM Regular

  • Members
  • PipPipPip
  • 40 posts
  • Location:Mentor,Ohio

Posted 12 September 2012 - 02:38 PM

Plastic Anonymous??? Don't like quitters! :lol:

#9 DAYTIME

DAYTIME

    MCM Regular

  • Members
  • PipPipPip
  • 97 posts
  • Location:West Carrollton, OH
  • Full Name:Patrick Moore

Posted 12 September 2012 - 03:04 PM

I would use Excel. that way you can sort, search, and put in pricing if you wanted to.

#10 Rob Hall

Rob Hall

    MCM Ohana

  • Members
  • PipPipPipPipPipPip
  • 6,124 posts
  • Location:Phoenix, Arizona
  • Full Name:Robert Hall

Posted 12 September 2012 - 03:05 PM

I've used Excel spreadsheets for mine for years...I've heard of other people using an Access database. I give each I kit I buy an inventory id, a box id and storage unit id (when they get transferred from the house to offsite storage), etc...

#11 Der Bugmeister

Der Bugmeister

    MCM Regular

  • Members
  • PipPipPip
  • 51 posts
  • Location:Canada
  • Full Name:Clay Cherneff

Posted 12 September 2012 - 04:01 PM

Check this one out. It was originally intended for inventorying tools and workshop items, but seems pretty adaptable.

http://www.thegarage...=11.msg19#msg19

#12 vypurr59

vypurr59

    MCM Avid Poster

  • Members
  • PipPipPipPipPip
  • 407 posts
  • Location:Cleveland Ohio USA
  • Full Name:Jeff Shorter

Posted 12 September 2012 - 05:41 PM

Google docs has a free spreadsheet program.

#13 jcbigpaw

jcbigpaw

    MCM Avid Poster

  • Members
  • PipPipPipPipPip
  • 284 posts
  • Location:Sunny Central California
  • Full Name:joe colvin

Posted 12 September 2012 - 06:38 PM

Should be real easy to set up an excel spreadsheet for this.

#14 ChrisR

ChrisR

    MCM Ohana

  • Members
  • PipPipPipPipPipPip
  • 2,315 posts
  • Location:South Africa
  • Full Name:Chris Roos

Posted 12 September 2012 - 10:44 PM

I use an Excel spread sheet for my collection of over 2 200 models. I list them under model manufacturer, kit number, description, date of purchase, cost price and for interest current value (from actual sales on auctions or model shop catalogues). The search facility makes it easy to find anything you look for.

#15 58 Impala

58 Impala

    MCM Ohana

  • Members
  • PipPipPipPipPipPip
  • 757 posts
  • Location:Melbourne,Fla.

Posted 12 September 2012 - 11:35 PM

Like several of you, I did an inventory a few years ago on paper and transferred it to an Excel spreadsheet. I came up with my own way of categorizing everything. Once you get one set up it's easy to keep it updated.

#16 mikemodeler

mikemodeler

    MCM Ohana

  • Members
  • PipPipPipPipPipPip
  • 2,993 posts
  • Location:NASCAR Country!
  • Full Name:Classified

Posted 13 September 2012 - 12:14 AM

I would use Excel. that way you can sort, search, and put in pricing if you wanted to.


This is what I have done for the last 15 years. I categorize them and use the filter function to sort them in several different ways to identify duplicates, kits that are opened vs. sealed, sell vs. keep, etc.

#17 crazyjim

crazyjim

    MCM Ohana

  • Members
  • PipPipPipPipPipPip
  • 11,759 posts
  • Location:Citrus Springs, FL

Posted 13 September 2012 - 02:14 AM

I just keep track of my kits in a MS Word file.

#18 bbowser

bbowser

    MCM Ohana

  • Members
  • PipPipPipPipPipPip
  • 3,339 posts
  • Location:Green Mountains
  • Full Name:Bruce Bowser

Posted 13 September 2012 - 12:05 PM

I made up an Excel spreadsheet for mine, a little over 200 kits not counting partials. Like others have said it's pretty easy to set up and filter/sort for what you want.

#19 darquewanderer

darquewanderer

    MCM Friend

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

Posted 14 September 2012 - 12:34 AM

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

#20 vypurr59

vypurr59

    MCM Avid Poster

  • Members
  • PipPipPipPipPip
  • 407 posts
  • Location:Cleveland Ohio USA
  • Full Name:Jeff Shorter

Posted 14 September 2012 - 02:46 AM

openoffice.org is an open source word/excell program software. Free and easy, all docs are compatable with microsoft produsts as well