Inventory Systems?

Replies to This Discussion

Permalink Reply by San Marcos Art Glass on May 15, 2012 at 1:00am

I have only 100-200 items in the store at a time. I keep inventory files for things bought for each year, then use color-coded mark-though according to when they are sold. The system is set up with tax returns in mind. (Items bought and sold in the same year are different than those bought and sold in different years.) I use simple Excel files, which works fine for me.

I also keep picture files for the different categories (company or country, etc.) of glass I handle. Within a file, I have three different subdirectories for things that are in the store, sold, or retired. I move pictures between the subdirectories as needed, so I have a visual record of where everything is. This works well for me because I do not have a lot of inventory. So far no mistakes (knock on wood).

Permalink Reply by Ornaments on May 15, 2012 at 8:10am

You're so organized!  I badly need a system.  I keep my inventory mostly in lidded plastic bins (I use the ones they make to store nails and screws and such for jewelry) but some things end up in my china cabinet and others are in the boxes that I put them in when I bought them at the auction.  I do maintain a spreadsheet and I mostly keep it up to date, but I really need a better system.