# Yeprem Jewellery — Selling Luxury Online Without Overselling or Losing Trust

> A piece of jewellery can sell in a boutique while a customer is mid-checkout online. For a luxury brand, that's a serious problem — not just a logistics headache. We built real-time ERP sync and database-level transaction locking that makes overselling physically impossible.

## Project context

- Client: Yeprem Jewellery
- Industry: Luxury Retail
- Year: 2024

## Challenge

Boutique sales happen in real time, independently of the web store. Previous system updated web inventory on a 24-hour batch sync — meaning items could appear available online for up to a day after being sold in-store. High-ticket item overselling was an occasional reality that damaged client relationships and required manual intervention every time.

## Solution

Webhook-driven ERP integration: boutique systems fire events on every completed sale, updating web store inventory within seconds. SELECT FOR UPDATE transaction locking at payment initiation — the row-level lock is held for the transaction duration. Concurrent checkout attempts on the same item fail early (before payment) with a clear message. Zero oversells since launch.

## Services

- Web Development

## Published results

- 0 Overselling incidents (since launch)
- <10s Boutique-to-web sync latency (ERP webhook driven)
- 100% Transaction integrity (DB-level locking)
- 0 Customer-facing oversell messages (caught before payment)

## Benefits

- Physically impossible to oversell — row-level DB locking
- Real-time ERP sync — boutique sales reflected in seconds
- Arabic RTL and English storefronts both first-class
- Security-first API design for luxury-scale transactions

## Source and contact

- Canonical project page: https://qualityx.co/en/portfolio/yeprem-jewellery-ecommerce
- Discuss a related project on WhatsApp: https://wa.me/905392376734