Import & Export of catalog.csv (V5)

Types

Import

Export

 

The catalog contains all the elements needed to build a guideline in 2D and in 3D, organized into brands and folders.

Types

During the item creation, the user must choose a type.
This type can’t be changed after the creation.

An instance is only linked to a restricted list of types.

Types available are:
product, tester, accessory, visual, furniture, object3D, compositeObject3D, pointOfSaleRepresentation, shoes, cloth, textileAccessory, storeComponent.

Import

On the import page, the user can import a catalog.csv file that can contain multiple columns.

This file can be named with a prefix and a suffix: “*-catalog-*.csv”.
Example: xxx-catalog-2020-02.csv

The first line contains the name of the columns.

Click here to download the CSV template

⚠️ Rule for import:

      • The file imported must be a valid UTF-8 file
uuid

UUID of the item. Has to be extracted from the platform.
The file can contain both filled and empty cells.

      • If filled, its content must be a valid existing UUID and it’s an update.
      • If empty, it’s a creation.

Optional

name

Name of the item.
Its content must be between 1 and 80 characters.
Mandatory

type

Type of the item.
The item type has to be available on the instance.
The type of item cannot be updated after the item's creation.

On creation, it must be a value between:
product, tester, accessory, visual, furniture, object3D, compositeObject3D, pointOfSaleRepresentation, shoes, cloth, textileAccessory, storeComponent.

Mandatory on creation

activated

Activation status of the item.
The value can be yes or no. For an item creation, by default the value is no.
Optional

archived Archive status of the item.
The value can be yes or no. For an item creation, by default the value is no.
Optional
code

The main corporate code used to identify the item.

      • Its content must be between 1 and 80 characters.
      • Two items of the same type can’t have the same code.

Mandatory

code2

The second corporate code used to identify the item.

      • Its content must be between 1 and 80 characters.

Optional

code3

The third corporate code used to identify the item.

      • Its content must be between 1 and 80 characters.

Optional

brand

The brand of the item. 

      • It must be an existing brand (Generic brand included).
      • Its content must be between 1 and 80 characters.

Mandatory

market

The groups of markets and markets on which the items are available.

      • The user can only use groups and markets that are already created.
      • This column is optional on update and if the value is empty, the markets won’t be changed.

Optional on item’s update - At least one market mandatory on item’s creation

Format to fill in: group1:marketA,marketB,...;group2:marketX,marketY

      • One group name is followed by “:” and then by one or multiple of its markets.
      • Markets are separated by ",".
      • Groups are separated by “;”.

Example: America:Mexico,USA,Canada;Asia:China,Japan;Europe:France,Italy

Shortcuts:

      • “*”: will automatically link the item to all markets.
      • group1”: if there is no market with this name already integrated, the item will be linked to all markets in this group of markets.
      • marketA” if only one market (and no group of markets) has this name, the item will be linked to it.
folderX

On creation, at least folder1 is mandatory because an item can be placed directly in a brand, it must be placed in a folder.

      • Its content must be between 1 and 80 characters.
      • If the folder doesn’t exist, it will be created.
      • We can’t have two folders with the same name in one location.

Mandatory

name2

The second name of the item. Can be a name in another language for example.

      • Its content must be less than 80 characters.
Optional
description

The description of the item.The second name of the item.

      • Its content must be less than 80 characters.
Optional
width

Width of the item.

      • It is set in mm in import
      • Value must be between 0 and 1000000
      • Can have 2 decimals maximum

Available for:
cosmetic, product, tester, cosmetic tester, shoes, accessory, textile accessory, cloth, bottle, factice, tobacco, watch, visual, store.

Not available if a 3D model is set. 
Mandatory if no 3D model set.

height

Height of the item.

      • It is set in mm in import
      • Value must be between 0 and 1000000
      • Can have 2 decimals maximum

Available for:
cosmetic, product, tester, cosmetic tester, shoes, accessory, textile accessory, cloth, bottle, factice, tobacco, watch, visual, store.

Not available if a 3D model is set. 
Mandatory if no 3D model set.

depth

Depth of the item.

      • It is set in mm in import
      • Value must be between 0 and 1000000
      • Can have 2 decimals maximum

Available for:
cosmetic, product, tester, cosmetic tester, shoes, accessory, textile accessory, cloth, bottle, factice, tobacco, watch, visual, store.

Not available if a 3D model is set. 
Mandatory if no 3D model set.

volume/weight1

First volume, weight, or capacity of the item.

      • Value must be between 0 and 10000000000
      • Can have 2 decimals maximum

Available for:
cosmetic, product, tester, cosmetic tester, bottle, factice, tobacco.

Optional - Mandatory if volume/weight1 unit is set.

volume/weight1 unit

The unit of the first volume, weight, or capacity of the item.

Values can only be:
mL, cL, L, fl oz, g, kg, oz, lbs, pieces.

Available for:
cosmetic, product, tester, cosmetic tester, bottle, factice, tobacco.

Optional - Mandatory if volume/weight1 is set.

volume/weight2

Second volume, weight, or capacity of the item.

      • Value must be between 0 and 10000000000
      • Can have 2 decimals maximum

Available for:
cosmetic, product, tester, cosmetic tester, bottle, factice, tobacco.

Optional - Mandatory if volume/weight2 unit is set.
volume/weight2 unit

The unit of the second volume, weight, or capacity of the item.

Values can only be:
mL, cL, L, fl oz, g, kg, oz, lbs, pieces.

Available for:
cosmetic, product, tester, cosmetic tester, bottle, factice, tobacco.

Optional - Mandatory if volume/weight2 is set.

stock

The stock is used both in exports and during the transition from 2D to 3D. It can be automatically calculated in relation to the depth of the furniture.

Values can only be:

      • None
      • Calculated (by default)
      • A value superior to 0 and inferior to 1000000 (Defined)

Available for:
cosmetic, product, shoes, textile accessory, cloth, bottle, tobacco, watch.

Optional

on exported document

Items that won’t be listed in reports.
Example: shelftalkers that appear in the guidelines, do not need to be listed in reports.

      • The value can be yes or no, default value is yes

Available for:
cosmetic, product, tester, cosmetic tester, shoes, accessory, textile accessory, cloth, bottle, factice, tobacco, watch, object3D, fixture.

Optional
can be placed

Items that won’t be available to be placed in a guideline.
Example: screws that appear on exported documents due to the set of order feature, don't need to be placed on guidelines.

      • The value can be yes or no, default value is yes

Available for:
cosmetic, product, tester, cosmetic tester, shoes, accessory, textile accessory, cloth, bottle, factice, tobacco, watch, object3D.

Optional

facing

Image of the item.

      • This image must be in *.png format.
      • This image must be less than 15MB.

The user must put the name of the image in the field.

To generate a temporary facing: write temp as a value in the column.

Available for:
cosmetic, product, tester, cosmetic tester, shoes, accessory, textile accessory, cloth, bottle, factice, tobacco, watch, visual, store.

Not available if a 3D model is set (in that case a facing will be generated)
Mandatory if no 3D model set.

3D model

3D model of the item.

      • This 3D model must be a valid *.display file.
      • The user must put the name of an existing 3D model or the name of 3D model file just uploaded.

The name of the 3D model is the name of the file's name, without the extension (*.display) and “_” replaced by spaces.

Available for:
cosmetic, product, tester, cosmetic tester, shoes, accessory, textile accessory, cloth, bottle, factice, tobacco, fixture, watch, store, object 3D.

Not available if dimensions/facing are set or if it’s a fixture built in 2D. 
Mandatory in the opposite case.

color

Available for items with a 3D model that allows a color.

When a 3D model is attached to an item if this model can have a color the user will be able to attach a color. 
This can be done by picking a color in a color picker or typing its code (HEXA, RGBA, HSLA, HSVA, or CMYK).

The color will be applied to the 3D model for this item.

Optional

texture

Texture of the item.

      • This image must be a PNG.
      • This image can’t be bigger than 15MB.

This texture will be applied to the 3D model for this item.

Available for items with a 3D model that allows a texture.
When a 3D model is attached to an item if this model can have a texture the user will be able to attach a texture. 
This can be done by uploading an image from a computer.

Optional

Export

On the export modal, the user can export a catalog.csv file that contains all the items with their information.

This file is divided into multiple columns and the first line contains their names. The list and details about these columns are in the import part.

This export will only contain items:

      • that aren't archived.
      • that are linked to at least one brand of the user.
      • that are linked to at least one market of the user.

 

Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request