Sell-Through Rate Calculator: Formula, Timing, and Actions
The percentage is easy; defining the cohort, window, returns, and decision correctly is the useful work.
Sell-through rate calculator
Net sell-through rate
80.0%
80 net units sold from 100 received.
This calculator runs in your browser and sends no inputs anywhere. Keep cohort rules and revenue treatment consistent when comparing periods.
Sell-through rate is the share of received units sold during a defined window. The calculation is simple, but the cohort definition determines whether the result is useful.
Table of Contents
- What is the sell-through rate formula?
- Why must the time window and receipt cohort match?
- How is sell-through different from inventory turnover?
- What should you do with a low or high result?
- How should a weekly sell-through review work?
- Sources
- FAQ
What is the sell-through rate formula?
The sell-through rate formula is:
Sell-through rate = units sold ÷ units received × 100
Use it for a specific receipt cohort and measurement window. A receipt cohort is a group of units received together or during a defined period. The measurement window is the period in which you measure sales from that cohort.
For example, if you received 100 units and sold 80 during the measurement window:
80 ÷ 100 × 100 = 80% sell-through
To calculate the metric:
- Identify the units received for the cohort.
- Identify the units sold during the selected window.
- Divide units sold by units received.
- Multiply by 100.
- Record the cohort dates and measurement window beside the percentage.
The numerator and denominator must describe the same merchandise. Do not divide companywide units sold by units received for one product launch. Do not combine a spring receipt with a replenishment received six months later unless that combined view is intentional.
Returns require a consistent policy. Suppose you received 120 units, sold 70, and five units were returned during the review period. If the policy measures net sell-through and the returns are resellable, count 65 net units sold:
65 ÷ 120 × 100 = 54.2%
If the business reports gross units sold and tracks returns separately:
70 ÷ 120 × 100 = 58.3%
Neither convention is automatically correct. Apply the same return treatment across products, periods, and channels, and label the metric clearly. A calculator can produce the percentage quickly; the harder task is defining what it represents.
Why must the time window and receipt cohort match?
A sell-through percentage without a cohort and time window can look precise while answering no useful business question.
A launch review might compare units received for a product launch with units sold during the first 14, 30, or 60 days. A seasonal review might measure a holiday receipt against sales through the end of the season. A replenishment review might measure a purchase order received in March against sales during March and April.
The window should match the decision. Reorder decisions may require a recent weekly or monthly window. Launch comparisons need a fixed post-launch window. Markdown decisions require inventory age as well as the percentage.
Partial receipts create another problem. A product may receive 40 units in January, 30 in February, and 50 in March. One blended rate can hide whether the original buy performed well or whether later replenishment expanded the denominator.
Use separate cohorts when appropriate:
- Launch cohort: units received before or at launch, measured over a fixed post-launch period.
- Replenishment cohort: units received after launch, measured from the replenishment receipt date.
- Seasonal cohort: units bought for a defined season, measured through the season’s end.
- Channel cohort: units received for a specific channel, measured against that channel’s sales.
A cohort also explains timing. A low rate after seven days may be normal for a product with a long consideration cycle; the same rate after 90 days may indicate excess inventory. A high rate may indicate strong demand, but it may also mean the business bought too little and lost sales through stockouts.
For broader planning, use your inventory tools and operating metrics, while keeping the cohort definition visible in every report.
How is sell-through different from inventory turnover?
Sell-through measures how much of a defined received assortment has sold. Inventory turnover measures how often inventory is consumed and replaced, generally using cost of goods sold divided by average inventory.
| Metric | Formula | Primary question | Best use |
|---|---|---|---|
| Sell-through rate | Units sold ÷ units received × 100 | What share of this receipt cohort sold? | Launches, buys, markdowns, and assortment decisions |
| Inventory turnover | COGS ÷ average inventory | How efficiently did inventory convert relative to investment? | Working capital, inventory efficiency, and financial planning |
Sell-through is unit-based and cohort-based. Inventory turnover is value-based and period-based. A product can have excellent sell-through but still contribute to weak turnover if it represents a large inventory investment or sells slowly outside the selected cohort.
Do not substitute one metric for the other. Use sell-through to assess a buying decision or receipt cohort. Use your inventory turnover ratio calculator for broader efficiency, and compare it with days inventory outstanding when you need a time-based view of inventory exposure.
What should you do with a low or high result?
Sell-through should trigger a decision, not merely a dashboard color. Interpret it alongside margin, inventory age, stockout risk, and replenishment lead time.
| Result and context | Likely interpretation | Action |
|---|---|---|
| Low, healthy margin, young inventory | Demand may still be developing | Hold price, improve merchandising, and set a short review date |
| Low, old inventory, weak margin | Capital is trapped in aging stock | Mark down selectively, bundle, or stop replenishment |
| Low, high stockout or availability problems | Missed selling opportunities may distort the rate | Check listing, store, fulfillment, and channel availability |
| High, healthy margin, available stock | The product is performing efficiently | Reorder within lead-time limits and protect availability |
| High, frequent stockouts | The business may be underbought | Increase the next buy carefully and estimate lost sales separately |
| High, low margin | Units are moving without enough profit | Review discounts, landed cost, and contribution margin |
| Mixed results across variants or channels | Aggregate performance hides the pattern | Break down the cohort and rationalize weak SKUs |
A low result is not always a product problem. The item may have been unavailable, poorly presented, incorrectly sized, or received too late for the window. A high result is not always a victory: an immediate sellout may mean the business left demand and profit on the table.
Place sell-through beside margin and availability data. Use the SKU rationalization scorecard when deciding whether to keep, reduce, or discontinue variants. For a broader operating view, connect the metric to the systems and workflows in the stack builder.
How should a weekly sell-through review work?
A weekly review should be reproducible enough that two analysts calculate the same result.
- Freeze the definitions. Decide the unit of analysis, return treatment, sales channels, receipt dates, and review window. Write them into the report.
- Build the cohorts. Group units by launch, purchase order, receipt date, season, or channel. Keep partial receipts visible.
- Calculate the core metrics. Record units received, gross units sold, returns, net units sold when applicable, sell-through rate, on-hand units, margin, and stockout days.
- Segment exceptions. Review low and high results by product, variant, channel, age, margin, and availability.
- Assign an action and date. Give each exception an owner and next step: reorder, hold, reprice, promote, transfer, discontinue, or investigate. Recalculate using the same definitions.
The goal is not to maximize one percentage. It is to make better buying, replenishment, and markdown decisions with a metric that has a stable meaning.
Sources
FAQ
Is sell-through the same as inventory turnover?
No. Sell-through is units sold divided by units received for a defined cohort and window. Inventory turnover uses cost of goods sold divided by average inventory over a period. Sell-through evaluates a receipt or assortment; turnover evaluates broader inventory efficiency.
What belongs in the sell-through denominator?
The denominator should be the units received for the evaluated cohort. Do not use total inventory on hand, unrelated purchases, or companywide receipts unless that is the deliberate scope.
How should returns affect sell-through?
Choose a consistent policy. Report gross units sold with returns separately, or subtract eligible returns to calculate net sell-through. Apply the same rule across comparable products and periods, and disclose it.
What is a good sell-through rate?
There is no universal good rate. The answer depends on category, inventory age, margin, season, channel, replenishment lead time, and stockout risk. Compare the rate with a defined cohort, window, target, and business decision.
We track pricing and new tools across the whole catalog. Get an email when prices move or a better tool launches.