does anyone know how to make a database query for phpmyadmin
that will update all the images ALT tags with the product name .
No, but an alternative solution is to export your images then open the file in Excel or similar app and edit the image location adding the [COLOR=“Blue”]ALT tag[/COLOR] and then import it.
example:
/var/www/html/demo.cs-cart.com/images/backup/product_image.jpg[COLOR="Blue"]#Product Name[/COLOR]i got it … thanks anyways
update cscart_images_links, cscart_images, cscart_product_descriptions set cscart_images.alt = cscart_product_descriptions.product where cscart_images_links.object_type = 'product' and cscart_product_descriptions.product_id = cscart_images_links.object_id and cscart_images_links.image_id = cscart_images.image_id;
update cscart_images_links, cscart_images, cscart_product_descriptions set cscart_images.alt = cscart_product_descriptions.product where cscart_images_links.object_type = 'product' and cscart_product_descriptions.product_id = cscart_images_links.object_id and cscart_images_links.detailed_id = cscart_images.image_id;