CaratIQ — Modern Jewelry Management by Sparsh GuptaCaratIQ — Modern Jewelry Management by Sparsh Gupta

CaratIQ — Modern Jewelry Management

Sparsh Gupta

Sparsh Gupta

CaratIQ — Modern Jewelry Management & Catalog Platform
Managing dynamic jewelry inventories across multiple sales channels often breaks under traditional database models due to real-time pricing recalculations and complex SKU variations.
What I Built: • Dynamic Catalog & Multi-Attribute Filtering: Architected sub-150ms catalog searches handling live metal spot pricing, carat grades, and stone certification tiers without client-side lag. • Server-Rendered Architecture: Leveraged Next.js Server Components to offload bulk queries, significantly reducing initial client bundle size. • Automated Inventory & Invoicing Sync: Integrated custom webhooks and payment flows for instant stock reservation and order processing. • Role-Based Access Control: Built multi-tenant admin dashboards for floor staff, store managers, and suppliers.
Tech Stack: Next.js, React, Node.js, PostgreSQL, Tailwind CSS, REST APIs & Webhooks
Results: • Sub-150ms Query Speeds: Cut search and filtering latency by over 40% across extensive catalog datasets. • Zero Sync Collisions: Automated live price updates and inventory locks, eliminating overselling across peak sales windows.
The Outcome: Transformed a traditionally fragmented retail inventory system into a unified, high-speed SaaS platform that bridges in-store sales and digital catalog operations.
Like this project

Posted Sep 30, 2026

CaratIQ — Modern Jewelry Management & Catalog Platform Managing dynamic jewelry inventories across multiple sales channels often breaks under traditional dat...