Loading...
Loading page contentLoading...
Loading page contentCustom ERP system and e-commerce platform for a leading Cyprus jewellery retailer, addressing the unique inventory and operational challenges of the jewellery industry.
Carats operates multiple retail locations across Cyprus, selling gold, silver, platinum, and diamond jewellery alongside watches and accessories. Jewellery retail presents inventory and operational challenges that generic ERP and e-commerce platforms are not built to handle. Every piece in a jewellery store is effectively unique — even two gold rings of the same design differ in exact weight, and their value fluctuates daily with precious metal spot prices. Tracking inventory by SKU alone, the way an appliance or clothing retailer would, simply does not work.
Carats was managing inventory across stores using a combination of spreadsheets, a legacy point-of-sale system, and manual stock counts. Pricing was recalculated by hand when gold prices moved, inter-branch transfers were tracked on paper, and there was no unified view of stock across locations. The business had no online sales channel, missing an increasingly important segment of customers who research and purchase jewellery online.
The company needed two things: a purpose-built ERP system that understood jewellery — tracking by individual piece, pricing by weight and material, supplier consignment management, and multi-store visibility — and an e-commerce store that could sell online while staying perfectly synchronised with physical store inventory so that a ring sold in-store would instantly disappear from the website.
Techlink ran the project on two parallel tracks with a shared data layer. The ERP track began with an intensive discovery phase where our team spent time in the Carats stores and back offices, documenting every workflow from goods receipt and consignment tracking to daily gold-price repricing and inter-branch transfers. We mapped the data model around the fundamental unit of jewellery retail: the individual piece, with its weight, material, purity, gemstone details, certification, supplier provenance, and location history.
The e-commerce track ran concurrently, with the WooCommerce store designed to consume inventory data from the ERP in real time. Rather than maintaining two separate product databases, the ERP serves as the single source of truth, and the online store reflects its current state. This architecture ensures that omnichannel fulfilment — buy online and pick up in-store, or browse online and reserve for in-store viewing — works reliably without overselling.
The ERP system, built on .NET with an Angular front end and SQL Server on Azure, gives Carats complete control over their jewellery operations. Every piece entering inventory is registered with its material, purity (karat for gold, grade for diamonds), weight, supplier, cost basis, and certification details. The pricing engine recalculates retail prices automatically based on daily precious metal spot prices, applying per-category markup rules and accounting for labour and gemstone valuations. Multi-store support provides a consolidated inventory view with inter-branch transfer workflows, and consignment tracking manages pieces held on behalf of suppliers with automated settlement reporting.
The e-commerce store on WooCommerce presents the Carats catalogue in a consumer-friendly format with bilingual support in Greek and English, high-resolution imagery with zoom, filtering by jewellery type, material, and price range, and secure checkout with local payment processing. Real-time inventory synchronisation between the ERP and the online store ensures that an item sold in any physical location is immediately removed from the website, eliminating the risk of double-selling unique pieces.
We'd love to achieve results like these for your business too.
Let's TalkSee all services