How to Manage Jewelry Store Inventory, Custom Orders, and POS

A jewelry store sells $25 silver chains and $25,000 engagement rings. The software has to handle both transactions with the same dignity — and remember which customer is which when she comes back two years later for the wedding bands, then again for the push gift after their first child. That cross-generational memory is what separates a jewelry store from a kiosk. Most off-the-shelf retail POS systems were not built for it.

The operational reality is messier than retail software vendors admit. Every piece in the case has a unique SKU, photographs, and probably a GIA or AGS certificate that has to surface during the sale. A meaningful slice of your inventory isn't yours at all — it's memo goods from a vendor with a 30-day return window and a faxed agreement somewhere in a filing cabinet. The bench has a backlog of repair tickets from $12 watch batteries to $400 prong rebuilds, and a custom design pipeline where a couple's CAD render is somewhere between casting and stone setting and the customer keeps emailing for status. Insurance carriers want appraisals. Suppliers want returns counted. Tax auditors want serial numbers. The store needs to know which longtime client just walked in before she gets to the case so the sales associate can greet her by name and pull up what her husband bought last Valentine's Day.

This guide walks through the five operational systems a working jewelry store needs in 2026 — itemized inventory, the custom design pipeline, repair tickets, memo goods, and multi-generational CRM — and how to run all of them on one platform instead of six.

Generic retail inventory thinks in SKUs and quantity-on-hand. Jewelry inventory thinks in pieces. Each ring, pendant, and watch is its own record because each one has its own metal weight, stone count, certificate number, cost basis, vendor, and physical case location.

Per-piece SKU structure: Every item gets a unique inventory ID at the moment it's tagged in. The record stores metal type and karat, total carat weight, center stone specs (cut, color, clarity, certificate number, lab), side stone counts, vendor, cost, retail price, markup percentage, and physical location down to the case and tray. Two seemingly identical 1-carat round solitaires are not interchangeable inventory — they are two distinct records.

Photographs at intake: Front, side, top, and a stamped-mark close-up. Photographs are not optional. They're the primary tool for insurance documentation, online listings, and recovering value if a piece is lost or stolen between the bench and the case.

Certificate tracking: GIA, AGS, IGI, EGL — each cert number is a field on the inventory record, with a PDF or scan attached. When a customer asks 'is this stone certified?', the answer is one click in the POS, not a trip to the safe.

Locked-case audit cadence: Daily open-and-close case counts, weekly full audit by tray, monthly reconciliation against the inventory system. Any variance triggers a same-day investigation. Most jewelers run a tiered audit — high-value cases counted daily, mid-value weekly, fashion and silver monthly. The audit log lives inside the inventory system, not on a clipboard.

Insurance documentation: Your jewelers block insurer wants a current schedule of inventory at retail value, with photos and certificates, refreshed at minimum quarterly. An itemized system exports that schedule in minutes. A spreadsheet system makes it a two-day project that gets postponed and then there's a claim.

The one-line rule: if you can't tell the difference between two pieces in your system, you can't tell the difference between them on the case floor either.

Custom work is the highest-margin and highest-friction product line in the store. The pipeline runs through six stages, each with its own deposit, deliverable, and customer touchpoint:

1. Design consult. The customer comes in with a Pinterest board and a budget. The designer scopes metal, center stone, side stones, mounting style, and finger size. This stage produces a written quote — not a verbal one — and a 25% non-refundable design deposit. The deposit is what filters tire-kickers from real customers.

2. CAD rendering. A 3D model goes back to the customer for approval. Two rounds of revisions are included; additional rounds bill at an hourly rate. Approval is in writing — sketched-on-a-napkin sign-offs are how disputes start.

3. Casting. Wax printed from the approved CAD, cast in the chosen metal. At this point, an additional 25-50% deposit moves the total to 50-75% paid. The customer is now committed because the metal is committed.

4. Stone setting. Center stone and side stones set by the bench jeweler. This is the longest-lead stage and the one most likely to slip the timeline if the center stone has to be sourced.

5. Polishing and finishing. Final polish, rhodium plating if white gold, hallmark stamping, and quality control inspection. Photographed at this stage for the customer record and for store marketing (with permission).

6. Delivery. Final balance collected, presentation box, certificate package, and a 30-day adjustment window for sizing. The customer leaves with a finished piece and a record in the CRM that ties this purchase to every future interaction.

A workflow tool that tracks each stage with photos, timestamps, and a status the customer can see is what keeps the 'where is my ring' emails to a minimum. Run it inside your store platform — not in a designer's email inbox.

Repairs are the unsexy backbone of a jewelry store's foot traffic. Every repair ticket is a customer in the door, an upsell opportunity, and a relationship deposit.

Standard pricing menu: Ring sizing (up or down 2 sizes): $35-65. Prong rebuild or retipping (per prong): $25-50. Solder split shank: $45-85. Chain repair: $20-40. Watch battery: $12-20. Watch band link removal: $5-15 per link. Pearl restringing: $45-95 depending on length and knotting style. Engraving: $25-75 by character count and font.

Turnaround commitments: Walk-in repairs (battery, simple sizing): same day. Standard bench work (sizing, chain, basic prong): 5-7 business days. Complex repair (full prong rebuild, custom solder, restoration): 2-3 weeks. Watch overhaul (mainspring, movement service): 4-8 weeks if outsourced. Promise the longer end of each window so a chunk of customers get their pieces back early. Surprise speed is a referral generator.

The ticket itself: Drop-off date, customer signature, before-photos, written description, estimate (with a 10-15% variance clause), promised pickup date, and the tag attached to the piece. The ticket lives in the POS — not on a paper duplicate — so the front-of-house can answer 'is my ring done?' without walking back to the bench.

Estimate vs. final price: Build the estimate honestly. If a 2-prong rebuild turns into a 4-prong rebuild after closer inspection, the customer gets a call with the revised price before the work starts. The number-one repair complaint in every jewelry store is the surprise upcharge at pickup.

Memo inventory is consigned goods you display and sell on behalf of a vendor — common with diamonds, signed designer pieces, and high-end watches. The bookkeeping is unforgiving.

The memo agreement: Every memo piece arrives with a written agreement specifying the vendor, the piece description, the memo cost, the agreed retail or your discount, the memo period (typically 30 to 90 days), and the return window. File it in the inventory record — not in a binder.

Inventory flag: Memo goods are flagged distinctly from owned inventory. The system tracks days-on-memo, the vendor, and the auto-reminder date for return-or-purchase decisions. A memo piece sitting at day 28 of a 30-day window should be on a daily report, not a surprise.

Sale flow: When a memo piece sells, the system generates two events. First, the customer sale at retail. Second, an automatic vendor invoice at the memo cost — converting the consignment into an owed payable. The vendor gets notified, the piece is removed from memo status, and the cash margin is recognized. Skipping the invoice step is how memo disputes turn into ugly phone calls and lost vendor relationships.

Returns: Pieces unsold at the end of the memo window get returned with a signed receipt, photographs at return, and a note in the vendor's record. Don't ship a $45,000 watch back without proof of condition.

Reconciliation: Monthly memo reconciliation matches the system's open-memo report against the vendor's open-memo report. Variances get reconciled inside the month, not at year-end audit when no one remembers what happened.

The jewelry industry's economic engine is the lifecycle: engagement, wedding bands, anniversaries, push gifts, milestone birthdays, then her daughter's engagement twenty years later. A store that captures and remembers that arc compounds. A store that treats every transaction as a one-off transaction watches the next generation buy from a competitor.

Customer record fields beyond name and email: Birthday, spouse's birthday, anniversary date, ring size (hers and his), favorite metal, favorite stones, allergies (nickel sensitivity is more common than people think), past purchases with photos, repair history, and notes from past consultations ('she wants something modern, he leans traditional'). The associate who pulls this up before a customer reaches the case is the associate who closes the sale.

Milestone reminders: Anniversary 30 days out: a personalized email or text from the associate who sold the engagement ring, suggesting a complementary piece. Birthday 14 days out: a curated set of options at the budget the customer historically buys at. First anniversary of a wedding band purchase: a paper card from the store. None of this is at scale — it's at relationship.

Transition between associates: The customer's relationship is with the store, not with one associate. When an associate leaves, the customer's full history transitions cleanly because it lives in the CRM, not in someone's head. Every detail another associate would need to pick up the relationship — kids' names, the time you fixed her grandmother's ring for free, the watch she's been considering for three years — is in the record.

Generational handoff: The daughter coming in for her engagement ring is in your system as 'daughter of [longtime customer]'. The store congratulates her by name, references her mother's pieces, and earns a customer for the next forty years. That's the asset.