I recently realized my hobby has turned into a business and I need some kind of jewelry inventory system, I know you make findings but do you have any experience building jewelry inventory systems ?
I would use Microsoft access to build my system.
The first thing to do in setting up a computerized inventory system is to establish a simple data base of 2 maybe 3 tables. The first table would be your master table where each item is assigned a product code number and it would resemble the following. By setting up a master table you will eliminate the need for keeping different tables for different types of inventory. It also sets up your system from the beginning for maximum flexibility which is essential for a business to prosper for anything but the shortest term.
Also, not knowing how much disk space etc you have I might add a 4th field to this table for a picture ( thumbnail) of the part
The next step would be to set up the actual inventory table using a structure like the following
The third table I would build from the beginning although it has nothing to do with inventory control (it will just make life easier if its done early) would be a vendor table and it would look something like this.
As far as transaction recording and the various reports you are going to need, it is best to keep them simple like the data base itself. We hope this little tid bit helps and at least gives you something to work with as you continue building your inventory management system. Keep in mind also that a strong inventory control system can greatly enhance your build to order profits.
All Guyot Products are now
(c) 2003-2018 Guyot Brothers Co Inc, A jewelry findings manufacturer