How to Number Your Jewelry Inventory: A Practical Guide to SKUs

Every jewelry business runs on its inventory numbers. That number is how you find a piece in the case, ring it up at the counter, track its cost, and know when it sold. Get the system right early and everything downstream is easier. Get it wrong, and you spend years fighting duplicate tags, unreadable codes, and counts you can’t trust.

Here’s how to think about numbering your jewelry inventory so the system stays clean as you grow.

What a good inventory number actually needs to do

Strip it back and a jewelry inventory number has three jobs:

• Be unique. No two items should ever share the same identifier—otherwise your counts, sales, and reports quietly break.
• Be findable. You need to look a piece up fast, ideally by scanning a tag rather than typing.
• Last the life of the piece. The number should stay with the item from the day it arrives to the day it sells, without needing to change.

Notice what’s not on that list: the number doesn’t need to tell you the piece’s price, its location, or its whole life story. Those things change, and things that change don’t belong in an identifier.

The big decision: smart SKUs vs. simple IDs

Most numbering debates come down to one choice.

Smart (or “intelligent”) SKUs pack meaning into the number itself—say, RG-14KW-060-VEN3 to mean a 14k white gold ring, size 6, from vendor 3. The appeal is obvious: a person can read the code and know what it is.

The problem shows up as you grow. Smart SKUs get long and brittle. You run out of category codes. A piece gets re-plated or re-sized and the “meaning” is now wrong. Staff mistype the segments. And the moment you want to slice your inventory a way the code didn’t anticipate, you’re stuck.

Simple IDs take the opposite approach: the number just identifies the piece—often a short sequential or system-generated code—and every attribute (metal, style, vendor, cost, size) lives in the software, attached to that number. You don’t read the code; you scan it and the system shows you everything.

For most jewelers today, the simple approach wins. Modern inventory software can filter and report on any attribute you’ve recorded, so you get all the benefit of a “smart” code without cramming it into the tag. Let the number be simple and let the system be smart.

Serialized vs. bulk: two numbering patterns

How you number also depends on whether a piece is tracked individually.

• Serialized items get a unique number each—one identifier, quantity of one. This is right for fine, one-of-a-kind pieces where exact cost, age, and margin matter.
• Bulk items share one number per style, tracked by quantity. This is fine for commodity pieces you stock by the dozen.

Most jewelers need both. If you’re deciding which is which, we wrote a whole guide on it: serialized vs. non-serialized inventory.

Practical rules that keep the system clean

Whatever scheme you land on, these hold up over time:

1. Keep the number itself simple and unique. Let the software store the details—don’t overload the identifier.
2. Make every piece scannable. Print a barcode tag at intake so lookups, counts, and sales are a scan, not a typing exercise.
3. Be consistent. One scheme, applied the same way by everyone, every time. Inconsistency is what actually breaks inventory—not the scheme you picked.
4. Don’t encode things that change. Price, location, and status belong in the system, not the number.
5. Leave room to grow. Give yourself enough digits that you won’t collide or run out as volume climbs.
6. Record cost, vendor, and date received against the number—in the system—so you can trace and report without decoding a tag.

Setting it up

If you’re starting fresh or cleaning up, the sequence is simple: decide serialized vs. bulk per style, pick a simple unique-number format with room to grow, record the real attributes (metal, vendor, cost, style) in your system rather than in the code, and print a scannable tag for every piece. Then—this is the part people skip—make sure everyone follows the same process at intake. A great scheme applied inconsistently is worse than a simple one applied the same way every time.

Where the software carries the weight

The reason “keep the number simple” works is that good jewelry software does the heavy lifting: it generates unique numbers for you, prints the tags, stores every attribute against the piece, and lets you search or report by any of them. That’s the whole idea behind purpose-built jewelry inventory management—the tag identifies, the system remembers, and your counts stay accurate no matter how big you get.

Get the numbering right, keep it consistent, and let the software hold the details. That’s a jewelry inventory system that scales with you instead of fighting you.