Start Free Trial
Start Free Trial

Add variants to existing Shopify Products

Add Variants to existing Product|Add Variants to existing Product|Add Variants to Product|Add Variants to existing Product|Shopify add variants to existing product variants

You may already have Products in your Shopify store with Variants, and you just want to add Variants without touching the existing Variants of your Products. Matrixify allows you to add Variants to your existing Products easily in bulk. You can do so by following this step by step tutorial.

Steps in short to add Variants to an existing Product

  1. Export your Products from Shopify using the Matrixify app.
  2. Construct the Import file.
  3. Import the edited file into Shopify using the Matrixify app.

Example Product

Here we have a Product with 12 Variants in Shopify Admin. This tutorial will be adding 2 new Variants to this Product.

Product with 12 Variants in Shopify Admin

1. Export your Products from Shopify using the Matrixify app

We must start by Exporting our Products from Shopify using Matrixify. Head to the Matrixify app and select “New Export”. On the Export page, select the export format Matrixify: Excel and select to export Products from the “Select Sheets” drop-down. From here, you must select the column groups – Basic Columns and Inventory/Variants.

Export set up to Export Products with Variants

Moreover, you can select only specific columns to Export from the Basic Columns drop-down. All columns in the Basic Columns group are not required to add a Variant to an existing Product. In the drop-down you can select to Export only Handle and ID.

Export set up to Export only certain Basic Columns

A word about images. If you want a new Variant you will be adding to use the existing images from your Product, then also Export the Media column group, and take the same link from the Image Src column, and put it in Variant Image column. However, if you will take the link from somewhere else, it will add that image to Variant and to the Product itself when adding the link to the Variant Image column.

You can also add Filters to your Export to Export only specific Products from your Shopify store.

Once you have set up your Export you can press the “Export” button.

2. Construct Import file

When the Export has finished, you can download the Exported file by pressing the “Download Exported file” button.

Download Exported Products file

In your Exported file you will see many columns. You do not need all of them. The only columns you need to keep are – ID, Handle , Option ... and all columns that start with Variant. Your file should now look something like this:

Only columns required to add new Variants

Now we can add the new Variants. In our case, the Product already has 12 Variants and we will be adding 2 new Variants. To do so, we will repeat the ID and Handle column value for two additional rows.

Added two new rows to the file with the ID and Handle column value

The next step is to leave the Variant Inventory Item ID and Variant ID column value blank as we will be adding new Variants. Then fill the Variant Command column with the value MERGE for the new Variant rows and also fill the following Option... columns with the new Variant you would like to add to the Product. It is important to note, that all Variant Option combinations must be unique.

Added new Variant Options to Product

Next you can fill the Variant ... columns. You need to make sure that the following columns have unique values (if you import them):

  • Variant SKU
  • Variant Barcode
  • Option values

That’s because – if they will not be unique for the Product, then the app will consider them as an update to an existing Variant which will be found by any of those.

Once you have finished editing your file you can save it.

3. Import the edited file into Shopify using the Matrixify app

Take your saved file and drop it into the Import section of the Matrixify app. The app will analyze your Import file. Make sure that the app has correctly identified your Import file as Products and the correct amount of Products are displayed. If all looks correct, you can go ahead and press “Import”.

Import to add Variants to an Existing Product

Once the Import has finished the Variants will be added to your Products. If there are any errors, you can download the “Import Results file” one the Import has finished and the errors will be displayed in the Import Comment and Import Results columns.

Now you will be able to see that your Product has the newly add Variants. In the case of this tutorial, two new Variants have been added to the Product.

Product with 14 Variants in Shopify Admin

Good to know

  • You can remove from Excel file all columns which you don’t want to update.
  • To add additional variants, you don’t need to list all the existing variants in your Import file. As long as your added variant Option valuesVariant SKU and Variant Barcode values are unique – you can import just the new added rows, and Matrixify app will add those (because it will not be able to match to any of the existing Variants of that Product).
  • Get the Template Excel file, or to the Export to generate it from your own store.
  • Read the Products Field Descriptions.
  • Read other Product Tutorials.
  • If you are not sure how to prepare the import file, ask our Support, we will teach you and answer any questions you may have!