ERP for a Jewelry Manufacturer

Jewelry manufacturing combines volatile economics with a very physical workflow. Suppliers quote in multiple currencies, gold and silver rates move daily, and the true cost of a piece depends on metal weight, alloy purity and labor markups buried in production data. On the floor, batches of jewelry physically travel between factory sections with paper vouchers, so the software had to strengthen — not replace — the signed chain of custody. For reliability, the client also required an on-premise production deployment on their private local intranet, with manual deployment pipelines favored over automated CI/CD to keep corporate control air-gapped.

We built a decoupled, API-driven platform: a Symfony backend with Doctrine ORM and API Platform generating secure REST endpoints, protected by JWT signatures and role-based access control, with a Vue.js / Nuxt single-page application on the front. Production runs on-premise on the factory intranet, with staging hosted on DigitalOcean and Sentry error monitoring. A spare parts and stones database feeds product recipes that specify the exact raw materials, labor steps and plating micron layers for each piece, while a pricing engine converts recorded bank exchange rates and precious metal indices into live THB-per-gram costs for gold, silver, rhodium and palladium. Purchase orders spawn automatically when stock falls below minimum order quantities, capture real landed costs on receipt, and spread bank charges, transport and customs across received items through a cost-spreading algorithm — with PO splitting to handle partial shipments. Digital stock cards log every movement, and material handovers require selecting a destination factory section and an assigned worker before a printable signed slip is generated. Production vouchers route each batch across Casting, Setting, Polishing, Plating and Quality Control with bulk transfer screens and A4 handover PDFs, while order modifications trigger dependency checks that lock affected vouchers until floor managers resolve them. On top, AI features run locally: an Ollama-served LLM and a Qdrant-powered visual search across tens of thousands of indexed product photos.