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 template

Ask it things like

What you can do

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