Why Shopify Inventory Doesn't Work for Jewelry Makers

Shopify is an excellent platform for selling jewelry online. But if you manufacture, assemble, or source materials for the pieces you sell, you've probably noticed something: Shopify tracks units. You track weight.

A fulfilled Shopify order decreases a SKU count by one. It doesn't deduct 4.2 dwt of 18K rose gold, a 0.50ct round brilliant diamond, and a 14K prong setting from your raw material inventory. That disconnect is the reason most jewelry makers end up managing inventory in spreadsheets alongside Shopify — and the reason those spreadsheets eventually fail.

The gap between Shopify and the bench

Shopify handles finished goods well. When a customer buys a ring, Shopify decreases the ring count from 1 to 0. That's fine for resellers who buy finished pieces and sell them.

But if you're a jeweler who buys gold, silver, platinum, gemstones, and findings — then transforms those raw materials into finished pieces — Shopify has no concept of:

• Materials tracked by weight. Your 14K yellow gold stock is measured in grams or pennyweight, not units. Shopify doesn't support weight-based inventory.
• Bills of materials. A solitaire ring requires 3.2 dwt of 14K gold, one 0.50ct diamond, and a prong setting. Shopify has no way to define that recipe or deduct those components when the ring is built. (We walk through what a proper BOM looks like in detail.)
• Production workflows. When an order comes in for a made-to-order piece, you need to check material availability, allocate stock, build the piece, and deduct materials upon completion. Shopify's order system knows nothing about manufacturing.
• Live metal pricing. Gold has moved between $4,500 and $5,600 per troy ounce in the past year. Your cost per piece changes every day, but Shopify's inventory has no concept of spot pricing or COGS that fluctuate with the metals market. (See our COGS calculation guide for the full math on how this affects margins.)
• Serialized inventory. Every one-of-a-kind piece and certified gemstone needs individual tracking — not just a count of how many you have, but which specific stone went into which specific ring for which specific customer.

This isn't a Shopify limitation that affects all merchants. It's specific to manufacturers, makers, and anyone who transforms raw materials into finished goods. Jewelers feel it more acutely than most because of the weight-based tracking, precious metal pricing, and the high value of individual components.

What jewelers actually do today

Based on conversations with jewelry makers across the country, the workarounds fall into a few categories:

Spreadsheets

The most common approach. A Google Sheet or Excel file that tracks metals by weight, stones by piece, and tries to keep material costs current. It works until it doesn't — which is usually when gold moves significantly, when you forget to update after a build, or when you hire your second jeweler and both of you are updating the same file.

Craftybase

A popular tool among handmade makers that offers material tracking and basic BOMs. It integrates with Shopify via a sync connection. The limitation for jewelers: it was designed for all makers (candles, soaps, cosmetics, food) and doesn't have jewelry-specific fields like metal purity, alloy color, carat weight, or stone certification. It also isn't embedded in Shopify — it's a separate app with a separate login, which means context-switching between systems. (We cover the full Craftybase comparison in a separate post.)

Katana or similar MRP systems

Manufacturing resource planning tools that handle BOMs, production orders, and inventory. Powerful, but priced for factories ($179–799/month) and designed for general manufacturing. They don't know what a pennyweight is, have no concept of metal purity, and require significant configuration to adapt to jewelry workflows.

Memory

More common than anyone admits. Experienced jewelers who've been at the bench for decades can eyeball their stock and know when to reorder. This works for a solo artisan but breaks down the moment anyone else needs to know what's in inventory.

What a Shopify jewelry inventory app actually needs to do

If you're evaluating inventory and production tools for your jewelry business on Shopify, here are the capabilities that matter:

Track materials by weight, not just count. Metals in grams, pennyweight (dwt), or troy ounces. Stones in carats or by piece. Findings and packaging by unit count. A single system that handles all of these natively.

Support multi-level bills of materials. Define the recipe for each product: what materials, in what quantities, with what waste factor. Nested sub-assemblies — like a setting that itself has a BOM — should be supported. The total material cost should calculate automatically from current stock values.

Connect BOMs to Shopify products. When an order comes in for a product that has a BOM, the system should know which materials are needed and whether they're available.

Deduct materials automatically. When a build is completed, the component materials should decrement from inventory without manual adjustment. The transaction should be logged for audit purposes.

Push inventory back to Shopify. Finished goods quantities should sync to Shopify so your online store reflects what's actually available.

Live inside Shopify Admin. An embedded app that uses Shopify's authentication and appears in the sidebar — no separate login, no tab-switching, no CSV export/import cycles between systems.

Handle the pricing reality. With gold at current levels, your cost per piece changes daily. A jewelry inventory app should either integrate with spot pricing feeds or make it straightforward to update material costs and see the impact on your product COGS immediately. (We cover how to price jewelry when material costs keep moving in a separate guide.)

Support the way jewelers actually work. Metal purity (10K, 14K, 18K, 22K, 24K, 925, 950 platinum). Alloy color (yellow, white, rose). Stone attributes (shape, cut, color, clarity, certification). These aren't nice-to-have fields — they're how jewelers describe and differentiate their materials.

The cost of not solving this

Most jewelers absorb the cost of manual inventory management without calculating it. A few data points from maker conversations:

Time. 5–10 hours per week on inventory management, production tracking, and ordering — operational work that isn't actually making jewelry. At $50/hour, that's $250–500/week in uncompensated labor, or $1,000–2,000/month.

Margin erosion. When gold moves 10% in a month and your material costs aren't updating, you're either overcharging (and losing sales) or undercharging (and losing margin). Either way, you're making decisions based on stale data.

Stockouts and overselling. Selling a piece and then discovering you don't have the stone or the metal to make it means rush orders from suppliers (expensive), delayed fulfillment to customers (reputation damage), or both.

Scaling limitations. A solo artisan can manage inventory in their head. A studio with 3–5 jewelers cannot. The moment you add a second person to the bench, you need a shared system of record. Most studios hit this wall and either stay small or suffer through chaotic growth.

What to look for in a Shopify jewelry inventory app

If you're searching for a solution, prioritize these criteria:

Jewelry-specific, not adapted. A tool built for jewelry should understand purity, alloy color, carat weight, and stone certification at the data model level — not as custom fields bolted onto a generic system.

Shopify-native. Embedded in Shopify Admin, using Shopify's authentication and billing. Real-time sync via webhooks, not periodic CSV imports.

Priced for studios, not factories. A solo artisan or 2–8 person studio shouldn't need to spend $300+/month on an ERP designed for manufacturing plants.

Handles both standard and outsourced production. Many jewelers outsource some steps — casting, stone setting, finishing — to trade shops. The tool should track jobs sent to vendors and reconcile materials when they return.

Grows with you. Start with basic material tracking and BOMs. Scale into serialized inventory, outsourced job orders, live metals pricing, multi-location management, and customer tracking as your business grows — without switching tools.