Customer stories
/
United Brands
How United Brands Replaced Spreadsheet Reporting with an AI Analyst
Wholesale & Distribution
Case study + video
Results
Custom apps built across sales, stock, purchasing and finance
Scheduled reports sent automatically, from daily sales orders to weekly dispatch and stock lists
Questions answered across Orderwise, Sage 50 and the team's spreadsheets
Days from connecting Orderwise to the first live dashboards and automated reports
About
United Brands is a UK wholesaler supplying homeware and consumer goods brands, including Yankee Candle, Pyrex and Curver, to retailers and independents. Their business runs on stock: buying the right quantities from suppliers, landing them in the warehouse, and getting orders out to customers on time.
Industry
Wholesale & Distribution, Consumer Goods
Role Leading Adoption
Operations and sales leadership, with the sales team adopting it for customer and order tracking.
Systems
Orderwise (orders, stock, purchasing, dispatch), Sage 50 (accounts, debtors, creditors), plus the teamโs working spreadsheets for transport bookings, goods in and stock lists.
The Challenge
United Brandsโ data sat in two systems that didnโt talk to each other: Orderwise for orders and stock, Sage 50 for the money. Everything in between was handled in spreadsheets, including transport bookings, goods-in schedules and customer stock lists. Questions like โwhich customers should we supply first when stock is short?โ or โis this purchase order worth it before the stock lands?โ meant pulling exports from both systems and stitching them together by hand.
The Solution
United Brands connected Orderwise on 23 June and Sage 50 a week later. Milo made sense of both and let the team ask questions across them in plain English.
What they built:
Automated operational reporting. Daily new sales orders, weekly dispatch and outstanding purchase orders, goods-in schedules and transport plans, all emailed on a schedule with no one building them.
Purchasing and stock tools. A PO Viability Report that checks a purchase orderโs cost against pre-sold orders before stock arrives. A PO Bring-In and Truck Planner that builds pallet-rounded loads, covering sold stock first. Plus an Oversold Stock Report and a Stock Turnover & Slow Mover Report.
Sales tools. Sales360, a live view for each salesperson of their customersโ orders, debt and repeat buying. Also a Repeat Order Tracker, a Customer Map for route planning, and monthly repeat lists sent to each rep.
Finance views from Sage 50. Aged debtors and creditors reports, an expense tracker, and a GRN invoice reconciliation app that checks goods received against supplier invoices.
Weekly progress against target. Every Friday, a sales update tracks progress towards the companyโs ยฃ3.5M sales goal.
The Result
Within 7 days of connecting Orderwise, United Brands had live dashboards for stock, dispatch and sales, plus their first automated reports. Five months on, the team has asked Milo 1,195 questions, built 18 custom apps, and receives 18 recurring reports and alerts covering sales, purchasing, stock and finance. Reports that used to be pulled from Orderwise and Sage by hand now arrive on their own.
All stories
More customer stories
Ready when you are
Donโt take our
word for it.
See Milo in action.
Try Milo on your own data. Ask a real question. Get a real answer, before you decide anything else.
Milo demo with Tom, 30 min
Tom Pickett, Founding GTM Lead at Milo.




