Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
This file can be used to: Create a new multimedia folder and the folder tree structure.
Example:
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" - for
comma 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.
This file can be used to: Assign attributes as category attributes.
column | required | limitation |
---|---|---|
_name |
---|
- the product data
- the multimedia resources
- the categories
- the category allowed attributes configuration
- the category trees
- the category trees configuration
- the completeness sets
- the multimedia folders
- the attributes
- the custom fields
- the collection attributes options
- the units
- the templates
- the templates configuration
- the section templates
- the section templates configuration
column | required | limitation |
---|
folder_one
folder_one/folder_two
_name
Max length of 255 chars.
_code | One of existing Attribute Codes. |
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
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:
This file can be used to: Create the completeness set.
* Language is 5 chars LCID language code. Example: name_en_GB
.
Example:
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
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 a new unit with a name and corresponding symbol.
This file can be used to: Create a new section template, and add a translation of the section template name.
Example:
This file can be used to: Create the category tree structure, or change the category branch location in the existing category tree.
Example:
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
column | required | limitation |
---|
_code | _attribute | _name | _language |
---|
column | required | limitation |
---|
_code | name_en_GB |
---|
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 |
---|
column | required | limitation |
---|
_name | _url | _language | _alt |
---|
column | required | limitation |
---|
column | required | limitation |
---|
_code | _name | _language |
---|
column | required | limitation |
---|
_code | _parent | _category |
---|
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
select | select | name | en_GB |
multiselect | multiselect | name | en_GB |
completeness_set_1 | Completeness set name |
completeness_set_2 | Completeness set name |
sku_with_variants | template_code | en_GB | VARIABLE-PRODUCT | sku_simple1,sku_simple2 | product_size | category_code_1,category_code_2 | text1 | textarea1 | -1 | 1 | 1 | 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 | -2 | 2 | 2 | 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 | 3 | 3 | -3 | 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 | 4 | 4 | -4 | 2022-01-25 | option_code_1 | option_code_1,option_code_2 | folder/multimedia.jpg | folder/multimedia.jpg,multimedia2.jpg | docs.pdf |
filename.jpg | www.ergonode.com/image1.jpg | en_GB | alternative text |
folder/filename.jpg | www.ergonode.com/image2.jpeg | en_GB | tekst alternatywny |
code | name | en_GB |
category_tree_1 | category_root |
category_tree_1 | category_root | category_child |
_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: pl_PL
attribute_code*
Column header represents existing Attribute Code. Value should be valid according to given attribute type.
Example: product_description
_code | Max length of 128 chars. |
_attribute | Applies for One of existsing Attribute Codes. |
_language | 5 chars LCID language code. Example: |
_name | Max length of 255 chars. |
custom_field_code* | Column header represents existing Custom Field Code. Value should be valid according to given type. |
_code | Completeness set code. |
name_{language} * | Name in specific language. |
_sku | Max length of 255 chars. |
_template | One of existing Template Codes. |
_type | One of { |
_language | 5 chars LCID language code. Example: |
_children | Applies for grouping and variable product types. Only existing SKUs. In case of |
_bindings | Applies for |
_categories | One of existing Category Codes. |
attribute_code* | Column header represents existing Attribute Code. Value should be valid according to given attribute type.
Example: |
_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. |
_symbol | Max length of 16 chars. |
_name | Max length of 255 chars. |
_code | Max length of 128 chars. |
_name | Max length of 128 chars. |
_language | 5 chars LCID language code. Example: |
_code | One of existing Category Trees Codes. |
_parent | One of existing Category Codes. |
_category | One of existing Category Codes. |
This file can be used to: Create a new category tree, and add category tree name translation.
Example:
This file can be used to: Create new custom fields in the SELECT and MULTISELECT attribute type.
* Note that this attribute must already exist, or the proper attributes.csv file that creates it must be included in the import zip, only SELECT and MULTI_SELECT attribute types support Custom Fields.
Example:
This file can be used to: Create a template structure using numeric values representing the position of each template element.
* Language is 5 chars LCID language code. Example: translation_pl_PL
.
This file can be used to: Create a section template structure using numeric values representing the position of each section template element.
* Language is 5 chars LCID language code. Example: translation_pl_PL
.
This file can be used to: Create new attributes, add attribute translations, define attribute type, scope, and other attribute specifications accordingly.
Available date formats:
Example:
This file can be used to: Create a new template, and add a translation of the template name.
Example:
if _name
column present
if _name
column present
if attribute values columns present
if _alt
or _title
column present
if _name column present
column | required | limitation |
---|---|---|
_code | _name | _language |
---|---|---|
column | required | limitation |
---|---|---|
_code | _type | _attribute |
---|---|---|
column | required | limitation |
---|---|---|
column | required | limitation |
---|---|---|
column | required | limitation |
---|---|---|
Date | CSV Date Format |
---|---|
_code | _type | _scope | _language | _name | format | currency | rich_edit | unit |
---|---|---|---|---|---|---|---|---|
column | required | limitation |
---|---|---|
_code | _name | _language |
---|---|---|
category_tree_1
Category tree one
en_GB
category_tree_2
Category tree two
en_GB
custom_field_1_code
IMAGE
attribute_custom_values
custom_field_2_code
TEXT
attribute_custom_values
custom_field_3_code
TEXTAREA
attribute_custom_values
custom_field_4_code
TEXTAREA_RTE
attribute_custom_values
1999-01-31
yyyy-MM-dd
99-01-31
yy-MM-dd
31.01.1999
dd.MM.yyyy
31.01.99
dd.MM.yy
01/31/99
MM/dd/yy
01/31/1999
MM/dd/yyyy
January 31, 1999
MMMM dd, yyyy
31 January 1999
dd MMMM yyyy
31 Jan 1999
dd MMM yyyy
text
TEXT
local
en_GB
text
textarea
TEXT_AREA
global
en_GB
textarea
true
numeric
NUMERIC
local
en_GB
numeric
price
PRICE
global
en_GB
price
PLN
unit
UNIT
local
en_GB
unit
m
data
DATE
global
en_GB
date
yyyy-MM-dd
select
SELECT
local
en_GB
select
multiselect
MULTI_SELECT
global
en_GB
multiselect
image
IMAGE
local
en_GB
image
gallery
GALLERY
global
en_GB
gallery
file
FILE
local
en_GB
file
product_relation
PRODUCT_RELATION
global
en_GB
product relation
code
name
en_GB
_code
Max length of 64 chars.
_name
Max length of 255 chars.
_language
5 chars LCID language code. Example: pl_PL
_code
Max length of 128 chars. Lowercased, alphanumerical and "_" signes are accepted.
_type
One of { IMAGE , TEXT , TEXTAREA , TEXTAREA_RTE}
_attribute
Code of the attribute*
_code
One of existing Template Codes.
_type
One of {attribute
, section
, heading
, divider
, note
}
_x
Numeric value 0-3.
_y
Positive numeric value.
_width
Numeric value 1-4.
_height
Numeric value 1-10.
attribute
One of existing Attribute Codes.
require
One of {true
, false
}
Max length of 255 chars.
Available for column _type
-heading
.
default
Max length of 255 chars.
section
One of existing Section Template Codes.
completeness_set
One of existing Completeness Set Codes.
Available for column _type
-section
.
translation_{language} *
Translation in specific language. Available for column _type
- heading
and note
.
_code
One of existing Section Template Codes.
_type
One of {attribute
, heading
, divider
, note
}
_x
Numeric value 0-3.
_y
Positive numeric value.
_width
Numeric value 1-4.
_height
Numeric value 1-10.
attribute
One of existing Attribute Codes.
require
One of {true
, false
}
Max length of 255 chars.
Available for column _type
- heading
.
default
Max length of 255 chars.
translation_{language} *
Translation in specific language. Available for column _type
- heading
and note
.
_code
Max length of 128 chars. Lowercased, alphanumerical and "_" signes are accepted.
_type
One of {TEXT
, TEXT_AREA
, NUMERIC
, PRICE
, UNIT
, DATE
, SELECT
, MULTI_SELECT
, IMAGE
, GALLERY
, FILE
, PRODUCT_RELATION
}
_scope
One of {local
, global
}
_language
5 chars LCID language code. Example: pl_PL
_name
Max length of 255 chars. Lowercased, alphanumerical and "_" signes are accepted.
_hint
Max length of 4000 chars. Lowercased, alphanumerical and "_" signes are accepted.
format
One of existing date formats (see table below)
currency
One of existing Currencies.
rich_edit
One of {true
, false
}
unit
One of existing Unit Symbols.
unique
One of {true
, false
}
_code
Max length of 128 chars.
_name
Max length of 128 chars.
_language
5 chars LCID language code. Example: pl_PL
if _name
column present
if _type
column is attribute
if _type
column is attribute
label ( deprecated - if given on import with default - default takes precedense)
if _type
column is heading
or note
if _type
column is section
if _type
column is attribute
if _type
column is attribute
label ( deprecated - if given on import with default - default takes precedense)
if _type
column is heading
or note
if one of _name
, _hint
or _placeholder
columns present
if _type
column is DATE
if _type
column is PRICE
if _type
column is TEXTAREA
if _type
column is UNIT
if _name column present