Creating Product Variants via Import
Product variants can be imported into an X-Cart based store in the products.csv file.
A store admin can get a sample products.csv file by exporting it via the Admin area's Export section.
It will be necessary to select Products in "What to export" and All attributes in the "Export product data with" dropdown. This way, the file will include the fields product variants are built on.
Let's consider a sample products.csv file below.
This file contains info on 3 (three) products:
- SKU 10000000102 - Samsung Galaxy S6
- SKU 10000000103 - Apple iPhone 8 Plus
- SKU 10000000104 - Apple iPhone X
The first product (Samsung Galaxy S6) does not have variants, while the other two (iPhone 8 and iPhone X) do.
We've kept in the file only the fields that distinguish a product with variants from a product without them and removed all the rest.
In our sample file, product variants are based on product class attributes. This means that the base fields for product variants creation are:
- productClass and Capacity, GB (field:class) for iPhone X
- productClass, Capacity, GB (field:class) and Color (field:class) for iPhone 8
The productClass filed is the field that defines a product class assigned to a product. Capacity, GB (field:class), and Color (field:class) are product class attributes that build the base for product variants creation.
If we decide to create variants for Samsung Galaxy S6 based on the same properties, i.e., based on the Mobile phone product class and its attributes, it would be necessary for us:
- Create a new line for each new variant with the same SKU (10000000102).
- Assign the product class to the parent product (productClass = Mobile phone).
- Specify the values for the fields that will become the base for the variants' creation.
We've decided to create variants based on the field Color (field:class).
Below is the file that we obtained as a result.
Now, we can import this file via the Import page of the store's Admin area (Catalog -> Import).
Make sure you've selected the "Update existing items" in the Import mode dropdown.
After the import process completes, the product properties should be updated:
Updating Price and Quantity of Product Variants
Let us imagine that you have a product SKU 10000000104 “Apple iPhone X,” and this product has 3 variants:
For example, you need to update the variants info as follows:
- define a different price for each product variant;
- set a different quantity stock for each product variant.
Here’s how you can do it:
1. Use the Export section of your store’s Admin area (Catalog > Export) to export your existing products:
If you need to export only one or several products, select them on the product listing page of your store Admin area (Catalog -> Products) and use the Export all button at the bottom of the page:
2. Download the resulting export file and import it into your favorite spreadsheet editor.
3. Edit the file removing the columns whose contents will not be updated. Care not to remove the required columns.
According to the section CSV import: Products of this manual, the required columns for importing products are sku and name; you will need to keep these columns.
Hence we are dealing not just with simple products but with product variants. You will also need to keep the column variantID OR the columns that correspond with the fields the variants were built on [attribute_name](field:product)- if variants were built based on product-specific attributes, [attribute_name](field:class) - if variants were built based on product-specific attributes and [attribute_name](field:global) - if variants were built based on global attributes)- the values in this column are necessary to identify the specific variants.
In our sample, we would use the variantID field as a variant identifier. As we will update the prices and quantities for variants, you should keep the columns variantPrice and variantQuantity in addition to the required ones. Now, if you look at the lines presenting the details of the variants of “Binary Mom,” you should have something like the following:
4. Adjust the values in the file:
- For variant ID 10000000104-64, add ”650” in the variantPrice column and “20” in the variantQuantity column.
- For variant ID 10000000104-128, add ”700” in the variantPrice column and “25” in the variantQuantity column.
- For variant ID 10000000104-256, add ”750” in the variantPrice column and “15” in the variantQuantity column.
As a result, your file contents should look like the following:
5. Save the file and re-import it into your store via the Import section in your store’s Admin area (Catalog > Import).
After the import process is completed, you should see the updated prices and stock quantity for the product variants.