New Products in v2

**rjdj2005** · 11-02-2005, 06:27 AM

Hello,

I have searched thru here and have yet to find a solution to keep new products showing even though they were in a previous month. If someone could point me to where I can make the change to keep products up on the main page without having to go into either easy populate or mysql to change the date added to the current month.

Thanks
RJ

**Maximon** · 11-10-2005, 11:10 AM

I just had this same problem, and found a relatively easy fix.

Go to /catalog/includes/modules/new_products.php

Find this code...

$new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, p.products_price as products_price from " . TABLE_PRODUCTS . " p where products_status = '1' and month(p.products_date_added) = month(now()) order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

Change to this code...

$new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, p.products_price as products_price from " . TABLE_PRODUCTS . " p where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

Basically this where the script is saying if there is a product, and the date created is this month, show it in the table.
You are changing this statement to; if there is a product, show it in the table.

I tested it pretty thouroughly and it seems to work 100%

**michael_s** · 11-10-2005, 01:42 PM

This post is funny to me... Only because your 'fix' is exactly opposite of all the posts from about 6 months ago... See back then, osCMax automatically did what you are saying above, by default, and everyone complained that it was not working right... So, we fixed it...

And now, of course, all we see are questions about how to 'fix' this again, effectivly changing it back to its 'broken' function. If you spend too much time on this stuff, it starts making you laugh.

Just making an observation ... carry on!

**timbrrr** · 11-10-2005, 03:05 PM

How about a fix to the fix before the fix that was the new fix? ha ha
kind of reminds a person of a certain cola...
anywho, I wonder if there would be a way to insert the option in admin to display the last XX number of items added to the catalog, or the items this month only... and/or a third option ... to kill the new items period... and have the option to add a list of admin controled "featured items"
but then again, this would be so complicated that even more questions regarding configuration would be posted.... ok, I'll stop rambling and dreaming out loud...

**cesara** · 12-02-2006, 04:03 PM

Originally Posted by Maximon

I just had this same problem, and found a relatively easy fix.

Go to /catalog/includes/modules/new_products.php

Find this code...

$new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, p.products_price as products_price from " . TABLE_PRODUCTS . " p where products_status = '1' and month(p.products_date_added) = month(now()) order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

Change to this code...

$new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, p.products_price as products_price from " . TABLE_PRODUCTS . " p where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

Basically this where the script is saying if there is a product, and the date created is this month, show it in the table.
You are changing this statement to; if there is a product, show it in the table.

I tested it pretty thouroughly and it seems to work 100%

Just FYI, this worked like a charm....for what it's worth.