Magento get new arrival products
Magento get new arrival products on home page or for some special display any where on site
<?php $todayDate = Mage::app()->getLocale()->date()->toString(Varien_Date::DATETIME_INTERNAL_FORMAT); $_productCollection=$this->getLoadedProductCollection(); $_productCollection = Mage::getResourceModel('catalog/product_collection') ->addAttributeToSelect('*') ->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'); $now = date("Y-m-d"); $newsFrom= substr($_productCollection->getData('news_from_date'),0,10); $newsTo= substr($_productCollection->getData('news_to_date'),0,10); ?>
Then use this $_productCollection to setup html structure as per need