how to associate an image with a product

[TomaszMyszak]

Good morning,
I wanted to update the PrestaShop database with about 1500 products, I want to do it directly in the database code and in the store script itself.
I wanted to ask for a hint where PrestaShop stores links to images of products shown on the page.

What I want to do is I have a list of images on the server, I have a table with links product => image(link).

How to make the image display properly in Presta.

thank you in advance for your help, thank you also for offers like I will do it for a fee. I want to learn this script and I can't find it in the documentation.

[Prestachamps]

Hi @TomaszMyszak,

Prestashop does not store the image url, it assigns images to the products based on productId, and stores the saved Prestashop image_id -> product_id corelation in the  table ps_image_lang , and also saves image information to tables ps_image_shop and ps_image_lang 

Also the images are being uploaded to the folder /img/p/X/X/X/X in format: example image id 1357.jpg will be placed in folder img/p/1/3/5/7/1357.jpg and the other image types  with the different resolutions will be in this same folder.

I hope that I could help.
Have a nice day, Leo.

[TomaszMyszak]

4 hours ago, Prestachamps said:

Hi @TomaszMyszak,

Prestashop does not store the image url, it assigns images to the products based on productId, and stores the saved Prestashop image_id -> product_id corelation in the  table ps_image_lang , and also saves image information to tables ps_image_shop and ps_image_lang 

Also the images are being uploaded to the folder /img/p/X/X/X/X in format: example image id 1357.jpg will be placed in folder img/p/1/3/5/7/1357.jpg and the other image types  with the different resolutions will be in this same folder.

I hope that I could help.
Have a nice day, Leo.

thank you for answer, that im looking for