New & Sale product list from specific categories

Question

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

Mehdi · Accepted Answer · 2015-06-18 14:46:46Z

1

answered Jun 18, 2015 at 14:46

Mehdi

8681 gold badge11 silver badges28 bronze badges

i tried this solution .... But the category filtering doesn't work ... It shows still all new products.
– Ronny
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
Jun 22, 2015 at 18:04

Add a comment |

1 Answer 1