From spreadsheet mosaic to an orchestrated AI platform.
Three stores, one online shop as a digital extension of the floor, around 22,000 active customer files — and reports that ate two days of every week. Today the morning briefing lands at 7am in the inbox: automated, commented, sorted.
+18.4 %
revenue per day, YoY after 6 months
−42 %
time spent on weekly reporting
22 K
customer files in real-time sync
How 9 spreadsheet tabs became one dashboard.
Before Mercurios, every Monday meant stitching together POS exports, stock lists, supplier PDFs and customer records by hand. Now the systems talk to each other — and the team talks to customers.
The company
Family-owned, third generation, three stores across northern Germany, around 35 employees — bricks-and-mortar retail with a connected online shop as an extension of the floor, not a standalone e-commerce business. High-quality menswear and womenswear, lots of NOS articles, short reorder cycles — and a loyal customer base that values advice. The pain point: data in every system, but none of it in the owner's hands.
The challenge
Weekly reporting was pulled by hand from at least four sources — POS, warehouse, online shop and supplier emails. Assortment decisions ran on gut feeling because hard numbers only arrived days later. NOS items were regularly out of stock, customer files duplicated, and the briefing for store managers rarely matched the reality on the floor.
Our approach
In four weeks we connected the data root, consolidated master data and switched on the AI briefing as the first touchpoint. Instead of a big bang, we used a clear sequence: see first, measure next, automate last.
- Week 1 · POS, ERP, online shop and CRM connected to Mercurios
- Week 2 · Master data cleaned, stores + departments mapped
- Week 3 · Smart Replenishment activated for the top-30 categories
- Week 4 · AI briefing emailed at 7am, with drill-down into the dashboard
Rollout in practice
Store managers were trained in 90 minutes — no manual, no three-day seminar. We sat with them once a week and walked through the briefing using real, current numbers. After three weeks the famous "finally I can just look at the screen in the morning instead of digging through five emails" started showing up.
What measurably changed.
Results after the first six months — measured against the same prior-year period.
+18.4 %
revenue per day, YoY comparison
−42 %
time the team spends on reporting
−58 %
stockouts on NOS items
+14 %
reactivated customers via wallet & newsletter
07:00
daily AI briefing in the inbox
1 source
instead of 9 spreadsheet tabs for the owner
„We waited years for data to actually tell us something in the morning, instead of us having to go searching for it. With Mercurios that's exactly what happened — and suddenly discussions about assortment and pricing got much calmer, because my store managers and I are looking at the same numbers."
Owner
Owner-led fashion retailer · 3 stores + online
Ready to orchestrate your retail autonomously?
A 30-minute intro call. We show you Mercurios live on your data — and tell you honestly whether it pays off today.