CODEWITHSUNDEEP
phpcollectionsmagento
Joe Mastey
Joe Mastey

Reputation: 27109

Filter Magento Product Collection for Products with Images

I have a product collection that I am getting from a configurable product, and I want to filter that collection to only include products that have images attached to them. How do I go about this?

Code looks something like this:

$configurableProduct = $this->getConfigurableProduct();
$childProducts = $configurableProduct->getTypeInstance()->getUsedProductCollection();

// add some filter here to get only products with images
$childProducts->addAttributeToFilter( /* what goes here? */ );    

foreach( $childProducts as $product ) {
   ...
}

Any help is appreciated. Thanks! Joe

Upvotes: 5

Views: 5090

Answers (2)

coylOne
coylOne

Reputation: 61

$this->_productCollection->addAttributeToFilter('small_image',array('notnull'=>'','neq'=>'no_selection'))

Upvotes: 6

Andreas Pauli
Andreas Pauli

Reputation: 21

Works also with this:

$collection->addAttributeToFilter('small_image',array('notnull'=>'','neq'=>'no_selection'));

Upvotes: 0

Related Questions