Shelf stock analysis
With the help of ‘Shelf stock analysis’, you can determine the percentage of shortage or surplus of products in the display and decide on the required number of products on the shelf.
The report is generated based on the average sales of the product for the selected period and the stock on the shelf. After applying the report, the products are colored in a certain color depending on the distribution group.
In order to change the boundaries of the distribution groups, you need to go to the report settings (the button on the right of the toolbar) and enter the desired
values into the appropriate fields using the slider. This will allow you to redefine which group each product belongs to depending on its value.
To change the color of a group, just click on the group color and choose from the palette or enter a hex code.
To select the period for which the report is generated, click on the Period field. By default, the last 30 days are used.
To select the interval for calculating the values of the Excess/Lack metric, click on the drop-down box. By default - is a day.
To download the report in Excel format, just click on the corresponding button in the upper right corner.
To configure the display of metrics (columns) in the report, click on 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
Faces qty
Quantity of product faces posted.
Product stock on the shelf, pcs./kg
The total quantity of products on the planogram.
For packaged products:
Product stock on the shelf, pcs. = Quantity of cases Depth of display Height of display.
For weighed products:
Product stock on the shelf, kg = Weight of the package or "1" if the weight of the package is not specified.
Product stock on the shelf, (day, week, month)
Displays how many days/weeks/months the displayed products will last.
Product stock on the shelf, (day, week, month) = Stock of products on the shelf, pcs/kg / Average number of product sales per (day, week, month)
Average number of product sales per (day, week, month)
Average number of product sales per (day, week, month) = Quantity of product sales / Quantity of (days, weeks, months) in the specified period.
Excess / Lack (%)
Excess / Lack (%) = (Stock on the shelf, units/kg - Average quantity of sales of the product for the selected interval * 100) / Average quantity of sales of the product for the selected interval.
Stock qty
Quantity of products available in the store at the end of the selected period.
Stock cost
Stock cost = Cost of products * Quantity of balances of this item.
The report is generated based on the average sales of the product for the selected period and the stock on the shelf. After applying the report, the products are colored in a certain color depending on the distribution group.
Customise the report
In order to change the boundaries of the distribution groups, you need to go to the report settings (the button on the right of the toolbar) and enter the desired
values into the appropriate fields using the slider. This will allow you to redefine which group each product belongs to depending on its value.
To change the color of a group, just click on the group color and choose from the palette or enter a hex code.
To select the period for which the report is generated, click on the Period field. By default, the last 30 days are used.
To select the interval for calculating the values of the Excess/Lack metric, click on the drop-down box. By default - is a day.
To download the report in Excel format, just click on the corresponding button in the upper right corner.
To configure the display of metrics (columns) in the report, click on 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
Faces qty
Quantity of product faces posted.
Product stock on the shelf, pcs./kg
The total quantity of products on the planogram.
For packaged products:
Product stock on the shelf, pcs. = Quantity of cases Depth of display Height of display.
For weighed products:
Product stock on the shelf, kg = Weight of the package or "1" if the weight of the package is not specified.
Product stock on the shelf, (day, week, month)
Displays how many days/weeks/months the displayed products will last.
Product stock on the shelf, (day, week, month) = Stock of products on the shelf, pcs/kg / Average number of product sales per (day, week, month)
Average number of product sales per (day, week, month)
Average number of product sales per (day, week, month) = Quantity of product sales / Quantity of (days, weeks, months) in the specified period.
Excess / Lack (%)
Excess / Lack (%) = (Stock on the shelf, units/kg - Average quantity of sales of the product for the selected interval * 100) / Average quantity of sales of the product for the selected interval.
Stock qty
Quantity of products available in the store at the end of the selected period.
Stock cost
Stock cost = Cost of products * Quantity of balances of this item.
Updated on: 16/01/2025
Thank you!