Can anyone help me find products that have no images assigned to them.
Either a list of products with no images or a way to delete them using a PHP script would be ideal
Thank you
-
I assume you are talking about the image gallery images.– Fabian BlechschmidtCommented Nov 7, 2013 at 17:35
Add a comment
|
1 Answer
$collection = Mage::getResourceModel('catalog/product_collection')
->addAttributeToFilter('media_gallery', array('isnull' => true))
should give you all the products.
$collection->delete();
should delete them all.
But be careful, if the filter is wrong, you might delete all products!
answered Nov 7, 2013 at 17:49
-
There is no delete() on a collection unless you implement it yourself, e.g. stackoverflow.com/a/7820188 Commented Nov 12, 2013 at 7:50
-
I'm sorry, there is, here:
\Mage_Eav_Model_Entity_Collection_Abstract::delete()Commented Nov 12, 2013 at 10:09 -
Oh well... spent too much time in Mage_Core_Model_Resource_Db_Collection_Abstract it seems ;-) It's funny that one class has it implemented and not the other. Commented Nov 12, 2013 at 13:21
-
Absolutely, should be moved up in the inheritance chain ! :) Commented Nov 12, 2013 at 19:18