Jewellery inventory when every piece is one of one

Jewellery stock cannot be counted by SKU and quantity. Track each piece by tag number, gross weight and net weight, with the fields to record and pitfalls.

A jewellery shop should manage stock piece by piece, not by SKU and quantity. Give every item its own tag number, and record its gross weight, net weight and stone details against that tag. Each sale, approval, transfer or return then moves that single tagged piece. When two "identical" bangles weigh differently, they are different stock, and your records have to show that.

Why do quantity-based SKUs fail for jewellery?

Most inventory systems are built for interchangeable goods. One box of a 500 ml bottle is the same as the next, so "SKU 1042, quantity 24" tells you all you need. Jewellery is not like that.

Take one chain design made in the same week by the same karigar. Each chain still comes out at a slightly different weight. The stone setting on one pendant may use a different stone count from its neighbour. Since the selling value depends on weight and stones, each piece has its own value.

If you hold these as "Design C-17, quantity 6", several problems follow:

When one sells, you cannot tell which of the six left the shop, or what weight it was.
The value of what remains becomes an average, and that average drifts away from the truth after every sale.
A missing piece shows up only as "quantity 5 instead of 6", with nothing to show which piece is gone or who last handled it.
Pieces given out on approval cannot be told apart from pieces on the counter.

The design code is still useful for grouping, reporting and reordering from a karigar. It just cannot be the unit of stock. The tag number is.

What should you record for every piece?

Record these fields when a piece enters stock, before it reaches the counter.

Field	What it holds	Why it matters
Tag number	A unique number printed on the tag and stored in the system	The one key every movement and bill points to
Design / style code	The design the piece belongs to	Grouping, sales analysis and repeat orders
Category	Ring, chain, bangle, earring, pendant, set and so on	Counter layout and reporting
Metal and purity	The metal and the purity it is sold at	Separates stock that must never be mixed
Gross weight	Total weight on the scale, including stones and attachments	What the customer sees weighed
Stone / other weight	Weight of stones, beads, thread, lac or other non-metal parts	Lets you derive and check net weight
Net weight	Metal weight only	The base for valuing the metal in the piece
Stone details	Type, count and any certificate reference	Needed to describe and value studded pieces
Size	Ring size, bangle size, chain length	Customers ask by size; avoids hunting through trays
Source	Karigar, supplier party or own workshop, with the inward reference	Traceability and returns
Location / status	Counter tray, safe, branch, on approval, with karigar, sold	Tells you where the piece is right now
Photo	A clear image of the actual piece	Settles disputes and helps identify it at stock-take

Keep a simple check in place: gross weight minus stone and other weight should equal net weight. If it doesn't, the entry is wrong. Fix it before the piece is tagged.

A worked example

These numbers are illustrative only. A studded pendant comes in from a karigar:

Gross weight: 6.480 g
Stone weight: 0.420 g
Net weight: 6.480 − 0.420 = 6.060 g

It gets tag number 24-PD-00318, status "Counter tray 3", and a photo. When it sells, the bill draws these weights from the tag record and status changes to "sold". Nobody re-types weights at the counter and nobody does any averaging.

How do tag numbers work in day-to-day movements?

Every movement of a piece should be recorded against its tag number:

Inward: the piece is weighed, recorded and tagged before it goes on display.
Branch transfer: the tag moves from one location to another, so both shops' stock stays correct.
Approval (piece sent to a customer to view): status becomes "on approval" with the party name, so it is still your stock but not on the counter.
Sent for repair or rework: status shows the karigar, and the piece is weighed again on return. If the weight changed, record the new weight and keep the old one in the history.
Sale: the bill picks up the tag, and status becomes sold.
Sales return or exchange: the same tag comes back into stock after it is weighed again. Don't create a fresh number for the same piece.

Barcode or QR tags make scanning faster, but the method does not depend on them. A handwritten tag number entered correctly still gives you one-piece-one-record.

Can a spreadsheet handle serialised jewellery stock?

For a very small shop, a well-kept spreadsheet can hold one row per tag. The trouble starts when you have several counters, branches, approvals out with parties, and pieces at karigars. A spreadsheet will not stop two people editing the same row. It will not block a sold tag from being billed again, and it keeps no history of who changed a weight. Our comparison of Excel vs inventory software covers where that line usually falls. If you are evaluating tools, choosing inventory software in India lists the questions to ask, and "does it support one record per serial number with custom weight fields" belongs at the top for a jewellery shop.

Common mistakes

Tagging after display. Pieces go on the counter "for now" and get recorded later. That gap is exactly when pieces go missing without a trace.
Recording only gross weight. Without stone weight and net weight, you cannot check your own entries or answer a customer's question about the bill.
Reusing tag numbers. It saves printing new tags but breaks every past record that used the number.
Averaging by design. Valuing six chains at an average weight hides both gains and losses.
Not weighing again after repair. Work done by a karigar can change weight. If you don't weigh the piece on return, your stock value is quietly wrong.
Treating approvals as sales or as counter stock. Approval is a separate status. Mixing it with either one gives you wrong counts.
Counting totals instead of tags. A count that says "212 pieces, matches" can hide one missing ring and one extra that was never entered. Match tag by tag.

When does this not apply?

Some jewellery-shop stock really is interchangeable and can stay quantity-based. Examples are loose packaging, boxes, polishing supplies, and identical low-value fashion items bought in bulk where individual weight does not affect price. Bullion and loose metal are usually tracked by total weight per purity rather than by piece. Use serial tracking for finished pieces whose value depends on their own weight and stones, and simpler counting for the rest. Mixing the two methods in one system is normal. Mixing them within one category is not.

This guide covers stock records only. Metal rates, making-charge rules, hallmarking and HUID requirements are separate topics. Check those with your CA or the official sources.

FAQ

Why can't I use normal SKUs and quantities for jewellery? Two chains from the same design almost never weigh the same, and the price depends on weight. A quantity of "5" under one SKU cannot tell you which chain was sold or what it weighed. You need one record per piece, found by its tag number, so that stock, sale and value all point to the same physical item.

What is the difference between gross weight and net weight? Gross weight is everything on the scale: metal, stones, beads, thread and any other attachments. Net weight is the metal alone, after you subtract stone and other non-metal weight. Record both for every piece, plus the stone weight, so the numbers can be checked against each other at stock-take or when a customer queries a bill.

Should the tag number ever be reused? No. Once a tag number is given to a piece, keep it attached to that piece's history for good. Sold, melted, returned to a karigar or reworked, the old number stays retired. Reusing numbers mixes two pieces' histories and makes it impossible to trace a past sale or approval.

How often should a jewellery shop do a physical stock count? Count the counter trays daily at opening and closing by tag number, and do a full count with weighing on a regular cycle you set with your accountant. Because each piece is unique, the count is a tag-by-tag match, not a total. Any tag on the system but not in hand is a real loss to look into.