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
if attribute values columns present