Rules on items
Import
Export
Data Dictionary
The catalog contains all the elements needed to build a guideline in 2D and in 3D, organized into brands and folders. Items can be managed manually, but thanks to the IMPORT & EXPORT features on the IWD Platform, it is also possible to create/update items in your catalog in bulk, allowing you to save a lot of time!
Rules on items
ITEM TYPES:
When creating a new item, the user must choose an item type. Several types are available, please refer to this article for more information about the most common item types and their behaviors. The available types are:
product, tester, accessory, visual, furniture, object3D, compositeObject3D, pointOfSaleRepresentation, shoes, cloth, textileAccessory, and storeComponent.
- Note that an instance is linked only to a restricted list of types.
- Keep in mind that the item type can no longer be changed after item creation.
2D IMAGES:
The IWD Platform provides you with realistic renderings. Therefore, each item image you wish to upload into the platform database must follow specific requirements. Make sure to learn how to retouch your images in order to create and feed new items to your catalog.
3D FILES:
- Each 3D file must be a valid *.display file.
- The name of a 3D file must not contain any spaces, make sure to replace spaces with "_".
Import
DATA IMPORT PROCESS
Please refer to this article for the step-by-step import process, including how to download the template and how to set up your *.csv file. It is essential to follow this process for the import to be successful.
RULES FOR IMPORT:
- We recommend you name this file with a prefix and a suffix e.g. xxx-catalog-2023-02.csv
- The first line contains the names of the columns, please refer to the Data Dictionary below to help you fill in the information. Make sure to fill in the mandatory fields for the import to be successful.
- As *.csv templates are case-sensitive, make sure to fill in the following columns in lowercase:
- Type: product, visual, tester, accessory, etc.
- Stock: calculated
- Can be placed: yes
- Activated: yes
- The following characters are not authorized in the import: [:] and [EOL ↵]
- You can import using commas or semicolons as separators but you can't use both in the same file.
- Imports are limited to 500 lines. If you need to import a larger document, you must split it into smaller files and import each file individually.
- ⚠️ Important: The file imported must be in valid UTF-8 format for the import to be successful.
IMPORT ERRORS:
If the import has failed, error messages will show up in red. The most common errors are listed below along with their solution. This will give you visibility on how to fix the most common import errors that might occur during the upload of your catalog.
Solution: Complete folder structure without skipping folder columns.
Export
On the EXPORT modal, the user can export a catalog.csv file containing all the items from the catalog and their information. The first line of the file contains the name of the columns, as described in the Data Dictionary below.
Note that the 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.
Data dictionary
Please refer to this data dictionary to fill in the import file and understand the content of the export file.
uuid |
UUID of the item. Has to be extracted from the platform.
Optional |
name |
Name of the item. |
type |
Type of the item. On creation, it must be a value between: Mandatory on creation |
activated |
Activation status of the item. |
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.
Mandatory |
code2 |
The second corporate code used to identify the item.
Optional |
code3 |
The third corporate code used to identify the item.
Optional |
brand |
The brand of the item.
Mandatory |
market |
The groups of markets and markets on which the items are available.
Optional on item’s update - At least one market mandatory on item’s creation Format to fill in: group1:marketA,marketB,...;group2:marketX,marketY
Example: America:Mexico,USA,Canada;Asia:China,Japan;Europe:France,Italy Shortcuts:
|
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.
Mandatory |
name2 |
The second name of the item. Can be a name in another language for example.
|
description |
The description of the item.The second name of the item.
|
width |
Width of the item.
Available for: Not available if a 3D model is set. |
height |
Height of the item.
Available for: Not available if a 3D model is set. |
depth |
Depth of the item.
Available for: Not available if a 3D model is set. |
volume/weight1 |
First volume, weight, or capacity of the item.
Available for: 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: Available for: Optional - Mandatory if volume/weight1 is set. |
volume/weight2 |
Second volume, weight, or capacity of the item.
Available for: |
volume/weight2 unit |
The unit of the second volume, weight, or capacity of the item. Values can only be: Available for: 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:
Available for: Optional |
on exported document |
Items that won’t be listed in reports.
Available for: |
can be placed |
Items that won’t be available to be placed in a guideline.
Available for: Optional |
facing |
Image of the item.
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: Not available if a 3D model is set (in that case a facing will be generated). |
3D model |
3D model of the item.
The name of the 3D model is the name of the file's name, without the extension (*.display) and “_” replaced by spaces. Available for: Not available if dimensions/facing are set or if it’s a fixture built in 2D. |
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. The color will be applied to the 3D model for this item. Optional |
texture |
Texture of the item.
This texture will be applied to the 3D model for this item. Available for items with a 3D model that allows a texture. Optional |
preview orientation |
Orientation of the item.
The "front" orientation is set-up by default if the column has no value. The default value can be changed in the instance settings. |