Definition: Sell-through rate is the percentage of available inventory sold within a specific time period. It tells you how well a product is moving relative to how much you stocked.
Sell-through rate answers a simple question: of everything you had available, how much did you actually sell? It is especially useful for seasonal buying - you commit to inventory before the season starts, and sell-through tells you whether your buying was on target. A 75% sell-through means you sold three quarters of what you bought. Below 50% and you are heading for a markdown situation. Above 90% and you may be underbuying, leaving money on the table. The right benchmark depends on your category, your season length, and your margin structure.
Sell-Through Rate Calculator formulas
Standard sell-through rate
Use when: The standard formula for most retail and ecommerce contexts. Use for any fixed time window - monthly, seasonal, or product lifecycle.Sell-Through Rate (%) = (Units Sold / Units Available) × 100
Sell-Through Rate = (Units sold in period ÷ Units available at start of period) × 100
| Symbol | Variable | Description |
|---|---|---|
| Units Sold | Units sold in the period(units) | Net units sold (after returns). For a monthly calculation, use total units sold in that calendar month. |
| Units Available | Units available at start of period(units) | Opening stock plus any units received during the period. For a seasonal buy, this is the total quantity ordered for the season. |
Limitation: A 100% sell-through rate is not always positive - it may indicate you understocked. Always check whether you had unfulfilled demand at end of period.
Value-based sell-through
Use when: When products in the same category have significantly different price points - a unit-based rate can be misleading if a high-value item is selling slower than cheap ones.Sell-Through Rate (%) = (Value Sold / Value Available) × 100
Sell-Through Rate = (Revenue from sold units ÷ Total retail value of available units) × 100
| Symbol | Variable | Description |
|---|---|---|
| Value Sold | Revenue from units sold(£ / $) | Actual revenue received. Use net revenue after discounts if comparing against full-price availability. |
| Value Available | Total retail value of opening stock(£ / $) | Units available × retail price. Useful when comparing categories with very different price points. |
Step-by-step examples
Scenario: “A Shopify brand orders 200 pairs of trainers for the spring season. After 30 days, 120 pairs have been sold.”
- 1Sell-through rate = (120 / 200) × 100 = 60%
- 2Remaining stock: 200 − 120 = 80 pairs
Interpretation: 60% after 30 days is moderate. Strong sell-through for footwear is typically 75%+. With 80 pairs remaining, consider whether to hold at full price or start a promotional push before end of season.
Scenario: “A seasonal cosmetics collection. 500 units bought. 430 sold by end of season. 20 returned.”
- 1Net units sold = 430 − 20 = 410 units
- 2Sell-through rate = (410 / 500) × 100 = 82%
- 3Remaining unsold: 500 − 410 = 90 units
Interpretation: 82% is a strong result for a seasonal collection - well above the 75% benchmark. The remaining 90 units can likely sell through at full price in an end-of-season push or carry forward if they are non-perishable.
Sell-through rate benchmarks by context
| Category | Benchmark | Note |
|---|---|---|
| Excellent (most categories) | ≥ 75 – 80% per month | Strong demand signal. Consider increasing buy depth next season. |
| Good | 60 – 74% | Solid performance. Minor markdown risk at end of period. |
| Warning zone | 40 – 59% | Slower than target. Review pricing and promotional activity. |
| Action required | < 40% | Poor. Markdown, clearance, or discontinuation should be evaluated. |
| Fashion - new season target | > 80% within season | Higher bar because unsold seasonal stock loses value rapidly. |
| Watch out: 100% sell-through | May indicate understock | If you sold out with demand still present, you left revenue on the table. |
Benchmarks vary significantly by product category and season length. Always compare sell-through against the same period from the previous year for the most useful signal.
Critical pitfalls to avoid
Not subtracting returns from units sold
Using gross sales instead of net sales overstates your sell-through rate - a 90% rate might only be 82% once returns are included.
Interpreting 100% sell-through as success
If you sold every unit but still had unfulfilled demand, you underordered. A 100% sell-through with frequent stockouts is actually a buying problem.
Comparing different time periods
Comparing January sell-through to December sell-through without accounting for different sales volumes distorts the analysis.
Using inaccurate Shopify inventory counts
If Shopify inventory is out of sync (due to bundles, missing adjustments, or oversells), the 'units available' figure is wrong and the sell-through rate is meaningless.
Focusing only on unit count for high-price-variance catalogs
If you sell items ranging from £5 to £500, a single unit-based sell-through masks the fact that your most valuable items may be slow-moving.
Shopify-specific tips
- Pull units sold from Shopify Analytics > Sales by product for your chosen period. Use 'Net quantity' to exclude returns.
- Units available: use opening inventory plus units received. Shopify's Inventory History report shows stock adjustments by date.
- Shopify's built-in sell-through reporting is limited. Use a custom report or inventory app to calculate this at SKU level automatically.
- For seasonal collections in Shopify, use tags or collections to group seasonal SKUs, then calculate sell-through across the collection as a whole.
- If you use Shopify Markets or sell on multiple channels, calculate sell-through separately per channel to understand where velocity differs.
Frequently asked questions
Related resources