Add Database Item

image

Note: Only available to a PlanogramBuilder Administrator

Video tutorial on this topic: 5: Adding your first product to the database

Video tutorial on this topic: 7: Adding shelf tools to the database

 

In this section we explain how to add products and shelf tools to the PlanogramBuilder database so you can then create planograms with your own items.

Tip: The process described in this section is for adding one item at a time. You can also use Batch Import Database Items to add several items quickly.

Tip: We advise backing up and then Clear Database to save and remove the sample items provided with the application before adding your own items.

Instructions:

1.      Select the type of items to add: Products or Shelf Tools.

2.      Click on the New Item button.

image

3.      In the Item Details on the right of your screen, fill-in the Database Item Properties to define your new item. Please consult the Database Item Reference for the detailed description of each property.

 

image

New Item Details for product

 

3.      Create / Cancel: Once you have entered all the desired values, press the Create button to validate the creation of your new item. (You can also press the Enter key on your keyboard.) Your new item will be created and becomes selected in the Item List. Otherwise, if you have changed your mind and don't want to create the new item, you can press the Cancel button (or the Escape key).

 

Note: Properties in Item Details are divided into 2 groups:

DB values that can be modified in planograms: the values for these properties can be predefined in the database, but you can additionally set or override these values per item in any planogram project. For example, you can change a product that was defined as Pegged in the DB to Stackable only in a particular planogram for a special case.Tip: If you have activated one or more filter(s), the values used by the filter(s) will be automatically pre-filled in the corresponding text field. (See Item Filters.) You can however overwrite the pre-filled values by typing any other text.

 

Note: For the fields A, B and C (the default headers are Category, Brand and Product Line), please see Item Classification Properties before entering any value. If you leave a value empty in these fields, your items will not be classified in the Catalog. For example, if you don’t enter a Brand value for your new product, the product will be displayed in the catalog when you click on any Brand. Example: To make a shelf strip available in the Catalog for all Product Lines within a Brand, enter a value for its Brand, but leave its Product Line value empty.

Note: For the fields 1, 2 and 3, please see Item Custom Properties before entering any value.

Note: With Image, you can apply an image onto your item. Click on the Browse... button, browse for your image file, and then click the Open button. See Guidelines for Images for preparing images.

Note: See Database Item Properties for details on what the Color is. Color can be entered in three different ways:

a.     Click on the colored rectangle to display the color palette and select the desired color.

b.     Click on the color picker icon to pick any color from the 3D item preview area. While pressing your mouse button over any area with the color picker, the colored rectangle swatch is updated with the selected color. Release your mouse button to apply the color. Note: the color picker mode remains active until you click on another tool such as Orbit.

c.      Type the color value using standard HTML color codes (ex: #FF0000 for red).

Note: We do not provide a database of products with PlanogramBuilder. Typically each client provides or enters directly the information about their products: name, EAN, dimensions, etc. and the image(s) for each product. If you don't have such data available, you may be able to obtain them from the product manufacturer or from third-party product databases, such as the ones listed below:

·         https://product.okfn.org/

·         https://www.ean-search.org/

·         https://www.upcdatabase.com/

·         https://www.gs1.org/services/gdsn

·         https://www.mynetfair.com/

·         https://www.itemmaster.com/

·         https://www.grocery.com/open-grocery-database-project

·         https://openfoodfacts.org/

·         https://www.gladson.com/




PlanogramBuilder Light User Guide - © Copyright zVisuel, 2001-2020