Sell-through rate: what sold, what stayed and what to do next.

Start with a defined batch

Sell-through describes the share of an identified stock pool that has sold within a chosen period. Before comparing percentages, agree which products, locations and dates belong in that pool. A launch collection followed for four weeks answers a different question from a permanent line followed for a year.

This article uses a closed batch: the units available at the start, with no replenishment or transfers during the measurement window. Net units sold means sales less customer returns from that same batch and period. It is a planning convention, not a universal definition used by every reporting system.

How to calculate sell-through

Divide net units sold by the batch’s starting units, then multiply by 100. If an illustrative garden shop starts with 80 pots and sells 48, with no returns, replenishment or transfers, its batch sell-through is 60%. The other 32 pots remain to be explained by the stock record.

Try the calculation below. It uses whole units and does not read or change your store’s inventory. A zero starting quantity has no meaningful percentage; sales above the starting batch mean the inputs do not fit this closed-batch example.

Read the percentage alongside the stock

A high percentage can mean a product connected with customers. It can also mean the opening buy was too small. If the best-selling size disappeared early, the remaining sizes do not tell you how much additional demand existed.

A low percentage can prompt a useful investigation. Check whether the items were actually on display, available to buy and described correctly. Record the selling time available to each item before deciding that the entire line needs a markdown.

Compare like with like

Use the same counting unit, return convention and measurement window on both sides of a comparison. A case and an individual item are different units. A full-price launch and a clearance event are different selling conditions.

For a replenished line, choose a documented measure that accounts for opening stock, receipts and transfers. Do not quietly switch between starting stock and total stock made available; the denominators answer different questions. Save the definition with the report so another person can reproduce it.

• Separate locations when their availability or trading hours differ.
• Flag stockouts, display changes and promotions beside the result.
• Compare a product with its own earlier, comparable periods before setting a target.
• Keep supplier lead times and remaining season length in the buying discussion.

Sell-through is different from inventory turnover

Sell-through follows units in a defined pool. Inventory turnover is commonly calculated using cost of goods sold divided by average inventory value over a period. One cannot replace the other, and unit counts cannot be substituted into a cost-based turnover formula.

Choose an action you can review

Pick one change and write down why you expect it to help. You might move a slow line to a more visible shelf, correct a missing size description or ask a supplier about smaller repeat orders. Set a date to inspect the next comparable result.

Avoid changing price, display and assortment at the same time if you want to understand which change mattered. Keep margin and cash needs in view: a higher sell-through percentage alone does not prove that the decision improved the business.