Jewelry Inventory Management: A Practical Guide.
Jewelry inventory is small, valuable and hard to tell apart, and much of it is priced by what it is made of rather than by a list price. This guide covers what to record, how to keep the count right, and how to know what your stock is worth.
Updated
Why Jewelry Inventory Is Different
A hardware store can count boxes. A jeweler holds pieces that look alike but differ in metal, karat, weight and stones — and therefore in cost and price. Many pieces are one of a kind, some are out with customers on memo, and the value of the metal in the vault moves with the market every day.
Good jewelry inventory management comes down to three things: describing every piece precisely enough that two people would agree which one it is, knowing at all times where it is and whether it is free to sell, and knowing what it cost you.
What To Record On Every Piece
Record the details you price by and the details you would need to identify the piece if its tag fell off. Keep them as separate fields rather than one long description, so you can filter, sort and value by them.
- SKU — a unique code, never reused
- Type — ring, earrings, pendant, chain, bracelet
- Metal, color and karat (or fineness)
- Gross weight and net metal weight
- Stones — type, count, total carat weight, and any certificate number
- Cost, broken into metal, stones and making or labor where you can
- Wholesale and retail price
- Supplier, and the date and order it was bought on
- Photos
- Status — in stock, on memo, sold, archived
SKUs And Tags
A SKU should identify one product and read the same way everywhere: on the tag, in your system, on an invoice. Short codes in a fixed order — type, metal and karat, stone, then a sequence number — make SKUs readable without making them long. Detailed attributes belong in the record, not the SKU.
Decide whether a SKU names a style you restock or a single unique piece. Restocked styles share a SKU and carry a quantity; one-of-a-kind pieces each get their own SKU and a quantity of one.
On Hand Is Not The Same As Available
A piece you own can still be unavailable: sent to a customer on memo, set aside for a client, or out for repair. Track these separately from what is on hand, so a piece out on memo is never promised or sold twice.
Available to sell = on hand − on memo − reserved.
Counting And Reconciling
High-value stock should be counted often. Many jewelers do a quick count of the showcase at open and close, and a full count of everything on a regular cycle. Count against a list, investigate every difference, and record each adjustment with a reason — never just overwrite the number.
Keep a movement history for every piece: received on which order, sold on which invoice, sent and returned on which memo, adjusted and why. When a count is wrong, the history is how you find out what happened.
Reorder Points For Pieces You Restock
For styles you sell repeatedly, set a reorder point: the stock level at which you order more, high enough to cover sales while the order is on its way. Leave one-of-a-kind pieces without one. Reviewing what fell below its reorder point each week turns restocking from memory into a routine.
Valuing Your Inventory
Know your inventory's value two ways: at cost (what you paid, including the cost of bringing it in) and at retail (what it would bring if sold at your prices). The gap between them is your potential gross profit — and the cost figure is the one that matters for your books and your insurance.
Because metal prices move, many jewelers also track the metal content of their stock — net metal weight by karat — so they can see how much of their inventory value is gold and how exposed they are to its price.
When To Leave The Spreadsheet
Spreadsheets work until several people edit them, pieces go out on memo, or you need to know what something actually cost. Signs it is time for inventory software: counts that do not match, pieces sold while out on memo, costs nobody can reconstruct, and a sales team that can see what everything cost.