Inventory Sell-Through Report for Shopify
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.
5 from 1,800+ merchants
2,000+ data fields
Trusted by 40,000+ Shopify stores
Updated June 2026
.png)
.png)
.svg)
.svg)
.svg)
Why this report matters
Most merchants don’t struggle because sales are low they struggle because the wrong inventory doesn’t move. Cash gets tied up in stock that sits, while best-sellers run out exactly when demand peaks. Revenue can look fine on paper while profit quietly leaks into slow-moving stock.
Sell-through rate is the single metric that exposes this. It measures how much of the stock you brought in actually sold within a window turning a vague sense of "this isn’t moving" into a hard number you can sort, filter, and act on. Industry practice measures it every 30 days; a high rate means efficient inventory and strong demand, a low rate means you over-bought.
Shopify’s native sell-through report exists but is limited to higher plans, can’t be scheduled, and offers little filtering. The Report Pundit version runs on every plan, lets you slice by vendor, type, collection, or location, and lands in your inbox or Google Sheet on whatever cadence your buying rhythm needs.
What’s included in the report
Product Title
Name of the product.
Variant Title
The specific variant sell-through almost always varies sharply by size and color, so variant-level detail is where the real insight lives.
Example: Crew Tee Natural / L sells through at 82%, while Natural / XS sits at 19%.
Variant SKU
Unique stock-keeping identifier for matching against POs and accounting.
Quantity movement
Starting Quantity
Units in stock on the first day of the monitored period.
Quantity Sold
Units sold across the entire monitored period.
Ending Quantity
Units still in stock on the last day of the period.
Heads up: Any variant whose ending quantity is below 0 (oversold or untracked items like gift cards) is treated as 0 in the calculation.
The headline metric
Sell-Through Rate
Formula: Quantity Sold ÷ (Quantity Sold + Ending Quantity) × 100
The percentage of available stock that sold during the period. The denominator is your inventory on hand at the time of sale, so restocks and newly received stock are accounted for automatically.
Example: Sold 180 units with 20 left → 180 ÷ (180 + 20) = 90% sell-through. Sold 30 with 270 left → 10% sell-through (markdown candidate).
Heads up: A variant only appears in the report if it sold at least once during the period. Items that never sold are absent here use the Never Sold Products report to find those.
Vendor · Product Type · Collections · Location · Inventory Value · Inventory Cost · Days of Inventory Remaining · Sales velocity
Who uses this report
01. Merchandisers separating winners from dead stock
02. Buyers planning the next purchase order
03. Founders protecting cash flow
04. Planners running seasonal sell-through reviews
How to read the report
- High rate + low ending quantity. A genuine winner that nearly sold out. Reorder before it goes to zero these are your lost-sales risks.
- Low rate + high ending quantity. Overstock. The capital is trapped. Promote, mark down, or stop reordering.
- Rate by variant, not just product. A product can look healthy overall while specific sizes or colors rot. Always read at the variant level.
- Window length matters. A 7-day window flatters slow-movers and punishes seasonal items. Use 30–90 days for buying decisions.
How to build the report in Report Pundit
Under 5 minutes from install to insight. No code, no SQL.
- Install Report Pundit. from the Shopify App Store 14-day free trial, no card required.
- Open Pre-built Reports. from your Shopify admin and click the Pre-built Reports library.
- Select Inventory Sell-Through. from the Inventory category.
- Set the monitored period. choose the window over which sell-through is measured last 30 days is the most common starting point; use 60–90 days for seasonal lines.
- Apply filters. narrow by vendor, product type, collection, or location to focus the analysis.
- Customize columns. add Inventory Value, Days of Inventory Remaining, or sales velocity to turn the rate into a buying decision.
- Run the report. sell-through is calculated for every variant that sold at least once in the window.
- Export or schedule. push to Google Sheets, Excel, CSV, or PDF or schedule it to land before each buying meeting.
Customization & filters
- Set the monitored period 7, 30, 60, or 90 days, or a custom range.
- Group by vendor or product type category-level sell-through for buying reviews.
- Filter by collection measure a single season or campaign.
- Filter by location sell-through per warehouse or store.
- Add Inventory Value see the dollars trapped behind low sell-through.
- Add Days of Inventory Remaining pair pace-of-sale with runway.
Automate & export
- Schedules — hourly, daily, weekly, monthly, or custom cron
- Delivery formats — Excel, CSV, PDF, or push to Google Sheets in real time
- Group by month or week — trends instead of a static snapshot
- Destinations — email (multiple recipients), Google Sheets, Google Drive, FTP/SFTP, Looker Studio, BigQuery
- Conditional alerts — get notified only if a channel's net sales drop more than X% week-over-week
Report Pundit vs Shopify's native Sales by Channel report
Frequently Asked Questions
Sell-through rate is the percentage of available inventory that sold during a chosen window. It’s calculated as units sold ÷ (units sold + units remaining) × 100. It measures demand and inventory efficiency, and is usually tracked every 30 days.
Quantity Sold ÷ (Quantity Sold + Ending Quantity) × 100. The denominator reflects inventory on hand at time of sale, so restocks during the period are accounted for. Negative inventory is treated as zero.
A variant only appears if it sold at least once during the monitored period. Products that never sold are excluded; find those in the Never Sold Products report.
Benefits
.svg)
Granular Product-Level Insights
.png)
Discount Analysis
.svg)
Order Tracking
Related Reports
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.
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 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 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.
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.
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
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 by Collections
This report provides a detailed view of inventory levels, organized by product collections, allowing businesses to track stock availability and manage inventory efficiently.
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 Status
A comprehensive overview of product inventory, detailing the quantity available for products that are live, in draft, or have been archived.
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 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.
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.