Sell-Through Rate: How to Calculate It

This calculator works out your sell-through rate — the percentage of inventory you sold during a period compared to what you had available to sell. You enter the units sold and the units received (or available at the start), and you get the sell-through percentage, plus the inverse (what remains unsold). This is a core retail and e-commerce metric that shows how quickly stock moves and whether you are over- or under-ordering.

Formula

Sell-through rate is expressed as a percentage and calculated with this simple formula:

Sell-Through Rate (%) = (Units Sold ÷ Units Received) × 100

Where:

• Units Sold – the number of items sold in the period (units, pieces, each).
• Units Received – the total number of items that were available to sell during that same period (units). This is usually the quantity you purchased or received from a supplier, or the starting inventory plus any additions.

The result is a percentage. For example, if you sold 120 units out of 200 received, your sell-through rate is 60%.

Worked Example

Using the default values from the calculator:

1. Units sold = 120
2. Units received = 200
3. Divide: 120 ÷ 200 = 0.6
4. Multiply by 100: 0.6 × 100 = 60

The sell-through rate is 60%. That means 60% of the inventory you brought in sold during the period, and 40% remains unsold.

When to Use Sell-Through Rate

Use sell-through rate to evaluate the performance of a specific product, a category, or your entire inventory over a defined period (weekly, monthly, quarterly). It is common in retail, e-commerce, and wholesale. A high sell-through (typically above 80%) indicates strong demand and efficient inventory management, but it can also mean you are understocking and missing sales. A low rate (below 40%) suggests overstocking, weak demand, or poor merchandising. Compare sell-through rates across products to decide which to reorder, discount, or discontinue.

How to Read the Result

The result is a percentage. The higher the number, the faster your inventory is moving. A sell-through rate of 100% means you sold everything you had. A rate above 100% is possible if you sold more than what you received (e.g., you had leftover stock from a previous period). The calculator allows this because the formula simply divides sold by received. If your sold number is larger than received, the percentage exceeds 100%. That is not an error; it indicates you are selling from existing stock. The “Remaining” output shows the complement (100 – sell-through).

Common Mistakes

• Using the wrong denominator: The most common error is dividing by the number of units sold instead of the number received. Always divide by the total available to sell.
• Mixing time periods: If you sold over a month but received goods over a quarter, the numbers are not comparable. Use the same period for both.
• Forgetting beginning inventory: If you started with 50 units and received 100 more, your “units received” for the period should be 150, not just 100. The calculator uses “received” to mean total available, so include any starting stock.
• Ignoring returns: If customers return items, those units are not sold. Use net sales (sales minus returns) for accuracy.

Tips

• Track sell-through consistently for the same period length (e.g., always monthly) to spot trends.
• Use sell-through alongside other metrics like inventory turnover (how many times you sell through your average inventory) and days of supply.
• For seasonal products, compare sell-through to the same period last year, not to a different season.
• If your sell-through is below 50%, consider markdowns or bundling to move stock before it becomes obsolete.
• For multi-location businesses, calculate sell-through per store to identify where products perform best.

Limitations of This Calculation

Sell-through rate is a snapshot. It does not tell you why products sold or didn’t sell. It ignores profit margins, so a high sell-through on low-margin items may be less valuable than a moderate sell-through on high-margin items. It also does not account for the time value of money or storage costs. Use it as one of several performance indicators, not the sole decision-maker.

Troubleshooting

If your sell-through rate seems too high or too low, check the following:

• Did you enter the numbers in the correct fields? Sold goes in the first field, received in the second.
• Are you comparing the same time period? The calculation is only valid if both numbers cover the same dates.
• Did you include all available inventory? If you had existing stock at the start, add it to the received amount.
• Are the units consistent? If sold is in pieces and received is in dozens, convert them first.
• If the result shows “Cannot compute,” it means the received value is zero or negative. Enter a positive number for received.

Frequently Asked Questions

What is a good sell-through rate?

It varies by industry. For fashion retail, 60-80% is often considered healthy. For electronics, 70-90% is typical. A rate below 50% generally indicates overstocking.

Can sell-through rate be over 100%?

Yes, if you sold more units than you received in the period, because you also sold from beginning inventory. That is not an error; it means you are drawing down stock.

Should I include units that were returned?

No. Returns mean the sale did not finalize. Use net units sold (gross sales minus returns) for an accurate picture.

What is the difference between sell-through rate and inventory turnover?

Sell-through rate is a percentage of a specific batch sold in a period. Inventory turnover is how many times your average inventory is sold and replaced over a year. They measure different aspects of inventory velocity.

How often should I calculate sell-through?

Monthly is common for most businesses. Weekly for fast-moving goods like groceries or trendy items. Quarterly for slow-moving categories like furniture.

What if I don’t know the exact number of units received?

Estimate from purchase orders or supplier invoices. If you have no data, you cannot calculate a meaningful sell-through rate.

Related

• Daily Data Usage Calculator: How Much Do You Need?
• Churn Rate Calculator and Formula
• Absolute Change and Relative Change Calculator

in sold | Units sold | units | 120 | 0 | 1000000
in recv | Units received (or available) | units | 200 | 1 | 1000000
out str | Sell-Through Rate | % | sold / recv * 100 | 1
out rem | Remaining (unsold) | % | (1 - sold / recv) * 100 | 1