What Is the Product by Collections Report?
The Product by Collections report in Data Export brings Shopify collection names, product titles, variant titles, SKUs, and current inventory quantity into one export. It helps you review which products belong to manually maintained custom collections and rule-based smart collections.
Use it to check collection assignments before a promotion, find unexpected products in a group, and review stock for the variants attached to those products. Collection membership is reviewed alongside variant details; the stock figure relates to the variant shown. Comparing the export with your intended product list helps you identify missing assignments.
Report Overview
- Reporting basis
- Current product, collection, and inventory data when generated; not a historical sales report.
- Data included
- Custom Collections, Smart Collections, Product Title, Variant Title, SKU, and Inventory Quantity.
- Best for
- Collection audits, launch preparation, and reviewing variant stock within selected collections.
- Export formats
- Excel, CSV, TXT, and PDF.
- Automation
- Schedule email delivery daily, weekly, or monthly; delivery options also include Google Sheets, Google Drive, and FTP delivery.
What Can You Learn from Your Collection Data?
1. Whether featured products have the expected assignments
Compare product titles and collection names against the assortment you planned. An expected product list gives you a reference for spotting missing assignments.
Example: For example, launch list includes a linen shirt whose collection fields do not include Summer Essentials.
What you can do: Check the product’s assignment or the smart collection rules before launch.
2. Which products need a collection cleanup
Review the products associated with a collection to find unexpected items. This is useful after a seasonal change or a catalog reorganization.
Example: For example, winter Gifts collection still includes a beach towel.
What you can do: Review the assignment and remove outdated products or adjust the relevant rule.
3. Where a collection has limited variant stock
Use Variant Title, SKU, and Inventory Quantity together to check the options available within a featured product. A collection can contain the intended products while key variants have little stock.
Example: For example, featured sneaker has zero inventory for its medium-size variant.
What you can do: Review replenishment or adjust the products featured in the promotion.
What Should You Check First in This Report?
Start with these checks before sharing or using the export.
Collection names: Confirm that the custom and smart collection fields match the groups you intend to audit.
Product and variant coverage: Compare the listed titles and SKUs with your planned assortment; a filtered collection export alone cannot list products missing from that collection.
Inventory quantity: Review low or zero quantities for priority variants, and confirm inventory tracking before treating a value as a stock alert.
Repeated records: Check how multiple collection memberships appear before counting products or summing stock.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Preparing a collection for launch | Compare expected products with collection assignments and review stock for featured variants. |
| Cleaning up seasonal collections | Find products associated with a collection that may need to be removed after a campaign. |
| Reviewing smart collection results | See which products are associated with rule-based collections and investigate unexpected inclusions. |
| Checking stock within a featured collection | Use variant titles, SKUs, and current inventory to identify options needing attention. |
| Sharing a collection audit | Export the same collection and product details for the team responsible for catalog updates. |
How to Create This Report in Data Export
Start with the premade Product by Collections report rather than building the field list from scratch.
- Open Data Export in your Shopify admin and find the premade Product by Collections report.
- Open the report and review the six default fields, including both collection types and Inventory Quantity.
- Apply a collection or SKU filter for the review you need. Keep broader product coverage when comparing assignments with a launch list.
- Save the report, generate it, and export it in your preferred supported format.
- For repeat audits, schedule daily, weekly, or monthly delivery and choose the recipients or supported destination.
Make the Most of This Report
Use these tips to keep each collection review focused and repeatable.
01 / COVERAGE
Keep a reference list. Compare expected products with a broad export; filtering to one collection hides products that are absent from it.
02 / COUNTING
Count carefully. Variant rows and multiple memberships can inflate product counts. Use unique products or SKUs according to the question.
03 / TIMING
Save dated exports. Keep comparable snapshots to review changes; the current inventory field does not reconstruct past stock.
04 / DELIVERY
Choose the useful format. Use Excel or CSV for matching and deduplication, or PDF for a readable audit shared with your team.
Frequently Asked Questions
Does this report include custom and smart collections?
Yes. Custom Collections and Smart Collections are separate fields, so you can review both manually maintained groups and rule-based groups alongside product and variant details.
Can I find products missing from a collection?
Compare the collection assignments with a list of products that should belong to it. Filtering only to the target collection will not reveal products excluded from that group. Ask support about a tailored view for products with no collection.
Does it show sales by collection?
This report includes collection membership and inventory fields, without sales amounts or quantities sold. Use a Sales by Collections report when you need collection sales performance.
Does Inventory Quantity show historical stock?
It shows current inventory when the report is generated. Save dated exports if you need a record of stock shown during earlier collection reviews.
Can I export and schedule the report?
Yes. Export as Excel, CSV, TXT, or PDF, and schedule email delivery daily, weekly, or monthly. You can also choose Google Sheets, Google Drive, and FTP as delivery options.