Jewellery Inventory Software: What Handmade Jewellers Need to Track

You can't pour a candle. You can't bake a loaf. Jewellery is different.

The thing about handmade jewellery is that one ring is rarely identical to the next. A baker makes 30 sourdoughs at a time. A candle maker pours 24 candles of one scent. A jeweller might make one pair of silver hoops, one pendant, one set of three stacking rings — each different.

This makes inventory tracking harder than other artisan businesses. You're not counting units of the same thing. You're tracking individual pieces, the raw materials they came from, the supplier lots of those materials, and where each piece sits in your sales pipeline (in-production, photographed, listed on Etsy, sold, shipped).

Most jewellery inventory systems were built either for big retailers (over-engineered, expensive) or for general ecommerce (under-built for material traceability). Handmade jewellers fall in the gap.

What jewellery inventory actually has to track

Jewellery inventory has four layers that all matter:

1. Raw precious metal stock. Silver sheet, silver wire, gold sheet/wire, casting grain, solder. Tracked by weight (grams), not by piece count. Most jewellers buy in standard sizes (1mm wire by metre, sheet by gram weight).

2. Components. Earring hooks, ear posts, jump rings, chain by the metre, clasps, settings, ear nuts, locking findings. Tracked by piece count.

3. Stones and pearls. Faceted gemstones, cabochons, freshwater pearls, beads. Tracked individually if expensive (one specific 5mm sapphire), by count or weight if not (a bag of 4mm rose quartz beads).

4. Finished pieces. Each one is a SKU. Each one has a status (in production / ready to photograph / listed / sold / shipped). One-of-a-kind pieces vs production-run pieces are tracked differently.

A spreadsheet can handle layers 1-3 for a small jeweller. Layer 4 is where it gets messy fast — especially once you're selling on multiple channels (Etsy, your own Shopify, in-person at craft fairs).

SKUs for handmade jewellery

Every distinct piece needs a SKU (Stock Keeping Unit) — a unique code that identifies it. Even if you're a one-person business making one piece at a time, SKUs matter because:

They're how you reconcile listings across platforms (the same SKU on Etsy, your website, and your craft fair stock list)
They're how you tie a sale back to its production cost (which goes into recipe costing — yes, jewellery has recipes too, sometimes called bills of materials or BOMs)
They're how you trace a customer return to the specific piece (and the supplier lot of metal it was made from)
They're how you spot which designs sell and which sit unsold

A useful SKU pattern for handmade jewellery uses 3-4 fields separated by hyphens:

[Collection]-[Type]-[Metal]-[Sequence]

Examples:

MOSS-RING-SS-0042 (Moss collection, ring, sterling silver, piece number 42)
CORE-EARR-GF-0118 (Core collection, earrings, gold-filled, piece 118)
OOAK-PEND-9KY-0007 (One-of-a-kind, pendant, 9ct yellow gold, piece 7)

The pattern doesn't matter as much as having one and using it consistently. Pick a format on day one and you won't regret it. Change formats partway through and you'll have a mess to clean up.

Hallmarking and the records you must keep

UK hallmarking law is the single most important thing that makes jewellery inventory different from other craft inventory.

Under the Hallmarking Act 1973, any silver item over 7.78g, gold item over 1g, palladium over 1g, or platinum over 0.5g must be hallmarked at an assay office before being sold or described in trade as the relevant metal. Selling unhallmarked metal that meets these weight thresholds as "silver" or "gold" is a criminal offence.

What this means for inventory:

Track piece weight at production. You need to know which pieces cross the hallmarking threshold.
Track which pieces have been hallmarked. A pending-hallmark piece can't be listed for sale yet — your inventory needs to distinguish "made but not sent to assay" from "hallmarked and ready to list."
Keep assay office records. When you submit items, you get back a record of what was hallmarked. Keep these — they're proof of compliance and useful for trace-back if a customer queries authenticity.
Track the responsibility mark (sponsor's mark). If you have your own registered mark, it's on every piece you hallmark. Keep records linking pieces to your mark.

If you're under the thresholds (most fine-wire earrings, small charms, lightweight pieces), you don't need to hallmark — but you also can't describe them as "silver" or "gold" in trade, only by composition (e.g., "925 sterling silver"). This is a frequent point of confusion.

What "good enough" jewellery inventory looks like

For a one-person handmade jewellery business making 20-100 pieces a month, "good enough" inventory means:

Raw materials tab: silver weight remaining, wire stock by gauge, gold weight, solder stock, components by count, stones by individual ID or batch. Updated when you receive supplies and when you do a stock count.

Pieces tab: each piece with SKU, type, metals used, weight, hallmark status, status (in production / awaiting hallmark / hallmarked / listed / sold), listing platforms, sold date, sold price.

Sales tab: sale date, SKU sold, platform, price, fees, net.

You can run this on a Google Sheet or Airtable for a while. The breaking points come at predictable moments:

Cross-platform listings get out of sync (sold on Etsy, still listed on your website)
Multi-channel sales make it hard to know what's actually available without a manual check
Production volume gets too high to maintain by hand
You start hiring or working with a part-time helper and need a system that more than one person can use

At that point — usually somewhere between 100 and 500 pieces sold per month — a dedicated inventory or production management system starts to earn its keep.

What to look for in jewellery inventory software

If you're evaluating tools, the must-haves for handmade jewellery are:

Per-piece tracking with custom SKU patterns. Generic ecommerce inventory assumes you have variants of the same product. You don't.
Material traceability. Which silver lot is in which piece. For hallmarking, for customer queries, for any future recall scenario.
Weight-based inventory for precious metals. Track stock in grams. Subtract the weight of each piece from raw material stock as it's made.
Status-based inventory. Pieces don't go from "in stock" to "sold" in one step. They progress through production → hallmarking → photography → listing → sold → shipped. Software that recognises these states beats software that doesn't.
Multi-channel sync. When a piece sells on Etsy, the listing on your own site should come down automatically (or at least flag).
UK-specific support. GBP pricing, UK hallmarking record-keeping, integration with UK platforms (Etsy UK, eBay UK, Shopify UK).

The nice-to-haves: cost per piece (margin tracking), label generation for hallmarked goods, photography workflow (uploaded → edited → listed).

The "skip it" features: features built for high-volume retail (POS terminals, barcode scanners, warehouse management). For a one-person bench, these are overhead.

When a SKU generator helps

Generating SKUs by hand is fine for the first 50-100 pieces. After that, you start forgetting which numbers you've used and which collection codes are which. A simple SKU generator that takes a pattern and the next sequence number saves time and reduces collision risk.

We're building a free SKU generator tool for makers in exactly this situation — pick a pattern, generate the next batch of SKUs, and use them in your inventory and listings. It works for jewellery, candles, soaps, ceramics — anything where each piece needs a unique identifier.

Jewellery inventory checklist

Raw materials tracked by weight (precious metals) or count (components, beads)
Each finished piece has a unique SKU following a consistent pattern
Hallmarking status tracked per piece (over-threshold pieces marked for assay submission)
Sponsor's mark records kept for hallmarked items
Cross-platform listings synchronised manually or via tooling
Cost per piece calculated using current metal and component prices
Stock counts performed at least monthly (weekly if production volume is high)
Sold pieces archived, not deleted (for return queries and tax records)

Inventory is the boring foundation of a profitable jewellery business. Get it right and you can grow without losing track of what you have. Get it wrong and every month you lose pieces, mis-price stock, and miss the wholesale enquiry because you can't say with confidence what you can produce by when.

This guide applies to UK handmade jewellers — sole traders and micro-businesses producing under their own responsibility mark or under client commissions. It is not legal advice. For specific questions about hallmarking, contact the Birmingham, London, Sheffield, or Edinburgh Assay Offices.