I have nearly 40k products and all images have been set to small only. If I go into the backend and then set each image one by one to the base, it will take me forever. Is there any way to do it via the database?
Magento 2 – Set Base Image as Small Image
magento2product-images
Best Answer
If you want to do by MySQL way follow below way
First, run below query to know the query is actually working and you will get a list of images
After that run below query to update small image path with a thumbnail image
You should run first in test ENV, after making sure you can run on other ENV.
Hope It will solve your issue