One platform for the showroom, the warehouse and the storefront.
Replacing spreadsheets with variant-aware inventory, barcode workflows and bi-directional Shopify sync — built on Next.js + MongoDB Atlas.
The client.
The client operates a wholesale clothing business across a physical showroom and a Shopify storefront. Before our work, every inventory decision lived in spreadsheets — sales, barcodes, stock and reporting were disconnected.
- ✕Spreadsheet-based inventory management
- ✕No barcode workflow
- ✕Slow showroom checkout
- ✕Recurring inventory mismatches
- ✕No centralized reporting
- ✕No unified dashboard
- ✕No real-time synchronisation
- ✓Build a single source of truth for inventory
- ✓Make showroom checkout instant
- ✓Sync stock, sales and products with Shopify both ways
- ✓Give the owner real-time business insight
How we built it.
A full-stack web application built with Next.js, MongoDB Atlas, the Shopify Admin API, a barcode system (bwip-js + BarcodeDetector API) and an analytics dashboard. Products are variant-first; every variant gets an auto-generated SKU and barcode; sales reduce stock everywhere in real time.
End-to-end flow.
Inside the platform.
Variant-first model. Each variant stores size, cost price, selling price, stock — profit margin is computed automatically.
- ◆Sizes: S / M / L
- ◆Auto profit margin
- ◆Variant-aware stock
Every variant gets a unique SKU and a CODE-128 barcode generated via bwip-js, ready to print directly from the dashboard.
- ◆Auto SKU (e.g. SP-4500-S)
- ◆CODE-128 generation
- ◆Printable sheets
USB scanner support on desktop, BarcodeDetector camera scanning on mobile — both open the same popup sales flow with negotiated pricing.
- ◆Instant variant lookup
- ◆Negotiation mode
- ◆Real-time stock −1
Products & variants push to Shopify as drafts; order webhooks pull sales back. Stock stays consistent in both directions.
- ◆System → Shopify: products, variants, inventory
- ◆Shopify → System: orders, stock, sales
Revenue, profit, units sold and remaining inventory — plus daily revenue and profit trends.
What it does.
Under the hood.
Measurable results.
Variant-first schema and stateless API routes mean new locations, users and Shopify stores can be onboarded without re-architecting.