Introduction
The product detail sheet provides a comprehensive view of a product's performance across key areas: sales, stock, and customers.
The displayed analysis is aligned with the selected stores, time period, and conditions. It is essential to distinguish between the commercial view, which reflects sales potential based on customer orders, and the financial view, which represents the actual sales transformation, net of returns.
The commercial view provides a "customer-ordered" perspective, indicating sales potential.
The financial view reflects the actual transformation of sales, net of returns.
Thus, to analyze customer appetite, the commercial view is more appropriate. To assess resource usage (stocks, sell-through), the financial view should be prioritized.
Main Sections
1. Performance Summary
A summary section compiles key performance indicators (KPIs) related to sales and sales conditions, including product impact within the collection and ticket context. For more details, refer to the glossary. Key metrics include:
Sales performance
Product impact within the collection
Assortment and purchasing behavior within ticket analysis
2. Complementary Purchase Context
This section identifies products purchased alongside the analyzed product within the selected scope. This helps understand customer associations and the product universe, facilitating optimized product recommendations and the development of more relevant offerings.
3. Stock and Sell-Through Tracking
Here, you will find a sell-through timeline showing stock distribution across different supply chain positions. By clicking on the various stock categories, you can assess their quality and quantity and compare them with the in-store situation.
4. Sell-Through by Size
This section displays stock distribution by size and status within the supply chain. It helps determine whether purchasing strategies align with customer demand at the size level.
5. Sales Distribution by Country and Channel
If the analysis covers multiple countries or sales channels, a chart presents the sales distribution according to these criteria. This allows you to adjust your strategy based on the most successful channels and markets.
6. Product Lifecycle Chart
This chart shows, over the selected period:
The weekly evolution of stocks in warehouses and stores
Sales volumes
Temperature trends in stores where the product was available, to assess its potential impact on sales
7. Product Score and Turnover Rate
This section tracks the product score week by week to identify whether demand is approaching its peak or if signs of decline are appearing, regardless of sales volumes, which may be influenced by stock availability.
8. Stock Service Rate by Store
This chart provides insight into stock availability in stores. Stores are sorted by sales potential, making it easier to identify trends and pinpoint any stock issues. This analysis should be conducted on a global level rather than store by store:
Is stock degradation concentrated in a specific group of stores or dispersed?
Is the impact more significant in high-potential stores (top left) or lower-potential ones (bottom right)?
These insights can help detect issues in the store replenishment algorithm or excessive allocations in terms of volume or assortment. You can then take immediate action by adjusting replenishment rules (such as restricting assortment scope or prioritizing a product) or refining structural assumptions for future products (e.g., revising initial allocation quantities or store module construction rules).
Conclusion
The product detail sheet provides a comprehensive overview of a product's performance in terms of sales, stock, and customer behavior. It enables you to adjust your strategy to maximize commercial opportunities and optimize resource management.