Ornament System: Jewellery Shop Management Platform

Overview

A full-stack inventory, sales and invoicing system built to replace a legacy Visual Basic 6 desktop application for a family-run jewellery shop, including migrating its legacy Access database to PostgreSQL.

What it does

• Tracks inventory with generated barcodes and grouped stock.
• Runs the full sale flow (item selection, gold-rate-based pricing, GST, draft and completed states) with exact decimal money math.
• Prints bilingual (Marathi and English) invoices, and tag sheets laid out for 70 x 136 mm labels (physical print calibration pending).
• Keeps staff login (NextAuth) separate from a public customer registration flow with its own signed session (SMS delivery not yet integrated).
• Uses row-level locking on payments, so two simultaneous submissions cannot overpay an invoice.
• Tests: 276 Vitest tests and 51 Playwright end-to-end tests. In the latest run all Vitest tests passed and 50 of 51 Playwright tests passed (one known flaky selector).