How a ₹5Cr D2C Skincare Brand Cut Stockouts by 60% in 90 Days
A D2C skincare brand was losing ₹2L/month to stockouts. Here's how they connected Shopify, inventory, and warehouse data into one system — and reduced stockouts by 60% in 90 days.
The Problem
A ₹5Cr/year D2C skincare brand was growing fast — but their operations were falling behind.
What they were dealing with:
- 3 SKUs out of stock at any given time
- ₹2L/month lost revenue from stockouts
- Inventory tracked in Google Sheets
- Warehouse team using WhatsApp to report stock levels
- No visibility into which products were running low until it was too late
The root cause: Disconnected data. Shopify showed one thing, the warehouse showed another, and the founder found out about stockouts only after customers complained.
What We Did
Week 1-2: Audit & Architecture
We mapped their entire commerce stack:
- Shopify (storefront + orders)
- Warehouse (Bidadi fulfillment center)
- Manual inventory tracking (Google Sheets)
- WhatsApp-based communication
Key finding: Their Shopify inventory didn’t match warehouse inventory. 3 SKUs showed “in stock” on Shopify but were actually out of stock in the warehouse.
Week 3-4: System Setup
We connected their data sources into a unified commerce operating system:
- Shopify ↔ Warehouse sync — Real-time inventory levels
- Stockout alerts — Automated detection when inventory drops below threshold
- Daily brief — Morning email with top risks, actions, and revenue
- Exception dashboard — One view of all inventory issues
Week 5-8: Optimization
- Set up automatic reorder triggers at 7-day inventory threshold
- Connected supplier communication for replenishment
- Built warehouse-level inventory visibility
The Results (90 Days)
| Metric | Before | After | Change |
|---|---|---|---|
| SKUs out of stock | 3 | 1.2 | -60% |
| Monthly stockout revenue loss | ₹2L | ₹80K | -60% |
| Time to detect stockout | 3-5 days | Real-time | -100% |
| Inventory accuracy | 72% | 95% | +32% |
| Reorder response time | 5 days | 1 day | -80% |
What Made It Work
The system, not the tool. They didn’t need a new ERP. They needed:
- Connected data (Shopify + Warehouse)
- Automated alerts (stockout detection)
- Daily visibility (brief + dashboard)
- Clear actions (reorder triggers)
Mera Commerce OS provided the operating layer. Vridhi Labs built the system.
Key Takeaway
“We were losing ₹2L/month to stockouts and didn’t know it until customers complained. Now we get alerts before it happens.”
— Founder, D2C Skincare Brand
This use case demonstrates our Commerce Operations system. Get a Commerce Assessment →
Running this problem today?
See where time and margin leak in your stack — mapped onto Mera Commerce OS.