Inventory by Collections Report for Shopify
This report provides a detailed view of inventory levels, organized by product collections, allowing businesses to track stock availability and manage inventory efficiently.
5 from 1,800+ merchants
2,000+ data fields
Trusted by 40,000+ Shopify stores
Updated June 2026

Custom Collections
Name of custom product collection created by merchant. Examples include Summer Collection, Winter Collection, etc.
Product Title
Name of unsold product.
Variant Title
Name of product variant (Variant is a version of the product differing by attributes like color, size, aging, etc.).
SKU
The unique identifier for the product in the shop.
Vendor
The supplier of the specific product.
Price
The listing price of the product.
Inventory Quantity
The number of items in stock for the product category.
Inventory Cost
Total product cost for available units in inventory. Calculated as Product Cost * Inventory.
Benefits

Monitor Stock Levels

Manage Inventory

Spot Low Stock
Related Reports
Inventory by Product Type
This is grouped inventory data organized by custom product types, alongside product and variant details, providing a comprehensive view to analyze overall inventory status.
Inventory Reorder Point
This report helps identify the exact point at which inventory should be restocked to prevent any interruptions in product availability, ensuring a smooth supply chain from both your inventory and your vendor's end. It informs the merchant about the sales velocity, lead time, and safety stock.
Inventory by Location
A report organized by inventory locations, detailing products and variants on hand, with a breakdown of the value for each product.
Inventory on Hand
A real-time snapshot of every product, variant, and SKU in stock - across every warehouse, retail location, and 3PL - with vendor, cost, and inventory value in a single view.
Inventory Sell-Through
The percentage of stock that actually sold for every product and variant so you can separate the fast-movers worth reordering from the dead stock eating your shelf space and cash.
Inventory Replenishment
A ready-to-action list of exactly which products need reordering now — driven by real sell-through velocity, adjusted for stock already on its way, and broken down by location.
Out of Stock Product
A report listing products that are out of stock, including essential details such as product inventory and the location where the stock was depleted.
ABC Analysis
Every product graded A, B, or C by its share of revenue — so you can pour stock investment into the items that earn it, and stop over-buying the ones that don’t.
Inventory level Indicator
The report provides Shopify merchants with a real-time analysis of stock levels, highlighting products that are overstocked, optimally stocked, or understocked. This report is essential for monitoring stock health and ensuring that inventory levels align with demand.
Inventory On Specific Day
A point-in-time snapshot of exactly what you had in stock on any past date — by product, variant, SKU, and location — for month-end accounting, audits, and cross-date comparison.
Inventory Sale Value
A report outlining the sale value of your inventory, including details on product quantities, variants, collections, and total value based on current sale prices for analysis.
Inventory Status
A comprehensive overview of product inventory, detailing the quantity available for products that are live, in draft, or have been archived.
Inventory Cost
The Inventory Cost Report provides a comprehensive analysis of the costs associated with your inventory, giving you a clear view of the financial investment tied up in stock. This report calculates the cost of inventory on hand and can include both current and historical cost data
Inventory Transfers
Every stock movement between your locations in one view — origin, destination, status, and received-vs-rejected quantities — so you can balance stock, reconcile transfers, and measure internal lead times.
Inventory Shipments
Every inbound shipment tracked end to end — shipped, received, accepted, and rejected quantities with acceptance rate — so you can catch discrepancies, plan around arrivals, and benchmark supplier reliability.
Low Stock Product
The Low Stock Product Report highlights products that are approaching or have reached a low stock threshold, helping Shopify merchants proactively manage restocking needs. This report is crucial for preventing stockouts on popular items and ensuring seamless sales without interruption
Build and automate your Shopify Reporting
Unlock the full potential of your Shopify store with Report Pundit. Gain access to over 2000 data fields, automate reports, and make data-backed decisions to grow your business.
.png)
.png)