I need to remove duplicate product photos after an import. Thumbnails were imported as product photos.
The thumbnail filename is based off the main images filename, so I have:
I need a query to look at each products images, and when it finds a product with images like:
Then the xxxxt.jpg image is removed.
Any MySQL experts have any advice? Were using Magento 1.7