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?

You can try this,

$collection = Mage::getModel('catalog/category')
                    ->load($categoryId)
                    ->getProductCollection();
up vote 0 down vote accepted

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);
$_products->addCategoryFilter($category);

Your Answer

 
discard

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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