What Is the Sales by Collections Report?
The Sales by Collections report in Data Export shows sales performance for Shopify smart collections. Each row represents a smart collection, with Order Count, Net Quantity, and Total Sales for your selected reporting period.
Smart collections group products automatically using conditions such as tags, vendor, product type, or price. Reviewing sales at this level helps you compare the product groups used to organize your store and decide which deserve a closer merchandising review.
Use this report to compare collection sales and share a regular export with your team. Its four default fields do not include collection page visits, conversion rates, costs, or profit, so use separate data to investigate those questions.
Report Overview
- Report period
- Choose the date range when generating the report.
- Data included
- Smart Collections, Order Count, Net Quantity, and Total Sales.
- Best for
- Comparing smart collection sales and planning merchandising reviews.
- Export formats
- Excel, CSV, TXT, or PDF.
- Automation
- Schedule email delivery daily, weekly, or monthly.
What Can You Learn from Collection Sales?
1. Which smart collections lead on sales
Sort by Total Sales to compare collections within the same reporting period. This identifies groups worth reviewing for storefront placement.
Example: For example, new Arrivals records more total sales than Summer Essentials.
What you can do: Review the leading collection’s product mix before changing featured placements.
2. Which collections move more units
Compare Net Quantity with Total Sales to distinguish high unit volume from a higher sales amount. Neither measure alone establishes profitability.
Example: For example, everyday Essentials leads on net quantity while Premium Gifts leads on total sales.
What you can do: Review stock separately for the collections moving the most units.
3. Which collections appear across more orders
Order Count helps you compare how frequently collections appear in reported orders. Read it alongside quantity and sales to understand each group’s contribution.
Example: For example, accessories appears in more orders than Outerwear but records lower total sales.
What you can do: Investigate product prices and assortment before deciding which group needs attention.
4. Which collections need a follow-up review
Lower sales can identify a collection to investigate, but the report does not establish why it underperforms. Check its rules, included products, and promotion history.
Example: For example, a featured seasonal collection records fewer sales than expected.
What you can do: Check its product selection and use separate traffic data to assess visibility.
What Should You Check First in This Report?
Start with a consistent reporting scope, then review the three sales measures together.
- Date range: Use comparable periods when evaluating collection performance.
- Total Sales: Sort to find the largest reported sales amounts before reviewing smaller collections.
- Net Quantity: Identify collections with stronger unit movement; check inventory in a separate stock report.
- Order Count: Compare order activity with quantity and sales before drawing conclusions about product demand.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Planning featured collection placements | Compare Total Sales and Order Count to select collections for a merchandising review. |
| Reviewing seasonal product groups | Assess the reported sales and net quantity of seasonal smart collections. |
| Preparing a collection sales update | Export one view of collection names and sales measures for your team. |
| Investigating a weak collection | Identify low reported sales, then review collection rules and included products. |
| Prioritizing a stock review | Use Net Quantity to choose collection groups for a separate inventory check. |
How to Create This Report in Data Export
Start with the premade Sales by Collections report instead of building the field list yourself.
- Open Data Export in your Shopify admin and find the premade Sales by Collections report.
- Open it and review Smart Collections, Order Count, Net Quantity, and Total Sales.
- Select your date range. Apply the filters or additional fields needed for your collection review.
- Save the report and generate it. Review the results, then export in your preferred supported format.
- If needed, schedule daily, weekly, or monthly email delivery to yourself or your team.
Make the Most of This Report
Use these checks to keep collection comparisons and shared exports useful.
01 / PERIODS
Compare like periods: Keep date ranges consistent and account for seasonal promotions before comparing results.
02 / COLLECTION RULES
Check the product mix: Review which products meet a smart collection’s rules when interpreting its sales.
03 / COUNTING
Check overlap: Before adding collection rows, confirm how products belonging to multiple collections are counted.
04 / DELIVERY
Choose the right format: Use Excel or CSV for further analysis and PDF for a readable team update.
Frequently Asked Questions
Does this report cover smart collections?
Yes. The default collection field is Smart Collections, which refers to automated product groups. Manual collections are not listed as a default field in this report.
Can I see collection traffic or conversion rates?
No. The default fields show order count, net quantity, and total sales. Use separate traffic and conversion data to assess whether collection visibility leads to purchases.
Can I add all collection rows to get store sales?
Confirm how overlapping collection membership is handled before summing rows. Do not assume collection totals are mutually exclusive or that their sum equals store sales.
Can I customize and export the report?
Yes. Adjust available fields and filters, including saved Shopify properties or metafields where needed. Export the results as Excel, CSV, TXT, or PDF.
Can I receive the report automatically?
Yes. Save your configuration and schedule email delivery daily, weekly, or monthly. Each delivered export reflects the report generated for that run.