Data retailers share & why it’s important: After your product ships (Part 1)

Date Posted: July 31, 2019

Landing a product on shelves is far from the last step in the sales cycle. Monitoring what happens to product after it leaves your warehouse is integral to maintaining an efficient supply chain and maximizing sales opportunities. Fortunately, most retailers provide data to help suppliers understand how they’re performing.

But out of that weekly or daily data deluge, what are the crucial metrics? And how do they inform better strategy and execution moving forward? Data provided by retailers varies, but the following list summarizes four of the eight most important data points, and why they’re important to growing sales and optimizing supply chain management.

Check out part two next week for the other four key data points.

Unit Sales (Net)

Unit Sales (Net) is the number of units sold from a retailer to a consumer, excluding any customer returns. Many also refer to it as sell-through or sell-out.

This metric is the best indicator of true demand because it measures when an end consumer actually buys a product, not just when a retailer places an orders, or sell-in. With that important distinction in mind, Net Unit Sales is what all brands should be using for performance measurement, demand forecasting, replenishment and many other day-to-day sales and inventory management activities.

If a retailer doesn’t provide Unit Sales (Net) directly, you can calculate it by subtracting returns from gross sales. Ideally, you want to collect and analyze this data at the store level to gain insight into geographic preferences and allocate inventory accordingly.



Of course, if a retailer provides the actual sales price, you should use that value to translate those numbers from units into dollars. One of our most popular metrics is Future Lost Sales Dollars, which is derived by combining sales price with forecasted demand, inventory on hand and inventory in transit.

Price is also an integral factor in understanding demand drivers, and what strategies brands can use to shape demand. If you’re thinking about running a promotion that lowers the effective price, what effect will it have on volume? Is the unit increase great enough to offset the reduced per unit margin? Analyzing historical and current price data across all your retailers can help answer these questions, guide your approach to promotions and generate more accurate demand forecasts.

Price is also worth monitoring to ensure that retailers are adhering to your pricing policies, such as MAP (Minimum Advertised Price) or UPP (Unilateral Pricing Policy).

Dollar Sales (Net)

Dollar Sales (Net) is the total dollar value of the products sold during a given period of time, excluding returns. It translates Unit Sales (Net) into what is often a more useful format.

For example, it enables teams to look past prioritizing volume and prioritize based on the size of the business instead. This important difference helps ensure you’re spending your time and resources where they’ll make the biggest impact, whether it’s deciding what problems to address or what products or geographies to focus on.

Another reason Dollar Sales (Net) is important is it can be used to calculate sales price if that information is not directly provided by retailers. By dividing Dollar Sales by Unit Sales, you get an average unit retail that you can apply to anything from out-of-stocks to on-hand inventory.


Retailer Cost of Goods Sold (COGS)

The Retailer Cost of Goods Sold, or cost of sales, is the amount the retailer pays for the product it sells. When subtracted from Net Dollar Sales, you get the Retailer Gross Margin, which is what they care most about. It’s the amount that they earn from the sale of products.

Best practice for brands is to take the perspective of the retailer in your conversations with them. That starts with understanding their margins. Buyers use this metric to gauge the value of their relationship with a supplier and make decisions, from how much to order to whether to extend shelf space or grow distribution to more stores. As you can imagine, margin is an integral component of any negotiation.

If the Retailer COGS is not provided directly by the retailer, you can calculate it by multiplying Unit Sales (Net) by the Dealer Cost. It’s worth noting that the Retailer COGS is often different from your sell-in. It is based only on what is actually sold to consumers, that true demand. Since retailers can return unsold product, they do not need to take into account the cost of excess inventory (beyond holding costs), even though it has a significant impact on your bottom line.

Next week, we’ll share the remaining four crucial data points to get a complete picture of your supply chain and derive metrics like Future Lost Sales Dollars. Subscribe below to get automatically notified when it’s available!

Related resources


Talking better product launch and allocation decisions with Ferrero USA

The global confectioner mitigates waste, improves service levels and controls costs by connecting digital supply chain visibility with POS analytics.

Keep reading

Say goodbye to constant supply chain firefighting: A guide

How to take an iterative approach to digital supply chain transformation with real-time alerts that motivate teams to collaborate on issue resolution

Keep reading

New white paper exposes the gap between planning and execution

Understand how gaps between systems, teams and processes are keeping you constantly firefighting and hurting your supply chain resilience

Keep reading