Sell-through rate calculator
Measure how much received inventory sold during a selected period and see the remaining stock at a glance.
Inventory inputs
Positive whole units made available in the period.
Whole units sold from that received quantity.
Live results
Sell-through rate
65.00%
65 of every 100 received units were sold.
Units remaining
350,000
Unsold share
35.00%
Sold-to-remaining ratio
1.86×
Sell-through rate is 65.00 percent; 350,000 units remain.
Sold versus remaining inventory
This part-to-whole view compares the two mutually exclusive outcomes for all received units.
650,000 units sold and 350,000 units remain from 1,000,000 units received.
Inventory disposition detail
| Status | Units | Share of received units |
|---|---|---|
| Sold | 650,000 | 65.00% |
| Remaining | 350,000 | 35.00% |
| Total received | 1,000,000 | 100.00% |
The table and Excel workbook use the same unrounded model values. Units sold must not exceed units received.
How to use the sell-through rate calculator
What this calculator does
This calculator measures the percentage of inventory received that was sold during the same analysis period. Sell-through is a compact merchandising and inventory-control indicator: it helps you compare demand against the quantity made available, identify slow-moving stock, and review whether purchasing quantities were aligned with actual sales. It does not by itself measure profit, inventory turnover, lost sales, markdown effectiveness, or future demand. Those decisions also require price, margin, timing, stockout, and replenishment information.
When to use it
Use it after a week, month, season, promotion, or product launch; when comparing products or locations over a consistent period; before planning a reorder or markdown; or when checking whether a shipment is moving quickly enough. Keep the time window and definition of “received” consistent across comparisons. Shopify's inventory reporting documentation explains how a commerce platform can present a products-by-sell-through-rate report.
How to calculate
- The calculator opens with a ready-to-use demonstration: 1,000,000 units received and 650,000 units sold. Its validated example workbook is immediately available through Download Excel.
- Replace Units received with the whole number of units made available during your chosen period.
- Replace Units sold with the whole number sold from that quantity. Results update live; no Calculate button is needed.
- Review the primary rate, remaining units, unsold share, ratio, donut breakdown, and detail table. Compare only records that use the same time period and inventory definition.
- Select Download Excel to create a fresh workbook from the current validated inputs. Select Reset to clear the demonstration values and all computed content. Reset may disable Download Excel until both required fields contain a complete valid state again.
Input guide
Units received is required and accepts a positive whole number, written with digits and optional standard comma grouping. For example, enter 1,000,000 or 1000000. It represents the denominator of the formula, so increasing it while sales stay constant lowers the sell-through rate. Do not enter currency, percentages, decimals, scientific notation, or a zero quantity. Also avoid mixing opening stock with new receipts unless that is the consistent inventory base used by your reporting process.
Units sold is required and accepts a nonnegative whole number in the same format. For example, 650,000 is valid. Increasing sold units raises the rate and lowers remaining units. It cannot exceed Units received; a higher sold count usually means that returns, transfers, receipts, or the measurement window were defined inconsistently.
Output guide
Sell-through rate is the exact identity Units sold ÷ Units received, displayed as a percentage. A value of 0% means no units sold; 100% means every received unit sold. A high or low result is not inherently good or bad without category, margin, stockout, and time context. Units remaining is received minus sold. Unsold share is the remaining portion as a percentage of received units and complements the sell-through rate to 100%. Sold-to-remaining ratio compares sold units with remaining units; when nothing remains it is shown as “All sold” rather than dividing by zero.
The header pills repeat Rate, Sold, and Remaining for quick scanning. The Sold versus remaining inventory chart uses the same sold and remaining unit counts as the table. The Inventory disposition detail table lists Status, Units, and Share of received units, including a total row that must reconcile to the received quantity and 100.00%.
Worked example
With 1,000,000 units received and 650,000 units sold, the calculation is 650,000 ÷ 1,000,000 = 0.65, or 65.00%. Remaining inventory is 1,000,000 – 650,000 = 350,000 units; the unsold share is 35.00%; and the sold-to-remaining ratio is 650,000 ÷ 350,000 = 1.86×. Every first-open result, chart value, table row, and workbook checkpoint uses these same figures.
Formula and interpretation
Sell-through rate = Units sold ÷ Units received × 100%
Sell-through is most useful as a comparable operational measure. Keep the product scope, channel, location, and period consistent. A 60% monthly rate and a 60% seasonal rate describe very different sales velocities. The metric can also be distorted when returns are netted differently, receipts arrive late in the period, transfers are included inconsistently, or stockouts suppress potential sales.
Using the result in inventory decisions
A lower-than-planned rate can indicate excess purchasing, weaker demand, an assortment issue, poor placement, or a measurement period that is too short. A very high rate can indicate strong demand, but it can also signal underbuying and missed sales if the item stocked out early. Pair the result with gross margin, weeks of supply, stockout history, lead time, and planned promotions. The U.S. Census Bureau's retail trade data resources provide broader context for retail sales and inventory trends, while the U.S. Small Business Administration's financial management guidance explains why reliable records and cash-flow visibility matter for operating decisions.
Common mistakes
- Using units available at the end of the period as the denominator instead of the defined received or available quantity.
- Comparing different time windows, channels, or product scopes.
- Ignoring returns, damaged goods, transfers, and inventory adjustments.
- Treating a target rate as universal. Appropriate rates vary by category, lifecycle, replenishment speed, margin, and seasonality.
- Using the percentage alone to reorder without checking lead time, demand forecasts, and safety stock.