Magento – Remove duplicate product photos

magento-1.7MySQLproduct-images

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:

fg60-2.jpg
fg60-2t.jpg

I need a query to look at each products images, and when it finds a product with images like:

xxxx.jpg
xxxxt.jpg

Then the xxxxt.jpg image is removed.

Any MySQL experts have any advice? Were using Magento 1.7

Best Answer

This was already taken care of with a module. Image Clean works with 1.4.2.0 on up to 1.7 and is available over on Magento Connect as a free install.

I recommend it as your issue will be an ongoing one. Magento does not remove images when product are deleted so not only do you have this import issue to contend with every time something goes akilter, but you have an ongoing and never ending disk usage bloat as Magento's less than stellar housekeeping lets it pack on the poundage in unused images from long dead and removed product.

Note: no affiliation with the above mentioned module. However, having tried to go the scripting route to manage images, found that this developer produced a module that works simply and efficiently. Just don't let it delete your placeholder images for "No image found"

Related Solutions

Magento Product Detail Page – Display Alt Attributes of Thumbnail Images

It turned out to be trivial when I looked into it. The $_image variable is an instance of VarienObject with a label property, so it's just a matter of calling $_image->getLabel().

Here's an abridged section of the final code

foreach ($this->getGalleryImages() as $_image): ?>
    <a href="#" ....>
        <img alt="<?=$_image->getLabel()?> ...

Magento 2.1 – Import Product with Images Using Absolute Path

With a small trick, I was able to use an absolute path to import the product images.

Magento way of retrieving the final folder is based on the current Magento installation location, therefore any root based path parameter won't go through. I was able to tric the Magento import system using /../. This allows to reach a parent or even sibling folder on any authorized level as the final path is still based on the current Magento installation folder.

For example, if your import file path is located as below:

/home/user/import/brand/img001.jpg

And your Magento installation location:

/home/user/magento

Then the Images File Directory import setting should be set as follow:

/../import/brand

And inside the CSV file under the base_image attribute column:

img001.jpg

Unfortunately this method still does not allow to include the path or a part of it in the CSV file which would have been better instead of having to input a new path on every import.

I think that Magento still has work to do in regards to their import system. At the time of writing, there is also an issue still present in the version 2.1.3 in which the verification function does not use the same Multiple value separator as the import function for the additional_images attribute. The result is that if any delimiter other than comma is used as Multiple value separator, the validation process will fail.

Best Answer

Related Solutions

Magento Product Detail Page – Display Alt Attributes of Thumbnail Images

Magento 2.1 – Import Product with Images Using Absolute Path

Related Topic