Context:
I have a product, a sofa, which is available in different configurations. The same sofa is available in 5 different lengths, can be made in 2 different materials and is available in 6 colours for each of the 2 materials (due to the materials being dyed via different methods, the colour options for each material are very distinct).
Question:
I am planning to charge differing costs for material and size but will not be charging differently based on colour. However, if I set up these 3 variations, I will end up with 5 * 2 * 12 options, all of which I need to configure a price for in Wix (or more realistically, via CSV).
Is there a way to configure the prices such that I can ignore certain variation option (in this case the Colour option)?
Product:
Wix Stores Product Variants/CMS
What are you trying to achieve:
For my product with 5 sizes, 2 materials and 12 colours, I want to set 10 prices based on the size-material combinations and ignore the colour variations as they do not have bearing on price.
What have you already tried:
The naive method of sorting each variation combination row in excel by sizes and materials and then copy-pasting the price 12 times per size-material group, but this is really not maintainable especially considering some of my more complicated products with different brands of the same type of material.
I’ve also tried leaving the product option blank in CSV, which doesn’t work.
Removing all rows save for the size-material combinations and copy pasting all of the possible colour options (i.e. the #6c93b7:Blue;#ff0000:Red;…) for these rows do not work; After looking at the CMS and seeing how Wix Stores > Variants organise the data I kind of understand why this doesn’t immediately work.
I’ve found like one or two other posts on Reddit/Stack about people facing remotely similar issues but their solutions boil down to separating the products based on certain variant combinations, which I am unable to implement due to aesthetic reasons (UX discussions concluded that we want to allow customers to select all of the variants via 1 product page and not flood the store with 10 of essentially the same product).