Hi guys. I'm trying to generate a CSV which with a variable product formation and need to auto populate a field....
Table below shows how my layout works, I need to read collumn A and if variation is followed by variable, then collumn C needs to be populated with collumn B.
If variation changes to Variable (next product) it needs to leave row C blank for the row saying variable and then copy tow B into row C for the next one down?
not sure how to explain that better, but hopefully the table will be of help.
<tbody>
</tbody>
Table below shows how my layout works, I need to read collumn A and if variation is followed by variable, then collumn C needs to be populated with collumn B.
If variation changes to Variable (next product) it needs to leave row C blank for the row saying variable and then copy tow B into row C for the next one down?
not sure how to explain that better, but hopefully the table will be of help.
Type | Sku | Parent |
variable | SKUAlphabet | |
variation | ABC | Skualphabet |
variation | DEF | Skualphabet |
variation | GHI | Skualphabet |
variable | SKUNumber | |
variation | 1234 | Skunumber |
variation | 5678 | Skunumber |
<tbody>
</tbody>