Product sort order on New Products Page not working

4 Aug 2014, 12:40 PM

Zen Follower

Join Date:: Jan 2010
Location:: Richmond, Virginia, United States
Posts:: 122
Plugin Contributions:: 0

Product sort order on New Products Page not working

The new products on the main page of our site are sorting by date available (which is correct). But on the new products page itself, the products are sorting by date added, not date available. I've tried everything I can think of to override this but can't figure it out.

Please help!

Thanks :)

JM Snyder

4 Aug 2014, 1:34 PM

jmsnyder23

Zen Follower

Join Date:: Jan 2010
Location:: Richmond, Virginia, United States
Posts:: 122
Plugin Contributions:: 0

Re: Product sort order on New Products Page not working

Never mind -- I found it. In the file includes/modules/listing_display_order.php file, I changed the line:

case ($_GET['disp_order'] == 6):
$order_by = " order by p.products_date_added DESC,

to read:

case ($_GET['disp_order'] == 6):
$order_by = " order by p.products_date_available DESC, pd.products_name";

and it works now. In case anyone's interested!