How can I load the product collection without some products?

Question

Actually, I want to load the product collection except for some products. I have the product ids that I don't want in the collection. For example, the product ids that I don't want in the product collection is like

$productIds = array(10,20,30);

How can I do this?

Answer 1

You can use this code.

$productIds = array(10,20,30);
$collection = Mage::getModel('catalog/product')->getCollection()
            ->addFieldToFilter('entity_id', array('nin' => $productIds));

Answer 2

Use addIdFilter() with the second parameter $exclude set to true, to invert the filter:

$productCollection->addIdFilter($productIds, true)

Answer 3

some time not in not work without addFieldToSelect I will always use this

$productIds = array(10,20,30)
$collection = Mage::getModel('catalog/product')->getCollection()
             ->addFieldToSelect('entity_id')   
             ->addFieldToFilter('entity_id', array('nin' => $productIds));