Hi, with explode we can build a term row with different colors attached to one product.
I would like to have the opposite. That when there are different colors in a row everything in the row is cloned based on how much variations there are in the cell. And the different rows should have an unique SKU

SKU,title, price, colors
10001, apple, 1 , yellow, green

The end result with correct mapping and SKU math SKU = SKU+ 1 should be 2 products:

SKU.  Title.   Price. Color
10001 Apple  1       Yellow
10002 Apple. 1       Green

Thanks a lo in advance for your reply
Greetings, Martijn

Comments

office@w3k.at’s picture

office@w3k.at commented

Don`t we want something more like this?

SKU,title, price, colors
10001, apple, 1 , "yellow/green/blue"

Should become 3 products:
SKU, Title, Color
10001-Y Apple 1 Yellow
10001-G Apple. 1 Green
10001-B Apple. 1 Blue

samwilson’s picture

samwilson commented
Issue summary: View changes

This would be a useful thing; is there currently any way of achieving it?

Collins405’s picture

Collins405 commented

Has anyone figured this out yet?

I thought making the field unique and using explode might achieve this but it doesn't