Resolved - category page sort by the newest first

[ravuth]

my store use cubecart v5.1.1 , and my store products are update daily ,

is any possible way to show products sort by date added (the newest first ) by default ?

is any one know how to customize that ?

[bsmither]

Please try this (I haven't tried it myself):

In catalogue.class.php, about line 426, find:

... $order = false, ...

Change to:

$order = array('date_added' => 'DESC'),

Instead of specifying 'no particular order', we are specifying the 'date added' from highest to lowest.

(Note: I really should be learning about the hook system so that stuff like this will survive updates and can be enhanced if needed. Oh, well.)

[ravuth]

@bsmither , i try it .

unfortunately, it not work..

you have any other idea ?

i do appreciate that you so often offer good advice.

[bsmither]

I keep forgetting to mention that changes to code that could affect how the database gets queried and/or how the page gets displayed, the various caches need to be cleared in the admin section under maintenance.

[ravuth]

dear Bsmither

i try to clear all caches, and it still dont work .

please let me know

[ravuth]

dear bsmither, i submit ticket to cubecart supporter.

and now it works.

thanks you for your help .

[Dirty Butter]

Please share the solution if you can, and I'll mark this thread as resolved.

[ravuth]

@Dirtybutter, surly here is the solution from cubecart support

Code change required.

OPEN

classes/catalogue.class.php

FIND

$order['name'] = 'ASC';

REPLACE WITH

$order['product_id'] = 'DESC';

Do it twice as two lines to find there.

Thanks