Beauty & cosmetics
Multi-brand beauty retailer, 20 stores, Morocco
A Moroccan retailer of international beauty and fragrance brands replaced weekly Excel ordering with proposals written straight into Sage 100cloud, across 20 stores in six cities, four weeks after the first data export.
The challenge
The order file was rebuilt from scratch every Monday. A planner exported stock from Sage into Excel, compared it with last year's sales by hand, then retyped the result back into the ERP one supplier at a time. Two days a week disappeared into that file. Best-sellers still ran out during launches and gifting peaks, while discontinued shades and slow references sat in the back rooms of the smaller doors. Supplier lead times were never measured, so safety stock was a habit rather than a calculation, and testers were opened wherever staff decided, with no allocation rule.
What IRISYS changed
IRISYS was connected to Sage 100cloud for the item master, stock by store and transit warehouse, invoiced sales and open purchase orders. Forecasts were calibrated on 24 months of history, category by category, with Ramadan, Eid and the end-of-year gifting season modelled explicitly rather than smoothed away. Proposals ran in parallel with the existing Excel process for two weeks so the planners could compare them line by line and adjust the rules. From week four, approved proposals were written back to Sage as purchase orders carrying the IRISYS reference, tester replenishment followed a ratio per category and per door, and inter-store transfers were proposed before any new purchase order was raised.
Results
-38 %
stock-outs on A-class references, first six months
-27 %
overstock value released across the network
94 %
of proposals approved without a manual change
3 h
of ordering work per week, down from two days
In their words
We stopped rebuilding the order file every Monday. The proposals are ready before the team arrives, the planners spend their time on the exceptions instead of the typing, and the stores have stopped calling us about missing best-sellers.
Supply chain director, 20-store beauty retailer, Morocco
A similar network? Let's compare notes.
We can walk you through this deployment in detail, from the Sage connection to the first automatic orders.