Default sort by position in category on NewProducts page

[sokpet]

Hello,

 

this question was many times on forum but I could not find clear answer, at least for 1.4.6.2 which I use currently.

 

My shop is done in a way that the home page is directly a list of new products. So I need to sort these products manualy according to the position (not id) in the category (home category)

 

I tested how it works in standard way on category product list pages and works perfect. Unfortunately the same default behavior of sorting does not work with newproduct.tpl which includes same product-list.tpl

 

how can I make it? do I need to modify newproducts controller for that?

 

Thanks

[sokpet]

product-sort works well if you change sort order manually on product list. But when I change position inside category in Admin and update front page no changes for the default sorting.

 

Any help would be appriciated.

[Richard S]

order is done in SQL query by getting list from database. In your case, you should look at public static function getNewProducts() in Product class at line 1346 and edit it is query to meet your needs.