Sell-through rate calculatorwith the formula and an example
Sell-through rate is the share of the stock you had available that actually sold in a period. Enter your units to get the rate, the units left, and how many weeks the rest will take to sell at the same pace.
The starting numbers are example values, not Spark data. Replace them with your own.
Sell-through rate
60%per month
You sold 60% of what you had available, about 15 points a week.
Units available
500
Units left
200
Units sold per week
75
Weeks to sell the rest
2.7
Sell-through rate = units sold ÷ (units at the start + units received) × 100.
The sell-through formula
How to calculate sell-through rate
Count everything that was available to sell in the period: the units on hand on the first day plus every unit received. Divide the units sold by that total and multiply by 100.
Sell-through rate = units sold ÷ (beginning inventory + units received) × 100
For one delivery or one season, many buyers divide by units received only. Either works if you use the same method every time. For more on reading the number, see our guide to sell-through rate. To see how long the remaining stock lasts, use the weeks of supply calculator.
Worked example (illustrative numbers)
- 1. Units available. The month starts with 400 units and a delivery of 100 arrives: 400 + 100 = 500 units.
- 2. Sell-through rate. 300 units sell during the month: 300 ÷ 500 × 100 = 60%.
- 3. What is left. 200 units remain. At 75 units a week, they take about 2.7 more weeks to sell.
The same 60% means different things for a seasonal item with 3 weeks of season left and for a staple you restock every month. Compare each product with its own history.
Beyond one number
Find the SKUs that are not selling through
One sell-through rate for the whole store hides the items that are stuck. Spark Inventory looks at every SKU and warehouse, and looks ahead with demand forecasting instead of only back at last month.
Days on hand for every SKU
Spark shows how long each SKU’s stock lasts in each warehouse, using the higher of the Demand ESP forecast and recent sales, so a slow seller is visible before the season ends.
Overstock and dead stock, named
Each item gets a 0 to 100 health score. Stock past 180 days of supply counts as excess by default and is priced as a monthly carrying cost; units with no demand at all are flagged as dead stock.
Hold, mark down or bundle
Ask Claude or ChatGPT through the Spark connector how long an item’s stock takes to clear at the current price, with a 15% markdown, or bundled with an item customers already buy with it, and what margin each keeps.
Buy less of what sits
Reorder recommendations follow each SKU’s forecast, netted against stock on hand and on order, so the next purchase of a slow item gets smaller instead of repeating the last one.
Sell-through FAQ
Sell-through rate questions
Comparing with the whole business? Try the inventory turnover calculator.
What is the sell-through rate formula?+
Sell-through rate = units sold ÷ units available × 100, where units available = units on hand at the start of the period + units received during it. If you sold 300 of the 500 units you had available this month, your sell-through rate is 60%.
How do you calculate sell-through rate?+
Pick a period (a week, a month or a season) and one product or category. Count the units on hand on the first day, add every unit received during the period, and divide the units sold by that total. Multiply by 100 for a percent. Use units, not dollars, so price changes and markdowns do not distort it.
What is a good sell-through rate?+
It depends on the product and the period. Many retailers treat about 80% over a season as healthy for seasonal or fashion goods, while staple items that are restocked all the time naturally sit lower each month. Compare a product against its own history and similar items, and watch the trend: a rate that keeps falling week after week points to overstock or a price problem.
Should I divide by units received or by beginning inventory?+
Both are in use. Dividing by units received alone answers how much of a new delivery sold, which suits a single purchase or season. Dividing by beginning inventory plus receipts, as this calculator does, counts everything that was available to sell, which suits ongoing products. Pick one method and keep it, or the numbers will not compare.
How is sell-through different from inventory turnover?+
Sell-through measures units sold against units available in one period, as a percent. Inventory turnover measures cost of goods sold against average inventory value, as a number of turns, usually over a year. Sell-through is quicker to read for one product or one delivery; turnover is better for the whole business. Try the inventory turnover calculator for the second.
How do I improve a low sell-through rate?+
Buy closer to demand on the next order, move stock to the channel or location where it sells, bundle a slow item with one customers already buy, or mark it down before it ages further. Check weeks of supply first: a low rate on an item with only a few weeks of stock left may need nothing at all.
How does Spark Inventory help with sell-through?+
Spark forecasts every SKU with Demand ESP and shows days on hand for each SKU and warehouse, flags overstock and dead stock in each item’s health score, and puts a monthly carrying cost on the excess. Through the Spark connector, Claude or ChatGPT can compare how long an item’s stock would take to clear if you hold the price, mark it down 15% or bundle it, with the margin each option keeps.
