export multiple image URLs

[andreiven]

So I am trying to extract a csv file with every product id and image source (URL) only.

I succeeded exporting a feed from catalog but it only gives me the first image of every product and I was wondering if anyone tried to export all the image URLs for that one product id.

 

edit: In the actual csv file, the form of the image url is this: http://www.example.com/img/p/9/1/8/5/9185.jpg

When I check the website every product's image has the following link: http://www.example.com/6724-pos_thickbox/tenisi-dama-36-40-engros.jpg

 

The first image is of low resolution and is as viewed in the product catalog and the second image has the full resolution.

I am thinking I should change the source selection for the images inside the sql query to match the second form. I don't know much about sql and any suggestion is appreciated.

Edited November 12, 2016 by andreiven (see edit history)

[gabdara]

Check out this tutorial: https://www.prestashop.com/forums/topic/540614-tutorial-export-products-with-all-the-fields-supported-by-csv-import/