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
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:
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.