Shelf stock analysis

This analysis allows you to determine the percentage of shortage or surplus of products in the layout and make decisions about the required quantity of products on the shelf.

In this article we will review shelf stock analysis: how to configure it and what indicators are available.

Contents

How to configure shelf stock analysis
Indicators table

How to configure shelf stock analysis

To open shelf stock analysis, click "Analytics" → "Shelf stock analysis" 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. Select the interval for analysis: Day, Week, Month;
3. Configure the percentage ratio between surplus and large surplus, shortage and large shortage using the slider;
4. If needed, change the group color — click the color circle next to the required indicator and select a color;
5. Click "Apply" to save the changes.

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. • Average sales qty per day/week/month = Product sales qty / Number of (days, weeks, months) in the set period;
   • Facings qty;
   • 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.

• Product stock (day/week/month) = Product stock on the shelf, pcs/kg / Average product sales qty per (day, week, month);
• Excess / Lack (%) = (Product stock on the shelf, pcs/kg − Average product sales qty for the selected interval * 100) / Average product sales qty for the selected interval;
• Stock qty — quantity of products in the store at the end of the selected period;
• Stocks price = Product cost * Stock quantity of this product.

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