Shopify sell-through rate: formula, example, and calculator

The sell-through rate formula

For an inventory review, use:

Sell-through rate = units sold during the period ÷ units available during the period × 100

When there were no other inventory movements, units available can be represented as starting inventory plus units received.

Example

A variant began the month with 80 units, received another 20, and sold 35.

• Units available: 80 + 20 = 100
• Units sold: 35
• Sell-through: 35 ÷ 100 × 100 = 35%

Use our sell-through rate calculator to run the arithmetic.

Why the denominator matters

Dividing sales by ending inventory answers a different question and can produce misleading results. If the example above ended with 65 units, 35 ÷ 65 equals 53.8%—but 65 was not the amount available to sell during the month.

Inventory transfers, returns, write-offs, and manual corrections can make a simplified starting-plus-received formula diverge from reality. For a rigorous internal report, define how each movement is treated and apply that definition consistently.

How Shopify presents the metric

Shopify includes a Products by sell-through rate report among its inventory reports. Report availability and definitions can vary by plan and analytics configuration, so read the column definitions shown in your store rather than assuming every dashboard uses the same denominator or time boundary.

How to interpret the result

A sell-through rate becomes useful when compared with a relevant expectation:

• the same variant in the previous equivalent period;
• similar products in the same category;
• the same season last year;
• the planned rate required to exit stock by a deadline.

Do not compare a replenishable staple with a limited seasonal collection as if they have the same job. A high rate can indicate strong demand, but it can also warn of an imminent stockout. A low rate can indicate weak demand, but it can also reflect a recent launch or a deliberately deep stock position.

Four mistakes to avoid

Comparing unequal windows

A seven-day rate and a ninety-day rate are not directly comparable. Label the period beside every rate.

Ignoring variant imbalance

The product-level rate can hide a stranded size or color. Review variants when the action can affect variant prices or replenishment.

Treating zero sales as zero information

Zero sales is important, but it does not create a usable velocity estimate for days remaining. Shopify notes that variants with no sales in its selected period can show N/A for days of inventory remaining.

Turning a metric into an automatic decision

Sell-through describes what happened. It does not know seasonality, brand positioning, product visibility, supplier options, or margin. Use it to open a review, not end one.

From rate to action

Pair sell-through with stock value, recent trend, inventory age, margin, and a deadline. A low-rate, low-value accessory may not deserve intervention. A low-rate product tying up substantial cash before a seasonal deadline may deserve attention immediately.