Operations automation and omnichannel platform for a regional retailer
Retailer with presence in 4 LATAM countries
The challenge
The company managed inventory, orders and logistics with disconnected systems: an on-premise ERP, a legacy e-commerce platform and manual Excel-based demand planning processes. The lack of real-time stock visibility caused frequent inventory stockouts and estimated annual sales losses in the millions. The consumer experience was inconsistent across physical and digital channels.
The solution
We built an integration layer on Google Cloud that unified the ERP, e-commerce and point-of-sale systems under an event-driven architecture with Pub/Sub. We implemented a real-time inventory synchronization engine and automated demand planning with predictive models in BigQuery ML. We redesigned the digital channel checkout experience with a new SPA connected to the same unified inventory backend.
Results
-
Inventory stockouts reduced by over 70% in 6 months
-
Stock synchronization time between channels: from 24h to under 2 minutes
-
28% increase in digital channel conversion
-
80% automation of weekly demand planning process
-
Unified real-time inventory visibility across all 4 countries
Technologies
- Google Cloud Pub/Sub
- BigQuery
- BigQuery ML
- Cloud Run
- Python / FastAPI
- React
- PostgreSQL
- Looker
"For the first time in years we have real visibility of inventory across all channels. Decisions that used to take days now take minutes with reliable data."
Do you have a similar challenge ?
Let's talk about your context. Our team can help you design a solution tailored to your industry and scale.
No commitment · Reply within 24h