DTC / E-Commerce

Shopify Order Tracker

Track every order from purchase to delivery, with auto-deduplicated customers, lifetime value, daily revenue trend, and top-customer rankings. Status pills on every order.

What's Inside

Start Here — How to add orders, how Customers auto-deduplicates, and connecting Shopify automation.
Orders — One row per order with Date, Customer, Email, Items, Total, Status pills (Pending / Shipped / Delivered / Cancelled / Refunded), Tracking #, Carrier.
Customers — Auto-built from Orders. Total Orders, Lifetime Value, AOV, Last Order Date per unique email.
Dashboard — Snapshot (Total Orders, Revenue, AOV, Pending, Shipped), Orders-by-Status column chart, Top 5 Customers by LTV, daily revenue line chart.

Key Features

Customers tab auto-aggregates from Orders — no manual customer entry.
Status pills with dropdown validation on every order.
"Pending" tile flags orders that haven't shipped yet.
Top 5 customers by Lifetime Value surfaced on the Dashboard.
Daily revenue trend line chart.
Drops into a Zapier / n8n pipeline — append a row, formulas update.

Sample Formulas

Here are some of the formulas powering this template:

Auto-build unique customer list

=SORT(UNIQUE(FILTER(Orders!C2:C, Orders!C2:C<>"")), 1, TRUE)

Lifetime value per customer

=SUMIF(Orders!C:C, A2, Orders!F:F)

Daily revenue trend

=QUERY(Orders!B2:F, "SELECT B, SUM(F) WHERE B IS NOT NULL GROUP BY B ORDER BY B")

Get this template free

Enter your email and we'll give you instant access to copy this template into your Google Drive.

You're in.

Click below to copy this template into your Google Drive. Check your email for setup instructions.

Make a Copy

Need this synced with Shopify automatically?

We build custom integrations that pull Shopify orders, inventory, and customer data into Google Sheets in real time — no manual exports, no copy-paste.

Start a build