Now let’s see how to update the prices and stock quantities 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:
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 selected button at the bottom of the page:
Download the resulting export file and open it in a spreadsheet editor.
Edit the file removing the columns whose contents will not be updated. Care not to remove the required columns.
According to CSV import: Products, the required columns for importing products are sku and name; you will need to keep them.
Since 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
[attribute_name](field:global) - if variants were built based on global attributes)
The values in these columns 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 “Apple iPhone X,” you should have something like the following:
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:
Save the file and import it back via the Import page 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.