Database Item Reference

image

This section provides the complete reference to integrate materials, products and shelf tools in your PlanogramBuilder database.

The properties are listed in the same order they appear in the exported database columns.

Database Item Properties

image

Property Name (Column header)

Property Value (Column content)

Reference

A compulsory unique reference code for each item. You can use the EAN, UPC, SKU code or any other unique reference. (ex: 045631)

Note: valid characters are [0-9][A-Z][a-z][the space character]$&@=.,;-_!^~)(][}{

Invalid characters are replaced by an underscore [_].

Note: the number symbol [#] is not allowed in Database Editor field, but can be used with a special meaning when importing or exporting the database.

Note: For materials, a Reference value is automatically assigned but you can override the automatic value if you wish.

Classification property A *1 *2

(ex: Category)

(default value: empty)

For each item, the value corresponding to the selected property. (ex: Drinks)

Classification property B *1 *2

(ex: Brand)

(default value: empty)

For each item, the value corresponding to the selected property. (ex: Coca-Cola)

Classification property C *1 *2

(ex: Product line)

(default value: empty)

For each item, the value corresponding to the selected property. (ex: Zero)

Name *2

(default value: empty)

The name of the item as it will appear in the catalog. This is usually the actual product name as printed on the product packaging (ex: Coca-Cola Zero 500ml).

Note: For materials, if the value is empty, an initial Name is automatically assigned using the image file name without extension as basis. You can also assign your own Name if you prefer.

Width *3 *4

(default value for products and

shelf tools: 10cm/100mm/5in)

(default value for

materials: 100cm/1000mm/36in)

For products and shelf tools, the physical width of the item in the selected measurement unit (ex: 6).

For materials, this value represents the width of 1 image tile when Tile is ON.

Note: For products and shelf tools, a value of 0 keeps the original 3D model width. This is useful when you import your own 3D model and you don’t know the exact width to type.

Height *3 *4

(default value for products and

shelf tools: 10cm/100mm/5in)

(default value for

materials: 100cm/1000mm/36in)

For products and shelf tools, the physical height of the item in the selected measurement unit (ex: 20).

For materials, this value represents the height of 1 image tile when Tile is ON.

Note: For products and shelf tools, a value of 0 keeps the original 3D model height. This is useful when you import your own 3D model and you don’t know the exact height to type.

Depth *3 *4

(default value: 10cm/100mm/5in)

The physical depth of the item in the selected measurement unit (ex: 6)

Note: A value of 0 keeps the original 3D model depth. This is useful when you import your own 3D model and you don’t know the exact depth to type.

Image1

(default value: empty)

For each item, an image can be used to achieve a more realistic look.

This property is the filename + extension of the item picture. (ex: 045631.png)

Note: Pictures are not compulsory. If you don't have a picture, the product will appear as a solid color, white by default, with its name printed on the front if it uses the box shape. See Color below for details on this property.

Note: The maximum supported size for image files is 5 MB.

Note for batch importing: If you type in only the image filename without extension in your Excel file, the importer will try to automatically find your image with the supported extensions in the following order: png, jpg, jpeg, jpe, jfif, bmp, tif, tiff, gif, tga, ico.

Please see Guidelines for Images for instructions to prepare your images.

Image2, Image3, Image4, Image5, Image6

(default values: empty)

Some 3D Shapes are designed to support several images for a more realistic look.

Image2, Image3 and Image4 work the same way as Image1 described above.

See Standard 3D Shapes for the list of shapes supporting two or more images.

Shape

(default value: box)

The Shape property defines the 3D shape of each item. (ex: cylinder)

A set of shapes is provided by the software to cover standard package types. Please refer to Standard 3D Shapes for the description of available shapes.

You can also upload your own 3D models to create new custom shapes.

Behavior

(product default: standard)

(shelf tools default: panel)

The Behavior property is specific to PlanogramBuilder. It determines how and where an item will be positioned when dragging it to the bay.

Behaviors for products:

Please see Product Behaviors for the list of possible values.

Behaviors for shelf tools:

Please see Shelf Tool Behaviors for the list of allowed values.

Note: The Behavior value can be overridden per facing in any planogram: see Item Info.

Collisions

(default value: 1)

1 (checked in GUI): the item will collide with other items.

0 (unchecked in GUI): the item will be able to overlap other items in the planogram. It can be necessary to disable collisions for items that have overhanging parts or are slanted.

Note: Collisions have no effect if the general collisions parameter in settings is disabled. See Collisions.

Facings Deep

(default value: empty)

Only applicable to products. By default, the depth of the underlying shelf or the length of the peg determines how many times a product is repeated along the depth axis. You can however override this behavior by specifying a maximum fixed number of items for any product in the database. Example: a value of 3 will force a maximum of 3 items in depth when you drag a product on a shelf, even if the shelf has enough space to fit more items.

Note: Facings Deep can also be overridden per facing in any planogram: see Change Product Facing Count.

Width gap [...]

(default value: empty)

Only applicable to products. Sets the horizontal gap between products with multiple facings wide.

By default, products with multiple facings wide are placed with no gap between each others. You can however override this behavior by specifying in the database a predefined gap between items.

 

Note: For products pegged on pegboard type panels, the value entered corresponds to the minimal gap: the product will be placed on the nearest hook guaranteeing this minimal gap.

Note: The Width gap can also be overridden per facing in any planogram: see Item Info.

Height gap [...]

(default value: empty)

Only applicable to products. Sets the vertical gap between products with multiple facings high.

By default, products are stacked along the height axis with no gap between each others. You can however override this behavior by specifying in the database a predefined gap between items. Example: a value of 1 will force a gap of 1 measurement unit (cm or inch) between each repetition of this product in height.

Note: For products pegged on pegboard or slatwall type panels, the value entered corresponds to the minimal gap: the product will be placed on the nearest hook guaranteeing this minimal gap.

Tip: This parameter is also very convenient if you want to represent products nested into each others on a pile. In this case, enter a negative value corresponding to the amount of space the product should be nested inside the one below. Ex: enter -3 for a bowl which is nested 3 units inside the bowl below itself. Each bowl on the pile with this reference will also use this value.

Note: The Height gap can also be overridden per facing in any planogram: see Item Info.

Depth gap [...]

(default value: empty)

Only applicable to products. Sets the depth gap between products with multiple facings deep.

By default, products are stacked along the depth axis with no gap between each others. You can however override this behavior by specifying in the database a predefined gap between items. Example: a value of 1 will force a gap of 1 measurement unit (cm or inch) between each repetition of this product along the depth axis.

Tip: This parameter is convenient if you want to represent products nested into each others in depth. In this case, enter a negative value corresponding to the amount of space the product should be nested inside the one behind it. Ex: enter -1.2 for a plate which is nested 1.2 units inside the plate behind itself. Each plate behind the front one will use this value.

Note: The Depth gap can also be overridden per facing in any planogram: see Item Info.

Lateral offset […]

(default value: empty)

Lateral offset (pegged products only) lets you shift products to the left or to the right. This is convenient when the product hanging tab is not centered on the product.

·          Default empty value = 0cm or 0”

·          value of 0 = the product is centered on the peg hole

·          positive values = moves the product right

·          negative values = moves the product left

Note: The offset can be previewed in database Editor if Show Peg Hooks is ON.

Vertical offset […]

(default value: empty)

Vertical offset (pegged products only) lets you shift products higher or lower by a specified distance. This is convenient to define the position of the hanging hole on a product.

·          default empty value = a negative offset of 1cm or 0.39"

·          value of 0 = the product top edge is aligned to the peg hole on the back panel

·          positive values = moves the product up

·          negative values = moves the product down

 

Note: The offset can be previewed in database Editor if Show Peg Hooks is ON.

Color

(default value: empty.)

Empty values are treated as if a white color was applied)

The Color property lets you specify a solid color for each item in the database. The color has the following effect on items:

The specified color is applied to the areas mentioned in the description of the shape. See descriptions in Standard 3D Shapes.

If no image is specified for an item, the specified color is also applied instead of the image. The color is also applied in Schematic view in box & text mode.

The color value is specified in the database using the standard HTML color codes (ex: #FF0000 for red). A complete reference of theses HTML color codes is available at http://www.colorpicker.com/ or https://html-color-codes.info/ for example.

In Database Editor, the item color can also be picked from a color palette by clicking on the color swatch, or by activating and clicking the color picker tool over the item preview area.

Caption

(default value: empty)

Applicable to shelf tools with the Tag behavior only.

Enter the text you want to display on the selected Tag item.

Allowed values are:

·          A text string (ex: On Sale)

·          [br]: insert a line break

·          [rp]: insert this value so the tag automatically displays the retail price (tax incl.) of the product placed closest to the tag. The price value is taken from the spreadsheet imported in Price List. Products with missing prices are labeled N/A.

·          [number]: display the Number of the nearest product. The number helps indentifying the product position and is the same as shown in report listings when choosing the Number column.

·          [reference]: display the Reference of the nearest product.

·          [name]: display the Name of the nearest product.

·          [custom1]: display the Custom Property 1 of the nearest product. Replace [custom1] by the actual property name you defined in Item Custom Properties. Ex: [Weight]

·          [custom2], [custom3], [custom4], [custom5] and [custom6]: same as [custom1] above, to display other custom property values.

·          Any combination of the above values

An empty value results in no text shown on the tag

Example: On Sale ! [br] 20% OFF [br] [name]

Note: Make sure to actually type the square brackets when applicable.

Text height

(default value: empty

= auto-height)

Applicable to shelf tools with the Tag behavior only.

Enter a numeric value to set the selected Tag item caption height.

The measurement unit used is the same as selected in Settings.

Example: 0.3

Note: with an empty Text height or a value of 0, an automatic allocation of the text height is applied based on the item height.

Text color

(default value: empty = black)

Applicable to shelf tools with the Tag behavior only.

Enter the color of text captions for the selected Tag item in hexadecimal format (with or without the # prefix, not case-sensitive).

Example: #0000FF results in blue text captions.

Note: with an empty value, text is black.

Custom property 1 *1 *2

(ex: Weight)

(default value: empty)

For each item, the value corresponding to the selected property. (ex: 5kg)

Custom properties 2, 3, 4, 5, 6 *1 *2

(default value: empty)

Same as Custom property 1. For each item, the value corresponding to the selected custom property.

Enabled

(default value: 1)

1 (checked in GUI): the item is available in the product or shelf tool catalog.

0 (unchecked in GUI): the item exists in the database, but is not available in the product or shelf tool catalog.

This is useful to prevent other users in your company from using some items in planograms, such as for products that are no longer sold but you may want to reactivate later.

Tile

 (default value: 1)

Only applicable to materials. This parameter determines how the material image is applied onto elements:

1 (checked in GUI): the material image is tiled (repeated) on the element when applied.

0 (unchecked in GUI): the image is stretched to cover the room element when applied.

Type

(default value: 0)

The Type of item:

0 = Product

1 = Shelf Tool

2 = Material

This property can be used to Batch Import Database Items. In Database Editor, it corresponds to the radio button to toggle Products / Shelf Tools / Materials.

Shelf Tool

(default value: 0)

Deprecated: now replaced by the Type property, but still supported for backwards compatibility.

The Shelf Tool property indicates:

0 = Product

1 = Shelf Tool

This property can be used to Batch Import Database Items. In Database Editor, it corresponds to the radio button to toggle Products / Shelf Tools.

 

Important Note: If you have set the language of the user interface to a language other than English, the above properties have different names. Ex: the Width property is named Largeur in French.

Note *1: Please see Database Setup for details on these properties.

Note *2: Denotes a property where you can use Unicode characters for non-Latin text values.

Note *3: Please see Measurement unit for information on how to select your preferred measurement unit.

Note *4: The direction of Width, Height and Depth is determined by the orientation of the object on the shelf, as shown in the image: Width is the left-right dimension, Height is the top-bottom dimension, and Depth is the front-back dimension. So Width is not necessarily the biggest dimension, or Depth the smallest dimension.

 image

 

 

Guidelines for Images

image

For each product and shelf Tool, one or more images can be used to achieve a more realistic representation. You can use existing images or take photos of your product.

Please follow the instructions below to prepare your images:

Choosing the right product view(s)

·         For Image1 (shapes with 1 image), take a picture of the product most representative face (usually the front face).

For Image2, Image3, Image4, Image5 and Image6 (shapes with multiple images), take a picture of the product other faces according to the chosen shape as documented in Standard 3D Shapes.

Taking the pictures

·         Don't use a flash as it creates bright hotspots on the photo.

·         Take the picture straight on, not from an angle.

Using a transparent background

·         PlanogramBuilder supports transparent backgrounds in images: the transparent area will be invisible when you place your product or shelf tool on shelf.

Note: the following image formats support transparency in PlanogramBuilder:

·          png and tif 32 bits with 256 levels of gray for variable transparency (alpha channel).

·          png and gif 8 bits with 1 transparent color.

Note: transparency in PlanogramBuilder only works in combination with specifically designed shapes as listed in Standard 3D Shapes.

Cropping your images

·         Auto-crop: if your images have a transparent background as explained above, PlanogramBuilder performs an automatic crop to remove the unwanted area surrounding the product. Please note that the auto-crop feature works with any 3D shape, even with shapes that don't support transparency.

·         Manual crop: images that don't have a transparent background should be cropped manually to the outer limits of your product (i.e. the image must be cropped so that the outline of the product touches the 4 edges of the image as much as possible). Please see the image examples below.

Image formats and resolution

·         Save the picture in a supported format: jpg, png, bmp, gif or tif. (use only gif, tif or png for transparency support)

·         Each picture file must be smaller than 5 MB for PlanogramBuilder. Otherwise it won’t be uploaded.

·         Images are automatically downsized by PlanogramBuilder if larger than 786'432 pixels (=1024x768 or 500x1573 for example). Uploading images larger than this will not provide better quality.

·         Make sure the image size is just large enough to distinguish the desired detail. Typically you want to be able to read the text on the product or packaging.

Batch importing products with images

·         If you intend to use the Batch Import feature, make sure you save your images in the same folder as your products *.txt list file, or in one of its child folders.

·         If you type in only the image filename without extension in your Excel file, the importer will try to automatically find your image with the supported extensions in the following order: png, jpg, jpeg, jpe, jfif, bmp, tif, tiff, gif, tga, ico.

·         Please see Batch Import Database Items for detailed instructions.

 

Please look at the examples of good and bad pictures below. The dotted lines represent the edges of each image:

image   image   image   image   image

 


Product Behaviors

image

Four types of products can be created with PlanogramBuilder, each of them corresponding to a specific value for the database Behavior field. Here are the possible values, descriptions and images showing example products for each Behavior value:


 Behavior value

 Description

Example

standard

(default value)

A standard product.

It sits on shelves and fills the shelf depth with facings by default. (ex:  a bottle of soda)

image

stackable

Stackable products are the same as standard products except they can be stacked onto different products which also have the stackable behavior.

Use this behavior for all products which must often be stacked on or below different products. Note: a stacked product is centered laterally on the product below, so it is best suited for stacking different products of the same width.

Do not use this behavior if you want to create vertical piles of the same product. In this case see instead Change Product Facing Count. Exception: if you have created project with products stacked as separate items, keep the stacked behavior for your products (typically projects saved before October 2019).

image

tester

A tester product.

It sits on shelves, but only one product is placed at the front edge of the shelf. You can place standard products behind it. (ex: a perfume tester, which will be placed in front the packaged perfumes)

image

pegged

A pegged product.

It hangs on pegs and is repeated along the length of the peg. (see Creating New Bays and Back Panel for help on defining peg length.) (ex: blister packs)

image

Note: Even if you choose a language other than English for the user interface, the names of the behaviors remain as listed above.

Shelf Tool Behaviors

image

Several types of shelf tools can be created with PlanogramBuilder, each corresponding to a specific value for the database Behavior field. Here are the possible values, descriptions and example images showing sample shelf tools for each Behavior value (listed alphabetically):


 Behavior value

 Description

Example

bay header

A shelf tool which snaps to the top of any back panel.

Note: if the bay has no back panel, you cannot place a bay header. In this case we suggest creating a small back panel as a crossbar to support your desired bay header.

Use this to place header panels above your back panels.

image

divider

A shelf tool which automatically snaps to the front edge of a shelf.

Use this to create lateral bay divider signs for example.

Tip: the box_sides shape is well suited to this type of objects.

image

ondisplay

An object which can be placed on any shelf without being duplicated in depth.

Please note that this is typically applied to custom products displayed out-of-box (on-display).

image

panel

(default value)

A shelf tool which snaps onto the back of any bay.

Note: if the bay has no back panel, the header can be positioned between the lowest and highest shelves.

Use this to create posters, back cards or any other hanging POS.

image

presenter

A shelf tool which is placed on the shelf and onto which you can place an ondisplay shelf tool.

Use this to create stands to present out-of-box products.

Note: An ondisplay placed on a presenter always sits at the same height as the shelf. So this shelf tool is only suitable for stands which have a very thin platform for placing an out-of-box.

image

Shelf badge

A shelf tool which snaps to the front edge of any shelf at 3 possible predefined positions: left, center, right.

Use this to create shelf cards / shelf badges.

image

Shelf strip

A shelf tool which snaps onto the front edge of any shelf. It is horizontally centered and aligned to the top of the shelf.

Use this to create single shelf strips.

image

sticker

A shelf tool which snaps to the front of a shelf or shelf strip at any lateral position.

Use this to create cards, typically used to show information or specials.

image

tag

A box which can be placed on the front edge of a shelf to display as a label for the actual product name, pricing or other  text (no image).

Tags have dedicated parameters:

Caption

Text height

Text color

See details for each above parameter in the Database Item Properties.

image

shape defined

This is a special behavior to use only if you have been instructed to.

 

Note: Even if you choose a language other than English for the user interface, the names of the behaviors remain as listed above.

 

Standard 3D Shapes

image

Video tutorial on this topic: 6: Adding products of various shapes to the database

 

PlanogramBuilder comes with the following set of basic shapes to cover standard package types. You can specify any of the shapes below in the Shape field for each item.

Shapes with 1 image

(See Image property in the Database Item Properties)

The list below is sorted alphabetically except the default box shape:

Shape name

Shape illustration

Result with product image

Description

box

(default value)

image

image

A box with 1 image fitted to all 6 sides.

Note: If you don’t specify a shape, the box shape is used by default.

Box_rounded

image

image

A box with rounded edges and 1 image fitted to all 6 sides.

bottle_soda_large

image

image

A large soda bottle (ex: 2 liters) with 1 image fitted to front and back.

bottle_soda_small

image

image

A small soda bottle (ex: 0.5 l) with 1 image fitted to front and back.

bottle_square

image

image

A bottle with 4 flat sides with 1 image fitted to front and back.

bottle_tapered

image

image

A bottle with tapered top with 1 image fitted to front and back.

bottle_wine

image

image

A typical wine bottle with 1 image fitted to front and back.

box_front

image

image

A box with 1 image fitted to the front face only. The other faces will use the specified Color*.

Use this when you don’t want the sides to show the front image, such as for shelf strips or headers.

box_sides

image

image

A box with 1 image fitted to the left and right faces only. The other faces will use the specified Color*.

Use this when you want only the side faces to show the image, such as for dividers (shelf tools).

box_top

image

image

A box with 1 image fitted to the top face only. The other faces will use the specified Color*.

Use this when you want only the top face to show the image.

can_drink

image

image

A typical cylindrical drink can with a metal lid and 1 image fitted to front and back.

can_drink_slim

image

image

A typical cylindrical drink can with a metal lid and 1 image fitted to front and back.

can_food_cylindrical

image

image

A typical cylindrical food can with a metal lid and 1 image fitted to front and back.

chocolate_bar

image

image

A typical chocolate bar shape with 1 image fitted to front and back.

cylinder

image

image

A cylinder with 1 image fitted to front, back, top and bottom.

cylinder_front_back

image

image

A cylinder with 1 image fitted to front and back only. The top and bottom will use the specified Color*.

Tip: This can be used for containers when you don’t want the front image applied to the lid for example.

cylinder_top

image

image

A cylinder with 1 image fitted to top and bottom. The other faces will use the specified Color*.

Tip: This can be used for plates or containers when the top picture is more representative.

plane_lying

image

image

A horizontal plane with 1 image fitted to top and bottom.

It has no visible thickness but the specified height is still accounted for to stack items in planograms.

You can use this for items not resembling any of the other provided 3D shapes.

plane_standing

image

image

A vertical plane with 1 image fitted to front and back.

It has no visible thickness but the specified depth is still accounted for to space items in planograms.

You can also use this for items not resembling any of the other provided 3D shapes.

pouch_lying

image

image

A soft pouch placed horizontally with 1 image fitted to top and bottom.

pouch_standing

image

image

A soft pouch placed vertically with 1 image fitted to front, back and bottom.

sphere

image

image

A sphere / ovoid shape with 1 image fitted to front and back.

tube

image

image

A tube with 1 image fitted to front and back.

Use for toothpaste, cream and similar items.


Shapes with 1 image and transparency

(See Image1 property in Guidelines for Images)

Tip: All shapes supporting transparency are prefixed with the term "alpha".

The list below is sorted alphabetically:

Shape name

Shape illustration

Result with product image

Description

alpha_cloth_lying

image

image

A shape well suited for clothing laying flat, with the image fitted to top and bottom.

alpha_cloth_standing_front

image

image

A shape well suited for clothing hanging facing front with the image fitted to front and back.

alpha_cloth_standing_sideways

image

image

A shape well suited for clothing hanging facing sideways with the image fitted to left and right side.

alpha_plane_lying

image

image

A horizontal plane with the image fitted to top and bottom.

It has no visible thickness but the specified height is still accounted for to stack items in planograms.

You can use this for items laying flat and not resembling any of the other provided 3D shapes.

alpha_plane_standing

image

image

A vertical plane with the image fitted to front and back.

It has no visible thickness but the specified depth is still accounted for to space items in planograms.

You can also use this for items facing front and not resembling any of the other provided 3D shapes.

Shapes with 2 images

(See Image1 and Image2 properties in the Database Item Properties)

The list below is sorted alphabetically:

Shape name

Result with product images

Description

bag_lying - 2 pics - 1 front - 2 top bottom

image

A bag with 2 images:

Image1 fitted to front face

Image2 fitted to top & bottom faces.

box 2pics - 1 front - 2 other faces

image

A box with 2 images:

Image1 fitted to front face

Image2 fitted to all other faces.

box 2pics - 1 left - 2 other faces

image

A box with 2 images:

Image1 fitted to left face

Image2 fitted to all other faces.

box 2pics - 1 right - 2 other faces

image

A box with 2 images:

Image1 fitted to right face

Image2 fitted to all other faces.

box 2pics - 1 top - 2 other faces

image

A box with 2 images:

Image1 fitted to top face

Image2 fitted to all other faces.

cylinder - 2 pics - 1 front back - 2 top

image

A cylinder with 2 images:

Image1 fitted to front & back faces

Image2 fitted to top face.

cylinder_lying - 2 pics - 1 front - 2 top bottom

image

A cylinder with 2 images:

Image1 fitted to front face

Image2 fitted to top & bottom  faces.

 

Shapes with 2 images and transparency

(See Image1 and Image2 properties in the Database Item Properties)

Tip: All shapes supporting transparency are prefixed with the term "alpha".

Shape name

Result with product images

Description

alpha_plane_standing_sideways - 2 pics - 1 left - 2 right

image

2 vertical planes with 2 images:

Image1 fitted to left face

Image2 fitted to right face.

It has no edges along its thickness but the specified width is still accounted for in planograms.

You can use this for dividers or side panels which don’t have a rectangular shape.

 

Shapes with 4 images

(See Image1, Image2, Image3 and Image4 properties in the Database Item Properties)

The list below is sorted alphabetically:

Shape name

Result with product images

Description

box 4pics - 1 front - 2 left - 3 right - 4 top

image

A box with 4 images:

Image1 fitted to front face

Image2 fitted to left face

Image3 fitted to right face

Image4 fitted to top face.

Shapes with 6 images

(See Image1, Image2, Image3, Image4, Image5 and Image6 properties in the Database Item Properties)

The list below is sorted alphabetically:

Shape name

Result with product images

Description

box 6pics - 1 front - 2 left - 3 right - 4 top - 5 back - 6 bottom

image

A box with 4 images:

Image1 fitted to front face

Image2 fitted to left face

Image3 fitted to right face

Image4 fitted to top face

Image5 fitted to back face

Image6 fitted to bottom face.

 

Notes for all 3D shapes

Note: Each of the above shapes is resized in width, depth and height to match exactly your item overall dimensions.

Note: In Database Editor, only the available Image[n] fields are enabled depending on the assigned shape. For example, assigning the box shape only enables the Image1 field.

Note: If you have specified image(s), it (they) will be resized to fit onto the selected shape.

Note: For shapes with area(s) using Color, the color is white by default but can be specified for per database item. See the Database Item Properties for details on the Color property. If you don’t apply image(s), the image(s) areas will be colored with the specified Color value.

Note: If you leave the Shape field blank, PlanogramBuilder will create your item using the shape "box".

Note: If you can’t read the entire assigned shape name in the collapsed drop-down list, you can display it in a tooltip by hovering your mouse pointer over the Shape label.

Note: If you need a different 3D shape not listed above, you can either use your own 3D models (see Custom 3D Shapes) or contact zVisuel to order a new 3D shape. We will give you a quote for creating the shape based on your description.

Note: Even if you choose a language other than English for the user interface, the names of the 3D shapes remain as listed above.

Custom 3D Shapes

image

If you need additional 3D shapes not listed in Standard 3D Shapes, you can add new shapes by importing your own 3D models.

The supported 3D model file format is *.3DS (Autodesk 3D Studio original DOS format).

In PlanogramBuilder, 3D shapes are basically 3D models with only their geometric mesh. The idea is to be able to re-use a 3D shape to generate several products or shelf tools by just changing the image(s) applied as texture and the dimensions of the item. PlanogramBuilder allows specifying directly in Database Editor the image(s) that will be applied to each product or shelf tool in the dedicated properties named Image1, Image2, Image3 and Image4 (see Database Item Properties and Guidelines for Images).

Note: The guide below explains how to prepare your 3D models with Autodesk 3ds Max, however these guidelines should also apply to any 3D modeling software, as long as it can save *.3DS files: 

Create a 3D Model

Material names convention: your 3D models must have specific materials assigned; each material must be named using the following naming scheme:

·         Image1: if you name a material Image1 in your 3D model, any part of the 3D model with this material will be interpreted by PlanogramBuilder so that when the user specifies a file for the Image1 property in the database, the image will be applied (mapped) onto this area of the model. Image2, Image3, Image4 material names can also be defined in your 3D model using the same principle, each corresponding to its respective database imageN property.

Note: Image1, Image2, Image3 and Image4 materials can only use maps in the diffuse slot. In PlanogramBuilder, these images can represent the diffuse color and optionally the alpha transparency.

Note: if you 3D model is designed to use images with alpha transparency, you must name the exported *.3DS file with the prefix “alpha_”. Ex: “alpha_mySHape.3ds”. When you use such shapes in the PlanogramBuilder database, you must also make sure to apply images with 32bit depth as explained in Guidelines for Images.

Note: other map types such as bump or reflections are not supported by PlanogramBuilder for the imageN materials.

Note: UVW Mapping for the diffuse maps in the 3D model must be applied to your geometry to match the result you want to achieve. You can apply tiling values in the UVW Mapping modifier. However do not apply tiling or offset in the material map setting as this is not supported by the 3DS format.

·         color: a material with the name color can be used to represent a solid color. In PlanogramBuilder, the actual color can be specified by the user in the color property.

Note: No image map is taken into account by PlanogramBuilder for the color material.

·         plano_keep…: your 3D models can also contain materials which will be imported as is by PlanogramBuilder, materials that the user will not be able to change in Database Editor. To define such materials, you must name the materials in 3ds Max with the prefix plano_keep (example of such material name: plano_keep glass).

Note: The only image map allowed in a plano_keep… material is a special environmental reflection map image named refmap.png (click to download). You can use this special map within any plano_keep…  material if you wish to achieve reflective surfaces such as glass. You don’t need to upload the refmap.png image since it is already available on our servers.

Material types: use only 3ds Max Standard or Multi/Sub-object materials with Blinn or Phong shading. Architectural materials or procedural shaders are not supported.

Material opacity: opacity / transparency values are supported for all materials. PlanogramBuilder uses additive transparency so make sure to set your material to use this system to preview your material accurately before exporting the 3DS file.

Measurement unit: the system units in 3ds Max should be in cm, as is used by PlanogramBuilder. If your model is in another measurement unit, convert it to cm.

Orientation: make sure your model is oriented in such a way that its top is facing upwards and it front is facing front, as you would like it to appear in a planogram.

Geometry:

·         Keep to a reasonable number of polygons as the 3D files will be used for real-time rendering. You can apply an Optimize or MultiRes modifier on the models to reduce the number of polygons.

·         Make sure to have clean models with welded vertices and no duplicated faces. In 3ds Max, the STL check modifier check can be used to check model integrity.

Animation:

·         PlanogramBuilder doesn’t support animation so you must remove all animation keys before exporting the 3DS file.

Save a 3D Model

1.      In 3ds Max, select only the items to export:

2.      In the File Menu, click Export Selected.

3.      In the Select File to Export dialog, select the type 3D Studio (*.3DS).

4.      Type a name for the 3DS file. You can use long names up to 50 characters for the 3DS model. The file name will become the name of the item in PlanogramBuilder, so make sure to think about the desired correct name, especially since each shape must have a unique name.

Warning: do not save a 3D model named exactly as an existing standard PlanogramBuilder shape such as “box”, because this would overwrite the existing box shape in PlanogramBuilder.

5.      Check Preserve Max’s Texture Coordinates in the options dialog.

To check if the 3DS file exported correctly, you can re-import the 3DS file in an empty 3ds Max document. All materials and geometries should still look as defined.

Tip: You can download our sample 3D model steak-fries & drink.3ds and the accompanying images which illustrates the above instructions. Just unzip it to your computer to access all the files provided. We also use this sample model in the next section to explain how to import it into PlanogramBuilder.

Import a 3D Model

To import a new shape, you can either assign it to a new item or to an existing item. Please see Add Database Item or Modify Database Item for details on these tasks.

In the instructions below, we create a new item using our sample 3D model steak-fries & drink.3ds for the shape to import.

1.      In the Database, create a new item or select the existing item to display it in the Item Details view.

2.      In the Item Details view, next to Shape, click on Browse.

image

3.      Select the *.3DS file on your computer and click Open.

image

4.      After the 3DS file has been uploaded, it appears in the PlanogramBuilder list of shapes.

5.      You can specify the Width, Depth and Height of the item as usual, but you can also enter 0 for any dimension if you just wish the item to use the actual respective dimension of the 3D model you imported.

6.      You can now also assign images (Image1, Image2, etc. as planned in your 3D model) and a Color value to your item. In our example, Image1 is for the steak, Image2 for the fries and Image3 for the liquid in the glass.

7.      Once you are happy with all values, click on Create or Update at the bottom of the Item Details view.

8.      Below is an example of the product created with our sample 3D model:

image 

Note: If you want to make changes to a shape after importing it, just import it again into PlanogramBuilder after making the desired changes in your 3D modeling software. The shape will be overwritten with the updated one.

Note: After uploading a shape, you can reuse it for any number of items in the database. You don’t have to import the 3D model again as it is already in the list of available shapes.

9.      Now try to create another item using the same shape, but:

image




PlanogramBuilder User Guide - © Copyright zVisuel, 2001-2020