Posts Tagged ‘stock’

Sort product list by stock

Posted: February 2, 2015 in How To?, Magento
Tags: ,

Use

$this->_productCollection = $layer->getProductCollection()->joinField('inventory_in_stock', 'cataloginventory_stock_item', 'is_in_stock', 'product_id=entity_id','is_in_stock>=0', 'left')->setOrder('inventory_in_stock','desc');

If you want to just list Out of Stock products use:

$collection->joinField('inventory_in_stock', 'cataloginventory_stock_item', 'is_in_stock', 'product_id=entity_id','{{table}}.is_in_stock=0');