What Is the Best Selling Collections Report?
The Best Selling Collections report ranks the custom collections you have built in Shopify by how much they actually sell, placing two numbers side by side: net quantity sold and total net sales. Custom collections are the groups you assemble by hand, such as Best Sellers, New Arrivals, Sale, Holiday, or a specific campaign line-up.
Putting units next to revenue is what makes the report worth reading. A collection can sit near the top because shoppers buy a high volume of items from it, because it drives strong revenue, or because it does both. Reading the two columns together tells you which is happening, so a high-volume, low-value collection is not mistaken for a genuine revenue leader.
One distinction to keep straight: this report groups by custom (manually built) collections, not smart collections that fill automatically from rules. Merchants use it to decide which proven collections earn homepage space, a top menu slot, email placement, or ad budget, based on real demand rather than a guess.
Which Fields Are Included in the Best Selling Collections Report?
These three fields let you rank curated collections and tell volume performance apart from revenue performance.
You can customize the pre-made report by adding, removing, or rearranging fields, including any custom property or metafield already saved in Shopify, so the ranking matches how you merchandise.
Important Insights You Can Find in This Report
Which collections move a lot of units but bring in little revenue?
Look for collections with a high net quantity sold sitting next to a modest total net sales. That pattern usually points to low-priced staples or a heavily discounted group. The volume is real, so the collection may still earn its placement, but it is worth pairing those items with higher-value products or checking whether discounting is doing most of the work.
Which collections earn strong revenue from relatively few units?
The reverse pattern, high total net sales against a low net quantity sold, marks a high-ticket or premium curated group. These collections reward strong product pages and prime placement more than volume-style promotion. Featuring them the same way you would a fast-moving bundle collection tends to waste the slot.
Are the collections you promote the same ones actually producing demand?
Compare where each collection ranks here against where you currently place it. If a collection that owns your homepage banner or top menu slot sits low on both net quantity sold and total net sales, the placement is not being earned by results. This is the fastest way to reclaim your most valuable merchandising space for collections that are proving demand.
THE ANALYST'S READ: The Signal Most Merchants Miss
Both numbers in this report are net figures, with returns and discounts already stripped out. That keeps the ranking clean, but it can also hide why a collection lands where it does. A collection that looks mid-pack on total net sales may sell strongly at gross and simply carry heavy discounting or a high return rate that drags the net figure down.
So if a collection you promote heavily ranks lower than expected here, it is worth checking its gross sales, discounts, and returns in a fuller collection report before concluding the collection is weak. The demand may be genuine and the margin may be the real issue, and those two problems call for very different responses.
How Can You Automate the Best Selling Collections Report?
Open the pre-made Best Selling Collections report in Report Pundit. The columns are already set, so you can save it as is, or adjust the fields, date range, and filters first. Once saved, schedule it to email you automatically on a daily, weekly, or monthly basis so the ranking stays current on its own.
You can export it as Excel, CSV, or PDF, or push it to Google Sheets or Google Drive. Scheduled delivery can also send the report straight to your marketing team, so promotion decisions run on fresh numbers instead of last month's.
Frequently Asked Questions
What is the difference between Net Quantity Sold and Total Net Sales in this report?
Net Quantity Sold counts the units a collection moved after returns, while Total Net Sales measures the revenue it produced after discounts and returns. One tells you how much sells, the other tells you how much money it makes. A collection can lead on one and trail on the other.
Does this report cover smart collections or only custom collections?
It groups by custom collections, meaning the ones you build and assign products to manually. Smart collections that fill automatically from rules are handled by other Report Pundit collection reports, so use this report when you want to rank your curated, hand-built groups.
How is this different from the Sales by Collections report?
The Best Selling Collections report is a lean ranking of custom collections on just units and net sales, built for quick merchandising decisions. Sales by Collections covers smart collections and adds order count and total sales, so it suits broader revenue analysis rather than a fast best-to-worst ranking.
Can I sort to find revenue leaders separately from volume leaders?
Yes. Sort by Total Net Sales to surface the collections generating the most money, or sort by Net Quantity Sold to find the ones moving the most units. The two views often rank collections in a different order, which is the point of keeping both columns.
Can I schedule this report to send automatically?
Yes. Save the report and set it to email on a daily, weekly, or monthly schedule, or auto-send it to Google Sheets, Google Drive, or your marketing team so the collection ranking stays up to date without rebuilding it.