The Bottleneck: A Manager Drowning in Repetitive Admin
Cape & Coast Homewares, a 12-branch Cape Town retailer, had a warehouse operations manager spending 22 hours every week on tasks that were entirely rule-based: pulling orders from WooCommerce, emailing suppliers, updating a spreadsheet, and cross-referencing stock levels. None of these tasks required human judgement — they just required time.
Mapping the Workflow
Before writing a single automation, our team spent a morning shadow-mapping every step the manager performed. We identified four core loops:
New order detection → supplier email trigger
Supplier confirmation receipt → spreadsheet update
Stock level check → low-stock alert to buyer
Weekly reconciliation report → emailed to MD every Monday 07:00
The Automation Stack We Deployed
Using webhook triggers and a lightweight integration layer, we connected their WooCommerce store to their existing Google Workspace environment:
New orders over R500 automatically trigger a structured supplier email with line-item detail.
Supplier replies containing "confirmed" update the master stock sheet via Apps Script.
A nightly stock sweep flags any SKU below reorder level and creates a draft purchase email for the buyer to approve with one click.
The Monday report is generated and dispatched without any human involvement.
The Outcome
Within two weeks of go-live, the operations manager's repetitive admin dropped from 22 hours to under 3 hours per week. The 19 hours freed up were reallocated to supplier relationship management — a task that had been deferred for months.
Error rates on purchase orders dropped by 84% because structured data from WooCommerce replaced manual re-typing.
What Business Automation Actually Costs
The Cape & Coast project was scoped, built, and handed over in three weeks. The monthly platform cost is less than the hourly rate of the employee time it replaced. Most small-business automation projects have a payback period of 60 to 90 days.
