Task
The supplier sends photos in separate image_1, image_2, and image_3 columns. WooCommerce expects one Images column with comma-separated links.
Short answer
Create Images from image_1, append ,{image_2} and ,{image_3} only when those columns are not empty, then remove a trailing comma.
How to Do It in Eofferix
- Open the settings of the output
Imagescolumn.
The click is on the settings icon of the output Imagescolumn. - In
Transformations, addAdd to endrules for non-empty extra images and cleanup for redundant commas.
The Transformationsblock shows the full rule chain for this case. - Save the column settings and go to the
Exportstep.
Before / After
Before
source data| SKU | Name | image_1 | image_2 | image_3 |
|---|---|---|---|---|
| WC-130 | Desk lamp | https://cdn.example.com/lamp-main.jpg | https://cdn.example.com/lamp-side.jpg | |
| WC-131 | Office chair | https://cdn.example.com/chair-main.jpg | https://cdn.example.com/chair-back.jpg |
After
result| SKU | Images |
|---|---|
| WC-130 | https://cdn.example.com/lamp-main.jpg,https://cdn.example.com/lamp-side.jpg |
| WC-131 | https://cdn.example.com/chair-main.jpg,https://cdn.example.com/chair-back.jpg |