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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
_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
if _name
column present