Sell-In vs. Sell-Through: The Ratio Most Brands Aren't Watching

You shipped $400,000 to Target last quarter. Revenue booked, PO closed, good quarter, everyone hit their number.

Then the reorder does not come.

The units never left the shelf. What you booked as a great quarter was really an inventory transfer, and now you have a buyer who is not returning calls and a forecast built on a repeat order that is not coming.

The forecast was not the failure. The failure was watching one number when the story lives in two.

What sell-in and sell-through actually mean

Sell-in is what the retailer buys from you: the purchase order from Target, the shipment to a distributor. It is what your finance team books as revenue. Sell-through, sometimes called sell-out, is what the shopper buys at the register. It is what actually leaves the store.

The difference between the two is inventory sitting somewhere in the retailer’s system, in a distribution center or on a shelf. Some gap is normal and healthy. What matters is which direction it is moving, and how fast.

Why finance and sales never agree about the quarter

Ask your finance lead and your VP of Sales how the Target business did last quarter and you can get two different answers from two people who are both reading their numbers correctly.

Finance lives in sell-in. That is what gets booked, what the general ledger reflects, and what the board sees on the revenue line.

Sales lives in sell-through. That is what proves demand, what the buyer raises in the next review, and what decides whether the account grows.

Both are right. Neither is complete. And because the two numbers usually live in different systems on different refresh schedules, the disagreement gets settled by whoever has the more confident slide rather than by the data.

Worth naming plainly: this looks like an alignment problem and it is actually a data problem. The argument ends when both numbers sit side by side in the same view.

The ratio is the metric

Neither number tells you much on its own. The relationship between them is where the signal lives.

A worked example. You ship 10,000 units to a retailer in Q1 and 6,000 sell through. That is a 60% sell-through rate, and 4,000 units are still sitting in their system. Ship another 10,000 in Q2 against 6,500 sold, and total inventory at the retailer has grown to 7,500 units. Revenue looks like it grew. Your exposure roughly doubled. Nothing on the sell-in line tells you that.

Three patterns are worth watching.

Sell-in running ahead of sell-through

Inventory is accumulating at the retailer. The reorder is at risk, and the longer it builds the more likely you are to see markdown pressure, deduction claims, or in the worst case a return. The revenue you booked last quarter was partly borrowed from the next one.

Sell-through running ahead of sell-in

You are heading for a stockout. This is the better problem to have, but only if you catch it with enough lead time to produce. Empty facings are how brands quietly lose placement, and a buyer who has to explain a hole in the planogram is a buyer already thinking about a replacement.

Both growing, but distribution growing faster than velocity

This is the one most brands miss. Revenue is up and to the right because you keep adding doors. Per-store velocity is flat or falling underneath it. You are adding shelves, not fans. It works right until door growth stops, and then the underlying trend surfaces all at once.

None of the three is visible from either number by itself. That is the whole argument for watching the ratio rather than the components.

The timing problem nobody mentions

Here is where most first attempts at this go wrong. Sell-in and sell-through are offset in time, so comparing the same calendar week tells you very little.

A shipment that lands in week one shows up as sell-through across weeks two through eight, spread according to how fast that product moves. Line the two series up week by week and a large shipment will always look like it outran demand, because the demand it was meant to serve has not happened yet.

Two practical fixes. Compare on a lag that matches the product’s typical shelf life at that retailer, which you learn from your own history rather than from a rule of thumb. Or skip the comparison and monitor weeks of supply instead, which folds both numbers into a single running figure and does not care about period boundaries.

The second is what most teams end up doing, and it is the reason weeks of supply keeps showing up as the metric that matters even in conversations that started out about sell-through.

Why the ratio has been hard to watch

Sell-in and sell-through arrive from different systems, on different cadences, with different product identifiers. Some retailers hand you both. Some hand you one. Some hand you neither directly, and you get there through a distributor login instead.

Reconciling that account by account has historically meant an analyst who owns the account. We wrote separately about why retail data is so hard to get and normalize in the first place. The short version is that the reconciliation work scales with the number of doors you sell through, so it becomes unmanageable exactly when growth makes it matter most.

Taste Salud is a useful case here. They grew sales 10x while expanding into Walmart and Target, and recovered more than 330 hours a year on budgeting alone, worth roughly $200,000 annually. Every new retailer adds another schema to reconcile. Brands that handle this well are not out-analyzing anyone. They stopped doing the reconciliation by hand.

What a sell-in vs. sell-through report actually shows

At the product level, over time, for a single retailer:

• Store count, unit volume, scan dollars, and average price
• Geographic breakdown, so you can separate the regions moving product from the regions merely carrying it
• Inventory health wherever the retailer provides it. Target gives inventory counts, which is what turns weeks of supply and out-of-stock store counts from estimates into calculations.
• A ranked list of products with low weeks of supply and a high count of out-of-stock stores

That last line is the difference between a report and a decision. A buyer conversation that opens with a ranked list goes differently than one that opens with a hunch.

One thing to watch for in the numbers: promotions distort the ratio in both directions. A deep discount spikes sell-through, drains the retailer’s inventory, and makes the account look healthier than it is. Then the post-promo lull arrives and the same account looks like it is collapsing. Neither reading is right. Any report you rely on should let you see promotional periods flagged rather than blended into the trend.

Slumber Cloud runs SKU-level inventory forecasting at 90% accuracy, and the framing in their story is the right one: the goal is preventing overstock and stockouts, not optimizing against one and getting blindsided by the other. Most brands pick a side without meaning to.

From numbers to a decision

The output that earns its keep is a flag, not a chart. Nobody reads the chart on a Monday morning.

The flags worth automating:

• SKUs that need an immediate production run
• Accounts where distribution is outpacing velocity
• Products at risk of losing facings

immi is the short version of what happens when reporting catches up. Their expansion into wholesale brought inventory requirements DTC never demanded, and once the forecasting caught up they cut actual-versus-budget variance by 50%.

SEEQ is the cost of not catching up: a 30 to 60 day reporting lag produced stockouts and marketing overspend at the same time, in the same business.

Once you can see the ratio, the next question is what to produce against it, which is a demand planning problem.

The one-line version

Sell-in is what you booked. Sell-through is whether you get to book it again.