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 Report settings 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.
Displaying metrics у report can customise by using the corresponding icon at the top right of the table.
The report allows you to analyse 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 = Quantity of sales \ Quantity 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 = Number of lost sales * 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 balance.
Faces qty
The number of product faces posted.
Product stock on the shelf, pcs./kg
The total number of products on the planogram.
For packaged products:
Product stock on the shelf, pcs./kg = Number of cases Depth of display Height of display.
For weighted products
Product stock on the shelf, pcs./kg = Package weight or "1" if no package weight is specified.
To change the period, click on the Report settings 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.
Displaying metrics у report can customise by using the corresponding icon at the top right of the table.
Available metrics for analysis
The report allows you to analyse 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 = Quantity of sales \ Quantity 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 = Number of lost sales * 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 balance.
Faces qty
The number of product faces posted.
Product stock on the shelf, pcs./kg
The total number of products on the planogram.
For packaged products:
Product stock on the shelf, pcs./kg = Number of cases Depth of display Height of display.
For weighted products
Product stock on the shelf, pcs./kg = Package weight or "1" if no package weight is specified.
Updated on: 17/01/2025
Thank you!