Skip to main content

CSV Import: Product Attribute Values

A
Written by Anna Verbichenko
Updated over a year ago

A product attributes CSV file for import must have the name product-attributes-xxxxxx.csv, where the part -xxxxxx can be anything you want, or can be even omitted.

Examples of correct product CSV file names:

  • product-attributes.csv;

  • product-attributes-13-01-01.csv;

  • product-attributes-from-my-provider.csv

A product attributes CSV file must contain at least four fields:

  1. productSKU - unique identifier of the product;

  2. type - type of an attribute;

  3. name - attribute name;

  4. value - attribute value.

Below is a list of supported fields and their respective value types for the import of product attribute values:

Fields supported by X-Cart core

Field in CSV file

What this field describes

Value type

productSKU*

SKU of the product which has this attribute value. Serves as a part of unique identifier.

String,
Max. length: 32

type*

Type of the attribute. Possible values are:

  • T - Text

  • S - Select

  • C - Yes/No

  • H - Hidden

Enum

name*

Text representation of the attribute. Serves as a part of unique identifier.

String,
Multilingual,
Max. length: 255

class

Attribute class. Serves as a part of unique identifier.

String,
Multilingual,
Max. length: 255

group

Attribute group. Can be blank. Serves as a part of unique identifier.

String,
Multilingual,
Max. length: 255

owner

Yes for *Product-Specific* attributes. No for *Global* attributes.
Owner value serves as a part of unique identifier. Note that changing No to Yes, and vice versa, will result in that a new attribute will be added (provided there hasn't been one).

Yes/No

value*

Actual attribute value

String

attributePosition

Attribute sorting position. If attribute has several values and, therefore, several rows, first encountered value is used.

Integer

valuePosition

Attribute value sorting position

Integer

priceModifer

Modifier of the product price. Should be written with a sign, either positive or negative (e.g. +1.5)

Signed float

weightModifier

Modifier of the product weight. Should be written with a sign, either positive or negative (e.g. +1.5)

Signed float

editable

Applied only if type is Text. Indicates that this value is editable by customer on the product page.

String

displayMode

Applied only if type is Select.
Indicates the plain field attribute display mode in the storefront. Available values are as follows:

S - selectbox;
B - blocks;

C - color swatch.

S/B/C

Fields added by the add-on Color Swatches

Field in CSV file

What this field describes

Value type

swatch

Color swatch name

String,
Multilingual,
Max. length: 255

Fields added by the add-on Multivendor

Field in CSV file

What this field describes

Value type

vendor*

Product vendor login name

String

* Required field.

** See CSV Field Notices for more info.

Tips:

  • If you are going to import data into X-Cart and do not wish to update certain X-Cart fields during the import process, you should not include these fields in your CSV file for import. Simply remove the respective column(s) from the file.

  • To check for the correct CSV file format export products with all attributes from the actual database. You’ll see what fields are currently in use.

Related pages:

Did this answer your question?