I need to export all products without images in my site.
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.
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') ->getCollection() ->addAttributeToSelect('*') ->addAttributeToFilter(array( 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' => '%/%/%' ), ));