Michael Gabriels / Gemstone Hub

From a Shopify order to the shop floor.

A custom jewelry ERP connecting orders, design, materials, production and fulfillment.

All selected work
GEMSTONE HUBDesign study / Sample records
Emerald-cut center stone in an eighteen-karat gold ring, with twelve shoulder diamondsGH–1042 / One piece. Every detail.
THE PIECE & ITS PROMISE

Made with care.
Tracked with care.

Center stone2.10 ct
Shoulder diamonds12 × 0.02 ct
Setting18k yellow gold
12 stones reserved8 available

Every material belongs to a decision.

Built for
Michael Gabriels
The work
Custom ERP · Integrations · Production workflows
Industry
Manufacturing & Jewelry

The decisions behind the build

Why it works this way.

01

What made it difficult

A stone can be in the workshop and already promised to another piece. A physical count alone cannot tell the next order what is available.

02

What we chose

Keep on-hand stock, reservations, and consumption distinct. Attach the reservation to the work order so the production decision has an explanation.

03

What someone can do

Reserve twelve stones for one piece, see eight remain available, and release the reservation without changing the physical count.

The sample below isolates the reservation rule from Gemstone Hub’s order and materials workflow.

Interactive example · Fictional records

Opening the sample workflow…

Try it Replay the reservation below. Watch what stays on hand and what becomes unavailable to other orders.

Watch the full Gemstone Hub story

Understanding the operation

The work behind the example.

Jewelry manufacturing has a language of its own. A design becomes a bill of materials. Stones need to match. A piece moves between specialists before it is ready to ship. Gemstone Hub brings those details into one connected operating system for Michael Gabriels.

More about the operating constraints

An online order is only the start. Production needs the right design, parts, people and sequence of work behind it.

Inventory includes certified stones, small diamonds, findings and metals, each with different rules for selection and allocation.

Office staff, the shop floor and outside vendors need a shared view of what a piece needs next.

The connected workflow

  1. 01Order
  2. 02CAD
  3. 03Materials
  4. 04Casting
  5. 05Bench
  6. 06QC
  7. 07Ship

What we built

01

A production system

Work orders, CAD, casting, bench work and quality control, organized around how jewelry is actually made.

02

Materials in context

Bills of materials, stone matching, inventory allocation and vendor purchasing connected to the work that needs them.

03

Connected handoffs

Shopify, design files, the shop floor and outside partners connected through specific workflows and activity records.

For the operator

What the system makes possible.

  • A work order provides a continuous thread from the original order to the piece moving through production.
  • Material availability, production stage and responsibility can be understood in context.
  • Separate contractor, runner and vendor views support the people outside the main office.

A better way to work

Does your operation have this many moving parts?

Tell me where things get complicated. We can start with one order, one handoff, or one spreadsheet your team depends on.