Tuvezz Posted October 20, 2014 Share Posted October 20, 2014 Hai All, Can someone please tell me how i can make the newest product appear on top list at homepage? Link to comment Share on other sites More sharing options...
NemoPS Posted October 20, 2014 Share Posted October 20, 2014 Is that the new products block? or the featured products one? If the latter, it takes them using their position in the home category, you have to modify that in the back office Link to comment Share on other sites More sharing options...
Tuvezz Posted October 20, 2014 Author Share Posted October 20, 2014 Is that the new products block? or the featured products one? If the latter, it takes them using their position in the home category, you have to modify that in the back office It is the new arrivals block. where to modify it? Thanks Link to comment Share on other sites More sharing options...
NemoPS Posted October 21, 2014 Share Posted October 21, 2014 getNewProducts method of the product class (classes/product.php). Find order_by towards the end and set it to product_shop.`date_add` Link to comment Share on other sites More sharing options...
Tuvezz Posted October 28, 2014 Author Share Posted October 28, 2014 (edited) getNewProducts method of the product class (classes/product.php). Find order_by towards the end and set it to product_shop.`date_add` Sorry can you please tell me which line should i change at classes/product.php. Because I found product_shop.`date_add` more than one and I am a bit confused about it Edited October 28, 2014 by Tuvezz (see edit history) Link to comment Share on other sites More sharing options...
NemoPS Posted October 29, 2014 Share Posted October 29, 2014 This one $sql->orderBy((isset($order_by_prefix) ? pSQL($order_by_prefix).'.' : '').'`'.pSQL($order_by).'` '.pSQL($order_way)); To $sql->orderBy('p.date_add DESC'); 1 Link to comment Share on other sites More sharing options...
Tuvezz Posted October 30, 2014 Author Share Posted October 30, 2014 (edited) This one $sql->orderBy((isset($order_by_prefix) ? pSQL($order_by_prefix).'.' : '').'`'.pSQL($order_by).'` '.pSQL($order_way)); To $sql->orderBy('p.date_add DESC'); Thanks for your quick response. I had change it and clear cache at admin panel but the result still same...so confused Edited October 30, 2014 by Tuvezz (see edit history) Link to comment Share on other sites More sharing options...
Tuvezz Posted October 30, 2014 Author Share Posted October 30, 2014 (edited) sorry double post Edited October 30, 2014 by Tuvezz (see edit history) Link to comment Share on other sites More sharing options...
NemoPS Posted October 31, 2014 Share Posted October 31, 2014 Try with ASC instead, see what it does. Are you using any override? Link to comment Share on other sites More sharing options...
Recommended Posts