What Is the Shopify Order Report?
The Shopify Order Report summarizes your order and sales performance by date. Each row groups a period, a day, week, or month, and shows how many orders came in and how the money moved: order count, gross sales, discount, returns, net sales, shipping, tax, total duties, total sales, and tip. Report Pundit ships it as a free pre-built template that works on every Shopify plan, including Basic.
The report is built around three sales figures that are easy to confuse. Gross Sales is product price times quantity, before any deductions. Net Sales subtracts discounts and returns from that. Total Sales starts from net sales and adds shipping, tax, and duties back on, so it reflects the full amount customers paid at checkout. Reading the wrong one is the most common reason a period looks stronger or weaker than it really was.
It also helps to know that Order Count measures the number of orders, not the number of items sold. Merchants use this report for a fast, regular read on trading: what came in, what got discounted or returned, and how the trend is moving, without scrolling the admin order list one order at a time.
Which Fields Are Included in the Shopify Order Report?
These fields let you see, for any period, how many orders you took and how the revenue broke down from gross to total
You can customize the pre-made report by adding, removing, or rearranging fields, and by changing the grouping from daily to weekly or monthly to match how you review your store.
Important Insights You Can Find in This Report
Are discounts and returns eating into a strong gross sales period?
Compare Gross Sales against Net Sales for the same rows, then read the Discount and Returns columns to see which one is opening the gap. A period can show high gross sales while net sales stay flat because discounting ran heavier than planned or returns clustered in the same window. If the gap keeps widening on your busiest periods, that is where to look before you assume the period was as strong as the headline gross suggests.
Is your headline Total Sales inflated by shipping and tax rather than product revenue?
The difference between Net Sales and Total Sales is shipping, tax, and duties, none of which is product revenue you keep. When Total Sales climbs but Net Sales does not, the extra is money you are collecting and passing on, not growth in what you actually sold. Reading these two columns side by side keeps you from mistaking a rise in tax or shipping collected for a rise in real sales.
Are more orders turning into more net sales, or is order value slipping?
Track Order Count against Net Sales across dates. If order count rises while net sales stays flat, the average order is getting smaller, often from deeper discounts or a shift toward lower-value items. That combination tells you volume is up but value per order is down, which points to pricing or promotion decisions rather than a demand problem.
THE ANALYST'S READ: The Signal Most Merchants Miss
Watch how returns land on a different date than the sale. In Shopify's logic, a sale is counted on the date the order was placed, while a return is counted on the date it was processed, often days or weeks later. In a report grouped by Date, that means a return can pull down a period that had nothing to do with the original purchase.
The pattern to look for is a date where Net Sales or Total Sales dips below what Order Count and Gross Sales would suggest, with the Returns column carrying the difference. When that happens, the soft period may not be a demand problem at all. It could be the accounting tail of a strong sales period earlier in the range.
This is worth checking before you react to a weak-looking day. Read your returns as a rolling pattern across the period rather than a single-day event. A smoother, lagged return line usually reflects reality better than the spiky version a raw daily total shows.
How Can You Automate the Shopify Order Report?
Once the report is grouped and filtered the way you want, you do not have to rebuild it. Save your fields and grouping, then schedule recurring delivery so the summary arrives ready to read.
- Schedules: daily, weekly, monthly, or a custom frequency
- Formats: Excel, CSV, or PDF
- Destinations: email to multiple recipients, Google Sheets (live sync), Google Drive, and FTP/SFTP
- Grouping by day, week, or month, so a scheduled version shows the trend, not just a snapshot
- Saved filters and fields, so every delivery matches the view you built
This means your finance lead, VA, or accountant can receive the same order summary on a set schedule without opening the app.
Frequently Asked Questions
What does the Shopify Order Report show?
It shows your order and sales performance grouped by date. For each period it lists order count, gross sales, discount, returns, net sales, shipping, tax, total duties, total sales, and tip.
What is the difference between Gross Sales, Net Sales, and Total Sales?
Gross Sales is product price times quantity before deductions. Net Sales subtracts discounts and returns. Total Sales takes net sales and adds shipping, tax, and duties, so it reflects the full amount customers paid.
Does Order Count mean the number of orders or the number of items?
Order Count is the number of orders placed in the period. It does not count individual items, so an order with five products still counts as one.
Why don't my Total Sales match my payout?
Total Sales is the amount customers paid before Shopify and payment processing fees are taken out. Your payout is lower because transaction and gateway fees are deducted after this figure.
Can I filter the Shopify Order Report by date range?
Yes. Set any date range, from a single day to a full quarter, and the summary recalculates for the period you choose.
Can I group the report by day, week, or month?
Yes. Change the grouping to see daily detail or roll it up into weekly or monthly rows for a cleaner trend.
Can I schedule and export the Shopify Order Report automatically?
Yes. Export to Excel, CSV, or PDF on demand, or schedule recurring delivery to email, Google Sheets, Google Drive, or FTP/SFTP on a daily, weekly, or monthly cycle.