Jewelry inventory management

Jewelry Inventory Management for Small Stores: A System That Actually Works

Independent jewelry stores lose money in a specific, quiet way: not through theft or fraud, most of the time, but through inventory nobody can fully account for. A loose stone that got remounted and never re-logged. A consignment piece from a local designer that's been on the floor for eight months with no review date. A repair job in the back that's technically still customer property, mixed in with store stock.

None of it shows up as a single dramatic loss. It shows up as a shrinkage number at year-end that nobody can fully explain.

What makes jewelry inventory harder than general retail

• Pieces get broken down and reassembled. A stone gets pulled and remounted, a chain shortened, a ring resized — the "item" isn't stable the way a t-shirt SKU is.
• A meaningful share of floor stock isn't owned by the store. Consignment pieces, trunk-show inventory, and customer repairs sit in the same space as owned stock but need separate tracking for accounting and liability.
• Value isn't fixed. Metal and stone prices move; a piece's insured or resale value today isn't what it was six months ago.
• Documentation matters as much as the object. A GIA or AGS certificate, an appraisal, an origin note — these are part of what you're selling.

The core fields to track per piece

• Description — metal, stone(s), carat weight, setting type
• Source — owned stock, consignment (and from whom), or customer repair
• Cost and current retail price, tracked separately so margin stays visible
• Certification — GIA/AGS number and a scan of the certificate, if applicable
• Location — showcase, safe, at a trade show, out for repair
• Status — in stock, on hold, sold, returned to consignor
• Date received and, for consignment, the review or return date

Handling consignment stock without losing track of it

Consignment is where most independent stores get into trouble, for the same reason galleries do: it's easy to bring a piece in and forget there was ever a deadline attached to it. A workable process needs:

• A written agreement per consignor covering commission split, duration, and what happens if the piece doesn't sell
• A review date, not an open-ended arrangement — 30, 60, or 90 days is standard, after which the piece is renewed or returned
• Clear separation from owned inventory in your records, so shrinkage and true margin aren't distorted by stock that was never yours

Why spreadsheets and generic POS modules fall short

Most point-of-sale systems built for general retail treat every item as a fixed SKU with a fixed price — which works for a t-shirt and breaks the moment a piece gets remounted, repaired, or renegotiated at the counter. A spreadsheet, while flexible, has no way to flag that a consignment review date is coming up next week, or that a repair item has passed its promised return date.

What to look for in dedicated jewelry inventory software

• Item-level detail built for jewelry — metal, stone, carat, certification — not generic product fields
• A clear separation between owned, consigned, and customer-repair stock
• Visible deadlines — consignment review dates, repair promise dates — surfaced without manual tracking
• Exportable records, so your data isn't locked into one vendor

FAQ