Planogram Products Web Settings
The Planogram Products table can be easily adapted to your requirements. You can add different columns to the table or remove some, set the size of the columns or their name. In addition, you can set different designs for different user groups.
You can find the Planogram Products web settings in the Web Settings section under Planogram Products Web Settings.
Click the New button to add a new configuration, which you can then edit in the property pane on the right.
The newly added configuration is set to what the web settings currently look like. That is, if you have a specific request such as I want to add column Stock Level to a table on the web, you just need to add the property in the Table property and save. You will find more detailed steps here.
The Planogram Products Web settings affect this table:
Properties Setting
For each configuration, you can set additional properties on the right after adding a new configuration.
- Parent Container - This is the configuration from which the values will be taken. Use this if you have multiple configurations set up and you only want to make minor changes to the new configuration compared to another, so you set the original configuration as the parent.
- Name and Display Name - Fill in the name of the configuration. The Display Name appears in the web selection if you have multiple configurations available.
- Container Title - Title of the table.
- Show Container Title - If the box is checked, the title will be displayed.
- Desktop Rights - Determines who will see this configuration in Quant, or who will be able to edit it.
- Web Access - Here you set the user groups who should have this configuration available on the web.
One user can have multiple configurations available at the same time. For example, you can set different table layouts for Category Manager and Store Manager. The Store Manager will only have access to its configuration, but the Category Manager can have access to both and can switch between them on the web. This way, you don't have to create multiple users with different user roles when setting up and testing and there is no need to constantly log in under a different user to check the table appearance for different users.
- Show Replacement Products - The table will show the replacements for the products. The replacement is listed in a new row under the product for which the replacement is set.
- Show Placeholder Products - Each placeholder (empty block) is displayed as a separate row in the table.
- Show Removed Products - The removed products are displayed at the tables for Waiting or Prepared planograms, where the planogram is compared with the Implemented planogram. These are products that are not in the displayed Waiting (Prepared) planogram, but were placed in the original Implemented planogram.
- Show Removed Products in Shelves - If the box is checked, the removed products are always listed within the shelf in the order in which the product was originally placed. If the box is unchecked, all removed products will be displayed at the end of the table in the Removed Products section.
- Show Backstock Products - Products that are marked with the Backstock flag in the planogram template will also appear in the table.
- Show Backstock Products in Shelves - If the box is checked, the Backstock products are always listed within the shelf in the order in which the product is placed in the planogram template. If the box is not checked, then all Backstock products are displayed at the end of the table in the Backstock Products section.
- XLSX Export - Specifies whether the table can be exported to Excel. If the Enabled checkbox is checked, then an XLSX button will appear on the website, through which you can export the entire table to Excel. You can also set whether you want to export the table header as well, what the file should be called, and whether to include a timestamp in the name.
- CSV Export - Specifies whether the table can be exported to CSV. If the Enabled checkbox is checked, then a CSV button will appear on the website, through which you can export the entire table to CSV. You can also set whether you want to export the table header as well, what the file should be called, and whether to include a timestamp in the name. You can also specify what the field and record separator should be in the CSV.
Content and Design Setting
The content and design of the table is set in the property: Table.
You can for example select which properties you want to display as columns in this table, in what order, how wide the columns should be, or how the text should be aligned in the table.
The following section explains some of the settings that can be used here.
- Table Display Type - specifies how the attribute should be displayed in the table. The classic view is the Column view, where the attribute is added as a column to the table. In some cases, the Group view may be useful, where the table will be grouped by that attribute.
- Name - here you can set a different name for the attribute, which will be displayed in the appropriate place on the web.
- Category - here you can edit the name of the category to which the property belongs.
- Display Category - the category name for the property will be displayed and the entire section will be divided into subsections by category.
- Tooltip - you can enter an explanation for the attribute that appears when you hover over the attribute name.
- Units - you can specify a unit (e.g. pcs), which is displayed next to the attribute in square brackets.
- Label Align - attribute name alignment.
- Value Align - attribute value alignment.
- Thousands Separator - for numeric values, specify here what character should be used to separate thousands (e.g. space - 1 000 000).
- Decimal Separator - for numeric values, you can set the character used to separate decimal places (e.g. comma 1,5).
- Rounding Mode - determine how the numbers should be rounded.
- Min Fraction Digits - the minimum number of decimal places that must appear in a number if it is not an integer (e.g. 12.50 = 2 decimal places minimum).
- Max Fraction Digits - the maximum number of decimal places a number can have if it is not an integer.
- Clear Decimals of Zero Values - decimal places with zero values will not be shown (e.g. 12.00 will be shown as 12).
- Links (section name) - in this section you can set the value in the cell to be displayed as a link and redirect the user somewhere when clicked.
- Barcode (section name) - here you can set the attribute to be displayed in the table as a barcode.
- XLSX Export (section name) - you can choose which attributes from the table you want to export to Excel. Here you can specify whether to export the column and you can change the header name if you don't want it to match the header name on the web.
- CSV Export (section name) - you can choose which attributes from the table you want to export to CSV. Here you can specify whether to export the column and you can change the header name if you don't want it to match the header name on the web.
- Table (section name) - in this section you can change the size of a given column on the web.
Attributes setting - on web
For the Info column, you can set which icons can be displayed in which style. If you select the Info property in the middle, then click in the Info Settings property and you can add or remove the information you want to display in this column. Next, if you select a specific info attribute, then in the Style row you can then select whether you want to display only the icon or both the icon and text or only the text.
If you have a large table width, we recommend adding the Freeze Left property. Properties that come before Freeze Left in the sequence will automatically scroll when you scroll to the right in the table. This allows you to always see the product ID, for example, which is usually in the beginning of the table. This can be useful for tables with a large number of columns and on smaller screens.