Most probably, you purchase your wholesale jewelry from the wholesaler online. If this is so, you also probably copy and save the jewelry supplier’s photo of each piece you buy, but if you don’t, start doing it today, because this is the basis to create the best and easiest jewelry business inventory spreadsheet. Curious? You should be! And here is how it works:
1. First, get an image from the wholesale jewelry supplier
In most cases, the supplier will be able to provide a picture of each jewelry piece, but if this is not the case, just take a photo of each one as soon as you receive them. Resize the image using a program like Paint, for PC’s, or a Preview program, for Mac’s, or, make instant thumbnail images.
2. Second, name the image
By selecting a significant name for each jewelry piece, you take care of the indexing and inventory at the same time. Let’s say you purchase three silver necklaces, this is the information you will write down in the file name:
- The date, ‘1209’ means December 2009
- The price, ‘3050’ means $30.50
- The number of necklaces, in this case, 3. You can add other important information, like the cost per piece, shipping cost, etc.
Once you’re done, the file name will look like this: 12093050310 (Dec. 09, $30,50, count 3, $10 each), to make it clearer, you can separate the numbers: 1209_3050_3_10. You can also add a small description of the pieces: 1209_3050_3_10silver_neck.
3. Third, add the pieces to a spreadsheet
This list of images can be viewed either as file names or as pictures, but if you want to be able to view a total column easily, use the file names. Copy the file names of the pictures, without the extension (.jpg, for example). And just in case you don’t know exactly how to copy and paste an image, follow these quick instructions:
- With the mouse, highlight the image file name
- Right-click and select ‘copy’
- Go to the spreadsheet
- Right-click again and select paste to place the file name in a row on the spreadsheet
See? In a quick and easy way, you will have all your wholesale jewelry pieces stored in your jewelry business inventory. If you want to make it more sophisticated, just create a column for the actual thumbnail picture and include it in your inventory.
An inventory is a great tool if you want to stay on top of things and sort pieces easily. If you’re looking for silver necklaces you have bought at different times, just sort the ‘type’ column and you will get all the data in an instant; however, remember to highlight the whole document before sorting it, or else, you will get all your inventory mixed up. Just in case, save another copy as backup and never mess with it.
As you sell your pieces, simply enter a minus number and include a new total. Your results will be a total cost of inventory on a daily basis.
You can find free spreadsheet programs online; no need to pay a fortune to get your wholesale jewelry professionally organized.
If you liked this article, tell all your friends about it. They’ll thank you for it. If you have a blog or website, you can link to it or even post it to your own site (don’t forget to mention www.paradisojewelry.com as the original source).
Don’t Forget to Subscribe by RSS or Email:
