Template library › Orders and deliveries
Online orders
A Google Sheets template by TrackerHacker LLC, version 1.
Orders from your shopping emails. An On the way tab shows what hasn't arrived and flags late ones, and TrackerHacker asks whether each order arrived. Spending this month on Glance. You add a hack for each sender the first time its email arrives.
Online ordersv1
Use this templateGoogle asks you to choose the template once, then TrackerHacker copies it into your own Google Drive, charts and all, and you pick the emails that fill it, like your bank's or PayPal's. New here? You sign in with Google on the way.
Columns
- Date (always filled): The day you placed the order.
- Shop (always filled): Where you ordered from, like Amazon.
- Order number: The shop's number for the order. A later email about the same order updates its row.
- Items: What you ordered, as the email lists it.
- Total: What the order cost, including tax and shipping, if the email says.
- Currency: ISO code such as USD; blank means your usual currency.
- Status: Where the order is, like Ordered, Shipped, Delivered or Cancelled.
Copied it and connected your copy? TrackerHacker asks how it's going on your sheet's page after two weeks, and your stars show up here.
More orders and deliveries templates · Template library · What is TrackerHacker?