B-219 Sec-55 Noida, India
+918010221733

How to select the images as base image thumbnail image in bulk?

UPDATE catalog_product_entity_media_gallery AS mg,
       catalog_product_entity_media_gallery_value AS mgv,
       catalog_product_entity_varchar AS ev
SET ev.value = mg.value
WHERE  mg.value_id = mgv.value_id
AND mg.entity_id = ev.entity_id
AND ev.attribute_id IN (85,86,87)
AND mgv.position = 1;

where 85,86 and 87 attribute id for base image, thumbnail and small image.

(Visited 55 times, 1 visits today)

Leave a reply