Jewelry ERP Software: What Small Studios Need

Why jewelers keep hearing about ERP

At some point, every growing jewelry studio hits the same wall. You've outgrown spreadsheets. Your Shopify inventory count says you have 14 pairs of a certain earring, but your actual stock is 9 because the other 5 were cannibalized for gold to fill a custom order. Your material costs are a moving target because gold has gone from $1,800/oz to over $3,000/oz in under three years. You Google "jewelry inventory software" and every result says you need an ERP.

The jewelry trade press reinforces this. Industry consultants recommend PIRO, Katana, or custom-built systems. The word "ERP" gets thrown around as if it's the natural next step after spreadsheets. But the gap between "I need better inventory tracking" and "I need an enterprise resource planning system" is enormous — in cost, complexity, and implementation time.

The question isn't whether you need better tools. You do. The question is whether you need that tool.

What traditional ERPs offer (and cost)

Full-featured jewelry ERPs like PIRO and Katana are built for manufacturing operations at scale. They handle multi-department workflows, capacity planning, demand forecasting, shop floor scheduling, supplier management with purchase order automation, and multi-location warehouse tracking. PIRO adds jewelry-specific modules for stone inventory, certification tracking, and job costing across dozens of workstations.

These are genuine capabilities. If you run a 30-person workshop with a casting department, a setting department, a polishing line, and a retail showroom — you may genuinely need them.

But for a studio with 1–8 people? The numbers tell the story:

System	Monthly cost	Implementation time	Target size
PIRO	$500–$2,000+	3–6 months	20–500+ employees
Katana	$299–$799	~6 weeks	10–200 employees
NetSuite (Oracle)	$1,500+	4–12 months	50–10,000+ employees

Those implementation timelines aren't optional. Traditional ERPs require data migration, workflow mapping, user training, and ongoing configuration as your processes change. A $500/mo PIRO subscription with 3–6 months of setup — plus consultant rates for configuration — can easily cost $10,000–$15,000 in the first year before anyone on your bench has logged in.

And here's the part nobody mentions in the sales demo: most of those features will sit unused. A 3-person studio doesn't need MRP scheduling. You don't have multiple plants to coordinate. Your demand forecasting is "I check my Shopify orders and talk to my two wholesale accounts." Paying for enterprise capacity planning when you can see your entire production queue from your workbench is not a wise use of capital.

What small jewelry studios actually need

Strip away the enterprise features, and what remains is a focused set of jewelry manufacturing capabilities. These aren't nice-to-haves — they're the specific things that spreadsheets and generic inventory apps cannot handle for this trade.

Materials tracking by weight, not just unit count

Jewelry materials are measured in grams, pennyweights, and troy ounces. When you buy 50 g of 14K yellow gold wire, you don't use it in discrete units — you cut what you need, and the remainder goes back in the drawer. Your inventory system needs to track fractional weights down to 0.01 g, convert between dwt and grams on the fly, and deduct material by weight when you complete a build. (For a deeper look at why this matters, see our guide to tracking raw materials for Shopify jewelry businesses.)

Bills of materials with waste factors

A BOM for a sterling silver cuff bracelet might call for 28 g of 925 silver sheet, 2 g of hard solder, and a fabrication waste factor of 12%. That waste factor is real — it accounts for filing, sanding, and the silver dust in your catch tray. Your BOM needs to reflect it, or your COGS will be understated on every single piece. Generic inventory tools don't have a concept of waste factors. Jewelry manufacturing software must.

Live precious metals pricing

Gold, silver, platinum, and palladium prices change every market day. When your material cost is dominated by precious metals — and for most fine jewelry, it is — your COGS is only accurate if it reflects current spot prices. A ring with 8 g of 18K gold cost you very different amounts to make in January versus April. We cover the full math in our guide to COGS tracking with volatile gold prices.

Shopify integration that works in real time

If you sell on Shopify, your inventory software needs to talk to your store — not once a day, not hourly, but in real time. When you complete a build order and add 3 finished rings to stock, Shopify should reflect that immediately. When a customer buys one, your manufacturing inventory should deduct the materials within seconds, not on a batch sync overnight. The gaps in Shopify's native inventory for jewelers are well documented — the question is how your tools fill them.

Serialized inventory for one-of-a-kind pieces

A production jeweler making 200 identical pairs of earrings can get by with quantity-based inventory. But if you make bespoke or limited-edition pieces — an 18K ring with a specific 1.4 ct Montana sapphire — that piece needs a serial number, a full material provenance trail, and a record of every operation performed on it. This is table stakes for fine jewelry. Most ERPs support serialization, but so should any jewelry-specific tool worth using.

Outsourced job tracking

Very few small studios do everything in-house. You send waxes to a caster, stones to a setter, finished pieces to a plater or engraver. Each of those handoffs involves sending material out, tracking turnaround time, receiving product back, and recording the cost. Your software should track these vendor jobs the same way it tracks in-house production — as steps in the manufacturing process, not as footnotes in a spreadsheet.

Pricing that reflects actual material cost

When gold is at $3,100/oz and your 14K ring uses 6 g of alloy, the metal cost alone is roughly $115. Add a 0.5 ct diamond, labor, casting, finishing, and overhead — and you need your pricing to reflect all of it accurately. We wrote an entire guide to pricing handmade jewelry around this calculation. The point here is that your software should make this math automatic, not something you rebuild in a spreadsheet every time spot moves.

The "just enough" approach

There's a category emerging between spreadsheets and full ERP: jewelry studio software. It's built for the specific manufacturing workflows that jewelers need, without the enterprise overhead they don't.

You don't need MRP scheduling if your production queue is a whiteboard and a stack of job envelopes. You don't need demand forecasting models if your best forecast is "holiday season is coming." You don't need multi-plant capacity planning if your entire operation fits in 800 square feet.

What you need is the jewelry-specific manufacturing layer that sits between your Shopify store and your bench — tracking what you have, what it costs today, what goes into each piece, and what's ready to sell. That's not an ERP. That's a focused tool built for how jewelers actually work.

Comparison: your actual options

Capability	Full ERP (PIRO/Katana)	Jewelry studio software	Craftybase	Spreadsheets
Weight-based tracking (g, dwt, ozt)	Yes	Yes	Partial (no dwt)	Manual
BOMs with waste factors	Yes	Yes	No waste factors	Manual
Live spot pricing	Some (add-on)	Yes	No	Manual
Shopify integration	Batched / third-party	Real-time, embedded	Hourly+ import	None
Serialized inventory	Yes	Yes	Batch only ($199/mo)	Manual
Outsourced job tracking	Yes	Yes	No	Manual
Metal purity/alloy fields	Yes (configured)	Yes (native)	No	Manual
Stone tracking (ct, grade, cert)	Yes (configured)	Yes (native)	No	Manual
Implementation time	3–6 months	< 2 hrs	2–5 hrs	Ongoing forever
Monthly cost	$300–$2,000+	$49–$99	$24–$199	$0 (+ your time)

For a deeper comparison between Craftybase and jewelry-specific tools, see our Craftybase alternatives guide.

How to evaluate before you commit

Before you sign up for any jewelry manufacturing software — ERP or otherwise — ask these questions:

• Does it track materials by weight natively? If you have to convert everything to unit counts, it's not built for jewelry.
• Can it pull live spot prices? If your COGS is only as current as your last manual entry, you're flying blind when metals move.
• How does it connect to Shopify? "Integration" can mean anything from real-time embedded sync to a daily CSV export. Ask specifically.
• Does it handle outsourced operations? If you send work to a caster or setter, your software should track that workflow — not just the in-house steps.
• What does implementation actually involve? Ask for a realistic timeline in hours, not a marketing answer. If it takes 60 hours to set up, factor that into your decision.
• What's the total first-year cost? Add the subscription, implementation, training, and any add-ons. A $299/mo tool with $5,000 in setup costs is a $8,588 first year.
• Can you try it with your actual data? A demo with sample data proves nothing. Import your materials, build a real BOM, run a production order. That's the test.

What Forge does differently

Forge is jewelry manufacturing software built for Shopify studios with 1–30 people. It is not an ERP. It doesn't try to be. Here's what that means in practice:

Shopify-embedded from day one. Forge lives inside your Shopify Admin. You don't toggle between tabs or wait for a sync cycle. When you complete a build order in Forge, your Shopify inventory updates in real time. When a customer places an order, Forge deducts the raw materials from your stock immediately. There is no integration to configure — it's native.

Jewelry-specific from the data model up. Every material in Forge has fields for purity, alloy color, and weight unit. Every stone tracks carat weight, grade, and certification. Every BOM includes waste factors. These aren't custom fields bolted onto a generic platform — they're the foundation the software was built on. We didn't adapt a candle-making tool for jewelry. We started at the jeweler's bench.

Live spot pricing, always. Forge pulls current gold, silver, platinum, and palladium prices and updates your material costs and COGS calculations automatically. When spot moves, your numbers move with it. No manual updates, no stale averages from last quarter's purchase orders.

Priced for studios, not factories. Full ERPs charge $300–$2,000+ per month because they're built for large operations with large budgets. Forge is priced for the studio jeweler who needs manufacturing-grade tools without the manufacturing-grade invoice. Implementation takes hours, not weeks.

Every feature earns its place. We don't ship features jewelers don't use to check boxes on a comparison chart. No demand forecasting. No multi-plant scheduling. No capacity planning algorithms. Instead: weight-based tracking, multi-level BOMs, production orders, vendor job management, serialized inventory, and live metals pricing. The features that matter at the bench, and nothing else.