I've enabled flat tables. Now the new arrival products aren't appearing which is filtered by a particular category. Below code works when flat tables are disabled.

$cat = Mage::registry('current_category'); 
    $catid = $cat->getId();
    $_products = $this->getProductCollection()
                      ->joinField('category_id', 'catalog/category_product', 'category_id', 'product_id = entity_id', null, 'left')
                      ->addAttributeToFilter('category_id', $catid);

Is there a different way to get new arrivals product filtered by a particular category when flat tables are ON?

2 Answers 2


You can try this,

$collection = Mage::getModel('catalog/category')

I was able to get new product collection and filter by category using below code

$cat = Mage::registry('current_category'); 
$catid = $cat->getId();
$_products = $this->getProductCollection();
$category = Mage::getModel('catalog/category')->load($catid);

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.