Alex Rivera | Logout

Magento - filter product collection by multiple SKU's

Asked 2011-02-25T18:33:26.590
12

I know it's possible to filter a collection by one SKU, as below:

$_testproductCollection = Mage::getResourceModel('catalog/product_collection')
->addAttributeToSelect('*')
->addAttributeToFilter('SKU', array('like'=>array('my-sku')));
$_testproductCollection->load();

But is there some way to add a list of SKU's, like the following (which doesn't work):

->addAttributeToFilter('SKU', array('like'=>array('my-sku1, my-sku2, my-sku3')))
Edit
Report

1 Answer

1

You need split 'addAttributeToFilter' or split second params in this functionly example:

$collection->addAttributeToFilter(
array(
    array('attribute'=>'sku','like'=>"%$sku%"),
    array('attribute'=>'sku','like'=>"%$sku%")
));
answered 2011-02-26T23:57:20.163

Your Answer