I need to list all product
SKU and associated images from the value field of
I need the output to be CSV based, so all images of each product will be listed in their relevant columns as shown below:
entity_id,sku,image1,image2,image3,image4 23321,prod1,/d/d/dsc_dasda.jpg,/d/d/dsc_d56.jpg,/d/d/dsc_d56.jpg,/d/d/dsc_542.jpg 32132,product2,/d/d/dsc_dsss.jpg,/d/d/dsc_d34s.jpg,/d/d/dsc_d432s.jpg,,
Not all products have the same number of associated images and I am not sure what the maximum is within the catalogue so the 4 images in the headers above is just an example.
Can anyone please help? I can't figure out the joins needed in the SQL but I imagine it is pretty simple if you know how.
I have tried the Magento export options and none can give the result I need.
Magento version 126.96.36.199