Lost sales
The Lost Sales report allows you to determine the number of unprofitable days when a product was not sold or its sales were below average. Products that have at least one day with losses are highlighted in red on the planogram.
To change the period, click on the Set up report button on the right of the toolbar. By default, the last 30 days are used.
To download the report in Excel format, just click on the corresponding button in the upper right corner.
To customize the display of metrics in the report, click on the appropriate icon in the top right-hand corner of the table.
The report allows you to analyze a wide range of metrics, including:
Product name
Article
Product type
Lost days qty
Quantity of days during the selected period when the product was not sold or had below-average sales in the selected period.
Qty of losing days when stocks are null
The total number of days during the selected period when the product was out of stock and the product was not sold or had below-average sales.
Average sales qty per day
Average sales qty per day = Sales qty / Number of days on which there were sales of products for the period.
Lost sales qty
The probable number of sales that could have been made during the selected period of time in the absence of problems in the store. The calculation takes place in two stages:
Lost sales qty per day with losses = Average number of sales per day - Number of sales per day.
Lost sales qty = The total value of lost sales on the days when there were losses.
Lost turnover
The probable turnover that could have been generated over a selected period of time in the absence of problems in the store. The calculation takes place in two stages:
Lost turnover on a day with losses = Lost sales qty × Price of products on that day (if there was no receipt for the day, the last available price value is taken).
Lost turnover = The total value of the lost turnover on the days when there was a loss.
Lost turnover by out-of-stock
Metric that takes into account the lost turnover that occurred on days when the products were not on the stock.
Faces qty
The number of product facings laid out.
Product stock on the shelf, pcs./kg
The total number of products on the planogram.
For packaged products:
Product stock on the shelf, pcs = Facing sqty × Placement depth × Placement height.
For bulk products:
Product stock on the shelf, kg = Package weight, or "1" if no package weight is specified.
To change the period, click on the Set up report button on the right of the toolbar. By default, the last 30 days are used.
To download the report in Excel format, just click on the corresponding button in the upper right corner.
To customize the display of metrics in the report, click on the appropriate icon in the top right-hand corner of the table.
Available metrics for analysis
The report allows you to analyze a wide range of metrics, including:
Product name
Article
Product type
Lost days qty
Quantity of days during the selected period when the product was not sold or had below-average sales in the selected period.
Qty of losing days when stocks are null
The total number of days during the selected period when the product was out of stock and the product was not sold or had below-average sales.
Average sales qty per day
Average sales qty per day = Sales qty / Number of days on which there were sales of products for the period.
Lost sales qty
The probable number of sales that could have been made during the selected period of time in the absence of problems in the store. The calculation takes place in two stages:
Lost sales qty per day with losses = Average number of sales per day - Number of sales per day.
Lost sales qty = The total value of lost sales on the days when there were losses.
Lost turnover
The probable turnover that could have been generated over a selected period of time in the absence of problems in the store. The calculation takes place in two stages:
Lost turnover on a day with losses = Lost sales qty × Price of products on that day (if there was no receipt for the day, the last available price value is taken).
Lost turnover = The total value of the lost turnover on the days when there was a loss.
Lost turnover by out-of-stock
Metric that takes into account the lost turnover that occurred on days when the products were not on the stock.
Faces qty
The number of product facings laid out.
Product stock on the shelf, pcs./kg
The total number of products on the planogram.
For packaged products:
Product stock on the shelf, pcs = Facing sqty × Placement depth × Placement height.
For bulk products:
Product stock on the shelf, kg = Package weight, or "1" if no package weight is specified.
Updated on: 18/02/2025
Thank you!