Case Study
Centralised Delivery Hub for Local Dairy
A high-performance operational portal designed for local dairies to streamline morning route planning, vehicle compliance, inventory margins, GoCardless payments, and Twilio customer SMS notifications.
Project Brief
Built a centralized administrative portal for an independent UK dairy business managing thousands of active doorstep deliveries and recurring subscriptions.
The primary goal was to replace manual route management with real-time fleet maps, automated morning load list generators, GoCardless Direct Debit processing, Twilio SMS alerts, and seamless billing ledgers.
The Challenge
Tracking live vehicle locations, battery charge statuses, and real-time delivery issues across multiple morning routes simultaneously.
Converting complex standing customer orders into accurate depot packing manifests and per-driver crate load lists before 03:30 AM shifts.
Managing DVLA vehicle compliance, UK VAT rate calculations, automated GoCardless Direct Debit collections, and real-time Twilio customer dispatch SMS notifications.
Functionality
Live Operations Dashboard
Real-time operational monitoring featuring fleet GPS tracking, pending daily deliveries, live driver run updates, Twilio SMS broadcast statuses, and MRR metrics.
Inventory & Margin Management
Product catalog tracking wholesale vs. retail margins, UK VAT exemptions, and real-time depot stock thresholds with status indicators.
Fleet Compliance & Telematics
Automated alerts for DVLA tax deadlines, MOT expirations, fleet insurance renewals, and electric vehicle battery charge levels.
Customer Directory & Schedules
Comprehensive profile manager supporting flexible 7-day standing orders, delivery instructions, Twilio SMS preference opt-ins, and doorstep account histories.
Interactive Route Optimization
Sequential doorstep drop list manager with drag-and-drop re-ordering, unallocated customer mapping, and turn-by-turn route previews.
Morning Depot Load Generator
Per-shift loading checklist converting individual customer bottle orders into printable crate counts and driver sign-off manifests.
Payments Ledger & GoCardless Billing
Multi-channel billing suite handling automated GoCardless Direct Debit mandates, manual cash logging, BACS transfers, failed payment tracking, and receipt generation.
Twilio SMS & Customer Messaging
Automated SMS gateway sending real-time doorstep delivery updates, schedule modification confirmations, and payment reminder notifications.
Multi-Role User Access
Granular permissions manager assigning custom system access to depot managers, drivers, admin staff, and field inspectors.
Operational Reports & Analytics
Visual reporting engine analyzing route profitability, delivery success rates, bottle returns, and customer churn trends.
Financial Overview
Executive financial dashboard displaying net profit margins, GoCardless payout reconciliation, fuel costs, and VAT liability calculations.
Expense Tracking & Auditing
Categorized expense logging tool for recording fleet maintenance, fuel, depot utilities, and equipment purchases.
A closer look
Dashboard Overview
Live operational metrics, active vehicle map, real-time morning run feed, and quick admin action triggers.
Product Inventory & Pricing
Catalog manager displaying wholesale costs, retail pricing, profit margins, UK VAT rates, and depot stock progress bars.
Fleet Vehicles & Compliance
Vehicle cards tracking DVLA MOT expirations, tax deadlines, battery charge levels, and driver assignments.
Customer Directory & Profiles
Comprehensive customer directory featuring detailed profiles, Twilio SMS preferences, and weekly standing order grids.
Delivery Routes & Sequence
Route selector and doorstep drop-sequencing interface with unallocated customer assignment tools.
Morning Load List
Depot packing manifest breaking down required crate counts and product quantities with print functionality.
Payments Ledger & GoCardless Billing
Financial transaction ledger for logging GoCardless Direct Debit payouts, doorstep cash payments, and customer receipts.
System Users & Roles
User access management control panel for assigning operational roles to drivers, depot staff, and admins.
Reports & Operational Analytics
Performance analytics suite tracking delivery efficiency, crate returns, customer growth, and drop success.
Financial Overview
Executive revenue summary detailing weekly profits, GoCardless payout processing fees, fuel expenditures, and VAT accounting.
Expense Tracking
Operational cost manager for recording depot expenses, Twilio SMS platform fees, vehicle repairs, and supplier invoices.
Settings & Configuration
System configuration panel for managing Twilio API keys, GoCardless credentials, and depot operational preferences.
Architecture
Built as a modular web platform leveraging Tailwind CSS and Alpine.js for a fast, responsive desktop and mobile administration interface. Route algorithms optimize sequential drops on the fly while Twilio SMS webhooks dispatch instant delivery notifications to doorstep customers.
Custom database indexing handles rapid standing-order calculations, generating depot-wide inventory requirements and driver load manifests in milliseconds while syncing recurring mandates directly via the GoCardless API.
Skills Used
This portal completely transformed our morning logistics. Generating accurate load lists takes seconds, our GoCardless integration completely eliminated payment chasing, and automated Twilio SMS updates cut customer support calls in half.
Have a similar project in mind?
Get in touch for a free, no-obligation quote.
Start a Project