Order Tracker

Follow every order from placed to delivered — items, totals, payment, courier and tracking — with lifetime value per customer.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Inventory

Tables

Orders, Customers

Fields

24

Views

grid, kanban, calendar, form, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

2 tabs24 fields10 sample rows

Views
  • All orders (Grid view)
  • Fulfilment (Kanban view)
  • Deliveries (Calendar view)
  • Place an order (Form view)
  • Sales (Report view)
16 fields
Orders: 6 sample rows
RowOrder ID (Text)Customer (Link to another table)Order date (Date)Items (Long text)Units (Number)Subtotal (Currency)Shipping (Currency)Discount (Currency)Total (Formula)Payment (Single select)Status (Single select)Courier (Single select)Tracking number (Text)Expected delivery (Date)Delivery (Formula)Notes (Long text)
1
ORD-1041
Pooja Sharma
10 Nov 2026
Handloom cotton saree ×1
1
₹3,400
₹0
₹200
₹3,200
Paid – UPI
Delivered
Delhivery
DLV8812345
15 Nov 2026
2
ORD-1042
Michael Brown
13 Nov 2026
Block-print cushion covers ×4
4
₹2,800
₹1,200
₹0
₹4,000
Paid – card
Shipped
DHL
DHL4433221100
21 Nov 2026
2 days to go
3
ORD-1043
Pooja Sharma
17 Nov 2026
Brass diya set ×2
2
₹1,800
₹80
₹0
₹1,880
Paid – UPI
Packed
Shiprocket
22 Nov 2026
3 days to go
4
ORD-1044
Arvind Swamy
14 Nov 2026
Kalamkari table runner ×1
1
₹1,250
₹80
₹100
₹1,230
Cash on delivery
Shipped
Blue Dart
BD77001234
18 Nov 2026
Late
5
ORD-1045
Fatima Al-Sayed
19 Nov 2026
Pashmina stole ×2
2
₹7,600
₹1,500
₹760
₹8,340
Paid – card
New
27 Nov 2026
8 days to go
6
ORD-1039
Arvind Swamy
30 Oct 2026
Terracotta planter ×3
3
₹1,500
₹80
₹0
₹1,580
Refunded
Returned
Delhivery
One planter arrived cracked.
Field details

Orders

Order ID · Text
Customer · Link to another table
Links to Customers
Order date · Date
Items · Long text
Units · Number
Subtotal · Currency
INR
Shipping · Currency
INR
Discount · Currency
INR
Total · Formula
{Subtotal} + {Shipping} - {Discount}
Payment · Single select
Paid – UPI, Paid – card, Cash on delivery, Refunded, Unpaid
Status · Single select
New, Packed, Shipped, Delivered, Returned, Cancelled
Courier · Single select
Delhivery, Blue Dart, Shiprocket, India Post, DHL
Tracking number · Text
Expected delivery · Date
Delivery · Formula
IF(OR({Status} = 'Delivered', {Status} = 'Cancelled', {Status} = 'Returned'), '', IF(AND({Expected delivery}, IS_BEFORE({Expected delivery}, TODAY())), 'Late', IF({Expected delivery}, DATETIME_DIFF({Expected delivery}, TODAY(), 'days') & ' days to go', '')))
Notes · Long text

Form view “Place an order” asks for: Customer, Items, Units, Notes.

Customers

Customer · Text
Email · Email
Phone · Phone
Shipping address · Address
Orders · Link to another table
Links to Orders
Order count · Count
Lifetime value · Rollup
sum of Total via Orders
Last order · Rollup
latest of Order date via Orders

Order Tracker: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates