Jump to content

Creating an Inventory Database


Roktman
 Share

Recommended Posts

Hey all,

 

I've finally come to the conclusion that there's no way I can build all the kits in my stash. I had been toying with the idea of creating a database so if and when the time comes, my wife and son will know what I have, and approximately what they can get for my left over stash.

Besides mfg, model name, scale, what its worth or what I paid - can anyone think of something that might be important?  TIA.

 

Link to comment
Share on other sites

A friend uses one of the commercial products, he uses it to track any aftermarket he has for the kit and reference photos (in case he ever gets around to building it).

  • Like 1
Link to comment
Share on other sites

Since most of my stash is in banker's boxes, I number the boxes and have a location field in my spread sheet to indicate which box a kit is stored. I also have columns for Classification (aircraft, armor, sci-fi, etc) and "Manufactured by/Series" (Douglas, North American, Grumman, Star Trek, Star Wars, etc). By filtering the data, this helps me quickly see if I already have a particular subject in my stash. I also list condition of the kit, i.e. bag kit or whether it is started, and in the notes I will list any aftermarket I may have for it. 

  • Like 1
Link to comment
Share on other sites

8 hours ago, AZRhino said:

I also list condition of the kit, i.e. bag kit or whether it is started, and in the notes I will list any aftermarket I may have for it. 

Ooh, those are good ideas - I need to add those to my database spreadsheet. I'm always buying duplicate aftermarket bits! 

  • Like 1
Link to comment
Share on other sites

I use Excel. I created a workbook with a separate worksheet for each major category (1/72 aircraft, 1/700 ships, etc.) with columns for the important data (kit manufacturer, catalog number, subject, number in inventory, aftermarket parts, aftermarket decals, storage box number, etc.).

Edited by SkyKing
  • Like 1
Link to comment
Share on other sites

Go to Scalemates. You can easily create an account and stash database there. The best thing is that if their database does not include an item, any member can add an item.

  • Like 1
Link to comment
Share on other sites

 Share

×
×
  • Create New...