Associate thousands of images with products

[Bluesky4777]

I have a bookshop here in France with 25000 titels. My image file consists of 20k images, some books have 2-6 images. I uploaded those images to a imageimport folder that I created in the root of the Prestashop directory. 

Using Filezilla again, I retrieved the URL's of the images. In Excel this looks like this:

 

http:/mywebsite/imageimport/100001.jpg

http:/mywebsite/imageimport/100003.jpg

http:/mywebsite/imageimport/100004_1.jpg

http:/mywebsite/imageimport/100004_2.jpg

etc

 

Now how do you guys transform this row to a column with image strings? I need that column to complete my csv import file.  

 

product ref.     image url's

 

100001           http:/mywebsite/../100001.jpg

100002

100003           http:/mywebsite/../100003.jpg

100004           http:/mywebsite/../100004_1.jpg,http:/mywebsite/../100004_2.jpg

etc.

 

Please note that book #100002 has not been photographed yet. Is there a module to automate this kind of association or do I have to programme a macro? Hope not, it's a long time ago that I have been programming in BASIC....

Edited December 10, 2014 by Bluesky4777 (see edit history)

[RogueWaveLimited]

I will do this for you.  I will need the list of images (in order).

 

Email me the info.

[Bluesky4777]

Thanks for this Richard, I'll send you the files!

[Bluesky4777]

Very happy with your work Richard, the image strings imported without problems into my shop. I now have up to 12 images per product. Thank you very much!

[prestashopmediarete]

Could you explain how did you do this?

 

Thank you