Spark Inventory
Free inventory tool

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.

Period

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. 1. Units available. The month starts with 400 units and a delivery of 100 arrives: 400 + 100 = 500 units.
  2. 2. Sell-through rate. 300 units sell during the month: 300 ÷ 500 × 100 = 60%.
  3. 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.

Free for one user

See which SKUs are sitting on the shelf

Connect your sales history and Demand ESP forecasts every SKU, flags overstock and dead stock, and turns it into monthly reorder recommendations. No spreadsheet to maintain.

  • Free: per-SKU Demand ESP forecasts and seasonal curves
  • Free: stock-risk reports and monthly reorder recommendations
  • Solo ($99/mo): continuous forecasts, live alerts and Text with Sparki