Short answer: A useful weekly Shopify report has seven numbers: orders, gross sales, discounts, refunds, net sales, average order value, and returning customers. Add one table that ranks your top products by revenue. You can build it from Shopify's orders CSV export in a spreadsheet. The one thing to get right is that the export has one row per line item, not one row per order.
Shopify already ships more than 60 pre-built reports. If you're happy reading those in Shopify admin, keep doing that. This guide is for people who want one page they can send to a partner, a bookkeeper, or themselves every Monday, with the same numbers in the same place each week.
What Shopify means by gross, net, and total sales
Use Shopify's own definitions so your sheet matches the admin. From the Shopify Help Center sales report reference:
- Gross sales = product price × quantity, before taxes, shipping, discounts, and sales reversals.
- Net sales = gross sales − discounts − sales reversals (returns, cancellations, and other negative adjustments).
- Total sales = net sales + taxes + duties + shipping charges + fees.
- Average order value = (gross sales − discounts) ÷ number of orders, with later adjustments excluded.
Net sales is the number to watch week to week. Total sales includes tax and shipping, which you collect but don't keep as revenue.
The quirk that breaks homemade Shopify reports
Shopify's orders export documentation says that orders with several line items put each extra item on its own row, and "many of the fields are left blank" on those rows. Order-level fields like Financial Status, Discount Amount, and Total sit on the first row of the order only.
Two mistakes follow from this:
- Counting rows as orders. An order with three products becomes three rows, so your order count is inflated.
- Filling down money columns. If you fill the blank Discount Amount or Total cells to "tidy up," every multi-item order gets counted two or three times.
The fix is to count orders with a column that only the first row fills, and to sum order-level money columns as they are. Line-level columns (quantity, price) are complete on every row, so they're safe to multiply and sum.
Worked example
Example data, made up for this post. It's a trimmed orders export from a small homewares store, with only the columns we need. Put it on a sheet called Orders starting in A1.
| Name | Financial Status | Created at | Discount Amount | Refunded Amount | Lineitem quantity | Lineitem name | Lineitem price | |
|---|---|---|---|---|---|---|---|---|
| #1001 | ana@example.com | paid | 2026-11-03 | 0 | 0 | 1 | Canvas Tote | 38 |
| #1002 | ben@example.com | paid | 2026-11-05 | 5 | 0 | 2 | Ceramic Mug | 18 |
| #1003 | cara@example.com | paid | 2026-11-07 | 0 | 0 | 1 | Linen Apron | 42 |
| #1004 | ana@example.com | paid | 2026-11-09 | 0 | 0 | 1 | Ceramic Mug | 18 |
| #1004 | 2026-11-09 | 1 | Canvas Tote | 38 | ||||
| #1005 | dev@example.com | paid | 2026-11-10 | 10 | 0 | 1 | Linen Apron | 42 |
| #1005 | 2026-11-10 | 2 | Ceramic Mug | 18 | ||||
| #1006 | eli@example.com | refunded | 2026-11-11 | 0 | 38 | 1 | Canvas Tote | 38 |
| #1007 | ben@example.com | paid | 2026-11-12 | 0 | 0 | 3 | Ceramic Mug | 18 |
| #1008 | fay@example.com | paid | 2026-11-13 | 6 | 0 | 1 | Linen Apron | 42 |
| #1008 | 2026-11-13 | 1 | Canvas Tote | 38 | ||||
| #1009 | gus@example.com | paid | 2026-11-14 | 0 | 0 | 1 | Canvas Tote | 38 |
| #1010 | cara@example.com | partially_refunded | 2026-11-15 | 0 | 18 | 2 | Ceramic Mug | 18 |
We'll report on the week of Nov 9–15, 2026. Put the start date in L1 (2026-11-09) and the end date in L2 (2026-11-15).
Before you start: a real export stores Created at as a timestamp with a time zone offset (for example 2026-11-09 14:03:22 -0700), and your spreadsheet may read it as text. Add a helper column with =DATEVALUE(LEFT(D2,10)) and point the formulas at that column instead. If your export leaves Created at blank on extra line-item rows, filling down dates is safe. Never fill down money.
The seven numbers
These formulas work in both Google Sheets and Excel 365.
| Metric | Formula | Result |
|---|---|---|
| Orders | =COUNTIFS(C2:C14,"<>",D2:D14,">="&L1,D2:D14,"<="&L2) |
7 |
| Gross sales | =SUMPRODUCT((D2:D14>=L1)*(D2:D14<=L2)*G2:G14*I2:I14) |
$380 |
| Discounts | =SUMIFS(E2:E14,D2:D14,">="&L1,D2:D14,"<="&L2) |
$16 |
| Refunds | =SUMIFS(F2:F14,D2:D14,">="&L1,D2:D14,"<="&L2) |
$56 |
| Net sales (approx.) | =Gross − Discounts − Refunds |
$308 |
| Average order value | =(Gross − Discounts) / Orders |
$52.00 |
| Units per order | =SUMIFS(G2:G14,D2:D14,">="&L1,D2:D14,"<="&L2) / Orders |
2.0 |
The orders formula counts rows where Financial Status is filled in. Only the first row of each order fills it, so you get 7 orders instead of 10 rows.
The net sales figure is an approximation. The export's Refunded Amount can include refunded shipping and tax, and Shopify's own reports book a refund on the date it was processed, not the order date. Use this sheet to see the breakdown, and check the headline figure against Shopify's own sales reports in admin.
Returning customers
Shopify defines returning customer rate as returning customers divided by all customers who ordered in the period. To reproduce it, add a helper column J called First order with this formula in J2, filled down:
=IF(B2="","",MINIFS($D$2:$D$14,$B$2:$B$14,B2))
Then count distinct customers this week, and the ones whose first order came before the week started:
Customers: =ROWS(UNIQUE(FILTER(B2:B14,(B2:B14<>"")*(D2:D14>=L1)*(D2:D14<=L2))))
Returning: =ROWS(UNIQUE(FILTER(B2:B14,(B2:B14<>"")*(D2:D14>=L1)*(D2:D14<=L2)*(J2:J14<L1))))
In the example, 3 of 7 customers (Ana, Ben, and Cara) are returning. That's about 43%. Your export needs to go back far enough to see first orders. A one-week export will show every customer as new.
Top products by revenue
=SUMPRODUCT((H2:H14="Canvas Tote")*(D2:D14>=L1)*(D2:D14<=L2)*G2:G14*I2:I14)
| Product | Units | Revenue (before discounts) |
|---|---|---|
| Canvas Tote | 4 | $152 |
| Ceramic Mug | 8 | $144 |
| Linen Apron | 2 | $84 |
Mugs move twice as many units as totes but bring in less revenue. If you only look at units, you'd reorder the wrong thing first.
How to read the example week
A report is only useful if it changes what you do. Here's what this week says:
- Refunds were 15% of sales after discounts ($56 of $364). That's high, but it comes from two orders. On small numbers, one refund swings the rate a lot. Look at the reasons before treating it as a trend.
- Discounts were 4% of gross sales ($16 of $380). That's low enough not to worry about yet.
- The prior week (Nov 3–8) had 3 orders and $116 gross, so this week is up. With weekly numbers this small, compare 4-week totals before you call it growth.
What to leave out of a weekly report
Sessions and conversion rate. These are useful, but they live in Shopify Analytics, not the orders export. Add them by hand from the admin if you watch them, or keep them on a separate traffic page.
Profit. Shopify only shows gross profit if you've entered product costs. Without cost data, a profit number in your sheet is a guess. Leave it out until the costs are in.
More than one page. If the report doesn't fit on one screen, nobody reads the bottom half.
Doing this without the spreadsheet work
If rebuilding these formulas every week sounds tedious, Chartlet.AI's Shopify connector imports Orders, Order Line Items, Products, or Customers with read-only access. The Shopify connector is on the Plus plan and above, and Pro keeps it in sync every week. It then builds a dashboard you can ask plain-English questions about, like "which products drove revenue last week?" Check the answers against the rows on the dataset's page, the same way you'd check a formula. The weekly report in this guide, built from a CSV export, works on the Free plan. Connect your Shopify store. Or start with a CSV export on the Free plan, no credit card.
FAQ
What is the best Shopify report to check weekly?
Net sales compared with the previous week, plus orders and average order value. Those three tell you whether you sold more, to more people, or more per order.
Why doesn't my order count match Shopify?
The orders export has one row per line item, so counting rows overcounts. Count only rows where an order-level field such as Financial Status is filled in.
Is net sales the same as revenue?
In Shopify, net sales is gross sales minus discounts and sales reversals. It excludes tax and shipping. Most store owners treat net sales as revenue for reporting.
How does Shopify calculate average order value?
Gross sales minus discounts, divided by the number of orders, with later edits and returns excluded (Shopify Help Center).
How far back should my export go?
At least as far back as you want to count returning customers. For a weekly report, export the last 12 months and filter to the week with the date cells.