Query to display just arrived product

Posted: November 7, 2009 in General, Magento, Version 1.3.*

$_parent_category = Mage::app()->getStore()->getRootCategoryId();
$storeId = Mage::app()->getStore()->getStoreId();

$_productCollection = Mage::getResourceModel(‘catalog/product_collection’)
->addAttributeToSelect(‘*’)
->setStoreId($storeId)
->addStoreFilter($storeId)
->addAttributeToFilter(‘status’,’1′)
->setOrder(‘created_at’, ‘desc limit 1’)
->load();

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s