New products shows newest first - how?

[Azeela]

Hi all..

Is there any way to make my newest new product first on my new product list?

I can understand that the list is random when I've added multiple products at the same date, but now I added a single product in the believe that it would appear first, but it doesnt?
Could it do that?

[kuroi]

Hi all..

Is there any way to make my newest new product first on my new product list?

I can understand that the list is random when I've added multiple products at the same date, but now I added a single product in the believe that it would appear first, but it doesnt?
Could it do that?

You haven't said which new product list. There are three, the side box, the listing box on the home page (and others) and the new products listing page.

In each case you would need to re-write the database query that extracts the data to order it by date added, and then re-write the PHP that steps through the list to remove the randomising.

[Azeela]

It's the box on my mainpage with just one product that's the most important. Well my sidebox thing will probably follow I guess, but it's the one in the main area that concerns me the most.

But where do I find where to rewrite what you said?

[kuroi]

Oh but you are so in luck. The specific change that you would need to make to achieve what you want is very easy indeed. You would over-ride your includes/modules/new_products.php file and in your copy would change this line (near the top)

$display_limit = zen_get_new_date_range();

to be this

$display_limit = ' order by p.products_date_added desc limit 1';

[Azeela]

Wohoo!!! Thanks SO much!!