What Is the Sales by Collections Group Report?
The Sales by Collections Group report groups your Shopify sales by collection for a selected date range. Review units sold, gross sales, discounts, returns and net sales together to see which collections contribute the most sales and which need a closer look.
Use this view to compare seasonal ranges, product categories or merchandising groups without adding up individual product rows. It helps you choose which collections to feature, investigate or review before your next campaign.
A product can belong to more than one collection, so its sales can appear under each collection. Compare the rows side by side; adding them together can overstate store sales.
Report Overview
- Report type
- Sales & Orders; grouped by Collection Title.
- Report period
- The date range selected when generating the report.
- Data included
- Net Quantity, Gross Sales, Discounts, Returns and Net Sales.
- Best for
- Collection reviews, seasonal comparisons and promotion follow-ups.
- Export and delivery
- Excel, CSV or PDF; scheduled email delivery daily, weekly or monthly.
What Can You Learn from Collection Sales?
1. Which collections lead on net sales
Compare Net Sales to find your strongest collection rows within the selected period.
Example: For example, a Summer collection has higher net sales than the Autumn collection.
What you can do: Review the leading collection for homepage placement and relevant campaigns.
2. Where discounts deserve a review
Read Discounts alongside Gross Sales and Net Sales. A large discount amount calls for a closer look at the offer, but does not establish whether it was profitable.
Example: For example, a gift collection has strong gross sales but much lower net sales after adjustments.
What you can do: Compare equivalent periods and inspect the promotion before repeating it.
3. Which collections have substantial returns
Returns can help you identify collections that need a product-level investigation. The grouped figures do not explain why customers returned items.
Example: For example, a furniture collection has a larger return value than the previous month.
What you can do: Review the products and return reasons separately before changing the range.
What Should You Check First in This Report?
Start with these checks before changing a collection or campaign.
- Net Sales: Rank collections by sales after adjustments, and compare the same date range.
- Discounts: Check whether large reductions explain the gap between gross and net sales.
- Returns: Investigate substantial return values before calling a collection a strong performer.
- Net Quantity: Read unit volume alongside sales value; higher-priced collections can generate more sales from fewer units.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Planning seasonal merchandising | Compare collection sales over comparable periods before changing featured ranges. |
| Reviewing a collection promotion | Read discounts and net sales together to decide what needs further investigation. |
| Investigating return-heavy ranges | Spot collection rows with substantial return values and inspect the underlying products. |
| Preparing a monthly sales review | Give the team a consistent collection-level export of units and sales amounts. |
| Deciding which collections need attention | Find low-sales collections to review for visibility, assortment or availability. |
How to Create This Report in Data Export
Start with the premade Sales by Collections Group report.
- Open Data Export and go to Prebuilt Reports.
- Open Sales by Collections Group and review the included columns.
- Set your date range and apply available collection or sales channel filters as needed.
- Save the report and export it in your preferred supported format.
- For recurring reviews, schedule daily, weekly or monthly email delivery to the relevant team members.
Make the Most of This Report
Use these checks to keep collection comparisons useful.
01 / PERIODS
Compare like periods. Use equal-length date ranges and account for seasonal demand before judging collection changes.
02 / COUNTING
Allow for overlap. A product’s sales may appear in multiple collections; do not sum the rows into store revenue.
03 / VISUALS
Chart net sales. Export to Excel or Google Sheets and use a bar chart to compare collection rows.
04 / CONTEXT
Check availability separately. Low sales can reflect unavailable products; these six fields do not show current stock.
Frequently Asked Questions
Why can collection sales add up to more than store sales?
Products can belong to multiple collections, and their sales can appear under each one. Use the report to compare collections rather than calculate a deduplicated store total.
Does this report show collection profit?
No. Net Sales is a sales measure. These fields do not include product costs, advertising spend or other expenses needed to calculate profit.
Can I compare seasonal collections?
Yes. Select the relevant period and compare collection rows. For changes over time, generate reports for equivalent periods and review them side by side.
Can I export the report and create charts?
Yes. Download Excel, CSV or PDF, or send the data to Google Sheets using the available delivery settings. Build a bar chart in Excel or Sheets to compare net sales; overlapping collections make a share-of-total pie chart misleading.
Can this report be emailed automatically?
Yes. Schedule daily, weekly or monthly email delivery after saving the report. Review recipients and the reporting period before activating the schedule.