UAE Retail Chain: From 14% to 4% Stock-Out Rate Across 12 Stores
How a UAE specialty retail chain combined Odoo Inventory with Rubicon’s AI demand forecasting to cut stock-outs by 71% and reduce overstock by AED 1.4M in 9 months.
The Business
- 12 specialty retail stores across Dubai, Sharjah, and Abu Dhabi
- 3,200 active SKUs across multiple categories
- Combined annual revenue: AED 48M
- Previous system: standalone POS + Excel-based reorder planning at HQ
The Problem
Two simultaneous, contradictory issues: stock-outs of 14% on fast-movers (lost sales estimated at AED 4–5M annually) AND overstock value of approximately AED 2.1M concentrated in slow-movers across 8 stores. The buying team relied on spreadsheets and gut feel; promotional uplifts and seasonality (Ramadan, summer travel, school terms) were impossible to plan for accurately.
The Solution
Phase 1: Odoo Inventory Foundation (Weeks 1–6)
Standard RIM-based Odoo Enterprise deployment with focus on multi-warehouse inventory, POS integration, and replenishment workflows. All 12 stores cut over together over a 3-day weekend.
Phase 2: AI Forecasting Layer (Weeks 7–12)
Rubicon deployed its AI inventory layer reading daily Odoo transaction data. Per-SKU per-store forecasts retrained nightly using 36 months of historical sales (migrated from POS exports). Seasonality models calibrated specifically to UAE retail patterns.
Phase 3: Automation Rollout (Weeks 13–20)
AI-generated draft purchase orders pushed into Odoo for buyer review and approval. Inter-store transfer recommendations generated weekly. Slow-mover markdown alerts created in Odoo for category managers.
The Results (Month 9)
| Metric | Before | Month 9 |
|---|---|---|
| Stock-out rate (top 500 SKUs) | 14% | 4% |
| Overstock value | AED 2.1M | AED 0.7M |
| Inventory days on hand | 78 days | 54 days |
| Forecast accuracy (MAPE) | ~55% | ~82% |
| Weekly time spent generating POs (buyer) | 22 hours | 8 hours |
| Inter-store transfers per week | 3 (ad-hoc) | 18 (system-suggested) |
Why It Worked
The combination of Odoo’s transactional discipline (every sale tied to inventory) plus an AI layer that learned UAE-specific seasonality created a feedback loop the previous Excel approach couldn’t match. Critically, the buying team retained final approval — the AI proposed; humans decided. Adoption rate was >95% within 60 days because buyers saw the AI suggestions were usually right but were never forced to accept them blindly.
Run a Free Forecast Test
Send us 12 months of POS data. We’ll forecast the next 30 days and show you accuracy vs your current approach.