What Is the Sales Attributed to Each Custom Collections Report?
The Sales Attributed to Each Custom Collections report groups revenue by the manual collections you build by hand, such as Best Sellers, New Arrivals, Gift Guides, Clearance, or Staff Picks. For each curated group it shows a full money view: order count, gross sales, discounts, returns, net sales, shipping, tax, duties, and total sales.
Custom collections are the ones you assemble yourself by picking specific products, which is what separates them from smart collections that fill automatically based on rules. This report only measures the collections you chose to curate, so it answers a question every hands-on merchant eventually asks: is the effort of building and maintaining these groups actually producing sales?
Because it carries the complete financial column set rather than a single sales figure, the report is built for judging value kept, not just revenue generated. A collection that posts strong gross sales but loses most of it to discounts and returns looks very different here than it would on a simple sales ranking.
Which Fields Are Included in the Sales Attributed to Each Custom Collections Report?
These fields let you evaluate both how much each curated collection sold and how much of that value it actually kept.
You can customize the pre-made report by adding, removing, or rearranging fields, including any custom property or metafield you have already saved in Shopify, so the columns match the way you review your curated collections.
Important Insights You Can Find in This Report
Which curated collections lose the most value between gross and net sales?
Compare Gross Sales to Net Sales for each collection, then look at how much of the gap comes from Discount versus Returns. A Gift Guide might post a high gross figure but surrender a large share to promotional discounts, while a fashion collection might lose value to returns instead. The size and source of that leakage tells you whether a collection is genuinely profitable or just busy, and whether the fix is pricing and promotion discipline or a closer look at product fit.
Does a collection's total sales come from the products or from shipping, tax, and duties?
Read Total Sales against Net Sales and check what sits between them in the Shipping, Tax, Duty Tax, and Total Duties columns. Two collections can show similar total sales while one is carried largely by product revenue and another is padded by shipping and cross-border duties. This matters when you rank collections by the headline total, because it separates groups that truly sell from groups that only look strong once fees are added in.
Are you spending curation effort on collections that convert into few, low-value orders?
Put Order Count next to Net Sales for each curated group. A Staff Picks collection that produces high net sales from a small number of orders behaves very differently from a Clearance group that generates many orders at low value each. The comparison guides real merchandising calls: which collections deserve prime homepage placement, which belong in an email, and which are absorbing curation time without earning it back.
THE ANALYST'S READ: The Signal Most Merchants Miss
Custom collection totals are not additive, and treating them as if they are will overstate your revenue. A single product can sit in several hand-built collections at once, so the same sale is attributed to Best Sellers, New Arrivals, and a Gift Guide if the product lives in all three. Sum the Total Sales column across every custom collection and the figure can climb well past your actual store revenue.
This is worth checking whenever a collection's numbers look surprisingly strong. Before crediting a curated group for a jump in sales, look at whether its top products also appear in other high-performing collections. If they do, the collection may be riding shared winners rather than driving demand on its own. The useful move is to compare collections against each other for relative contribution and to isolate a single collection with a filter when you need a clean read, rather than adding the rows together as a store total.
How Can You Automate the Sales Attributed to Each Custom Collections Report?
Open Report Pundit and select the pre-made Sales Attributed to Each Custom Collections report. The columns are already set, so you can save it as is, or adjust the fields, date range, and filters first, such as narrowing to one collection or to a campaign window. Once saved, schedule it to email automatically on a daily, weekly, or monthly basis so the numbers stay current, and route it to your merchandising team so placement calls use fresh data. You can also export it to Excel, CSV, or PDF, or send it to Google Sheets or Google Drive.
Frequently Asked Questions
What is the difference between the Sales Attributed to Each Custom Collections and Smart Collections report?
This report measures custom collections, which are the manual groups you build by handpicking products. The Sales Attributed to Each Smart Collections report measures smart collections, which fill automatically based on rules such as tags, price, or product type. Both carry the same financial columns, so choose this one when you want to judge collections you curated yourself.
What counts as a custom collection in this report?
A custom collection is any manual collection where you selected the products yourself, such as Best Sellers, New Arrivals, Gift Guides, Clearance, or Staff Picks. Rule-based smart collections are not included here.
Why might the total sales across all my custom collections be higher than my store's revenue?
Because a product can belong to more than one custom collection, its sale is counted under each collection it sits in. Adding the Total Sales column across all collections double counts those shared products, so use the report to compare collections against each other rather than as a store-wide total.
Can I filter this report to a single custom collection or a date range?
Yes. You can filter to one collection to study it on its own, and set any date range, including a specific campaign window, before saving the report.
Can I schedule this report to send automatically?
Yes. You can set it to email on a daily, weekly, or monthly schedule and deliver it to yourself or your team, so merchandising decisions run on current numbers.