What Is the Inventory by Collections Report?
The Inventory by Collections report in Data Export groups current Shopify inventory under custom collections. It shows the products and variants in each collection, together with SKU, vendor, price, inventory quantity, and inventory cost, so you can review the stock behind a curated range.
Use it before promoting a collection, preparing a seasonal launch, or reviewing inventory costs. The report reflects current stock when generated; a date range does not turn it into a historical inventory balance. Its product and variant details help you identify which specific items need attention.
Report Overview
- Report period
- Current inventory snapshot when the report is generated.
- Data included
- Eight fields covering custom collections, product details, quantity, and inventory cost.
- Best for
- Collection launch checks, variant stock reviews, and inventory cost reviews.
- Export formats
- Excel, CSV, TXT, and PDF.
- Automation
- Schedule email delivery daily, weekly, or monthly.
What Can You Learn from Collection Inventory?
1. Which featured variants need attention
A collection can look ready while individual sizes or colors have little stock. Review variant titles alongside inventory quantity before choosing campaign products.
Example: For example, a summer collection includes a featured medium-size shirt with two units.
What you can do: Restock the variant or choose a better-stocked item for the campaign.
2. Where inventory costs need a closer review
Inventory Cost helps you find items that warrant a cost review within a collection. Sales performance is not included, so a high cost alone does not establish that stock is slow-moving.
Example: For example, a curated furniture collection contains several items with high inventory costs.
What you can do: Compare those items with a separate sales report before planning a clearance.
3. Which vendors supply low-stock collection items
Vendor, SKU, and quantity help turn a collection review into a supplier follow-up list. Keep the variant details with the export to make each request clear.
Example: For example, three low-stock variants in a gift collection share the same vendor.
What you can do: Send the vendor a focused replenishment list using the relevant SKUs.
What Should You Check First in This Report?
Start with the collection you plan to feature, then review the item details that affect your next stock decision.
- Inventory Quantity: Sort to find low-stock items, then compare quantities with your own replenishment threshold.
- Variant Title and SKU: Check the specific sizes or colors you intend to promote.
- Inventory Cost: Review costly stock and confirm how this field is calculated before summarizing it.
- Custom Collections: Check collection membership before combining exports; confirm whether repeated product rows would duplicate stock in your totals.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Preparing a collection promotion | Check current quantities for the products and variants you plan to feature. |
| Reviewing a seasonal range | Find gaps in sizes or colors using variant titles and inventory quantity. |
| Preparing supplier follow-ups | Use vendor and SKU details to identify items needing replenishment. |
| Reviewing inventory costs by collection | Locate items for a closer cost review before comparing with sales performance. |
| Sharing a stock review with operations | Export collection inventory details or schedule an email for a regular review. |
How to Create This Report in Data Export
Start with the premade Inventory by Collections report so the core fields are already available.
- Open Data Export in your Shopify admin and find the premade Inventory by Collections report.
- Open the report and review its eight columns, including variant details and current inventory quantity.
- Filter to the custom collection or vendor you want to review. Adjust columns as needed; use current quantities for stock checks.
- Save the report and export it as Excel, CSV, TXT, or PDF.
- Optionally schedule daily, weekly, or monthly email delivery to yourself or your operations team.
Make the Most of This Report
Use these checks to keep each collection inventory review useful.
01 / TIMING
Generate before a campaign Refresh the report close to launch; an older export may no longer represent current stock.
02 / COUNTING
Check overlapping collections Confirm how shared products appear before adding quantities across collections.
03 / COST
Keep price and cost separate Price is not inventory cost. Confirm cost calculations before using collection totals.
04 / SHARING
Match the export to the task Use Excel or CSV for sorting and PDF for a straightforward shared review.
Frequently Asked Questions
Does this report cover custom or automated collections?
The premade report uses the Custom Collections field. If you need automated or smart collections, ask Data Export support to confirm the appropriate report setup.
Can I use it to see inventory from a previous month?
This report shows current inventory when generated. Choosing an earlier date range does not reconstruct past stock levels. Keep dated exports if you need to compare saved snapshots.
Does it identify slow-moving inventory?
It shows quantity and inventory cost, but does not include sales or sell-through fields. Compare it with a separate sales report to assess whether items are moving slowly.
Is Inventory Cost the same as Price?
No. Price is the listed selling price, while Inventory Cost is a separate cost field. Confirm the cost calculation and treatment of missing cost data before using it for valuation.
Can I export and schedule this report?
Yes. Export it as Excel, CSV, TXT, or PDF, and schedule email delivery daily, weekly, or monthly for recurring stock reviews.