How to delete products with no images

Question

Is there away i can delete all product or at least find them in the backend interface ?

There must be away to export products with no images in dataflow and then import them back in but this time delete entries ?

Thank you

Answer 1

To my knowledge there is no way of deleting a product via Dataflow. However, if you're comfortable running a script - the following standalone script will delete all products that don't have images^*:

<?php
require('app/Mage.php');
Mage::app();

$collection = Mage::getModel('catalog/product')->getCollection();
$collection->getSelect()
    ->joinLeft(
        array('_gallery_table' => $collection->getTable('catalog/product_attribute_media_gallery')),
        'e.entity_id = _gallery_table.entity_id',
        array()
    )
    ->where('_gallery_table.value IS NULL');
$collection->delete();

Do not run this on your production database without having tested it thoroughly first.

---

_{^* Disclaimer: I am not responsible for any damage caused to your system. This code is untested. You alone are responsible for running code that you copied and pasted from a random person on the internet.}

Sources:

https://stackoverflow.com/questions/16892513/magento-get-products-without-images-using-collections

https://stackoverflow.com/questions/5486350/how-do-i-delete-data-using-collection-in-magento-orm

Answer 2

Absolutely, Heres the logic:

Decide what type of product you are using Run a mage.app (or other) Programatic code to run all the filters, then using the API delete process you will be able to delete the product based on ID

I use it all the time myself for updating product statuses, and disabling/deleting bundles that have 0 stock.