Thursday, April 26, 2012
Magento: Sort latest product by ‘created date’
Use following code to sort/order product by created date
$todayDate = Mage::app()->getLocale()->date()->toString(Varien_Date::DATETIME_INTERNAL_FORMAT);
$collection = Mage::getModel('catalog/product')
->getCollection()
->addAttributeToFilter('news_from_date', array('date' => true, 'to' => $todayDate))
->addAttributeToFilter('news_to_date', array('or'=> array(
0 => array('date' => true, 'from' => $todayDate),
1 => array('is' => new Zend_Db_Expr('null')))
), 'left')
->addAttributeToSort('news_from_date', 'desc')
->addAttributeToSort('created_at', 'desc');
Labels:
Magento
Subscribe to:
Post Comments (Atom)
4 comments:
Anyway to sort newest products by price instead?
Reply DeleteHey,
DeleteInsert the following code at last:
$collection->setOrder('price','DESC'
This comment has been removed by the author.
Reply DeleteThis comment has been removed by the author.
Reply Delete