Retail · Hong Kong

A live sales dashboard for a Hong Kong multi-channel retailer

Yesterday's numbers, before the first coffee.

-90%daily reporting time
5→1apps checked each morning
HK$27,000saved / month

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

  1. Connect the channels. Online store, POS, payments and marketplace all feed one data store automatically.
  2. One live view. Revenue, orders, average order, channel mix and top products — updating through the day.
  3. Phone-ready. The same dashboard works on the owner's phone — numbers at a glance, anywhere.
  4. Quiet-channel alerts. If a channel stops selling unexpectedly, the owner hears about it the same hour.

A week before, a week after

TopicBeforeAfter
Gathering numbersEvery 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.
CopyingThey copied yesterday's figures into one spreadsheet by hand, which took most of the morning.Nobody copies numbers any more; the dashboard updates itself.
ReportsWeekly 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 viewThe owner waited for the sheet before seeing how yesterday went.The owner checks yesterday's numbers on the phone before the first coffee.
ProblemsA 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

  1. 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.
  2. 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.
  3. Run side by side. For a period the staff kept their manual morning report, and both were compared until the figures matched.
  4. 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

n8nGoogle SheetsMetabase

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 →