SpotBook: Initial Production Deployment

The Context & Problem

Trade expos are high-intensity 3-day events where jeans manufacturers take bulk orders worth crores from hundreds of visiting Retailers linked to that city's distributor.

Before SpotBook's initial deployment for P10 Denim / MG Sales, sales reps wrote down hundreds of order items manually on paper slips. At peak hours, two reps would unknowingly sell out the same limited stock to different retailers, leading to post-expo cancellation chaos, angry retailers & distributors, and zero real-time sales reporting for the manufacturer.

The Solution

In 15 days, I architected and built the first SpotBook production deployment — a progressive web app (PWA) tailored for noisy, fast-paced expo environments. It was the initial deployment, not a claim that every later platform capability already existed.

• Role-Based Access: Admin dashboard, Sales Agent interface, and Distributor view.
• Mobile QR Scanning: Sales staff scan sample tags using their phone camera to instantly pull up product variants and stock levels.
• Real-Time Stock Locks: Prevents overbooking with DB-level pessimistic locking during checkout.
• Automated WhatsApp Receipts: Instant PDF/text receipt generated and pushed directly to the distributor's phone upon order placement.