Jewelry Inventory Management: The 2026 Complete Guide

In a jewelry business, inventory is the balance sheet. A typical independent store has more money in its cases and safe than in its bank account, most of it in pieces that are unique or nearly so, and all of it moving: to the bench, out on memo, to a show, to a customer's finger for a week on approval. Inventory management is not a feature of the software you buy; it is the discipline buying, pricing, staffing, and the website all rest on.

This guide covers the principles, the tools, the mistakes that repeat from store to store, and how WJewel keeps one live record of every piece.

Core Principles

Serialize what matters, count the rest

Every finished piece above a threshold you set gets its own record: a unique ID, its cost, its attributes, and its history from receipt to sale. Not everything needs it. Findings, chain sold by the inch, fast-turning sterling, and loose melee are bulk items tracked by quantity, and serializing them wastes time without adding control. WJewel's inventory handles both in one list, so the $6,000 bridal piece and the tray of $40 charms each carry the right level of detail.

Track attributes, not descriptions

A description says "14K white gold diamond halo ring". Attributes say metal 14K, center 0.75 ct, total weight 1.10 ct, vendor style, certificate number, cost, date received. Attributes can be searched, priced by metal weight, synced to the website, and reported on; when a customer asks for yellow gold under $2,000 with a sapphire, attributes answer in seconds.

Keep it real-time

A nightly sync was acceptable when the website was a brochure. Now a piece sold at 2pm and still listed online at 4pm is a refund waiting to happen, and a transfer that shows up in the other store's system tomorrow is a piece nobody can find today. Every movement should post as it happens; see real-time tracking for what that requires.

Reconcile constantly, act on aging

Trusting a once-a-year physical count means discovering in January that something went missing in May. Small, frequent checks shrink the search window from a year to a shift. And a piece's age should be visible on every stock list, because crossing an age line should trigger a decision, not a shrug.

A Counting Cadence That Works

A practical schedule for a single store with, say, 2,500 serialized pieces looks like this.

• Daily: case counts at open and close. With RFID this is a pass of the reader over each case; with barcodes, a scan of each tag. A case that opened with 62 pieces and closes with 61 is found the same evening, when it is usually at the bench rather than lost.
• Weekly: the safe and anything out on memo or at the bench, reconciling the memo-out list against what has come back or been invoiced.
• Monthly: one category counted in full, rotating so every category is done within the quarter.
• Annually: a full audit against book value, with the shrinkage number recorded. See audit best practices for running it without closing the store.

The Tools That Make It Work

RFID turns a case count from a fifteen-minute chore into a few seconds, and it finds a piece sitting in the wrong case, which barcodes cannot. The comparison is in RFID vs barcode, and the RFID page covers how WJewel tags and counts. Serialized barcodes remain right for lower-value stock; the two coexist in one workflow.

Beyond tagging, the tools keep every movement inside the system: a memo module so consignment in and memo out stay on the books; multi-store transfers with in-transit status so a piece between stores is neither counted twice nor lost; e-commerce sync so the website sells from the same stock list; and aging and turnover reports that turn the list into decisions. WJewel adds demand forecasting, projecting what each style, category, and vendor is likely to sell.

Aging: What to Do at Each Bucket

Bucket stock by age at cost (0 to 6 months, 6 to 12, 12 to 24, over 24). Say a store carries $600,000 at cost and $150,000 of it is over two years old: a quarter of the inventory producing almost nothing while occupying a quarter of the case space.

Each bucket gets a different action. Under six months: leave it alone and watch sell-through by vendor. Six to twelve: move it to a better case position and make sure the associates know it exists. Twelve to twenty-four: a price adjustment, a remount, or a return-to-vendor conversation while the vendor still cares. Over twenty-four: remount, scrap the metal and reuse the stones, or sell through another channel. Avoid the blanket discount, which trains customers to wait and rarely moves the pieces that were wrong for the store to begin with. The KPI guide shows how aging, turn, and GMROI fit together.

The Common Mistakes

Leaving memo off the books. Vendor memo off the system is inventory you are responsible for but cannot see; customer memo off the system is a piece you may never get back. Both belong in the stock list with a return date; see memo and consignment tracking.

Uncontrolled overrides. If any associate can change a cost or override a price without a permission and a record, the margin reports stop meaning anything. Set per-user permissions for cost changes, price overrides, voids, and refunds, and review the log monthly.

Ignoring salesman stock. For wholesalers, road inventory carried by reps needs the same tracking as a store case. See salesman inventory management.

How WJewel Handles Inventory Management

1. One record per piece, created once with full attributes and a unique ID, or per bulk item with a quantity; receipts import from Excel, CSV, or vendor catalog.
2. RFID and barcode counts in one workflow, so daily case counts and the annual audit use the same tags and reports.
3. Memo, repair, transfers, and salesman stock as first-class statuses, so a piece that leaves the case stays on the books until sold or returned.
4. Real-time sync across stores and to Shopify or the website, so a sale anywhere reduces stock everywhere.
5. Aging, turnover, and sell-through reports, plus Ask AI for plain-English questions and demand forecasting for what to buy next.

Why WJewel for Inventory

WJewel was built for jewelry rather than adapted to it: metal weight pricing, certificates on the record, memo in both directions, serialized and bulk stock in one list. The same inventory serves the point of sale, the wholesale invoice, the memo slip, and the website, for independents, multi-store chains, and wholesalers and manufacturers alike, with unlimited training and support to get the counting discipline established.

FAQs

How often should I count?
Cases daily at open and close, the safe and memo-out weekly, one category in full each month on a rotation, and a complete audit once a year with the shrinkage number recorded. RFID is what makes the daily count take seconds rather than a quarter of an hour.

Which items should be serialized and which tracked in bulk?
Serialize anything unique or above a value threshold you choose: finished pieces with stones, anything with a certificate, anything you would want to trace by piece if it went missing. Track by quantity what is interchangeable and fast-moving: findings, chain by length, basic sterling, loose melee. Most stores end up with a few thousand serialized records and a few hundred bulk items.

Can WJewel migrate my existing inventory?
Yes. The onboarding team regularly migrates inventory, customers, and transaction history from most jewelry POS systems, and stock can also be bulk-imported from Excel or CSV. See the FAQ page for what the process involves and how long it typically takes.

See Live Inventory, Everywhere

Request a Free WJewel Demo →