How to do inventory for a jewelry store

Inventory in a jewelry store is not the same problem as inventory in a clothing store or a hardware shop. A single ring can be worth more than a week of sales. Two seemingly identical wedding bands can differ by 0.3 grams of gold and 200 euros in value. A diamond on consignment from a supplier sits in your display case but does not belong to you. A repair that came in last Tuesday is technically not your stock, but it is in your safe.

Most generic inventory advice ignores these realities. This guide does not. It walks through how jewelers actually manage stock day to day: what to track, how to audit without closing the store, how to handle consignment and memo goods, how to deal with gold price changes on items that have been in stock for years, and where software like Gem Logic removes the manual work entirely.

If you are still on a spreadsheet or a notebook, the second half of this article will be uncomfortable reading. That is the point.

Why jewelry inventory is fundamentally different from retail inventory

Before the how, it helps to be honest about the why. Jewelry inventory is hard for reasons that have nothing to do with how organized you are, and everything to do with the nature of the goods.

Each item is often unique

A ring with a 0.5 ct diamond is not the same piece as another ring with a 0.5 ct diamond. Color, clarity, cut, fluorescence, certificate: all of it differs. That is why serious jewelers do not work with one SKU per model, they work with a serial number per individual piece.

The underlying value changes daily

The gold price moves every day. A ring you made in January 2023 with gold at 55 euro per gram is a different commercial story than the same ring today. Who is tracking that? Keep an eye on the spot rate with our free live gold price tool, and let metal price sync do the recalculation for you inside your stock.

You carry stock that is not yours

Consignment pieces, memo goods, customer repairs, items out on approval. They all sit in your safe, but they are not all your property. Treating them as one undifferentiated pile is how jewelers end up selling something they did not own.

Insurance and legal documentation are stricter

Insurers require appraisals. After a theft you have to produce a serial number and a photograph. That is not a nice-to-have, it is a condition of being paid out.

Repairs blur the line between stock and not-stock

A repair is not inventory, but it is physically part of what is in your store. It needs its own track, separate from the pieces you can actually sell. Good repair management keeps that boundary clean.

Build a categorization that matches how jewelers actually work

"Categorize by type and material" is the standard advice. It is correct, but too basic. Here is what jewelers need in practice.

Primary categorization (type)

• Rings: engagement, wedding bands, eternity, signet, fashion
• Necklaces: chains, pendants, chokers, lariats
• Bracelets: tennis, bangles, cuffs, charm
• Earrings: studs, hoops, drops, ear cuffs
• Watches
• Loose stones (diamonds, colored gems)
• Bullion (gold bars and coins, for those who buy and trade)

Secondary attributes per item

This is where generic retail software fails and jewelry software wins. Every piece should carry:

• Metal type and karat (9k, 14k, 18k, 22k, 24k, sterling, platinum)
• Gold color (yellow, white, rose)
• Total weight in grams, essential for revaluing when the gold price moves
• Stone details: type, carat, color, clarity, cut, certificate number
• Origin: made in your atelier, bought-in collection, or consignment
• Status: in stock, on display, on memo, in repair, reserved, sold

In Gem Logic, this is built in: gold is tracked by karat with automatic purity conversion, gemstones carry their clarity, cut, shape, color, and carat weight, and every piece holds its own photos, barcode, and live stock status.

Why this matters operationally

Good categorization means you can answer questions like "show me every 18k yellow gold ring with an emerald under 2000 euro." That is not a luxury, it is the basis for smarter buying and smarter clearance. It only works when your product catalog and your wider store management share the same structured data.

Choose a tracking system that matches your store size

"Pick a system" is not enough guidance. Here is the real decision tree.

Under 100 pieces, one location

A spreadsheet can work, if you have the discipline. But the moment you add a second team member, it falls apart: versions, double entry, mistakes.

100 to 500 pieces, one location, no webshop

This is where a spreadsheet stops being enough: barcode scanning, photos per piece, status tracking, and a link to your sales. This is where dedicated software starts to pay for itself.

500+ pieces, multiple locations, or a webshop

No more debate: you need a proper system. Real-time sync between shop and webshop, stock across multiple locations, and automatic status updates the moment a piece is sold.

Signs your current system no longer fits

Answer these honestly:

• Did you find a "lost" piece in a drawer at least once last year?
• Is there more than a 2% gap between your administrative and physical stock?
• Has a team member sold a piece that was already reserved online?
• Does your annual stocktake take more than two days?
• Can you not see, within 30 seconds, what a specific ring cost you?

More than two "yes" answers and it is time to look at the features of a real system and what they cost.

Photograph every piece (and why most jewelers do this wrong)

"Take good photos" is correct, but it misses the point: the value is in doing it consistently and attaching the result to the right record.

At least three photos per piece

• Front, on a white background, for your records and your insurer
• A side or inside detail, for recognition if there is a dispute after a repair
• A close-up of any stones and hallmarks

A lightbox setup for under 200 euro

You do not need a professional studio. A small lightbox, a phone tripod, and consistent light are enough to get clean, repeatable shots that look the same across your whole catalog.

Attach photos to the stock record, not a random folder

Photos are worthless if they live in a random folder on someone's phone. They have to be tied to the piece itself. In Gem Logic, photos live directly on the product record, and our AI image tools can clean up a background or sharpen an old shot so your catalog looks consistent without a studio day.

Why this is also a legal safeguard

For customer repairs, a photo taken before intake is your only defense against "my diamond is smaller now" or "the engraving has changed." A lost claim can cost thousands. This is exactly why repair intake should capture photos the moment a piece crosses the counter.

Stocktaking: a full inventory without closing the store

This is the chapter most guides skip, and the one every jeweler struggles with. You do not have to shut for a week in January.

Count in cycles

Instead of closing for a week, count one category each week. By the end of the year you have counted everything without ever shutting the door, and you catch errors as they happen rather than all at once.

High-value pieces: monthly

Anything above 5000 euro gets a physical check every month. This is not optional.

What to do with discrepancies

• Recount first
• Check whether the piece is in a repair box
• Check whether it is out on approval with a customer
• Check recent sales around that item number, in case of a wrong scan
• Only as a last resort, write it off as a loss or suspected theft

A practical process

• Two people count independently
• The count sheets are compared afterwards
• A third person recounts any differences
• Only then is the system adjusted

Tracking consignment, memo goods, and items on approval

This is a real pain for jewelers who work with brands and designers, and most guides ignore it entirely.

Consignment: what is it legally?

Pieces that physically sit with you but remain the supplier's property until they sell. In a theft or fire, the supplier's insurance usually applies, but read your contract: the details matter.

How to keep it separate

• A separate stock category
• The owner clearly recorded in the system
• The purchase invoice raised at the moment of sale, not on receipt
• Periodic reconciliation with the supplier: which pieces are still here?

In Gem Logic, consignment is a first-class flow: each piece carries its owner, the payout is tracked as a percentage or a flat amount, and the sale is linked back to the right partner so settling up is straightforward.

Memo goods (out on approval with a customer)

Pieces you hand to a customer to live with for a day. The risk often sits with you, so documentation is everything: a signed receipt with a photo and an estimated value. With memos, the stock knows a piece is out on memo rather than on the shelf, so it cannot accidentally be sold elsewhere, and memo inventory stays separate from the stock you actually own.

Pricing dynamics: gold price changes on aged stock

The problem

You made an 18k ring in March 2024 with gold at 60 euro per gram. It is still in the case. Today gold is 78 euro per gram. What is the correct selling price?

Three approaches

• Historic cost-plus: hold the original margin. Predictable, but you either leave money on the table or sit too expensive.
• Market cost-plus: recalculate on today's gold price. Your margin stays constant, but prices change often and customers can get confused.
• Hybrid: revalue the standard collection each quarter, and price bespoke work at the day's rate.

Whichever you choose, doing it by hand is the problem. With metal price sync, every time the metal cost on a product moves, the regular price and any sale price are recalculated using the rule you set, so your margins stay where you put them and every new piece made from bought-in gold is priced on its weighted average cost.

Aged stock (over 12 months)

There is a second consideration: opportunity cost. A piece sitting in the case for the third year running is better sold at a marginal profit than admired for another season. Lean on your reporting to see what is moving and what is not, and act on it.

Reorder points: not just finished goods, also raw materials

For retailers: bestseller models

Wedding bands in standard sizes, basic chains. Set a minimum and get an alert when stock drops below it, so you never miss an easy sale because a staple ran out.

For workshops: precious metal in raw form

How much 18k gold do you hold as sheet, wire, or grain? When do you reorder? It gets complex: lead times from the refiner are often 2 to 5 days, the price moves, and you do not want to build up stock when gold is high. A workshop that tracks raw metal alongside finished pieces makes this a decision rather than a guess.

Seasonality

Engagement rings peak around Valentine's and Christmas. Communion silver moves in spring. Plan your stock around the calendar your customers actually live by.

Security, insurance, and inventory documentation

What your insurer actually requires

• An up-to-date inventory list, usually each quarter or half year
• A photo of every piece above a set value (this varies per policy)
• Purchase invoices or appraisals
• Serial numbers where applicable

What you need when you file a claim

No insurer pays out on "we had a ring worth around 4000 euro." You need a dated photo, a purchase invoice or appraisal, the piece in your last inventory, and any certificates.

A practical tip: an annual digital backup to your insurer

Each January, send your broker an exported list plus the photo archive. Gem Logic lets you export your data to Excel, so you stand on much firmer ground if you ever have to make a claim.

Connecting your inventory to your sales channels

This is where inventory stops being a back-office task and becomes a sales question.

In-store POS

When you sell at the counter, stock should drop immediately. It sounds obvious, but in spreadsheet workflows it only happens in the evening, with errors.

Webshop sync

Stock has to be synchronized in real time between shop and webshop. Otherwise you sell a piece online that was already sold in the store that morning. A jewelry ecommerce website that shares one stock source with your counter removes that risk entirely.

Marketplaces and external platforms

Selling in more than one place needs a single, central stock source, or you get double sales and unhappy customers. Gem Logic syncs with WooCommerce out of the box, and connects to other tools through API integrations.

Conclusion: from spreadsheet to system, from chaos to control

Inventory management is not about admin. It is about knowing where every euro sits, every ring, every karat of gold. It is about knowing which pieces have sat too long and which you need to reorder tomorrow. It is about telling a customer within 10 seconds whether that specific earring is still available, in which size, and what it costs today.

The jewelers who do this well sell more, lose less, and sleep better. The technology to get there exists. The only question is whether your system grows with your business.

Key takeaways

• Generic retail software is not built for the complexity of karat, weight, certificates, and consignment
• Cyclical counts beat a once-a-year big-bang stocktake
• Photos are legally and commercially essential, and must be tied to the stock record
• Gold price changes call for active stock management, not a static price list
• Inventory is not a back-office problem, it is the basis of sales, margin, and service