# Sell-in vs sell-out: reconciling wholesale and retail truth
A department store buyer places a spring order for 500 units of a new handbag line. The brand's sales team celebrates: shipment invoiced, revenue booked, quarter looks strong. Three months later, the boutique's point-of-sale system shows 40 units actually sold to real customers. The other 460 sit on a stockroom shelf, quietly heading toward a markdown rack. The brand's own dashboards never flagged the problem, because they were only ever measuring the truck leaving the warehouse.
This is the sell-in versus sell-out gap, and it is one of the oldest data-quality traps in luxury distribution.
Sell-in is the data generated when a brand ships and invoices goods to a wholesale partner (a department store, a multi-brand boutique, a franchisee, a duty-free operator). It lives in the brand's ERP (Enterprise Resource Planning, the system that manages orders, inventory and invoicing) and gets recognized as revenue at the point of shipment or delivery.
Sell-out is what happens next: actual purchases by end consumers, recorded in the retailer's own point-of-sale (POS) system. This data belongs to the retailer, not the brand, which is precisely why it is harder to get and easier to ignore.
Sell-in tells you what the brand shipped. Sell-out tells you what the market wanted. In a healthy business the two converge over a season. In a struggling one, sell-in keeps rising (or holding steady) while sell-out quietly collapses, masked by channel stuffing (pushing more inventory into a channel than it can realistically sell) that inflates near-term numbers at the cost of future write-downs and markdowns.
Public companies like LVMH, Kering and Richemont increasingly emphasize "retail" (directly operated store and online) revenue over wholesale in their disclosures precisely because directly operated data is cleaner and closer to real demand. Kering's and Richemont's annual reports (see Richemont's investor relations site for real disclosure examples) routinely break out retail versus wholesale sales as a core reporting line, an implicit acknowledgment that wholesale sell-in is a noisier signal.
To reconcile the two truths, analysts pull from distinct systems:
1. ERP / order management, sell-in volumes, invoice dates, ship dates, wholesale price (often net of trade discounts).
2. Retailer POS feeds, sell-out units, price actually paid (including in-store markdowns), timestamp, sometimes customer ID if loyalty-linked.
3. EDI (Electronic Data Interchange), the standardized messaging protocol many department stores use to send sell-out and inventory data back to suppliers automatically, when the relationship contract requires it.
4. Inventory-on-hand reports, how much unsold stock sits with the wholesale partner right now; the critical bridge metric between sell-in and sell-out.
5. Sell-through rate, the percentage of shipped inventory actually sold to end consumers in a given period.
Sell-through rate is the single most useful reconciliation metric:
Sell-through rate = Units sold to consumer (sell-out) / Units shipped to retailer (sell-in) × 100Worked example using the opening scene:
Industry benchmarks vary by category, but as a general estimate, healthy fashion sell-through in a single season is often cited in the range of 60 to 80% (estimate, varies widely by brand and product category); anything under 30% within the first reporting window is typically treated as a red flag warranting markdown or reorder cancellation. An 8% rate three months in is a strong early warning that the product is not resonating, well before the brand's own revenue line would show any weakness, because the invoice was already booked at shipment.
Timing mismatch. Sell-in books instantly; sell-out trickles in weekly or monthly, sometimes with a reporting lag of 30 to 60 days. Comparing the two without aligning periods produces false conclusions.
Granularity mismatch. Brand ERP may track sell-in by SKU (Stock Keeping Unit, a unique code per product variant). Retailer POS may report sell-out only at category or style level, hiding which exact colorway or size is actually moving.
Ownership and access. Sell-out data belongs to the retailer. Contracts vary: some department stores share full POS feeds via EDI, others share only aggregated monthly summaries, and some share nothing beyond reorder requests. This is a governance issue, not just a technical one: data-sharing clauses need to be negotiated into vendor agreements.
Definitional drift. "Sold" can mean different things: shipped, invoiced, delivered and accepted, or paid. A single brand operating across US wholesale and European wholesale may find partners use different definitions, making cross-market aggregation unreliable unless a shared data dictionary is enforced.
Returns and markdowns. US department stores commonly negotiate markdown allowances or return rights that mass-produce noise in sell-out figures if not separated from gross sell-out units.
Knowledge check
1. In the handbag example, why did the brand's sales team celebrate a strong quarter even though most units never reached a real customer?
2. What does 'channel stuffing' describe in the context of sell-in vs sell-out dynamics?
3. A brand wants to know whether a new handbag line genuinely resonates with consumers rather than just with buyers. Which data source should it prioritize, and why?
4. Select ALL correct answers about why sell-out data is harder for brands to obtain than sell-in data.
Select all the correct answers.
5. Select ALL correct answers describing signs of a 'struggling' business according to the sell-in vs sell-out framework.
Select all the correct answers.
Fixing this is less about better dashboards and more about data governancedata governanceData governance is the set of policies, roles, and processes that ensure data is accurate, secure, well-defined, and used responsibly across an organization.View full definition → discipline:
For a broader primer on retail data standards, the GS1 organization, which maintains global EDI and barcode standards used across department store supply chains, is a useful free reference.
🎬 [VIDEO: "What is EDI (Electronic Data Interchange)?" - youtube.com/results?search_query=what+is+edi+electronic+data+interchange - a short explainer on how EDI standardizes data exchange between brands and retail partners, the backbone of sell-out reporting]