What Is the Shopify Order Report?
The Shopify Order Report brings daily order activity and sales amounts into one view. It lists the date and order count alongside gross sales, discounts, returns, net sales, shipping, tax, total duties, tips and total sales for the period you choose.
Use it to review how order volume and sales values change from day to day. Because discounts, returns and other amounts appear beside sales, you can see what contributes to the reported totals without switching between separate views.
The premade report in Data Export is ready with these columns. You can save it as supplied or adjust the report to suit a recurring review with your team or accountant.
Report Overview
- Report period
- A date range chosen for your order review, with results organized by date.
- Data included
- Order count plus ten sales-related amount fields.
- Best for
- Daily sales reviews, weekly performance checks and finance handoffs.
- Available exports
- Excel, CSV, TXT or PDF.
- Delivery
- Schedule email delivery daily, weekly or monthly; Google Sheets, Google Drive and FTP destinations are also available.
What Can You Learn from Your Order Data?
1. Which dates bring in more orders?
Compare Date and Order Count to spot busy days, slower periods and shifts in order activity.
Example: On a hypothetical Saturday, the store records 85 orders compared with 50 on Friday.
What you can do: Compare similar weekdays before changing staffing or promotion plans.
2. How much are discounts affecting sales?
Read Gross Sales, Discount and Net Sales together to see whether a strong sales day also involved substantial discounting.
Example: A hypothetical $8,000 gross-sales day includes $1,200 in discounts.
What you can do: Review discount-heavy dates alongside campaign activity before running the same offer again.
3. Are returns changing the sales picture?
Returns and Net Sales help show when returned amounts reduce the sales outcome despite an apparently healthy gross-sales figure.
Example: A hypothetical day with high gross sales also shows $900 in returns.
What you can do: Investigate the relevant period with an order- or product-level report when more detail is needed.
4. What makes up total sales?
Review Shipping, Tax, Total Duties and Tip alongside Net Sales and Total Sales so you do not mistake every part of the total for merchandise revenue.
Example: A hypothetical $5,000 total-sales day includes shipping and tax amounts.
What you can do: Share the separated amounts with finance before comparing reports.
What Should You Check First in This Report?
Begin with the measures that best explain both order activity and the sales breakdown.
- Order Count by Date: Check the pattern across days rather than focusing only on a single peak.
- Gross Sales versus Net Sales: Look for dates when discounts and returns materially change the picture.
- Returns and Discount: Review unusually high amounts before drawing conclusions from a strong headline total.
- Total Sales with Shipping, Tax, Duties and Tip: Keep non-merchandise components visible during financial reviews.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Checking daily orders and total sales | Reviews order count and total sales by date to spot changes. |
| Reviewing sales during a promotion | Compares gross sales and discounts across campaign periods. |
| Planning around busy and quiet trading days | Uses daily order counts to understand busy and quiet periods. |
| Preparing a breakdown of sales components | Reviews net sales, shipping, tax, duties and tips as separate amounts. |
| Sharing a recurring dated sales summary | Receives a consistent dated sales breakdown for further review. |
How to Create This Report in Data Export
Start with the premade Order Report rather than building every column from scratch.
- Open Data Export and find the premade Order Report.
- Open the report and review its 11 columns, including Date, Order Count and the sales amounts.
- Choose your reporting date range; adjust available columns or filters if your review needs a narrower view.
- Select Save to keep the report configuration. Export the results in your preferred available format.
- If needed, schedule delivery daily, weekly or monthly to the intended recipients or configured destination.
Make the Most of This Report
These four habits help make the dated sales summary easier to interpret and share.
01 / PERIODS
Compare like-for-like dates — Match weekdays or comparable trading periods when reviewing changes in order volume.
02 / CONTEXT
Read the breakdown — Keep discounts and returns next to gross sales rather than relying on one total.
03 / DETAIL
Use a second report for products — This report is grouped by date, not by product or variant.
04 / DELIVERY
Keep a consistent schedule — Send the same report period and columns to the people who need them.
Frequently Asked Questions
What does the Shopify Order Report show?
It shows Date, Order Count, Gross Sales, Discount, Returns, Net Sales, Shipping, Tax, Total Duties, Total Sales and Tip for the selected period.
Can I view orders by day?
Yes. The report uses Date as a field, so you can review daily order counts and sales amounts within your chosen date range.
Does the report list each individual order or product?
Not in the supplied premade layout. It is a date-based summary. Use or build a more detailed report if you need order IDs, products, variants or individual transactions.
Can I export the report to Excel or PDF?
Yes. You can export in Excel, CSV, TXT and PDF. Use Excel for further analysis or PDF for a shareable summary.
Can I schedule the Order Report?
Yes. You can schedule daily, weekly and monthly emails, including sending the report to team members or an accountant. Other configured destinations may also be available.
