Lost sales

The "Lost sales" report allows you to determine the number of days when a product was not sold or had very low sales. The report includes products with regular sales that were not sold for at least one day during the selected period (for example, when the product was out of stock). Such products are highlighted in red on the planogram.

In this article we will review the "Lost sales" report: how to configure it and what indicators are available.

Contents

How to configure the report
Indicators table

How to configure the report

To open the report, click "Analytics" → "Lost sales" on the left toolbar.

In the "Report settings" panel:

1. Click the "Period" field and select the required date range in the calendar or use one of the ready-made options. The last 30 days are set automatically;
2. Click "Apply" to save the changes.

Products with at least one day of losses are highlighted in red on the planogram.

Indicators table

At the bottom of the page, a table with product information and indicators for the selected period is displayed:

1. Product attributes:
2. • Name;
   • Article;
   • Barcode;
   • Type (packaged/weighting).
2. Indicators:
3. • Lost turnover — the probable turnover that could have been generated during the selected period with stable sales. 

Calculated in two stages:

1. Lost turnover per day with losses = Lost sales qty * Product price on that day (if there was no receipt for the day, the last available price value is taken);
2. Lost turnover = Total value of lost turnover on days when there were losses.

• Lost turnover by out-of-stock — lost turnover that occurred on days when the product was out of stock;
• Average sales qty per day = Sales qty / Number of days on which there were product sales during the period;
• Lost sales qty — the probable number of sales that could have been made during the selected period with stable sales. 

Calculated in two stages:

1. Lost sales qty per day with losses = Average sales qty per day − Sales qty per day;
2. Lost sales qty = Total value of lost sales on days when there were losses.

• Lost days qty;
• Qty of losing days when stocks are null — total number of days when the product was out of stock and was not sold or had below-average sales;
• Faces qty — the number of product facings placed;
• Product stock, pcs/kg — total quantity of placed products on the planogram:

For packaged products:
Product stock on the shelf, pcs. = Facings qty * Placement depth * Placement height.

For weighting products:
Product stock on the shelf, kg. = Package weight, or "1" if no package weight is specified.

The table can be flexibly configured:

• Drag columns by name to change their order;
• Hold the bottom right corner of a column and move it left or right to change its width;
• Click the arrow next to a column name to sort products by that indicator.

The following tools are available for convenient data management:

• Search — find products by name, article or barcode;
• Customize columns — select the indicators to be displayed in the table;
• Save table template — save column settings so you don't have to reconfigure the table each time.

To download the report in .xls format, click "Download report" on the top toolbar.

Updated on: 28/07/2026