Vercha Jewels: from stockouts to a live tracking dashboard
How a jewellery business replaced daily stockouts and order mistakes with one automated Google Workspace dashboard — and saw its error rate drop massively.
The challenge
Vercha Jewels ran its day-to-day operations on manuals, phone calls, and scattered spreadsheets. Stock moved fast, but the records didn't. The result was a familiar pair of problems: stockouts on items that were actually available, and order mistakes when records fell out of sync.
Nitin Verma put it plainly: "Stockouts and order mistakes were draining us." Every mismatch cost trust, time, and margin.
The solution
We built Vercha a custom Google Workspace system centred on a live dashboard. Every sale, purchase, and movement updates the sheet automatically, and the dashboard reflects it instantly.
- A single live dashboard showing stock, orders, and recent activity in real time.
- Automated record-filing so nothing depends on someone remembering to update a sheet.
- Order capture and tracking that keeps the unit, the record, and the customer aligned.
- Alerts that surface discrepancies instead of burying them.
The results
The change was immediate and visible. What the client described:
- "Everything is now tracked live on one dashboard."
- "Our error rate has dropped massively."
- Fewer stockouts because stock levels no longer rely on memory.
- A clear daily picture of the business with zero manual compiling.
Systems used
- Google Sheets live dashboard and inventory engine
- Google Apps Script automation for filing and alerts
- Google Forms for structured order capture
