How do you keep your inventory, and how do you store it keep track of it ? I have about 80 items only but even now it is getting a bit unwieldy to manage stock in my home. How do you online sellers that don't have a Bricks and mortar store doing it. I have a "work room" that acts as my inventory space as well as my office and photography area. Any one have a good system they might like to share with the rest of us?
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).
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.