Magento 1.9 – How to Delete All Product Images

magento-1.9product-images

I have a magento Installation which has had several image imports done by the client and its got wrong images in the wrong products, toasters with fridge freezers as the initial import had the wrong img names. After a further import via CSV it seems to have appended the images rather than change them.

I need to delete all product images on the site, then re-do the CORRECT import so all the images are correct.

Is there a quick way to delete all images then do a fresh import via Dataflow Profiles and re-map the correct fields?

Any help would be awesome!

Best Answer

Fastest way to remove image,then follow below steps: delete all records from

  1. catalog_product_entity_media_gallery
  2. catalog_product_entity_media_gallery_value'

table because magento is save all product image data at those table.

Then index from Index management from admin for set image black.

Then remove image from dir then goto Your magento dir at media/catalog/product and from this folder delete all file.

Another Process:

Andy Simpson,you need a script which is delete all product from your system which will delete from DB and file system.

Step1: Create a php at root direct of magento system which include Mage.php at first code.

require_once "YOURMAGENTODIR/app/Mage.php";
umask(0);

Step2: set current store is admin and set Developer mode

Mage::app('admin');
Mage::setIsDeveloperMode(true);

Step3: Get Product Collection and create a loop for get one product by one by one

$productCollection=Mage::getResourceModel('catalog/product_collection');

Step4: fetch product image by one and remove image one using below code:

$remove=Mage::getModel('catalog/product_attribute_media_api')->remove($product->getId(),$eachImge['file']);

FULL CODE:

<?php
require_once "YOURMAGENTODIR/app/Mage.php";
umask(0);
Mage::app('admin');
Mage::setIsDeveloperMode(true);

$productCollection=Mage::getResourceModel('catalog/product_collection');
foreach($productCollection as $product){
echo $product->getId();
echo "<br/>";
         $MediaDir=Mage::getConfig()->getOptions()->getMediaDir();
        echo $MediaCatalogDir=$MediaDir .DS . 'catalog' . DS . 'product';
echo "<br/>";

$MediaGallery=Mage::getModel('catalog/product_attribute_media_api')->items($product->getId());
echo "<pre>";
print_r($MediaGallery);
echo "</pre>";

    foreach($MediaGallery as $eachImge){
        $MediaDir=Mage::getConfig()->getOptions()->getMediaDir();
        $MediaCatalogDir=$MediaDir .DS . 'catalog' . DS . 'product';
        $DirImagePath=str_replace("/",DS,$eachImge['file']);
        $DirImagePath=$DirImagePath;
        // remove file from Dir

        $io     = new Varien_Io_File();
         $io->rm($MediaCatalogDir.$DirImagePath);

        $remove=Mage::getModel('catalog/product_attribute_media_api')->remove($product->getId(),$eachImge['file']);
    }


}
Related Topic