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
Tables
Orders, Customers
Fields
24
Views
grid, kanban, calendar, form, dashboard
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
| Row | Order 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. |
| Row | Customer (Text) | Email (Email) | Phone (Phone) | Shipping address (Address) | Orders (Link to another table) | Order count (Count) | Lifetime value (Rollup) | Last order (Rollup) |
|---|---|---|---|---|---|---|---|---|
| 1 | Pooja Sharma | +91 98111 23456 | B-12 Vasant Kunj, New Delhi, 110070, India | ORD-1041ORD-1043 | 2 | ₹5,080 | 17 Nov 2026 | |
| 2 | Michael Brown | +1 646 555 0172 | 210 W 85th St, New York, NY, 10024, United States | ORD-1042 | 1 | ₹4,000 | 13 Nov 2026 | |
| 3 | Arvind Swamy | +91 98840 55667 | 45 TTK Road, Alwarpet, Chennai, 600018, India | ORD-1044ORD-1039 | 2 | ₹2,810 | 14 Nov 2026 | |
| 4 | Fatima Al-Sayed | +971 55 987 6543 | Marina Gate 2, Apt 1904, Dubai, United Arab Emirates | ORD-1045 | 1 | ₹8,340 | 19 Nov 2026 |
Orders
Form view “Place an order” asks for: Customer, Items, Units, Notes.
Customers
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.
Products with SKUs, costs and prices, where stock on hand is calculated live from every stock-in, sale, return and adjustment.
2 tables · 25 fieldsArt Inventory TemplateCatalogue every artwork with images, medium, location, provenance and pricing, linked to the artists you represent.
2 tables · 24 fieldsAsset Inventory TemplateA fixed-asset register with tags, assignees, warranty dates and straight-line depreciation to today’s book value.
1 table · 18 fieldsBar Inventory TemplateCount spirits, beer, mixers and bar equipment against par levels, see what to order from which supplier and what your stock is worth.
2 tables · 21 fieldsBook Inventory TemplateTrack titles, ISBNs, copies on the shelf and margins for a bookstore or library, with low-stock flags and cover gallery.
1 table · 17 fieldsEquipment Inventory TemplateKnow where every piece of equipment is, when it is due for service, and who has it checked out right now.
2 tables · 27 fields