company project · ongoing
As Jewels Jewelry ERP
B2B jewelry operations ERP — master catalog, cart-to-SO flow, PO/job cards, diamond/gold/labour rate settings, bulk Excel catalog upload, sales/purchase invoices, and audit logging.
Master Catalog — Product management
Problem
Jewelry businesses needed end-to-end operations management — from catalog masters and configurable pricing to purchase orders, job cards, and invoicing — with bulk data import from Excel.
Solution
Built a full jewelry ERP with master catalog, bulk Excel upload (catalogAdder), cart → sales order → purchase order → job card workflow, rate settings, and RBAC with audit trails.
Architecture
React 19 + Vite frontend with Redux and Tailwind 4. Express + MongoDB backend with Socket.IO real-time updates, AWS S3 file storage, and xlsx/exceljs bulk import pipeline.
Business Impact
Unified jewelry operations from catalog management through invoicing, eliminating manual Excel catalog updates and fragmented order tracking.
Technical Decisions
- MongoDB for flexible catalog schema with nested stone/diamond details
- Settings-driven pricing engine over hardcoded rate logic
- Vitest for critical workflow unit tests
Feature Breakdown
Responsibilities
- Architected cart-to-SO-to-PO-to-job-card workflow for jewelry operations
- Built bulk Excel catalog upload pipeline with validation and catalogAdder scripts
- Implemented diamond/gold/labour rate settings with settings-driven pricing rules
- Developed RBAC middleware, audit logging, and PDF/print export modules
Challenges
- Modeling complex jewelry pricing (gold, diamond, labour) with configurable rate rules
- Handling large bulk Excel catalog uploads with validation and error reporting
Performance Considerations
- Streaming Excel parsing for large catalogs
- Socket.IO for real-time order status updates
Lessons Learned
- Bulk Excel pipelines need clear validation feedback — users must understand import failures
- Audit logging is essential for financial and catalog mutations in jewelry ERP