Start Free Trial
Start Free Trial

Bulk import Shopify product variants by generating combinations of Options

Shopify product variant combinations generated from Options - thumbnail|Shopify variant options to bulk generate variants from|Shopify bulk generated variants for Products|Shopify generate variants from options - generate file with dry run|Shopify download import results file after dry run of generated variants from options|Shopify bulk generated product variants in Excel from Options values

Generate Variants from Options

If you need to generate variants in bulk for your Shopify products, you can enter Option values split by ; (semicolon) in columns:

  • Option1 Value
  • Option2 Value
  • Option3 Value

And add column “Variant Generate From Options” with a value “TRUE” for each Variant to row. This will tell the app to generate Variants from your semicolon split Options.

As a result, the Matrixify app will generate your variants as combinations of all those options.

For example, if you have the import file Options like this:

generate variants from semicolon splt options Shopify products import csv excel excelify

It will result in imported variants like this – all of their semicolon-separated-value combinations:

Shopify bulk generated variants for Products

Of course, you don’t have to fill all 3 options. You can do it with just one or two option value cells, too.

Edit generated variants before importing

If you need to fine-tune your generated variants or delete some of them before importing, you can run the import with the “Dry Run” (select Options button after uploading the file).

Dry-run for generating optionsThen press the “Import” button. After the dry run is complete, press the “Download Import Results” button.

Import Results file from generating options

You will get the Import Results file with all the generated variants – change them as you like, and then import this changed file again with Matrixify – as the normal import.

generated variants from semicolon splt options Shopify products import csv excel excelify

Good to know

  • Shopify allows a maximum of 100 Variants so be cautious not to exceed that when multiplying your option values.
  • All of the other values for the variants will get duplicated from that one import row for all the variants.
  • You can look into more information about importing Shopify products.
  • Check out Matrixify tutorial on how to import your Products.