Executive Summary
When Vasundhra Jewellers Pvt. Ltd., a well-established retail jewelry business in New Delhi, approached Net Soft Solutions for a custom software development engagement, their core challenge was clear: the business had grown beyond what spreadsheets and manual registers could handle. They were losing track of stock, billing was slow and error-prone, and customer loyalty programs existed only on paper. Within six months of deploying a fully custom jewelry management platform, the results were transformative — billing time dropped by over 70%, inventory accuracy improved to 95%, and overall sales grew by 40%.
This case study walks through every phase of that engagement — from the initial business audit and requirement discovery, through system architecture and iterative development sprints, all the way to staff training, go-live, and measurable business outcomes.
About the Client — Vasundhra Jewellers Pvt. Ltd.
Vasundhra Jewellers Pvt. Ltd. is a second-generation, family-owned retail jewelry company headquartered in New Delhi, India. The company deals in gold, diamond, and silver jewelry, as well as BIS 916-hallmarked gold coins. With a loyal customer base built over two decades, the business was thriving but operationally strained.
The Managing Director had been exploring options for a jewelry shop management system for over a year, evaluating several off-the-shelf products. None of them fit the specific workflows of a multi-category jewelry business with exchange programs, gold savings schemes, karigar (artisan) job work, and a complex GST billing structure. That is when Net Soft Solutions was referred through a mutual business contact.
| Parameter | Details |
|---|---|
| Client Name | Vasundhra Jewellers Pvt. Ltd. |
| Industry | Retail Jewelry (Gold, Diamond, Silver) |
| Location | New Delhi |
| Showrooms | 1 showroom |
| Project Type | Custom Jewelry Management Software (ERP) |
| Development Partner | Net Soft Solutions, New Delhi |
| Project Duration | 22 Weeks (5.5 Months) |
| Technology Stack | ASP.NET Core, SQL Server 2019, HTML5 / Bootstrap, SMS & WhatsApp API |
The Business Challenges — What Was Broken Before
Before the custom software was built, Vasundhra Jewellers relied on a patchwork of manual processes, generic accounting software, and personal spreadsheets. The problem was not just inefficiency — it was the compounding cost of errors at scale. Read our related article on Custom Software Solutions for Retail Businesses in India to understand why these challenges are common across Indian SMB retail.
1. Inventory Without Visibility
With over 2,800+ SKUs covering necklaces, bangles, rings, earrings, pendants, and other types of jewellery, as well as coins in multiple purities — there was no single source of truth for stock. Physical stock-taking took 3–4 full days every month, pulling sales staff away from the counter. After the introduction of HUID (Hallmark Unique Identification) mandatory tagging by the Bureau of Indian Standards (BIS), the team struggled to track items individually without a digital system.
2. Billing That Slowed the Showroom
Every billing transaction required manually looking up the current gold rate, computing making charges, adding GST at the correct slab, and typing it into a printable Excel template. A single bill took 15–20 minutes on busy days. GST computation errors occurred regularly, causing reconciliation issues at month-end. Exchange of old gold involved even more manual calculation.
3. No Customer Loyalty or Scheme Management
Vasundhra Jewellers ran a popular Gold Savings Scheme — a monthly installment plan that allowed customers to buy jewelry at a discount after 12 months. But managing this was done in a paper register. Installment tracking, missed payments, maturity alerts, and birthday/anniversary reminders were all done manually. There was no loyalty points program whatsoever.
4. Karigar (Artisan) Job Work Was Untracked
Gold is sent to artisans (karigar) for custom jewelry making, repair, and modification. Keeping track of exactly how much gold was sent, in what purity, and what was returned involved handwritten notes — leading to disputes, purity loss miscalculations, and occasional shrinkage that could not be accounted for.
5. Reports Came Too Late to Be Useful
The Managing Director could only see a consolidated picture of the business at the end of the month, after the accountant spent 3–4 days pulling numbers from registers and Excel sheets. Category-wise profitability, top-selling items, stock valuation, and daily cash positions were never available in real time.
As highlighted in our article on Essential Features of a Jewellery Shop Management System and Their Business Benefits, these exact pain points are why purpose-built jewelry management software delivers a fundamentally different ROI compared to generic ERPs or spreadsheet workarounds.
Our Approach — How Net Soft Solutions Engaged
We do not believe in giving clients a pre-packaged software with their logo slapped on it. Every engagement at Net Soft Solutions begins with a deep business audit. Our methodology, described in detail on our company methodology page, involves understanding the client's actual workflows before writing a single line of code.
Phase 1: Requirements Discovery (Weeks 1–2)
Our team spent two weeks on-site at Vasundhra Jewellers showroom. We interviewed the Managing Director, the floor supervisors, the billing staff, the accountant, and the karigar coordinator. We mapped every process, timed every manual task, and identified every point of friction.
Key outputs from this phase:
- A Business Requirements Document (BRD) covering 68 distinct functional requirements
- A Process Flow Map showing the current state vs. the desired future state
- A Priority Matrix ranking features by business impact and development effort
- A Data Migration Plan for transferring existing stock data from Excel to the new system
Phase 2: UI/UX Design & Database Architecture (Weeks 3–5)
Once the BRD was signed off, our designers created wireframes for every screen — from the POS billing interface to the management dashboard. We prioritized ease of use for non-technical counter staff. The database schema was designed to handle jewelry-specific data points including HUID number, purity percentage, gross weight, net weight, stone details, and karigar records.
The client reviewed and approved the design prototype before any development began, ensuring zero misalignment later.
Phase 3: Agile Development in 4 Sprints (Weeks 6–14)
Development was organized into four two-week sprints, each delivering a working, testable module:
- Sprint 1: Core database architecture, user authentication, RBAC (Role-Based Access Control), and Gold Rate Engine
- Sprint 2: Inventory Management Module — HUID tracking, barcode generation, stock in/out, karigar job work module
- Sprint 3: POS / Billing Module — GST-compliant invoicing, old gold exchange, advance booking, receipt printing, WhatsApp bill delivery
- Sprint 4: CRM (Customer Relationship Management) — loyalty points, Gold Savings Scheme, SMS/WhatsApp automation; Reports module — stock valuation, sales reports, day book, MIS; Accounts module — ledger, outstanding, P&L
The development approach we followed aligns with best practices described in our article on The Custom Software Development Process for Small Businesses.
Phase 4: QA & User Acceptance Testing (Weeks 15–17)
Our QA team ran over 300 test cases covering functional testing, GST calculation accuracy, load testing for concurrent users, and edge case handling (e.g., partial old gold exchange, multi-product transactions). We also ran a UAT (User Acceptance Testing) session with actual counter staff from the showroom, refining the UI based on their feedback.
Phase 5: Data Migration & Deployment (Weeks 18–19)
The existing stock data — approximately 2,800 SKUs from Excel sheets and physical registers — was migrated, cleaned, and tagged into the new system. The software was deployed on an on-premises Windows Server 2022 machine at the showroom. We set up automated daily backups to an external NAS drive and a cloud storage bucket.
Phase 6: Staff Training (Weeks 20–21)
We trained all staff members at the showroom — from the MD and accountant down to billing staff and karigar coordinators. We created role-specific training manuals, screen-recorded video tutorials, and laminated quick-reference cards for counter staff. A WhatsApp support group was set up for instant resolution of queries during the first 30 days post-launch.