Sell-Through Rate Calculator: Track Product Performance by Week, Month, and Season

TL;DR

What Is Sell-Through Rate? (And What It Doesn't Measure)

Sell-through rate is the percentage of a defined pool of inventory units that sold during a defined reporting period. It answers a practical question: how much of this assortment moved through the channel?

Retail and ecommerce teams can review it weekly, monthly, daily, or across an entire season. The units-sold-to-units-received approach is widely used for short-period measurement, while inventory turnover is a separate longer-horizon measure. 2 3

This article uses sell-through strictly as a unit movement metric. It is not sell-through value, revenue, gross margin, GMROI, store profit, open-to-buy, days on hand, or inventory turnover.

Inventory turnover is commonly calculated as cost of goods sold divided by average inventory. That cost-and-average-inventory calculation answers a different question from the unit formula used here. 4

Use sell-through alongside those measures, not as a substitute for them. A SKU can have fast unit movement and weak margin. It can also carry a strong margin and move too slowly. Neither outcome changes the unit sell-through calculation.

The metric earns its place in several operating conversations. Buyers use it in open-to-buy and vendor discussions. Merchandisers use it as one input to markdown planning. Ecommerce operators use it to assess a launch or replenishment. Gift shops can use it for consignment settlement and end-of-season review.

Each use requires context. A low interim rate can reflect an incomplete season, a late receipt, low traffic, stock-outs in key variants, or a product that is intentionally carried as evergreen. Seasonal stock build can also make an interim rate look low without proving weak demand. 4

The Sell-Through Rate Formula, and Why the Denominator Matters More Than You Think

Use this article's standard formula:

Sell-Through Rate (%) = (Units Sold ÷ Units Available) × 100

The numerator and denominator must use the same product scope, channel, and reporting window. At SKU level, do not silently combine one color or size with another unless you intentionally report a model or design family.

For this calculator, Units Available is declared in one of two ways:

Convention A matches the beginning-available-stock definition published by APQC. 1 Convention B is a practical available-for-sale convention for a period where both opening units and new receipts can be sold. Industry sources also use a same-period units-received denominator, which is a third convention. Do not call all three results comparable just because they share the name sell-through. 2 3

The choice becomes especially important after replenishment. Opening stock alone may be appropriate for a fixed initial-drop question. It becomes misleading if sales later include replenishment units.

Returns require an equally explicit policy. Report gross and net units separately, rather than implying that every retailer must calculate them one way. No researched source establishes a universal rule for subtracting returns from the numerator. For post-return reporting, use:

Net Units Sold = Gross Units Sold − Returns

Gross sell-through uses gross units sold in the numerator. Net sell-through uses net units sold. Keep the return window and attribution policy stable. That matters in seasonal ecommerce, where most holiday returns occur in January after the December selling window. 8

The following original table uses the same hypothetical SKU data under both conventions. It shows why the same SKU can be described as 72% or approximately 54% sold through, depending on the denominator. The 54% display is rounded to a whole percentage.

Neither percentage is automatically wrong. They describe different inventory pools. Mixing them across vendors, stores, collection drops, or prior seasons produces a comparison without a stable meaning.

Do not average weekly sell-through percentages to make a monthly or seasonal result. Roll up the actual units instead: total net units sold divided by the total denominator units under the same convention. This avoids giving a tiny weekly denominator the same influence as a large one.

The Sell-Through Rate Calculator

Use this retail sell-through calculator as a manual worksheet. Fill in one row for one SKU, model, collection, or deliberately defined category. Do not use a category rollup if its products have different selling windows unless the purpose of the rollup is explicit.

If a return arrives after the reporting cutoff, do not rewrite history silently. Keep a gross view and a post-return net view, label their windows, and use the same approach for comparison periods.

Copy this table into a spreadsheet or use the worksheet link: [Download the Sell-Through Worksheet - branvas.com/academy]. For brand founders tracking sell-through across a new accessories line, see How Branvas Works.

A calculator produces a number, not a verdict. Before acting, check whether the item was in stock, whether it was distributed to the same number of stores or channels, whether a promotion occurred, and how far through the selling window it is.

The Branvas Sell-Through Clarity Framework™

The Branvas Sell-Through Clarity Framework™ is a four-step system for making a sell-through report operational. It is designed for a founder or buyer who needs a clear next decision, not an isolated percentage.

1. Fix your denominator

Choose Convention A or Convention B before the season, launch, or reporting cycle begins. Put the convention in the report title, spreadsheet, and vendor communication.

For a fixed capsule with no receipts, both conventions are the same. For a replenished item, Convention B usually gives the clearer available-for-sale view. If you also need to assess the initial buy, run that as a separate, labeled initial-drop cohort rather than blending it with replenishment.

2. Normalize for elapsed time

Never compare a four-week result with an eight-week result at face value. Report elapsed weeks, net units per week, and sell-through percentage points per week.

A weekly pace is not a forecast guarantee. Demand can change with traffic, promotions, weather, holidays, stock-outs, and price response. It is still a much better conversation starter than a bare percentage. POS-based research also shows that retail demand varies by day, holiday, and season. 6

In our experience at Branvas, founders can misread an early seasonal-drop result by comparing week two with a full-season percentage they found online. The useful question is whether the product is following its own staged plan at week two, with its in-stock status and planned selling window visible.

3. Segment by assortment role

Separate hero SKUs, core SKUs, and tail SKUs before you judge performance. A hero item may justify rapid replenishment. A core item can have a longer evergreen window. A tail item may be experimental, campaign-linked, one-of-one, or intentionally shallow.

Jewelry and accessories frequently need more than an exact-SKU view. A replenishable bracelet may be evaluated by exact SKU, while a variant-heavy or custom design may be better reviewed at the model or design-family level. Jewelry-specific operating guidance makes the same distinction, while cautioning that its examples are not a public benchmark dataset. 9

4. Trigger an action, not just a report

For each assortment role, pre-agree an action when the product is ahead of, on, or behind its staged plan. The action might be reorder, hold, move stock, adjust content or placement, markdown, return to vendor, or discontinue.

Do not set a generic percentage as an automatic markdown trigger. Fashion markdown work supports SKU-level, weekly scenario planning that considers seasonality, promotion intensity, traffic, stock-outs, price response, and the start and end dates of the selling window. 7

A clear trigger records the evidence, owner, deadline, and decision. That transforms sell-through from a retrospective dashboard into a way to manage the next receipt, campaign, or exit path.

What Is a Good Sell-Through Rate? (The Honest Answer)

The popular claim that 80% is a good sell-through rate is incomplete to the point of being misleading. A high rate may be excellent for one short-life launch, ordinary for another, or evidence that you underbought and missed sales. A lower rate may simply reflect that the season has several weeks left.

ISM describes 80% or higher as very good general guidance and reports a 60% typical fashion figure quoted from a Dutch menswear practitioner. Those are useful contextual signals, not a representative cross-category benchmark study. 2 SPS and other publisher guides also offer directional ranges without transparent underlying samples or a common denominator. 3

APQC publicly displays a 68.0% retail sell-through figure, but its public page does not disclose enough sample, category, date, or percentile methodology to turn it into a universal target. 1 It is a reference point to investigate, not permission to ignore your selling window.

The correct comparison is same category, same channel, same denominator, same receipt treatment, same return policy, same in-stock condition, and equal elapsed selling time. A 45% rate at week 4 of a 12-week season can be on a reasonable trajectory. The same 45% at week 10 can signal that a clearance or exit decision deserves attention. The percentage alone does not decide either case.

Public category evidence is uneven. The table below deliberately separates what is documented from what must be treated as a retailer's planning rule. It is an original comparison tool, not an industry-average table.

The only ranges worth using where public evidence is weak are planning ranges, created from your own comparable history and risk tolerance. They are not industry averages. Document the base case, upside case, target selling window, planned receipts, and action tied to each range.

For apparel, a vendor such as Heuritech publishes 60-80% fashion guidance, roughly 50% luxury, and 80%+ fast fashion. Its page does not disclose a transparent sample, geography, or source methodology, so treat those figures as weak vendor guidance rather than settled standards. 10

For accessories and jewelry, no rigorous universal unit sell-through benchmark was found. A leather-accessories case reported 0.82 versus 0.59 in a model-based comparison, but it used quarterly sales divided by average monthly stock, not the receipt- or opening-stock unit formula in this article. It is evidence that assortment planning can matter, not a jewelry benchmark to copy. 11

For gift shops, holiday retail sales are concentrated in time, but sales concentration is not unit sell-through. NRF reports that November and December averaged about 19% of annual retail sales over the prior five years. That broad retail statistic cannot be converted into a gift-shop sell-through target. 8

Worked Example 1: Fixed Seasonal Collection (Accessories / Jewelry)

An accessories founder launches a 12-week capsule jewelry collection. The collection is a fixed buy, so no replenishment is expected during the season.

At the end of week 6, the collection has opening stock of 200 units, no receipts, gross sold of 98 units, and returns of 4 units. The analysis uses a post-return net view.

Because there were no receipts, the two conventions agree. That agreement does not make the rate universally good or bad. It makes the measurement clean.

At a mechanically unchanged pace, six more weeks would add roughly 94 net units, or 188 units for the 12-week window. That would equal about 94% of the 200-unit fixed collection. This is a pace check, not a demand forecast. It assumes the remaining weeks, stock availability, return behavior, and customer response remain comparable.

Interpretation: the collection is broadly on a full-clearance trajectory if 94% is appropriate for this founder's planned exit. Check key variants before celebrating. A complete early sell-out can indicate that the original buy was too shallow and sales were missed. The next decision is to preserve the documented fixed-capsule result, assess stock-outs by design, and decide whether a future collection should receive a deeper initial buy or a planned replenishment option.

Worked Example 2: Replenished Collection (Apparel or Gift Shop)

A gift shop carries an occasion-led collection through an eight-week selling window. It begins with opening stock of 150 units. It receives 80 additional units in week 4. By the end of week 8, it has gross sold 175 units and recorded 12 returns.

Convention A exceeds 100% because the numerator includes units sold after replenishment, while the denominator keeps only opening stock. That is not proof of impossible demand. It is a signal that the metric scope is mismatched.

Interpretation: for an all-in season view, Convention B is the meaningful rate because 230 units were available to sell. The 70.9% net result leaves 67 units from that denominator before any later adjustments. The gift shop should now check its remaining event dates, on-hand sellable units, consignment obligations if applicable, and returns after the close of the season.

For a clean initial-buy assessment, the shop would need receipt and sales attribution that separates the original 150-unit cohort from the 80-unit replenishment. If that tracking does not exist, do not present the 108.7% Convention A figure as a standard all-season sell-through result.

Sell-Through Rate in Practice: Apparel, Accessories, and Gift Shop Scenarios

Apparel needs a calendar-aware view. A markdown decision should consider the SKU's selling age, remaining season, traffic, promotional intensity, stock-outs, and cross-item effects. BCG describes a preparation and live-adjustment approach using detailed store and SKU data, rather than one fixed markdown rule for every item. 7

Open-to-buy belongs beside this review, not inside the rate. Open-to-buy is a purchasing-budget calculation based on planned sales and inventory, inventory on hand, and purchase orders. It can guide what to buy next, while sell-through explains unit movement in the assortment already available. 12

Accessories and jewelry often have lower SKU counts and more variation in individual unit demand. A capsule drop and an evergreen core should not be judged on the same time horizon. Track exact SKUs when they are replenishable. For variant-heavy designs or custom work, also report a model or design-family view so a colorway does not hide the demand signal.

We often see founders struggle with treating a slow-moving tail design as evidence that an entire jewelry launch failed. A hero SKU, a core replenishable, and a shallow experimental design each need a different planned window and action rule.

We often see founders struggle with counting returned ecommerce units as permanently sold in a launch recap. A gross view is useful for order flow, but a post-return net view is necessary when deciding what truly moved through the assortment.

Gift shops have sharper timing constraints. Holiday concentration, exhibit changes, and occasion-linked inventory mean that the same weekly rate can mean different things before and after the event. Museum-store inventory can also be shaped by changing exhibits and leftover exhibit-linked goods rather than a conventional commercial-retail cycle. 13

Track consigned goods as their own cohort. The consignor retains ownership until sale and unsold goods are generally returned or the agreement extended, although terms vary. Reconcile sold, returned-to-consignor, damaged or lost, and on-hand units before a settlement. 14

If you're launching an accessories or jewelry line and want to track sell-through from day one, explore Branvas's catalog and fulfillment model.

Frequently Asked Questions

1. What is the sell-through rate formula?

The sell-through formula is Sell-Through Rate (%) = (Units Sold ÷ Units Available) × 100. First declare what Units Available means. This article shows Convention A, opening stock only, and Convention B, opening stock plus receipts during the period. For a post-return view, calculate Net Units Sold = Gross Units Sold − Returns and use net units sold in the numerator. Keep the same convention, return policy, product scope, and time window when comparing results. 1 2

2. What is a good sell-through rate for retail?

There is no universal good sell-through rate. An 80% result can be strong in some settings, but it is not meaningful without category, channel, season length, replenishment model, stock availability, return treatment, denominator, and elapsed selling time. ISM calls 80%+ very good as broad guidance, while its 60% fashion figure is a practitioner reference rather than a representative benchmark. 2 Compare your rate against comparable internal history at the same point in the selling window.

3. How do you calculate seasonal sell-through rate?

Define the season's start and end dates, product cohort, denominator convention, and return cutoff. Then add net units sold across the season and divide by the total available units under that same convention. For Convention B, that is opening stock plus the included seasonal receipts. Do not average weekly percentages. Divide total seasonal net units sold by total seasonal denominator units instead. Check interim results at equal elapsed time, such as week 4 versus week 4 of a comparable prior season.

4. How does replenishment affect sell-through rate calculations?

Replenishment increases the inventory pool that was available to sell. If sales after replenishment are included in the numerator but opening stock alone stays in the denominator, Convention A can exceed 100%. That may be useful for a narrowly labeled initial-stock question, but it is misleading as an all-in seasonal result. Use Convention B, opening stock plus included receipts, for the broader available-for-sale view. Or track original-drop and replenishment cohorts separately when the system supports attribution.

5. How is sell-through rate different from inventory turnover?

Sell-through measures the percentage of a defined unit inventory pool that sold during a period. Inventory turnover measures how often inventory is sold and replaced over a longer horizon, commonly using cost of goods sold divided by average inventory. 4 Sell-through is especially useful for a launch, SKU, drop, season, or receipt cohort. Turnover is useful for a broader inventory-efficiency view. Neither metric is revenue, margin, GMROI, or store profit.

References