ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
E-COMMERCE ORDER TRACKER
2
Order IDOrder DateCustomerProductSKUUnit Price ($)QtyOrder Total ($)PaymentOrder StatusTracking No.Ship DateEst. DeliveryAlert
3
#100101-Oct-2026Amaka O.Wireless mouseWM001$25.992$51.98PaidDeliveredTRK8420102-Oct-202607-Oct-2026
4
#100202-Oct-2026Daniel E.Laptop StandLS002$35.001$35.00PaidDeliveredTRK8420203-Oct-202608-Oct-2026
5
#100303-Oct-2026Grace U.Ring LightRL006$55.001$55.00PaidShippedTRK8420304-Oct-202609-Oct-2026Delivery overdue - follow up
6
#100404-Oct-2026Samuel A.Bluetooth keyboardBK004$42.001$42.00PendingAwaiting PaymentSend payment reminder
7
#100505-Oct-2026Esther I.Phone ChargerPC009$15.003$45.00PaidProcessing13-Oct-2026Ship soon
8
#100606-Oct-2026Michael B.WebcamWC010$45.501$45.50PaidShippedTRK8420607-Oct-202614-Oct-2026Delivery overdue - follow up
9
#100706-Oct-2026Blessing N.Wireless EarbudWE008$39.992$79.98PaidOn Hold
Contact customer / check stock
10
#100807-Oct-2026Chika M.Laptop BackpackLB007$48.001$48.00RefundedCancelled
11
#100908-Oct-2026Ini T.Phone TripodPT005$18.992$37.98PaidProcessing15-Oct-2026Ship soon
12
#101008-Oct-2026Victor P.USB-C-HubUH003$29.501$29.50PaidShippedTRK8421009-Oct-202616-Oct-2026Delivery overdue - follow up
13
14
How to use: pick Product, Payment and Order Status from the dropdowns; SKU, price and total fill in automatically.
15
Alert column: flags overdue deliveries, unpaid orders (3+ days), orders waiting to ship (3+ days) and orders on hold. It uses today's date, so it updates each day.
16
Sample data only - customer names and tracking numbers are fictional.
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100