Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Overview of the import and export files format
The entire format is represented as an .zip archive containing the following .csv files.
Only zip-archived files are processed properly in case of an import - a simple .csv file upload won't work.
Files within the archive must be named accordingly as in the documentation below.
The maximum archive size is 250 MB.
The maximum single file size within the archive is 1000 MB.
Columns are separated using ","(comma) or ";"(semicolon) separator depending on the configuration.
Files have to be UTF-8 formatted.
Cell value needs to be escaped with the " sign if it contains a column separator.
"sku1,sku2" - forcomma separator
"the ; sign is called semicolon" - for the semicolon
The files are placed in the zip archive as top-level entities.
Those should not be placed in a subdirectory within the archive - an often mistake for MacOS users - when using right-click menu on a directory containing files and using the option Compress "directory" which does just that.
Below you can find an example of import data.
Please refer to a specific file description for more details.
products.csv - the product data
multimedia.csv - the multimedia resources
categories.csv - the categories
category_attributes.csv - the category allowed attributes configuration
category_trees.csv - the category trees
category_trees_elements.csv - the category trees configuration
completeness_sets.csv - the completeness sets
multimedia_folders.csv - the multimedia folders
attributes.csv - the attributes
custom_fields.csv - the custom fields
options.csv - the collection attributes options
units.csv - the units
templates.csv - the templates
templates_elements.csv - the templates configuration
section_templates.csv - the section templates
section_templates_elements.csv - the section templates configuration
This file can be used to: Create a new category tree, and add category tree name translation.
Example:
| column | required | limitation |
|---|---|---|
| _code | _name | _language |
|---|---|---|
category_tree_1
Category tree one
en_GB
category_tree_2
Category tree two
en_GB
_code
Max length of 64 chars.
_name
Max length of 255 chars.
_language
5 chars LCID language code. Example: pl_PL
if _name column present
This file can be used to: Create the completeness set.
* Language is 5 chars LCID language code. Example: name_en_GB.
Example:
| column | required | limitation |
|---|---|---|
| _code | name_en_GB |
|---|---|
completeness_set_1
Completeness set name
completeness_set_2
Completeness set name
_code
Completeness set code.
name_{language} *
Name in specific language.
This file can be used to: Assign attributes as category attributes.
| column | required | limitation |
|---|---|---|
_code
One of existing Attribute Codes.
This file can be used to: Create new products, make changes to existing ones, add variants to products with variants, and add products to a grouping product. Leave the attribute value empty to also delete its value in PIM.
In the example, some values are collections(_children, _categories, multiselect_attribute, etc) separated by semicolons.
If your column separator is semicolon as well the CSV file should contain those values escaped with " sign to tell the importer that the value represents a single column i.e. "option_code_1,option_code_2".
Example:
* Note in the above example columns not starting with _ prefix represents product attribute values. Each header name represents an attribute code identifying this Attribute and the cell contains the value.
text_short_description text attribute represented by the text value
textarea_description textarea attribute represented by the text value
numeric_size numeric attribute represented by the numeric value
price price attribute represented by the positive numeric value
unit_weight unit attribute represented by the numeric value
date date attribute represented by the date value
select_brand select attribute represented by the Attribute Option Code
multiselect_attribute multiselect attribute represented by the list of Attribute Option Codes separated by a comma
image image attribute represented by the Multimedia Path
gallery gallery attribute represented by the list of Multimedia Paths separated with a comma
file_appendix file attribute represented by the list of Multimedia Paths separated with a comma
product_relation product relation attribute represented by the list of SKUs separated with a comma
| column | required | limitation |
|---|---|---|
| _sku | _template | _language | _type | _children | _bindings | _categories | text_short_description | textarea_description | numeric_size | price | unit_weight | date | select_brand | multiselect_attribute | image | gallery | file_appendix | product_relation |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sku_with_variants
template_code
en_GB
VARIABLE-PRODUCT
sku_simple1,sku_simple2
product_size
category_code_1,category_code_2
text1
textarea1
2022-01-25
option_code_1
option_code_1,option_code_2
multimedia.jpg
folder/multimedia.jpg,multimedia2.jpg
docs.pdf
sku_simple1
template_code
en_GB
SIMPLE-PRODUCT
text2
textarea2
25-01-2022
option_code_1
option_code_1,option_code_2
folder/multimedia.jpg
folder/multimedia.jpg,multimedia2.jpg
docs.pdf
sku_with_variants,sku_simple2
sku_simple2
template_code
en_GB
SIMPLE-PRODUCT
text3
textarea3
2022-01-25 12:00:00
option_code_1
option_code_1,option_code_2
folder/multimedia.jpg
folder/multimedia.jpg,multimedia2.jpg
docs.pdf
sku_grouping
template_code
en_GB
GROUPING-PRODUCT
sku_with_variants,sku_simple1
text4
textarea4
2022-01-25
option_code_1
option_code_1,option_code_2
folder/multimedia.jpg
folder/multimedia.jpg,multimedia2.jpg
docs.pdf
_sku
Max length of 255 chars.
_template
One of existing Template Codes.
_type
One of {SIMPLE-PRODUCT, GROUPING-PRODUCT, VARIABLE-PRODUCT}
_language
5 chars LCID language code. Example: pl_PL
_children
Applies for grouping and variable product types. Only existing SKUs. In case of GROUPING-PRODUCT multiplication of SKUs is allowed - the amount represents the quantity.
_bindings
Applies for VARIABLE-PRODUCT type only. Only existing Attribute Codes.
_categories
One of existing Category Codes.
attribute_code*
Column header represents existing Attribute Code. Value should be valid according to given attribute type.
Example: product_description
This file can be used to: Add supported files to Ergonode resources, add media translation, and media alternative text.
Please keep in mind that importing multimedia via HTTPS protocol requires an SSL certificate to be valid, otherwise, you will receive an import error "Can't download media from URL ... "
Note that _name has to contain an extension valid according to the files MIME type.
Example:
This file can be used to: Create new categories, and add category name translations.
In the example, some values are collections(multiselect_attribute, gallery, etc) separated by semicolons.
If your column separator is semicolon as well the CSV file should contain those values escaped(surrounded) with " sign to tell the importer that the value represents a single column i.e. "option_code_1,option_code_2".
In order to import attribute values the attributes need to be enabled in Category attributes. This can be done either by Ergonode UI or via import file category_attributes.csv.
Example:
* Note in the above example columns not starting with _ prefix represents product attribute values. Each header name represents an attribute code identifying this Attribute and the cell contains the value.
text_short_description text attribute represented by the text value
textarea_description textarea attribute represented by the text value
numeric_size numeric attribute represented by the numeric value
price price attribute represented by the positive numeric value
unit_weight unit attribute represented by the numeric value
date date attribute represented by the date value
select_brand select attribute represented by the Attribute Option Code
multiselect_attribute multiselect attribute represented by the list of Attribute Option Codes separated by a comma
image image attribute represented by the Multimedia Path
gallery gallery attribute represented by the list of Multimedia Paths separated with a comma
file_appendix file attribute represented by the list of Multimedia Paths separated with a comma
product_relation product relation attribute represented by the list of SKUs separated with a comma
if attribute values columns present
| column | required | limitation |
|---|
| _name | _url | _language | _alt |
|---|
| column | required | limitation |
|---|
| _code | _name | _language | text_short_description | textarea_description | numeric_size | price | unit_weight | date | select_brand | multiselect_attribute | image | gallery | file_appendix | product_relation_attribute |
|---|
filename.jpg | www.ergonode.com/image1.jpg | en_GB | alternative text |
folder/filename.jpg | www.ergonode.com/image2.jpeg | en_GB | tekst alternatywny |
category | category one | en_GB | text1 | textarea1 | -1 | 1 | 1 | 2022-11-09 | option1 | option_code_1,option_code_2 | folder/multimedia.jpg | folder/multimedia.jpg,multimedia2.jpg | docs.pdf | sku_with_variants,sku_simple2 |
category | pierwsze kategoria | pl_PL | text2 | textarea2 | 2 | 2 | -2 | 09-11-2022 | option2 | option_code_1 | folder/multimedia.jpg | folder/multimedia.jpg,multimedia2.jpg | docs.pdf |
_name | Max length of 128 chars. Only existing folders(if given). Name has to contain a matching MIME type extension. |
_url | URL from multimedia can be downloaded from. Download happen only once on multimedia creation. |
_language | 5 chars LCID language code. Example: |
_alt | Max length of 128 chars. |
_title | Max length of 100 chars. |
_code | Max length of 128 chars. Lowercased, alphanumerical and "_" signes are accepted. |
_name | Max length of 255 chars. |
_language | 5 chars LCID language code. Example: |
attribute_code* | Column header represents existing Attribute Code. Value should be valid according to given attribute type.
Example: |
if _alt or _title column present
if _name column present
This file can be used to: Create a new unit with a name and corresponding symbol.
| column | required | limitation |
|---|---|---|
_symbol
Max length of 16 chars.
_name
Max length of 255 chars.
This file can be used to: Create options in SELECT and MULTISELECT attribute types. Add options for translations. Add custom field value to already existing custom fields.
* Note in the above example columns not starting with _ prefixes represent custom field code values. Each header name represents a custom field identifying this option and the cell contains the value.
Example:
| column | required | limitation |
|---|---|---|
| _code | _attribute | _name | _language |
|---|---|---|---|
select
select
name
en_GB
multiselect
multiselect
name
en_GB
_code
Max length of 128 chars.
_attribute
Applies for SELECT and MULTI_SELECT Attribute types only.
One of existsing Attribute Codes.
_language
5 chars LCID language code. Example: pl_PL
_name
Max length of 255 chars.
custom_field_code*
Column header represents existing Custom Field Code. Value should be valid according to given type.
This file can be used to: Create a new multimedia folder and the folder tree structure.
Example:
if _name column present
| column | required | limitation |
|---|---|---|
| _name |
|---|