Sell-Through Rate for Shopify: Formula, Benchmarks, and What to Do Next

Sell-through rate is the percentage of inventory that sold in a chosen period. On Shopify, the operating formula is units sold divided by units sold plus units still on hand, then multiplied by 100.

That number tells you whether a SKU is clearing stock, sitting unsold, or moving so fast that the next purchase order is already late. Calculate it at the variant level. A store-wide average hides both problems.

The sell-through rate formula

Shopify’s Products by sell-through rate report uses this calculation, documented in Shopify’s inventory reports help page:

Sell-through rate = units sold ÷ (units sold + units still in inventory) × 100

The denominator is stock on hand for the window. Shopify states that this total accounts for restocks and new inventory received during the selected period. Units sold are measured across the period. Units still in inventory are measured on the last date in that period.

A purchase-order version is also common in retail math: units sold divided by units received in the same window, times 100. Use that version to judge a single inbound shipment. It will not match Shopify’s report if you received extra stock mid-period, because the report folds those receipts into ending on-hand.

Shopify’s sell-through article writes the same idea as (total sales / stock on hand) × 100. In the admin report, “sales” means units, not revenue. Keep the unit definition fixed so month-to-month comparisons stay honest.

A worked Shopify SKU example

Mug A sold 180 of the 200 units that were available (180 sold + 20 left). 90% is a strong 30-day clear. Reorder against lead time, not against last month’s leftover.

Mug B sold 80 and still holds 120. 40% means most of the buy is still sitting. Pause the next purchase order until you know whether demand was overestimated, the listing is buried, or a promotion never ran.

Mug C looks like a winner at 95%. Confirm cover before you treat it as a merchandising win. Five units left can be a stockout in a few days. Open Shopify’s Inventory remaining per product report and compare days of stock to supplier lead time.

How to pull sell-through rate in Shopify

You do not need a spreadsheet export to get the first cut. Shopify documents these steps in the same inventory reports guide.

1. In Shopify admin, go to Analytics > Reports.
2. Open the Category filter and choose Inventory.
3. Open Products by sell-through rate and note the date range printed at the top of the report.

Shopify’s help docs state that the most recent period this report can return is about two days before the current date, and closer to three days in time zones such as UTC +14:00. The exact dates sit at the top of the report. Do not assume the row is “through yesterday.”

A few report rules change how you read the number:

• A variant appears only if it sold at least once before or during the selected period.
• Quantity sold does not include returns, manual adjustments, or transfer receipts.
• Untracked inventory (gift cards, many digital products) is treated as zero units sold for the sell-through calculation.
• Negative ending quantity is treated as zero in the sell-through math, which can happen when a variant is oversold.
• Historical inventory metrics in these reports start on October 1, 2023. Earlier stock history is not available there.

If you need a second view of the same window, open Products by percentage sold. That report divides units sold by starting quantity, so restocks mid-period will not match sell-through. Use one report as the source of truth for weekly reviews.

What is a good sell-through rate

According to Shopify’s sell-through rate guide, the benchmark sell-through rate is at or above 80%. The same page describes a healthy range of 70% to 80% for in-period assortments. Use that as a starting target, then split the catalog by product life cycle.

• Seasonal or limited drops: Shopify suggests aiming above 80% inside the launch window, because replenishment is limited and markdown risk rises the longer units sit.
• Evergreen core SKUs: Shopify says 40% to 60% per month or quarter can be acceptable if inventory turns stay on plan and margin is protected.
• A rate near 100% on a bestseller often means you under-bought. Check remaining days of stock before you cut the next purchase order.

Shopify also lists illustrative category examples on that page: fragrance around 23% after 8 weeks and 63% after a year, cosmetics around 25% and 48%, and home improvement around 55% and 90%. Shopify labels those figures illustrative. Set your live targets from your last three to six comparable periods, not from another merchant’s category average.

Compare like-for-like windows. A December apparel drop should not be scored against a quiet February. Holidays, weather, and launch calendars move the same SKU by a wide margin.

What a high or low rate is telling you

High sell-through: reorder risk

A high rate means the buy is clearing. That is healthy only if cover still lasts through the next inbound shipment. Open Inventory remaining per product. Shopify calculates days of inventory remaining as ending quantity divided by average daily units sold over the last 28 days.

• If days of stock are shorter than supplier lead time, place the reorder now.
• If you cannot restock before cover hits zero, pause paid traffic to that variant so clicks do not land on an empty product.
• Do not triple the next order off one 95% month. Check whether the spike was a one-off promo, a stockout bounce-back, or true repeat demand.

Low sell-through: cash sitting on the shelf

A low rate means most of the buy is still unsold. The first move is to stop adding more units. Then split the cause: no demand, no exposure, or a buy that was simply too large.

• Traffic is thin: move the SKU higher in the collection or feature it on the home page before you cut price.
• Traffic is fine and conversion is weak: fix the listing (title, photos, price, reviews) before you buy again.
• The buy was too large: create a targeted discount or pair the slow mover with a faster SKU. Shopify can apply a percentage, amount-off, buy X get Y, or free-shipping discount from the Discounts page.
• Sales have been fading for several periods: cancel the next purchase order and move ad budget to SKUs that still convert.

Pair sell-through with inventory-to-sales

Sell-through answers how much of the stock sold. It does not tell you how much cash that leftover stock is tying up. Pair it with the inventory-to-sales ratio, which is average inventory value divided by net sales for the same period.

A SKU can post a decent sell-through and still lock too much capital if the remaining units are expensive. Another SKU can look efficient on inventory-to-sales because it stocked out. Read both numbers, plus days of cover, before you reorder or markdown.

What to do next, by SKU

Match the action to the cause. One store-wide promo will not fix a bestseller that is about to stock out.

1. Sell-through high, days of stock shorter than lead time: reorder now. Use recent daily velocity and lead time, not last year’s order quantity.
2. Sell-through high, days of stock already at zero: pause ads on that variant and stand up a back-in-stock path if you use one.
3. Sell-through low, traffic low: raise merchandising before you discount. Check collection position and on-site search.
4. Sell-through low, traffic fine: run a dated, SKU-specific discount or bundle. Recalculate sell-through after the promo window, not during it.
5. Sell-through low and falling for two or more periods: stop the next purchase order and move spend to SKUs that still convert.
6. Sell-through in range, cash still heavy: the leftover units may be high cost. Check inventory-to-sales before you buy the same quantity again.

For the reorder-point math itself, use lead time and daily sales velocity so you trigger the PO before cover hits zero. Our Shopify reorder formula walkthrough covers that trigger.

How often to review sell-through

Review weekly for the SKUs that actually pay the bills. Review monthly for the long tail. A quarterly store-wide average will not catch a bestseller drifting into a stockout or a slow mover absorbing cash on every reorder.

Shopify’s ABC product analysis grades each variant on revenue share over the last 28 days. A-grade variants collectively account for 80% of revenue, B-grade the next 15%, and C-grade the last 5%. Put A-grade SKUs on the Monday checklist. Let C-grade wait for the monthly pass unless a promo is live.

Between those checks, watch sales velocity against on-hand units. Stock intelligence that monitors inventory levels and flags stockout risk early can surface a SKU that will miss its next inbound window before the weekly report does. The sell-through number still belongs in the review. The alert just keeps the review from starting after the stockout.

Pull Products by sell-through rate this week for your A-grade variants. For each row outside your target, write one action: reorder, promote, markdown, or pause the PO. Then do that action before the next inbound shipment lands.