How to Track Custom Jewelry Commissions Without Spreadsheets

If you run a custom jewelry studio, you know the chaos. A client enquiry comes in by email. You scribble down their ring size and metal preference on a Post-it. The design approval lives in a WhatsApp thread. The deposit payment is in your Shopify orders but the commission details are in a spreadsheet. And somewhere in the middle, you're trying to remember which stage each piece is at.

It works when you have three commissions on the go. It falls apart at ten.

Why Spreadsheets Break for Custom Jewelry

Custom jewelry commissions aren't like standard retail orders. Each one is a multi-week (sometimes multi-month) process with distinct stages: enquiry, consultation, design, approval, production, quality check, and delivery. A spreadsheet can list these stages, but it can't enforce them, automate transitions, or give your client visibility into where their piece is.

The real problems start when you try to track the details that matter:

• Client preferences — Ring sizes, metal preferences, stone choices, allergies, budget ranges. These live in emails, notes apps, and your memory. A spreadsheet row can't hold a rich client profile.
• Design iterations — Clients change their minds. The original brief evolves through three consultations. Tracking revision history in a spreadsheet means adding columns until the sheet is unreadable.
• Materials and costing — Gold prices change. You need to track what was quoted, what was ordered, and what was actually used. Spreadsheet formulas can do this, but they break the moment someone inserts a row in the wrong place.
• Communication history — When did you last update the client? What did you tell them? If your communication is scattered across email, phone, and messaging apps, the answer is always "I think it was last week."

What a Purpose-Built System Looks Like

The right tool for commission tracking isn't a generic CRM or project management app. Those tools don't understand the language of jewelry — they'll make you adapt your workflow to their structure instead of the other way around.

A purpose-built commission tracker gives you:

• A visual pipeline — See every active commission at a glance, grouped by stage. Know instantly which pieces are waiting for client approval, which are in production, and which are ready for collection.
• Rich client profiles — Store preferences, measurements, past orders, and notes in one place. When a returning client calls, you know their history before they finish their sentence.
• Consultation scheduling — Book design consultations, send reminders, and log what was discussed — all linked to the commission record.
• A client portal — Give your clients a branded space where they can see their commission progress, approve designs, and access documents. It's a better experience for them and fewer "any updates?" messages for you.

The Cost of Not Switching

Every jeweler we've spoken to who tracks commissions in spreadsheets has the same stories. A client detail that got lost. A follow-up that was forgotten. A piece that sat finished on the bench for a week because nobody updated the status. These aren't catastrophic failures, but they add up — in wasted time, in missed revenue, and in the occasional awkward conversation with a client.

The irony is that most jewelers got into the craft because they love making beautiful things. The last thing they want is to spend their evenings maintaining a spreadsheet.

Making the Switch

If you're a Shopify jeweler, the switch is simpler than you think. JewelryStudioManager was built specifically for this — it lives inside your Shopify admin, syncs with your store data, and replaces the spreadsheet with a proper commission management system.

You don't need to migrate years of data on day one. Start with your active commissions, get comfortable with the workflow, and expand from there.

Ready to ditch the spreadsheet?

Try JewelryStudioManager or see all our tools.

Related reading: Best Jewelry CRM Software in 2026 · Best Jewelry CRM Alternatives for Independent Designers in 2026 · Best Shopify Apps for Jewelry Stores in 2026 · Jewelry Valuation Software: What to Look For · JMS Dev Lab — jewellery software.

Part of our jewellery software series — explore the full jewelry store software suite for Shopify.