Case Study · Business Process Automation

Order-to-Delivery Automation for a UK Wholesale Distributor

A £8M ARR UK wholesale distributor was stuck in 1990s operations — fax orders, spreadsheet stock checks, phone-call status updates. SpiderHunts replaced four full-time roles of manual work with an end-to-end automation platform: order intake from email/web/EDI/WhatsApp, real-time inventory allocation, smart dispatch routing, automated payments via Stripe, and live customer tracking. Order-to-delivery time fell from 3.5 days to 18 hours, errors dropped 93%, and the £12,500 build paid back in 4 months.

B2B Wholesale DistributionIndustry
End-to-End Process AutomationProject Type
12 weeksDuration
£12,500 fixed-priceInvestment

Project Snapshot

Sterling Wholesale Group (anonymised) is a Manchester-based £8M ARR B2B distributor supplying retailers across Northern England. Orders came in via fax, email, and phone. Stock was checked manually against spreadsheets. Order confirmations were typed individually. Delivery scheduling required a series of phone calls. Customers chased status daily.

Industry
B2B Wholesale Distribution
Project Type
End-to-End Process Automation
Duration
12 weeks
Investment
£12,500 fixed-price
Payback
4 months
Annual Savings
£42,000+
The Challenge

The Challenge

Sterling Wholesale Group (anonymised) is a Manchester-based £8M ARR B2B distributor supplying retailers across Northern England. Orders came in via fax, email, and phone. Stock was checked manually against spreadsheets. Order confirmations were typed individually. Delivery scheduling required a series of phone calls. Customers chased status daily.

Before SpiderHunts

  • Four full-time staff spent ~80% of their day on data entry, status updates, and phone-calls
  • Order-to-delivery time averaged 3.5 days versus 24-hour industry benchmark
  • Order error rate at 8% — costing £2,000–£3,000 per week in returns and credit notes
  • 40+ daily "where is my order?" calls clogging the support line
  • Customer NPS sitting at 32 with rising complaints
  • Hiring more staff was not viable — margins already thin

After SpiderHunts

  • 3.5 days → 18 hours — Order-to-delivery time
  • 8 hrs/day → 25 min/day — Manual data entry
  • 8% → 0.6% — Order error rate
  • 40/day → 3/day — "Where is my order?" calls
  • 32 → 71 — Customer NPS
  • +42% — Revenue per employee
The Solution

The Solution

SpiderHunts designed and built a unified Order-to-Delivery Automation Platform tying together every step from order intake to delivery confirmation. The platform sits on top of their existing Sage accounting system, so finance workflows were preserved while operations were fully transformed.

01

Multi-channel order intake

AI-powered email parser, web order form, EDI from key accounts, WhatsApp Business API — every channel flows into a single normalised order pipeline.

02

Real-time inventory allocation

Automatic stock check against live inventory; out-of-stock SKUs auto-suggest substitutes or trigger purchase orders.

03

Automated payment & credit

Stripe invoice generation; existing customer credit terms applied automatically; failed payments routed to credit control.

04

Smart dispatch routing

Algorithmic assignment of warehouse and courier (Royal Mail, DPD, in-house van) based on destination, weight, and urgency.

05

Customer tracking portal

Live status updates, ETAs, and signature capture — all branded and embedded in their existing customer login.

06

Automated notifications

SMS, email, and WhatsApp updates triggered at every stage (received, picked, dispatched, out for delivery, delivered).

07

Delivery confirmation

Courier scan and proof-of-delivery photos pulled back into the order record and the customer portal automatically.

08

Finance reconciliation

All transactions auto-reconciled in Sage; finance team sees outstanding invoices and matched payments in a unified dashboard.

Technology

Tech Stack

Production-grade components selected for reliability, observability, and ease of handover.

Python 3.12 FastAPI PostgreSQL Redis Celery React + TypeScript n8n Sage Accounting API Stripe Royal Mail API DPD API Twilio SMS WhatsApp Business API SendGrid AWS ECS Fargate OpenAI GPT-4 (email parsing)
Measurable Outcomes

Results

Numbers measured 3 months post-launch versus the same period the previous year.

3.5 days → 18 hours
Order-to-delivery time
-79%
8 hrs/day → 25 min/day
Manual data entry
-95%
8% → 0.6%
Order error rate
-93%
40/day → 3/day
"Where is my order?" calls
-93%
32 → 71
Customer NPS
+121%
+42%
Revenue per employee
4 months
Project payback
£42,000+ / year
Ongoing operational savings
The biggest competitive advantage we have added in 15 years. Our customers think we doubled in size — we just stopped wasting time on manual work.

— Operations Director, UK Wholesale Distributor (anonymised)

Ready for a Similar Result?

Have a similar operations problem? We deliver fixed-price automation projects with measurable ROI. Book a free discovery call.

Book a Free Discovery Call WhatsApp Us