I have imported a number of products at once, but the problem is: the Base Image, Small Image, Thumbnail are all set to the same image.
On the catalog page, I'm trying to change the image shown when you hover over a product. I believe, to do this, the small image and thumbnail image would need to be set to different images for the same product.
How can I achieve this?
I found below query, but I do not understand how to modify it to meet my requirement.
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 (70, 71, 72) AND mgv.position = 1;
Please, can you help me find the right modifications.