Skip to content
company project· ongoingProject 01 / 11

B2B Jewelry Operations ERP

B2B operations ERP — master catalog, cart-to-SO flow, PO/job cards, pricing settings, bulk Excel catalog upload, sales/purchase invoices, and audit logging.

  • React 19
  • Vite
  • Redux
  • Tailwind CSS
  • Express
  • MongoDB
  • Socket.IO
  • AWS S3
  • xlsx
  • Vitest

Workflow

  1. 01

    Cart

  2. 02

    Sales order

  3. 03

    Purchase order

  4. 04

    Job card

01

Problem

Operations teams needed end-to-end business management — from catalog masters and configurable pricing to purchase orders, job cards, and invoicing — with bulk data import from Excel.

02

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.

03

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.

04

Business impact

Unified jewelry operations from catalog management through invoicing, eliminating manual Excel catalog updates and fragmented order tracking.

Decisions

Technical decisions

  1. 01MongoDB for flexible catalog schema with nested stone/diamond details
  2. 02Settings-driven pricing engine over hardcoded rate logic
  3. 03Vitest for critical workflow unit tests

Features

Feature breakdown

  • Master Catalog
  • Bulk Excel Upload
  • Cart → SO → PO → Job Cards
  • Rate Settings
  • Sales/Purchase Invoices
  • RBAC
  • Audit Logs

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

Related engineering library

Explore more← All projectsEngineering library →