25+ years in the jewellery industry means encountering the same problems over and over — and building systems that actually solve them. These case studies document what went wrong, what we built, and why it works.
When branches share database tables, one heavy query from any branch slows down every other branch. The fix: branch-isolated tables within a single database. How we implemented it and why it eliminated all branch-contention problems.
A large jewellery company where staff edited the database directly. Reports that couldn't be trusted. The complete redesign: department isolation, same-day rollback restriction and mandatory daily balancing that restored data integrity.
Current gold rate margin and historical purchase cost margin answer different questions. Using only one gives a misleading picture. The hybrid dual-rate method that shows management both simultaneously — and why each matters.
OGP fraud is one of the hardest control problems in jewellery retail. The 9-stage end-to-end system: customer SMS at purchase, OTP verification, real-time head office visibility, dispatch notes, in-transit tracking and pending action workflow.
Sudarshana is the founder of Jwellex and Nextcode Solutioons Pvt Ltds, a Sri Lankan software company specialising in jewellery management systems. With over 25 years of direct experience in the jewellery industry, he has designed and implemented software solutions for jewellery retailers, wholesalers and manufacturers across Sri Lanka.
The case studies on this site document real problems encountered during that work — and the architectural decisions, system designs and implementation approaches that solved them. They are written for jewellery business owners and managers who want to understand the principles behind good jewellery management software, not just its feature list.
Jwellex is used by 30+ jewellery businesses across Sri Lanka, including some of the country's leading retail networks and manufacturers. We do not publish customer names without permission, but references are available on request.