crash11 Posted September 28, 2022 Share Posted September 28, 2022 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 Link to comment Share on other sites More sharing options...
ComGrafPL Posted September 28, 2022 Share Posted September 28, 2022 SEO Images (ALT Tags) Module - PrestaShop Addons 1 Link to comment Share on other sites More sharing options...
crash11 Posted September 28, 2022 Author Share Posted September 28, 2022 I dont want a module to do this, thnk you Link to comment Share on other sites More sharing options...
webprog Posted September 29, 2022 Share Posted September 29, 2022 Hello, you can use ps_image_lang table for this. Link to comment Share on other sites More sharing options...
Ress Posted September 30, 2022 Share Posted September 30, 2022 Do you want to put custom texts, or use certain formulas, e.g. product name + certain feature or + certain attribute? Link to comment Share on other sites More sharing options...
crash11 Posted October 1, 2022 Author Share Posted October 1, 2022 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; Link to comment Share on other sites More sharing options...
musicmaster Posted October 3, 2022 Share Posted October 3, 2022 You can use Prestools. It is free. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now