Sell-out vs sell-in: what commercial teams actually need to know

The two numbers that run every retail P&L

Every consumer brand tracks two very different flows of goods. Sell-in measures what leaves your warehouse and lands in a retailer's DC or store. Sell-out measures what a shopper actually takes home. They rarely match on any given week, and confusing the two is the fastest way to make the wrong commercial decision.

Why sell-out wins the argument

Sell-in tells you what you invoiced. Sell-out tells you what the market absorbed. If sell-in is up 20% while sell-out is flat, you built inventory in the trade — and that inventory will come back as returns, markdowns, or a brutal Q+1.

Modern retail commercial teams anchor every review on sell-out because it is the only signal that survives promo cannibalization, forward-buying, and channel stuffing.

Structuring a weekly sell-out review

• Pull sell-out by SKU x customer x week.
• Compare vs last year, not vs last week — retail is deeply seasonal.
• Separate promoted vs non-promoted weeks to see the true baseline.
• Layer stock coverage so you know whether a drop is a demand issue or an out-of-stock.

The Excel trap

Most teams still stitch retailer files together in Excel every Monday morning. It takes hours, breaks every time a retailer changes its template, and buries the actual insight under manual formatting. That is exactly the problem Sell-Out Copilot solves.