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.
Important Note: In the video above, required column “Variant Generate From Options” with the value “TRUE” is not added to the file.
This extra column has been developed recently due to potential issues by unintentionally generating Variants.
Sorry for the inconvenience, we will update the video soon and remove this note.
For example, if you have the import file Options like this:
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.