Database Setup

image

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

image

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.

image

To customize these properties, do the following:

  1. Click on Settings.

image

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

image

 

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:

Category

 

Category

 

Category

 

Country

Classification property B:

Brand

 

Subcategory

 

Group

 

Category

Classification property C:

Product Line

 

Region

 

Year

 

Subcategory

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

Item Custom Properties

image

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.

image

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

image

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

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