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 Excelify app will generate your variants as combinations of all those options.
For example, if you have the import file Options like this:
It will result in imported variants like this – all of their semicolon-separated-value combinations:
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).
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 Excelify – as the normal import.
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 Excelify tutorial on how to import your Products.