What Is the Shopify Sales by Collection Group Report?
The Shopify Sales by Collection Group report puts one smart collection on each row and shows the full money flow behind it: order count, gross sales, discounts, returns, net sales, shipping, tax, duties, and total sales. Instead of one revenue number per group, you see how that number is built and where it gets smaller along the way.
The distinction worth understanding is gross sales versus total sales. Two collection groups can finish the period with the same total sales while getting there very differently. One may start high and lose ground to discounts and returns; another may hold its value cleanly. This report exposes that difference by keeping every deduction in its own column.
Merchants use it to compare whole automated product groups at once, without opening products one by one, and to catch groups that look healthy on the headline figure but quietly leak margin underneath.
Which Fields Are Included in the Shopify Sales by Collection Group Report?
These fields trace each smart collection's revenue from the first sale to the final total, with every adjustment in between.
You can customize the pre-made report by adding, removing, or rearranging fields, including any custom property or metafield you have saved in Shopify, so it matches the way you review group performance.
Important Insights You Can Find in This Report
Which groups look strong on gross sales but shrink once discounts and returns come off?
Read gross sales and net sales side by side for each group. A wide gap means the headline revenue is not what the group actually keeps. If discounts are driving the gap, the group may be over-promoted; if returns are driving it, the products themselves may be the issue. Sorting by the size of that gap tells you which group to review first.
Is shipping or duties quietly making a heavy or cross-border group less worthwhile?
For groups of bulky, heavy, or internationally shipped products, compare the shipping and total duties columns against total sales. A group can rank well on net sales yet carry disproportionate shipping or duty costs that eat into what it contributes. This is where you decide whether to adjust shipping rules, pricing, or which regions a group is promoted in.
Are high order counts turning into proportional total sales?
Line up order count against total sales per group. A collection with many orders but modest total sales is busy but low-value, often a sign of small baskets or heavy discounting. A collection with fewer orders but strong total sales is doing more with less traffic and may deserve more storefront visibility.
THE ANALYST'S READ: The Signal Most Merchants Miss
Most merchants read total sales per group and stop there. The more useful signal is where the gap between gross and total sales comes from, since each source needs a different fix. Two groups can lose the same amount, one to discounts, one to returns, and one to shipping: a pricing and promotion problem, a product or sizing problem, and a fulfillment-cost problem respectively. Read across the discount, returns, and shipping columns for each group and ask which one is doing most of the shrinking, because a group leaking to returns won't be fixed by pulling back a promotion. This report keeps all three deductions separate on a single row, so the diagnosis is right there if you read across instead of down.
How Can You Automate the Shopify Sales by Collection Group Report?
Open the pre-made Sales by Collection Group 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 automatically on a daily, weekly, or monthly cycle so group performance stays current without rebuilding it. You can also export it as Excel, CSV, or PDF, or push it to Google Sheets or Google Drive, and auto-send it to your finance or merchandising team so their reviews always use fresh numbers.
Frequently Asked Questions
What does "collection group" mean in this report?
Each row represents one smart collection, the automated groups Shopify builds from rules you define. The report totals sales across all products that fall into each group, so you compare whole groups rather than individual products.
How is this different from the Shopify Sales by Collections report?
Sales by Collections is a lighter view, mainly order count, net quantity, and total sales for a quick read on which groups contribute most. Sales by Collection Group adds the full money breakdown (gross sales, discounts, returns, net sales, shipping, tax, and duties), so you can see not just how much a group sold but where its value was gained or lost.
Why is a group's total sales different from its gross sales?
Gross sales is product revenue before adjustments. Total sales is what remains after discounts and returns are subtracted and shipping, tax, and duties are factored in. The columns in between show exactly which adjustments caused the change.
Can I filter this report to a single collection or date range?
Yes. You can filter to one collection group, a specific date range, or both, and sort by any column, such as total sales to rank groups or returns to find where value is coming back.
Does this report cover manual (custom) collections too?
This pre-made version groups by smart collections. If you organize products in manual collections, the Report Pundit team can tailor a custom-collection version of the report to match how you sell.