To import product variants you should use a regular products.csv file.
To reference a specific product variant, you have to 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 -
variantID field. This field is autogenerated by X-Cart and strictly unique. Export the existing products and product variants to obtain them.
The field variantID is completely 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, values of non-variant specific fields (i.e., all but the fields added by the Product Variants add-on) should not be repeated for each variant. This means that such values as memberships, productClass, taxClass, enabled, shippable, categories, inventoryTracking, name, description, etc., need to be specified only once per product variant set; specifying them for each variant SKU may result in such undesirable effects as the creation of duplicate values or re-writing of 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 which specify the variant if you are using 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.