To import product variants, you should use a regular products.csv file.

To reference a specific product variant, you must provide all its attribute values. The attribute value column has the format of: <Attribute name> (field:<class or global>). See the example below:

Also, starting from X-Cart 5.3.3, there is an alternative way of specifying variants - the variantID field. This field has a unique value and is generated automatically. Therefore, you can obtain the field values by exporting existing products with product variants.

The field variantID is entirely separate from the variantSKU and serves only identification needs, don't mistake one for another.

For example, the file below is sufficient to update the variant prices:

When importing product variants, you should not repeat the values of non-variant specific fields (i.e., all but the fields added by the Product Variants add-on) for each variant. It means that such values as memberships, productClass, taxClass, enabled, shippable, categories, inventoryTracking, name, description, etc., need to be specified only once per product variant. Setting them for each variant SKU may result in such undesirable effects as creating duplicate values or re-writing a value by a subsequent value.

For example, import of variants for the product SKU 10000 Binary Mom using the following file will rename the product SKU 10000 from "Binary Mom" to "BinaryMom" (so you will no longer have a product "Binary Mom" after the import process completes). It will also make all the four variantSKUs (100001, 100002, 100003, and 100004) available to both Wholesale and VIP membership levels.

Please note that the given table image is not complete. Provide all attribute values that specify the variant if you use X-Cart 5.3.2 and earlier. X-Cart 5.3.3 and later versions can use variantID field to reference the specific product variant.

Related pages: