Images alt

[crash11]

Hello, someone to help me to add alt text to all product images? I want to do this on all products not one by one

Thank you

[ComGrafPL]

SEO Images (ALT Tags) Module - PrestaShop Addons

[crash11]

I dont want a module to do this, thnk you

[webprog]

Hello, you can use ps_image_lang table for this.

[Ress]

Do you want to put custom texts, or use certain formulas, e.g. product name + certain feature or + certain attribute?

[crash11]

On 9/29/2022 at 8:30 AM, webprog said:

Hello, you can use ps_image_lang table for this.

Yes, I did it. I used this code to do it

First this:

CREATE TABLE result_table2 AS
SELECT p.id_product, p.id_image, s.name
FROM ps_image_shop p
LEFT JOIN ps_product_lang s ON p.id_product = s.id_product WHERE s.id_lang=1;

Then this:

UPDATE ps_image_lang
JOIN result_table2
ON ps_image_lang.id_image = result_table2.id_image
SET ps_image_lang.legend = result_table2.name;

 

 

[musicmaster]

You can use Prestools. It is free.