This question already has an answer here:

I need to export all products without images in my site.

marked as duplicate by Raphael at Digital Pianism, Fabian Schmengler, Amit Bera, Keyul Shah, mbalparda Jul 11 '16 at 0:41

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


go to system > import/export > Dataflow Profiles > you can see Export al Products option > click on that , than go to Run profile , than click on Run profile in pop up , than check var/export folder , you can see file with all products.


if you look at the excel sheet , which contains columns of only images. you can observe the blank values in some fields, those products not have images.

  • i need only export which product has no images – Gem Jul 8 '16 at 7:05
  • check my update. – Baby in Magento Jul 8 '16 at 7:07

For this you have to write a custom module or need to filter the product collection which don't have images.

$_products = Mage::getModel('catalog/product')
        array (
            'attribute' => 'image',
            'like' => 'no_selection'
        array (
            'attribute' => 'image', // null fields
            'null' => true
        array (
            'attribute' => 'image', // empty, but not null
            'eq' => ''
        array (
            'attribute' => 'image', // check for information that doesn't conform to Magento's formatting
            'nlike' => '%/%/%'

Not the answer you're looking for? Browse other questions tagged or ask your own question.