Magento: Sort latest product by ‘created date’ and ‘new from date’

Here is a quick tip to sort/order latest product by both created date and new from date.

Looking for improvement for your Magento Store?
Facebook Connector Extension
Product related article extension
Unlimited Slideshow Magento Extension
Light Checkout in One Step Magento Extension

Created At date is automatically added when you add a new product. However, you have to set New from Date manually while adding or editing product.

You may have product with same new from date.

And, then you need created at date to sort the latest product.

Here is the code to sort/order product by both created date and new from date:

$todayDate = Mage::app()->getLocale()->date()->toString(Varien_Date::DATETIME_INTERNAL_FORMAT);

$collection = Mage::getModel(‘catalog/product’)
->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’);

Hope this helps. Thanks.