Order Fulfillment Sankey Diagram: Editable Template
Follow customer orders from receipt through stock check, shipping speed and delivery, with backorders, cancellations, holds and late or lost deliveries all shown.
An order fulfilment Sankey follows orders from the moment they are placed to the moment they arrive, and shows every way an order can fall out of the happy path.
Of 5,000 orders, 4,400 are in stock and 450 are backordered. The picture then follows how each is shipped and whether it arrives on time, late or not at all.
Different routes to the same outcome are shown separately so you can see whether restocked orders arrive later than same-day ones. Figures are invented.
How to read this diagram
- 4,400 of 5,000 orders (88%) are delivered on time; 230 arrive late and 50 are lost.
- 450 orders are backordered; 380 of them are shipped later and 70 are cancelled.
- Restocked orders have the worst loss rate, 20 of 380 (5%), against under 1% for same-day.
- 220 orders are cancelled in total, 150 by customers at the start and 70 after a backorder.
The data behind it
Invented figures for illustration. Not data about any real business.
| From | To | Amount (orders) |
|---|---|---|
| Orders received | In stock | 4400 |
| Orders received | Backordered | 450 |
| Orders received | Cancelled | 150 |
| In stock | Shipped same day | 3300 |
| In stock | Shipped next day | 1000 |
| In stock | Held for review | 100 |
| Backordered | Shipped after restock | 380 |
| Backordered | Cancelled | 70 |
| Shipped same day | Delivered on time | 3150 |
| Shipped same day | Delivered late | 130 |
| Shipped same day | Lost or undelivered | 20 |
| Shipped next day | Delivered on time | 900 |
| Shipped next day | Delivered late | 90 |
| Shipped next day | Lost or undelivered | 10 |
| Shipped after restock | Delivered on time | 350 |
| Shipped after restock | Delivered late | 10 |
| Shipped after restock | Lost or undelivered | 20 |
The same data as CSV
source,target,value
Orders received,In stock,4400
Orders received,Backordered,450
Orders received,Cancelled,150
In stock,Shipped same day,3300
In stock,Shipped next day,1000
In stock,Held for review,100
Backordered,Shipped after restock,380
Backordered,Cancelled,70
Shipped same day,Delivered on time,3150
Shipped same day,Delivered late,130
Shipped same day,Lost or undelivered,20
Shipped next day,Delivered on time,900
Shipped next day,Delivered late,90
Shipped next day,Lost or undelivered,10
Shipped after restock,Delivered on time,350
Shipped after restock,Delivered late,10
Shipped after restock,Lost or undelivered,20How it works
Take orders from your order system
One period, counting each order once.
Add stock status and how each was shipped
In stock, backordered, cancelled, held.
Add the delivery outcome
On time, late or lost, from carrier data.
Check the balance
Each shipping route should send on exactly the orders it received.
Frequently asked questions
Should I count order lines or orders?
Pick one. Orders are simpler; lines are better if an order can ship in parts.
How do I handle partial shipments?
Count each shipment as its own item, or split the order into a shipped and a backordered part before drawing.
Edit this fulfilment Sankey
Open the example as your own chart and enter your order counts.