You operate in brick-and-mortar retail, you don’t have an online store, and when someone asks how your in-store sales are performing, you answer “pretty well” while keeping your fingers crossed. That’s not a critique — it’s the reality for many brands selling through indirect distribution. Measuring sell-out without e-commerce is a real topic, and it’s often handled poorly. Yet there’s a practical method: leveraging the data reported by your retailers.
Without e-commerce, the most reliable way to measure sell-out is still the data shared by your retailers: sales reports, EDI extracts, weekly or monthly sell-out files. The method is to centralize these feeds, normalize them, then cross-reference them with your marketing actions to separate what sells from what doesn’t — aisle by aisle, SKU by SKU.
The core issue: you’re managing with sell-in
Most brands without a direct channel measure what they ship to retailers — sell-in — and assume it sells through. That’s a management mistake. What you ship to a wholesaler or a retail chain says nothing about what the end consumer actually buys at shelf. In between, there’s slow-moving stock, silent out-of-stocks, and promotions that never really get executed.
True in-store sell-out happens without you. And without data, you’re flying blind.
What your retailers have (and don’t always share)
Your retail partners have access to detailed data: units sold by SKU, purchase frequency, sell-through rate, stock levels. Some share it proactively via dedicated portals or automated exports. Others send it only on request, in a raw format, in a hard-to-read Excel file. Others don’t share it at all unless you negotiate it contractually.
So collecting retailer data is first a relationship and contractual challenge before it’s a technical one. If you don’t have a sell-out reporting clause in your commercial agreements, start there.
Available data sources
In practice, the data you can access to measure your in-store sales comes from several channels:
- Retailer portals (Carrefour, Leclerc, Système U…) offering reporting interfaces to listed suppliers
- EDI feeds (Electronic Data Interchange) automated between your systems and your partners’ systems
- Manual exports sent by your retail contacts
- Retail panel data purchased from institutes like Nielsen or Circana (formerly IRI), aggregating checkout data across many chains
- Where to buy tools that track purchase-intent clicks toward retailers and help reconstruct part of real demand
Each source has limitations. Portals are often fragmented. EDI requires technical integration. Panels are expensive and remain declarative. Ideally, combine at least two sources to cross-check signals.
How to structure your sell-out reporting
Once you’ve collected the data, you still need to make it usable. Most files come in different formats, with different naming conventions depending on the retailer. Before any analysis, you need to normalize: align product IDs, harmonize time units, remove duplicates.
Here are the priority metrics to track in your retailer performance dashboard:
| Metric | What it measures | Recommended frequency |
|---|---|---|
| Sell-out volume per SKU | Units sold at checkout per product | Weekly |
| On-shelf rotation rate | How quickly stock moves | Monthly |
| Out-of-stock rate | How often the product is missing on shelf | Weekly |
| Shelf share (facing) | Visual presence vs competitors | Monthly |
| Average selling price | Gap between recommended price and actual price | Monthly |
| Post-promo sell-out | Real impact of a promotion on sales | Per campaign |
Crossing sell-out with marketing actions: the real challenge
Having in-store sales data is good. Knowing whether last month’s digital campaign moved those sales is much better. That’s where retail sell-out measurement becomes a true marketing management lever.
In practice: if you run a drive-to-store campaign in October and your retailer data shows a sell-out lift over the same period in the targeted geographic areas, you have a strong signal. It’s not absolute proof of causality — but it’s an actionable correlation to optimize your next budgets.
What blocks you in real life
Even with the right method, a few obstacles show up again and again:
- Not all retailers share the same data at the same pace
- Formats vary by chain and sometimes by contact
- Data arrives late — sometimes two to three weeks after the period concerned
- Some smaller retailers simply don’t have reliable reporting tools
- Consolidation takes time if done manually
That’s not a reason not to do it. It’s a reason to do it right from the start: automate what can be automated, and accept that data will never be perfect — but it will always be better than a rough guess.
How can you measure in-store sell-out without going through e-commerce?
Without an e-commerce channel, sell-out measurement relies on sales data sent directly by your retailers: POS extractions, EDI reports, weekly sell-out files. The key is to centralize these feeds, normalize them, and cross-reference them with your marketing actions to get a reliable view of what truly sells on shelf.
How can you leverage retailer data to finally know your true in-store sales?
By collecting and structuring the sales reports shared by your retailers, you gain a clear view of what actually sells on shelf. The trick: centralize the data, clean it, and cross-reference it with your marketing actions to turn raw numbers into real decision levers.
How do you turn retailer data into an effective marketing management tool?
By standardizing the data feeds received from your retailers and integrating them into a dedicated dashboard, you move from a simple list of numbers to a real management tool. You can then measure promo impact, identify best-performing SKUs, and adjust your strategy in near real time.
20 reviews
Maxence Antao, Communications Officer at Click2Buy
“Our role at Click2Buy: guide our customers throughout the purchase journey and optimize their marketing ROI with real-time retailer stock data.”
