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:
productSKU - unique identifier of the product;
type - type of an attribute;
name - attribute name;
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 | |
productSKU* | SKU of the product which has this attribute value. Serves as a part of unique identifier. | String, |
type* | Type of the attribute. Possible values are:
| Enum |
name* | Text representation of the attribute. Serves as a part of unique identifier. | String, |
class | Attribute class. Serves as a part of unique identifier. | String, |
group | Attribute group. Can be blank. Serves as a part of unique identifier. | String, |
owner | Yes for *Product-Specific* attributes. No for *Global* attributes. | 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. S - selectbox; C - color swatch. | S/B/C |
Fields added by the add-on Color Swatches
Field in CSV file | What this field describes | |
swatch | Color swatch name | String, |
Fields added by the add-on Multivendor
Field in CSV file | What this field describes | |
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: