This topic has 2 voices, contains 4 replies, and was last updated by TB Support 4572 days ago.

Change product order to latest

This topic has been marked as resolved.

Hi there, I have searched lots of forums looking on how to get the latest products to show first by editing the product.php file but cannot get this working. For example the latest products link here: http://www.bhanuclothing.co.uk/index.php?route=product/category&path=25 There are 6 pages here. Page 1 is showing the oldest products whilst page 6 the newest, is there a way of manually showing the latest products first throughout all categories? There are a lot of products in the database now and so would take ages to manually add the order in so wondering if there is something I can change in a php file to overcome this. Many thanks Ollie	fullfatstudios
October 10, 2011 at 12:21 pm #2281
Hi fullfatstudios! You have to modify the following in order to achieve default sorting by date: You will need to register in order to post topics and read replies in the ThemeBurn.com support forums! This should do the work. This hack is for opencart 1.4.9.x only. It may not work on 1.5.x Regards, ThemeBurn team	TB Support
October 13, 2011 at 10:56 am #2401
Hi there, I cant see the amended code on this post?? I received an email notification but was riddled with all over. Can you post it again as I dont see anything under where you have put ‘You have to modify the following in order to achieve default sorting by date:’ Many thanks Ollie	fullfatstudios
October 13, 2011 at 11:59 am #2410
Did you only change one thing in that block of code? $sql .= ” ORDER BY p.date_added”; I changed to this from $sql .= ” ORDER BY p.sort_order”; I deleted my files in system > cache however the order hasnt changed on this page for example: http://www.bhanuclothing.co.uk/index.php?route=product/category&path=25 If there were other edits you have made, then could you resend the code over as it didnt display on your last post. Many thanks Ollie	fullfatstudios
October 13, 2011 at 12:18 pm #2413
Sorry, I hid it by mistake.	TB Support
October 13, 2011 at 12:51 pm #2415

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.