Securing store replenishment and inventory planning
A single ERP-connected tool to manage retail inventory across the entire product lifecycle
Before Anaplan was implemented, store replenishment planning relied on locally maintained Excel files. This approach had major limitations: formula errors, untracked manual changes, unreliable data, and a lack of harmonisation across regions. Business expectations were high: improve product availability, reduce store overstocks, and deliver tangible efficiency gains for teams.
Challenge met. Planners, who previously spent around 60% of their time on manual data processing, saw their roles evolve and can now focus on higher value-added activities.
Thanks to the deployment of Anaplan:
- more than 1,500 stores and 1,000 products are now replenished daily,
- overstocks on permanent products have been reduced, and
- more precise management of promotional campaigns has enabled better initial stock allocation and greater responsiveness to sales signals.
The project also helped secure all the data foundations required for the process, through the development and automation of more than 20 interfaces, executed several times per day.
Detailed design
A key step in building the target process
The scoping phase began with one week of on-site workshops bringing together the project team, decision-makers, and key users from the two pilot regions. These sessions made it possible to review the existing process and identify key issues in order to define the main stages of the target process.
Workshops then continued remotely over an additional three weeks to refine design decisions and address open points. From this phase onward, and throughout the project, monthly meetings were also organised with regions outside the pilot scope to share design progress, collect feedback, and anticipate local specificities.
Involving all subsidiaries from the outset was essential to ensure model consistency and the success of future rollouts.
Core Model approach
Harmonising practices while integrating local specificities
Regional differences made process standardisation challenging. Ignoring certain local requirements would have jeopardised user adoption. The key challenge was therefore to design a solution that was both modular and adaptable to the maturity and needs of each subsidiary, while preserving the Core Model approach and ease of use.
OneHive teams met this challenge by deploying a shared, flexible, and collaborative tool, supported by an architecture that allows local adaptations without undermining the global model.
Data and interface management
Ensuring the quality and reliability of data feeding the solution
Like most operational processes, replenishment relies on inventory, in-transit, and sales data sourced from the ERP and other enterprise systems. The reliability of results therefore depends directly on the quality of data integrated into the solution.
In close collaboration with IT teams, we designed a single Data Hub fed by the ERP or BI systems, supported by robust and automated interfaces. Consistency checks and traceability mechanisms were implemented to secure the data used and surface the right alerts on a daily basis.
We also supported the design of outbound interfaces, which are critical to the process. The deployed solution is directly interfaced with the ERP to automatically create and transmit new distribution orders, while a return flow verifies correct integration. The setup handles large data volumes: around 40 million sales records, 8 million inventory records integrated into the models, and a daily flow of approximately 20,000 orders sent to the ERP.