Order tracker
Every customer order from placed to delivered and paid.
Two tabs. Orders has one row per order with its status and whether it is paid. Customers adds up how many orders each customer has placed and how much they have spent.
Try this templateAsk it things like
- “Which orders are still unshipped?”
- “Has order ORD-1012 shipped?”
- “How much is unpaid right now?”
- “Who is our top customer by spend?”
- “Which orders have been open for more than 7 days?”
What you can do
- Look up orders
- Add an order
- Update an order's status
- Mark an order paid
- Add a customer
What is in the sheet
Orders: Order ID, Order date, Customer, Product, Quantity, Unit price, Status, Shipped date, Payment status, Amount, Days open
Customers: Customer, Phone, City, Orders, Total spent