I would like to make 2 links with containing all new (link 1) and sale (link 2) products from a specific category and it's sub categories.

For example: I want to show all new products from the baby category (Id=3) The category is already an anchor.

And the same with sale items (items have sale prices generated by the catalog sale rules)

How can i do that? Because magento hasn't have a category filter for this ...

I have magento 1.8.1 CE

1 Answer 1


Here it explains step by step: http://www.dnawebagency.com/displaying-new-products-in-magento-with-pagination/

  • i tried this solution .... But the category filtering doesn't work ... It shows still all new products.
    – Ronny
    Commented Jun 19, 2015 at 20:35
  • $collection = Mage::getModel('catalog/product') ->getCollection() ->joinField('category_id', 'catalog/category_product', 'category_id', 'product_id = entity_id', null, 'left') ->addAttributeToFilter('category_id', array('in' => array('finset' => '3'))) ->addAttributeToSelect('*');
    – Mehdi
    Commented Jun 22, 2015 at 18:04

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.