+
One notebook line sold through at 80 percent. Another reached only 40 percent. For a store buyer choosing the next purchase, the first looks like the easy winner. But both lines may have sold exactly the same number of notebooks.
Sell through rate compares units sold with a stated inventory base over a stated period. A higher percentage can reflect a smaller stock base, not more unit sales. Before ranking products, check the report's formula, dates, and handling of new receipts. The worked comparison below shows how the denominator can change the buying story.
Start with an invented stationery store. During the same month, it sells eighty plain notebooks and eighty dotted notebooks. At the end, twenty plain notebooks and 120 dotted notebooks remain. Assume the counts are sound and all units belong in the selected report. These are hypothetical figures, not a merchant result.
Using sold units divided by sold units plus ending stock, the plain line reaches eighty divided by one hundred, or 80 percent. The dotted line reaches eighty divided by two hundred, or 40 percent. Both sold eighty units. The difference comes from the stock left behind, which makes the percentage useful for a different question than total sales.
The plain line used up a larger share of its reported stock base. That supports a closer look at its remaining supply. The dotted line leaves more units to carry. It raises a question about the buying plan. Neither result, by itself, establishes how many extra buyers wanted either notebook or what the store should order next.
The formula above is the one described for Shopify's products-by-sell-through report. It divides quantity sold by the sum of quantity sold and ending inventory. The help page specifies a selected selling period and an ending stock measure. That gives the percentage a defined basis.
A sheet built around units received can produce a different answer. Suppose the invented dotted line opened with one hundred units, received one hundred more, sold eighty, and ended with 120. Eighty divided only by the one hundred received is 80 percent. Eighty divided by eighty sold plus 120 left is 40 percent. Both arithmetic steps are simple; their denominators describe different things.
There is no benefit in arguing over which percentage looks better before naming the question. A received-stock view can be relevant to a defined shipment review. A period inventory view can describe a broader stock base. The problem comes when the team calls both numbers the same measure and treats a change between them as a change in product performance.
| Shopify's documented report basis | Reading consequence |
|---|---|
| Quantity sold is divided by quantity sold plus ending inventory. | Inspect both sold units and stock remaining behind the percentage. |
| Sales cover the selected period; remaining stock is measured at its end. | The dates of the two inputs belong beside the result. |
| The report has processing delay and stated inclusion rules. | Use the report's displayed dates and scope, not an assumed live count. |
Source: Shopify Help Center, reviewed November 13, 2026. The notebook calculations are original hypothetical examples, not extracted store data.
Timing can make a fair-looking product comparison awkward. Imagine the dotted notebooks arrived near the end of the month. The stock is in the denominator, but those new units had little time on the shelf. Comparing that line with a product available throughout the month needs more thought than sorting a percentage column.
The buyer could review a later period after both lines have had a meaningful selling window. Another option is to keep the original period and state the late delivery beside the result. What matters is choosing a view that answers the buying question, rather than hiding a timing difference inside a single rank.
The reverse issue occurs when the plain line is unavailable for part of the period. A small amount left at month-end may look efficient, yet recorded sales give a limited view of demand while shoppers could not buy. Dates of availability help explain the result. The percentage is not a count of the orders that might have happened.
A reorder review and an excess-stock review deserve different follow-up questions. For the plain notebooks, twenty left may prompt a check of supply timing and the coming selling period. For the dotted line, 120 left may prompt a review of why the store bought that amount and whether the offer still fits current buyers.
The result is more useful when the buyer compares similar product groups and equal periods. A newly launched line and a mature bestseller have different starting points. A holiday month and an ordinary month do too. The team can acknowledge those differences without inventing a universal good percentage.
For the next comparison, place sold units, ending units, period, and formula next to each product. In the invented notebook case, write eighty sold and twenty left for plain, eighty sold and 120 left for dotted. Then add the reason for the next action: check supply cover for plain; review the larger remaining position for dotted.
This note is small enough to use in a real buying meeting. It prevents the phrase stronger product from carrying several untested meanings at once. A line may sell more units, use a larger share of its stock base, or leave more money per sale. Those are related commercial questions, but they are not identical results.
The inventory turnover ratio uses a cost-based view of movement and average stock. A unit sell-through percentage has a different job. Reading both can be useful, provided the team does not compare their values as if they were two versions of the same score.
Physical availability is another check. A quantity in the wider inventory system may include stock that cannot serve this channel. The stock-state and location review helps make the operational view clear. A buying plan needs goods the store can actually use, not just a total that makes the ratio look tidy.
The better conclusion from the notebook comparison is not that 80 percent is always good or 40 percent is always bad. It is that equal sales can leave very different stock positions. The buyer has a clear reason to investigate those positions before committing to the next order.
There is still a money question behind any plan to clear or promote the remaining units. A contribution-margin comparison can show what an extra discounted order leaves toward other costs. Sell through rate tells you how much of the stated stock base sold. The next decision improves when the team keeps both the stock and the sale in view.
Latest Articles

As an essential, data-driven toolkit for TikTok influencers and marketers, KOLSprite provides powerful features for effortless creator discovery, trending content identification, and actionable real-time insights.
It empowers users to make smarter decisions and significantly boosts their TikTok business.