Center Box New Products Listing on Category with Subcategories Pages are Random

[jilbert]

*** Please excuse this noob if I've posted this in the wrong forum ***

I have a very strange problem with my "New Products" Listing on my category pages. On my HOME page, the listing is of new products sorted from new to old. When I click on one of my categories, my new products listing is totally random. In fact, it changes every time I reload the page.

I'm sure it's something I did, but I have no clue how to fix it.

My Shop -- http://www.jilbert.org/shop/

Thanks in advance,
Jill

[kobra]

No that is normal and you will also find that the products when viewing a product are in that same category if I recall correctly

[jilbert]

Yes ... it only shows the items in the same category ... but they aren't showing the newest first.

Are you saying this is how it's suppose to be? If so, can I fix it so it basically shows the newest first?

[mesnitu]

You have to override the modules/new_products.php
Not quite into the zenway, but for what I've seen, if you change

if ($new_products_query != '') $new_products = $db->ExecuteRandomMulti($new_products_query, MAX_DISPLAY_NEW_PRODUCTS);

to

if ($new_products_query != '') $new_products = $db->Execute($new_products_query, MAX_DISPLAY_NEW_PRODUCTS);

And
$new_products->MoveNextRandom();
to
$new_products->MoveNext();

In the query, you make a ORDER BY products_date_added ... Not sure the name of the field.
Or use the sort order, and order by that.
Anyway, it's more or less this way.
But I think that the random makes more sense, because a customer, can see different products
For specific products, perhaps the featured module....or even copy all that related to new products, and make a new module, that would query by the date.