The Problem
The organisation operated across multiple locations — each branch running its own product purchases, stock movements, and customer sales independently. There was no central system connecting them. When management needed to understand what was happening across the business, someone had to manually visit each branch's records and piece the picture together by hand.
The gaps were significant. There was no reliable way to know which products were moving fastest, which branches were holding excess stock, or which customers were buying what and when. Billing records existed at branch level but couldn't be queried across locations. And without a unified view, stock discrepancies often went undetected until they became a real problem.
What We Built
Centralised Product Operations Platform
We consolidated stock movement and transaction data from all branches into a single reporting layer. For the first time, the business had one place to look for answers about product flow — across every location, every billing reference, and every customer interaction — without needing to export or reconcile anything manually.
Full Transaction Traceability
The platform captures transaction data at the item level, with traceability across every dimension that matters to the business:
- By location: Which branch received, moved, or sold a product — and when.
- By billing reference: Every bill number, date, and time linked to the items it covered.
- By customer: What each customer purchased, from which location, and across what period.
- By product: Full movement history — purchases in, transfers between branches, sales out.
- By staff context: Transaction attribution to the staff or doctor involved, where relevant.
Time-Based Analytical Views
Rather than static snapshots, the platform gives management dynamic, filterable views of the business across time. Daily, weekly, and monthly analytical perspectives are available out of the box — so the team can spot a trend in this week's stock movement, compare it to last month, and act before it becomes a problem.
Stock Movement Intelligence
The platform tracks the full lifecycle of each product unit: from the point of purchase into the business, through any inter-branch transfers, to the final point of sale. This gives management a complete picture of stock velocity, ageing inventory, and branch-level demand patterns — the foundation for smarter purchasing and stock allocation decisions.
Tech Stack
The Results
Management can now see the entire business — every branch, every product, every transaction — from a single dashboard. Stock discrepancies are caught in real time rather than discovered at month-end. Customer purchase patterns are visible for the first time, enabling smarter sales and stocking decisions. And the branch-by-branch manual reporting process has been retired entirely.
Key Takeaways
- Multi-location businesses often underestimate how much value is locked in their transaction data — the question isn't whether the data exists, but whether it can be queried across locations in a unified way.
- Traceability at the billing level is what turns a reporting dashboard into an operational tool. When a discrepancy appears, the team can trace it to an exact bill, branch, and time — not just a monthly total.
- Time-based analytical views (daily, weekly, monthly) aren't just a nice-to-have — they change how management thinks about the business. The ability to detect trends early is worth more than any single snapshot.