I'm trying to import products with multiple variant options, for example size of t-shirt (Small, Medium, Large) and colour of t-shirt (red, blue, yellow). I've found its very easy to import one variant by mapping relevant price columns to [Variant Price] and then entering the Variation Group to (for example) "Size" and the Variation Name to the respective variation names (e.g. Blue, Red, Yellow) for each column.
However when I attempt to add in two different Variation Groups then in doesn't work. I'm guessing this is because I would only be mapping the variants individually (e.g. only giving a price for Blue t-shirts OR Large T-shirts instead of a Large Blue t-shirt).
Firstly, is it even possible to map more than one variation group? if it is, is there special syntax/delimiter/method I have to use to do this?
If it's not possible, does anyone have any idea how I can do this without manually entering many many different prices??
A sample CSV designed to import this kind of data would be really useful!!
Thanks in advance!