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 accessories 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:

Click on Settings.

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:	Category	Category	Category	Country
Classification property B:	Brand	Subcategory	Group	Category
Classification property C:	Product Line	Region	Year	Subcategory

Your choices will be reflected in Database Editor header labels, as well as in Product Catalog, Accessory 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 accessory (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:

Click on Settings.

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

The Weight custom property is now defined and Weight values can be assigned to your products and accessories. 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 accessories.

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