What Is the Shopify Sales by Product Report?
The Shopify Sales by Product report shows how many units each product sold and the sales value recorded for your selected date range. It brings net quantity, gross sales, discounts, returns, net sales, tax, and total sales together with the product title, vendor, and type.
Each row represents one product, combining sales across its sizes, colors, and other variants. This makes it easier to compare products as a whole. Use the Sales by Variant report when you need a separate breakdown by SKU or option.
In Data Export, you can open the premade report, adjust its columns, and save a version for regular reviews. Use it to prepare a product sales export, compare revenue after deductions, and give your team a consistent report to work from.
Report Overview
- Report period
- Any selected date range, with one row per product.
- Data included
- Ten fields covering product details, units, sales, discounts, returns, and tax.
- Best for
- Product sales reviews, purchasing discussions, and revenue comparisons.
- Export formats
- Excel, CSV, and PDF.
- Automation
- Schedule daily, weekly, or monthly delivery by email, FTP, or SFTP.
What Can You Learn from Product Sales Data?
1. Which products lead on units and revenue
Compare Net Quantity with Net Sales to see whether your busiest products are also your strongest revenue contributors.
Example: A hypothetical accessory leads on units, while a higher-priced jacket leads on net sales.
What you can do: Bring both rankings into purchasing discussions and check current stock before reordering.
2. Where discounts reduce sales value
Read Discount alongside Gross Sales to understand how much of a product’s sales value comes off through markdowns.
Example: A hypothetical product records $2,000 in gross sales and $400 in discounts.
What you can do: Review the offers used on that product before repeating the promotion.
3. Which products need a returns review
Compare Returns with Gross Sales and Net Sales to find products whose sales value falls substantially after returns.
Example: A hypothetical bestseller falls below other products once returns are deducted.
What you can do: Investigate the reasons for returns before increasing the product’s purchase quantity.
What Should You Check First in This Report?
Start with the fields that make product comparisons useful.
- Net Quantity: Rank products by units sold after returns, keeping your selected date range consistent.
- Net Sales: Compare product revenue after discounts and returns. This figure does not show profit.
- Discount and Returns: Check which deduction explains the gap between gross and net sales.
- Product Title, Vendor, and Type: Check that you are comparing the intended products and groups.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Preparing for a purchasing review | Shows the products contributing the most units and net sales, ready to compare with a separate stock report. |
| Reviewing a product promotion | Places discounts beside gross and net sales so you can assess revenue after markdowns. |
| Investigating reduced product revenue | Helps you see whether discounts or returns account for the reduction. |
| Comparing two sales periods | Provides a consistent product export for each period, making changes easier to review. |
| Sharing a recurring product summary | Delivers the saved fields and layout to the people who need the numbers. |
How to Create This Report in Data Export
Start with the premade Sales by Product report and save the view you want to reuse.
- Open Data Export and find the premade Sales by Product report.
- Open the report and choose your date range.
- Review the fields, reorder or remove columns, and apply a product filter if needed.
- Run the report, check the results, and save your version.
- Download Excel, CSV, or PDF, or schedule daily, weekly, or monthly delivery. Choose email, FTP, or SFTP and set the recipients or destination.
Make the Most of This Report
Use these tips to keep each export useful and easy to compare.
01 / PERIODS
Compare equal periods. Use matching date ranges, such as two complete weeks, to avoid mistaking a shorter period for weaker sales.
02 / PRODUCT DETAIL
Keep the right level of detail. Product rows combine variants; use Sales by Variant when size, color, or SKU matters.
03 / STOCK DECISIONS
Check stock separately. Net Quantity measures sales activity. Pair the export with current inventory and supplier lead times before placing a purchase order.
04 / SHARING
Send the useful columns. Save a focused layout for the recipient, then review the date range and delivery settings before scheduling it.
Frequently Asked Questions
Does this report show separate rows for each variant?
No. It combines a product’s variants into one product row. Use Sales by Variant for a breakdown by SKU, size, or color.
How do gross sales and net sales differ?
Gross sales is product revenue before discounts and returns. Net sales subtracts those deductions, before tax and shipping. Neither figure measures profit.
Can I compare product performance over time?
Yes. Run the report for matching date ranges and compare the exports. Keep the columns, filters, and period lengths consistent so the comparison is useful.
Can I change the columns or focus on one product?
Yes. Add, remove, or reorder columns, sort the results, and filter for a product. Save your version to reuse the same layout.
Can I export this report and schedule delivery?
Yes. Export it as Excel, CSV, or PDF, or schedule daily, weekly, or monthly delivery by email, FTP, or SFTP.