Database Editor


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

Database Editor provides you with the tools to view, add, edit and delete materials, products and accessories in your database.

To launch the Database Editor, click on the Database tab.


View Database Items

Note: If you have read-only access to the database (as a Standard User), the following database commands are hidden: Import, Clear and New Item. Also, the item details are read-only.

Type of items to manage


Radio buttons let you choose if you want to work on Materials, Products or Accessories:


Click on the radio button of your choice to select the type of item you want to display. For example, when Products is selected, you won’t see Materials or Accessories. You can switch from one type to another at any time.

Item List


The left side of the screen shows a list of all your items in a table similar to a spreadsheet. Each line contains one item and each column corresponds to the following properties: Reference, Name and classification columns (A:, B: and C:), which are detailed in Database Item Reference.

This is where you can view and select items in the database.

To select an item, click on its line in the list.

Use the Up/Down arrow keys to switch to the previous/next item.

A maximum of 50 items is shown on each page. If there are more than 50 items, they are displayed on additional pages. To select another page to display, use the page navigation tools in the lower left corner of the panel:


Note: If your screen is small, scroll down to see more items.

Note: Materials don’t have classification properties.

Tip: By clicking on the headers at the top of each column, you can sort the list according to the column content. For example to order the list by product names click on the Name header and to order it by references click on Reference. Clicking again on a header reverses the order.

Item Filters


By default, the Database Editor shows the complete Item List in its listing. If you have many items in your database, you can use one or several filters to display only items matching the chosen filter(s).

Filters are available for the Reference, Name and classification columns (A:, B: and C:).

After you select or type values for filtering, the other drop-down lists only display items matching that filter combination, so you can narrow down quickly on available items.

Selecting the * symbol means all available items will be displayed in the list.


For the Reference and Name filters, you can type any text string: only items with values matching your string will be displayed. The filter boxes accept single or multiple keywords following these rules:

Example: typing frozen CHOCOLATE in the box above Name will display all the items containing chocolate AND frozen in their name.

Note: Items with values of different text cases are grouped in the Database Editor. Ex: Lego and LEGO are grouped as the same value.

Note: Materials don’t have classification filters.

Item Details


The right side of the screen shows all the properties of the selected item. This is where you can review and edit each item attributes, such as name, dimensions, shape, image(s), etc.

Note: The available properties vary depending on the type of items being viewed.

Item Preview


When you select an item in the list, this area displays a small preview of the item in 3D.

Note: you can Zoom, Pan and Orbit the item in the preview, and also see it in Fullscreen using the standard 3D navigation tools on the right side of the bottom toolbar.

PlanogramBuilder User Guide - © Copyright zVisuel, 2001-2022