What Is the Best Selling Collections Report?
The Best Selling Collections report in Data Export helps you identify the custom collections leading on product movement and net sales. It brings together Custom Collections, Net Quantity Sold, and Total Net Sales so you can rank collections using the measure that matters for your next decision.
Each row summarizes a custom collection for your selected reporting period. Use it to compare curated groups such as New Arrivals, Sale, Holiday, or a campaign collection before choosing what to feature on your homepage, in navigation, or in your next email.
Review both sales measures together. The collection selling the most units may differ from the one generating the most net sales, so a single ranking will not answer every merchandising question.
Report Overview
- Report period
- Your selected date range.
- Data included
- Custom Collections, Net Quantity Sold, and Total Net Sales.
- Best for
- Ranking custom collections before selecting merchandising and promotion priorities.
- Export formats
- Excel, CSV, TXT, and PDF.
- Automation
- Schedule email delivery daily, weekly, or monthly.
What Can You Learn from Your Collection Rankings?
1. Find the Collections Leading on Net Sales
Sort by Total Net Sales to see which curated collections generate the highest net sales in the selected period. Use this ranking when choosing which collections deserve prominent placement.
Example: For example, holiday leads net sales even though Sale sells more units.
What you can do: Give Holiday a homepage feature and review its results in the next reporting period.
2. Identify the Collections Moving the Most Units
Sort by Net Quantity Sold to find your volume leaders. This helps you choose collections for promotions aimed at product movement, without treating unit volume as a revenue ranking.
Example: For example, everyday Essentials sells 420 net units, ahead of every other collection.
What you can do: Include Everyday Essentials in your next collection promotion.
3. Recognize Different Kinds of Best Sellers
Read the two measures together to distinguish collections with strong unit volume from collections with strong net sales. A high sales ranking alone does not establish profitability or explain what caused demand.
Example: For example, premium Gifts ranks second on net sales but seventh on units.
What you can do: Choose the ranking that fits the campaign goal before selecting a featured collection.
What Should You Check First in This Report?
Make these checks before sharing a list of your top collections.
- Reporting period: Use the same date range for every collection in a comparison.
- Total Net Sales: Check the sales leaders when the goal is revenue contribution.
- Net Quantity Sold: Check unit leaders when the goal is product movement.
- Collection scope: Confirm the custom collections you want to compare are included before exporting.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Choosing a homepage collection feature | Rank collections by net sales or units before assigning prominent placement. |
| Planning an email featuring collections | Select collections with demonstrated sales in the chosen period. |
| Reviewing a seasonal assortment | Compare seasonal collection results for the relevant sales window. |
| Reordering collection navigation | Use sales rankings to inform which collections receive greater visibility. |
| Preparing a weekly merchandising review | Export the same fields on a recurring schedule for a consistent team discussion. |
How to Create This Report in Data Export
Start with the premade Best Selling Collections report; its three core columns are already selected.
- Open Data Export in your Shopify admin and find the premade Best Selling Collections report.
- Open the report and review Custom Collections, Net Quantity Sold, and Total Net Sales.
- Set your date range, apply the filters you need, and sort by Total Net Sales or Net Quantity Sold.
- Save the report, then export it in Excel, CSV, TXT, or PDF for your review.
- Optionally schedule daily, weekly, or monthly email delivery to yourself or the team reviewing collection performance.
Make the Most of This Report
Keep each collection review focused and easy to repeat.
01 / PERIOD
Use comparable windows: Compare periods of similar length, and separate seasonal peaks from your usual trading weeks.
02 / RANKING
Name the ranking: Tell recipients whether the export is sorted by net sales or net quantity sold.
03 / COUNTING
Check collection overlap: Before adding collection rows into a store total, confirm how products belonging to multiple collections are counted.
04 / DELIVERY
Match the review cycle: Send a weekly export before your merchandising meeting so everyone reviews the same generated results.
Frequently Asked Questions
What makes a collection best selling in this report?
It depends on the measure you choose. Sort by Total Net Sales for the sales leader or Net Quantity Sold for the unit leader; the same collection may not lead both.
Does this report cover custom collections?
Yes. Custom Collections is the collection field in this premade report. Use it to review the curated collections identified in the report.
Does Total Net Sales show collection profit?
No. The report has no product cost or profit field. Use Total Net Sales to compare sales performance rather than margins.
Can I export and schedule the report?
Yes. The report supports Excel, CSV, TXT, and PDF exports, plus daily, weekly, or monthly email delivery.
Does the report prove a collection page caused a purchase?
No. These three fields summarize collection sales performance. They do not include collection-page visits, conversion rates, or a purchase journey showing that a collection page caused an order.