function getOutOfStockProducts() { $products = Mage::getModel('catalog/product') ->getCollection() ->joinField( 'is_in_stock', 'cataloginventory/stock_item', 'is_in_stock', 'product_id=entity_id', '{{table}}.stock_id=1', 'left' ) ->addAttributeToFilter('is_in_stock', array('eq' => 0)); return $products; }