Retail · Hong Kong
A live sales dashboard for a Hong Kong multi-channel retailer
Yesterday's numbers, before the first coffee.
Two staff opened five different apps every morning — online store, POS, payments, marketplace, spreadsheets — to piece together yesterday's sales. We built one live dashboard that pulls every channel together and updates itself.
The challenge
Two staff spent most mornings — plus the weekly and month-end reports — copying numbers out of five apps into spreadsheets: around 245 hours a month. Channel-level problems (a dead listing, a payment issue) often went unnoticed for days.
The solution
Connectors pull sales, orders and stock from each channel into one data store every few minutes; a dashboard shows revenue, orders, channel mix and top products live, on desktop and phone, with alerts when a channel goes quiet.
The workflow we built
- Connect the channels. Online store, POS, payments and marketplace all feed one data store automatically.
- One live view. Revenue, orders, average order, channel mix and top products — updating through the day.
- Phone-ready. The same dashboard works on the owner's phone — numbers at a glance, anywhere.
- Quiet-channel alerts. If a channel stops selling unexpectedly, the owner hears about it the same hour.
A week before, a week after
| Topic | Before | After |
|---|---|---|
| Gathering numbers | Every morning, two staff opened five apps — online store, POS, payments, marketplace and spreadsheets — one after another. | Sales, orders and stock from every channel flow into one data store every few minutes. |
| Copying | They copied yesterday's figures into one spreadsheet by hand, which took most of the morning. | Nobody copies numbers any more; the dashboard updates itself. |
| Reports | Weekly and month-end reports meant another round of the same copying. | Weekly and month-end figures are already on screen when the period closes. |
| Owner's view | The owner waited for the sheet before seeing how yesterday went. | The owner checks yesterday's numbers on the phone before the first coffee. |
| Problems | A dead listing or a payment problem could go unnoticed for days. | If a channel goes quiet, the owner hears about it the same hour. |
How the saving adds up
- Morning reports: 2 staff × about 4.5 hours × 22 working days ≈ 198 hours a month.
- Weekly reports: about 5 hours a week ≈ 20 hours a month.
- Month-end report: about 27 hours of copying and checking.
- Total ≈ 245 hours a month × HK$110 an hour (≈ HK$19,000 a month for one full-time admin staff, MPF included) ≈ HK$27,000 — ≈ 1.4 full-time staff (173 hours = one full-time month).
These are the working assumptions behind the figure, not an audited result.
How the project ran
- Free audit of the real process. We followed the morning routine across all five apps and listed the numbers the owner actually used. The timeline was agreed after the audit.
- Built on their own files. The dashboard was first built from the client's own recent sales exports, so the first figures on screen were ones the team already knew.
- Run side by side. For a period the staff kept their manual morning report, and both were compared until the figures matched.
- Live, then monitored. The manual copying stopped. After go-live, we monitor the connectors and fix what needs fixing.
Questions owners usually ask
- Did anyone lose their job?
No. The two staff got most of their mornings back, and that time went to customers and stock. Where freed-up hours go is always the owner's decision. - What happens when it gets something wrong?
If a channel stops selling or stops sending data, the quiet-channel alert tells the owner the same hour, so a gap is noticed instead of trusted. - Where does our data live?
In the tools named on this page — your sales channels, Google Sheets and the dashboard. Where each piece of data sits, and who can see it, is agreed after the free audit.
Tools we used
The results
- Daily, weekly and month-end reporting went from hours of copying to a glance at one screen.
- Channel problems now surface within the hour instead of days later.
- Around HK$27,000 of time saved monthly — the work of about 1.4 full-time staff — and better decisions from live numbers.
Representative example — figures illustrative, client anonymised.
Have an operation that looks like this?
Tell us the process and we'll show you exactly how to automate it — free, and no obligation.
Get a Free Automation Audit →