Database Setup


Note: Only available to a PlanogramBuilder Administrator

Video tutorial on this topic: 4: Introduction to the database


In this section, you will learn how to customize your database structure to match your product classification structure.

Important Note: Please perform this step prior to start filling your database with products, because your customization will have an impact on all future Database Editor Tools.

Item Classification Properties


PlanogramBuilder provides 3 properties (A:, B: and C:) to classify your products and shelf tools as you do in your business (not applicable to materials). By default, these properties are respectively labeled Category, Brand and Product Line. You can change these labels to match your own classification criteria.


To customize these properties, do the following:

1.      Click on Settings.


2.      Under Settings affecting all users, Item Classification Properties, select a label from the drop-down list for each property (A:, B: and C:).


The above image reflect example 3 on table below

Standard labels: Brand, Brandline, Category, Group, Main Group, Manufacturer, Product Line, Region, Sub-brand, Subcategory, Subgroup.

Custom labels: If the standard labels don’t fit your needs, you can also select Custom in the drop-down list. In this case a new text field will appear where you can type a custom label, such as shown below with the labels Year and Country.

For example, you may choose one of the following combinations of classification criteria:


Default label


Example 1


Example 2


Example 3

Classification property A:








Classification property B:








Classification property C:

Product Line







3.      Your choices will be reflected in Database Editor header labels, as well as in Product Catalog, Shelf Tool Catalog and reports.

Item Custom Properties


PlanogramBuilder also provides up to 6 additional user-defined properties for items to let you optionally add attributes for each product or shelf tool (not applicable to materials). To activate a custom property, you must enter its label. Once labeled, the property becomes available in your database and you can then assign any text value for each item in your database. You can then output the values of these properties in your published reports for example.

As an example, let’s create a property to hold the weight of your products in your database:

1.      Click on Settings


2.      Under Settings affecting all users, Item Custom Properties, type in the label of Custom property 1: Weight, then press enter to validate.


3.      The Weight custom property is now defined and Weight values can be assigned to your products and shelf tools. The custom property is also reflected within several PlanogramBuilder features:

·         Database Editor detailed view

·         Report columns

·         Import projects

·         Schematic view labels

·         Products / Shelf Tools catalog captions and search

Note: Custom properties which you have not labeled are not available for your products and shelf tools.

Note: Unicode characters can be used for the labels of Item Custom Properties.

PlanogramBuilder User Guide - © Copyright zVisuel, 2001-2022