Step 01 · Starting point
deliveries_tuesday_v2.xlsx
AddressWindowDriverDelivered?
4 Linden Street16:00–23:59Van 2?
17 Field Road16:00–23:59?–
4 Linden Street16:00–23:59Van 2duplicate
3 Sunny Court00:00–07:00Van 1call driver
9 Flower Lane16:00–23:59Van 1–
21 Garden Road16:00–23:59?–
Planning

Delivery list on paper or in a spreadsheet

Every morning

File import into a third-party courier app

After the route

The shop and the kitchen do not know which delivery arrived

Step 02 · List and proof of delivery
Dispatcher panel · today's deliveries
AddressWindowVanStatus
4 Linden Street16:00–23:59Van 2on route📷 17:42
17 Field Road16:00–23:59Van 2📷 17:18
9 Flower Lane16:00–23:59Van 1planned
3 Sunny Court00:00–07:00Van 1tomorrow morning
Notification: your order is at the door
Driver · Van 2
4 Linden Streetstaircase B · floor 3 · intercom 34
Window 16:00–23:59note: leave at the door
Mark as delivered
Photo saved17:42 · GPS location
Step 03 · Vehicle instead of driver
Fleet · vehicles
Fiat Doblozone A
Citroen Berlingozone B
Fiat Ducatozone C
Renault Masterspare
Fiat Doblo
Cost per 1 kmPLN 0.50
Cost per working hourPLN 30.00
Capacity (parcels)set
Maximum route timeset
Average time per stop2.0 min
Route startkitchen
drivers change, the vehicle and its costs stay
Step 04 · Routes from the algorithm
Route planning · Tuesday

Automatic planning

✓delivery windows
✓driver working time
✓cost per km and per hour
✓vehicle start and return
Fiat Dobloroute ready
Citroen Berlingo23.0 km · 50 min
Fiat Ducatoroute ready
Google algorithm · up to 100 stops per route dispatcher: small corrections
Step 05 · Template and new markets
Routes · Wednesday
Tuesday · route saved
4 Linden Street
17 Field Road
9 Flower Lane
Wednesday = Tuesday + 3 stops
4 Linden Street · 17 Field Road · 9 Flower Lane
+ 2 Birch Street
+ 15 Forest Lane
+ 7 Green Court
no API call

Requirements of new markets

Poland

delivery zones by postcode

Qatar

addresses without a city name

Kuwait

amounts with three decimal places

UAE

deliveries every other day, cooler bags

USA

subscriptions and rescheduled deliveries

Deposit

for bags and ice packs

sample data