ERP for Jewellery and Luxury Retail in the UAE: Serial Tracking, Valuation and Multi-Store Control

Jewellery retail in the UAE is a high-value, low-count business with an unusual set of system requirements. Stock is small, portable and expensive. Prices change daily with the gold rate. The same piece may move between a showroom in Deira, a mall boutique and a workshop in the same week. And the regulator expects a dealer in precious metals and stones to know its customer and report large cash transactions.

Most retailers run a point-of-sale system that sells pieces, a spreadsheet that values stock at month end and a handwritten register for the workshop. Each is fine on its own. Together they produce the two problems we are called in to fix most often: stock that cannot be reconciled across stores, and a valuation that nobody fully trusts. This guide covers what an ERP has to do for a jewellery or luxury retailer, and the configuration decisions that matter.

The piece is the unit, not the design

A fashion retailer manages a style in sizes and colours. A jeweller manages a design in individual pieces that differ in weight, stones, cost and sometimes certificate. The system model that works is a product for the design, and a serial number for each physical piece, with the piece-level attributes stored against the serial.

Loose stones, bullion and findings are the exception: they are quantity-tracked by lot or weight rather than serialised, and they become serialised the moment the workshop sets them into a finished piece.

Pricing from the daily gold rate

Gold jewellery in the UAE is sold on the day's rate plus making charge, and customers expect the shop price to track the published rate. The configuration we recommend keeps three components on the price: metal value, which is weight multiplied by purity multiplied by the rate; making charge, as a per-gram or fixed amount; and stone value. The rate is maintained once per day, centrally, and every store's POS uses it.

This structure does more than save retagging. It makes the margin on each sale readable by component, it lets you run promotions on making charges without touching the metal price, and it supports the common practice of exchanging old gold at the day's rate as part payment. Diamond and branded luxury items are typically fixed-price, and the same product record can hold a fixed list price instead of a rate-driven one.

Multi-store control and the stock count

Every showroom, display case, safe, workshop bench and consignment partner is a stock location. A piece moves between them only by a recorded transfer, scanned out and scanned in, with the person responsible named on each side. That sounds obvious, but it is the discipline most retailers lack, and it is why a monthly count turns into a two-day exercise.

With serialised pieces and scanning, a count is a matter of walking the cases with a scanner and reviewing the exceptions. Daily case counts at open and close become feasible, and the difference between "missing" and "in transit to the other store" is visible in the system rather than discovered a week later. Consignment stock held by partners or placed with a customer on approval sits in its own location, still owned by you, still valued, and still counted.

Valuation that finance and the owner both trust

Stock valuation is where jewellery accounting differs from most retail. The cost of a piece is known, but the owner also wants to see the stock at today's metal value, and the two numbers answer different questions. The ERP should hold cost on each piece for the books and produce a market-value report by applying the current rate to the metal weight on hand, with stones and making charges at cost.

Scrap, old gold taken in exchange, and metal issued to the workshop each need their own accounting treatment, and the loss in the workshop needs to be measured against a tolerance rather than absorbed silently. Insurance also depends on an accurate schedule of what is where, which the location-based model provides for free.

Workshop, repairs and custom orders

Many UAE jewellers make or finish pieces in their own workshop. The flow in the ERP is a job order that issues metal by weight and stones by serial or lot, records labour and any outsourced steps such as setting or polishing, and completes by creating a finished piece with its own serial number and a cost built from the inputs. Metal loss on the job is calculated from issued weight minus returned weight minus finished weight, and reported by craftsman and by job.

Customer repairs and resizing use the same mechanism with one difference: the customer's item is not your stock. It is received into a dedicated customer-items location, worked on, and returned, with the service charged on an invoice. Custom orders start as a quotation with a design reference and a deposit, become a job when the deposit clears, and close with the sale of the finished serialised piece.

VAT and anti-money-laundering records

Retail sales of jewellery to consumers are standard rated at 5 percent. Wholesale supplies of gold and diamonds between VAT-registered businesses can fall under the reverse charge mechanism introduced for the sector, which changes who accounts for the VAT and what the invoice must state. The ERP should apply the right treatment based on the customer type and the product category rather than relying on the cashier.

Dealers in precious metals and stones in the UAE are also subject to anti-money-laundering obligations, including customer due diligence and reporting of cash transactions above the threshold set by the Ministry of Economy. Practically, the point-of-sale flow needs to capture customer identification on qualifying transactions, flag cash sales above the threshold and retain the records for the required period. Building this into the sale screen is far easier than reconstructing it for an inspection.

The UAE e-invoicing mandate will also reach the sector. Business-to-business supplies to other dealers will need to be issued as structured invoices through an accredited provider, with the first phase set for 1 January 2027 for larger businesses and a second phase from 1 July 2027. Our e-invoicing page covers what to prepare.

Customer relationships and the second sale

Jewellery is a repeat and referral business. The ERP should keep the purchase history, certificates, sizes and preferences on the customer record so a sales associate in any store can see them, and so anniversaries and occasions can drive a well-timed message rather than a generic campaign. Loyalty, gift cards and layaway or instalment plans are all common in the UAE market and should be configured in the POS rather than tracked on paper.

How Kaido approaches it

We begin by walking the physical flow of a piece through the business: supplier receipt, tagging, allocation to a store, display, sale, exchange, repair, return to supplier. Each step becomes a location or a transaction in the design, and the people responsible at each step become the users who will scan it. We then settle the pricing model, the valuation reports and the compliance capture before any screen is configured, because changing those after go-live is expensive.

For most retailers of this size we implement on Odoo, where serial tracking, multi-location stock, point of sale, manufacturing orders for the workshop and accounting sit in one system, with the gold-rate pricing and AML capture handled through configuration and light customisation. We have done this for jewellers with showrooms and workshops across the UAE, and the pattern that holds is the same every time: the system only earns trust when every movement is scanned at the moment it happens, so we put most of the training effort on exactly that.