Adding more limited days for the new products box

[Princess]

I have now in my admin under New Product Listing - Limited to ... the following days:

Limit the New Product Listing to
0= All desc
1= Current Month
30= 30 Days
60= 60 Days
90= 90 Days
120= 120 Days

How can I add more days? for example 3 or 7 days

[Ajeh]

You would need to set the configuration_key SHOW_NEW_PRODUCTS_LIMIT for the number of days ...

In theory, anything not set to 0 or 1 will be that many days ...

[Princess]

Hi

That is what I meant what is not working, I have changed that, in the new_products.php and all other files where these lines are in, but nothing changes in the admin file.

[Ajeh]

Note: that this theory would only work in v1.3.5 ...

What version of Zen Cart are you running?

[Princess]

Hi Ajeh,

I am using 1.2.7,

[Ajeh]

Well ... that isn't going to work then without a lot of coding ...

The new method uses a totally different scheme for obtaining New Products based on date to speed up the processes ...

The old method used date math in a more primative way and it really slowed things down on large sites ... or sites with poor configuration of MySQL ...

You can try a search via the Tools ... Developer's Tool Kit ... in the bottom input box for:
SHOW_NEW_PRODUCTS_LIMIT

This should locate all of the code that needs to be customized in v1.2.7 ...

[Princess]

Well ... that isn't going to work then without a lot of coding ...

The new method uses a totally different scheme for obtaining New Products based on date to speed up the processes ...

The old method used date math in a more primative way and it really slowed things down on large sites ... or sites with poor configuration of MySQL ...

You can try a search via the Tools ... Developer's Tool Kit ... in the bottom input box for:
SHOW_NEW_PRODUCTS_LIMIT

This should locate all of the code that needs to be customized in v1.2.7 ...

Hi Ajeh,

That is what I have tried before, but the admin doesn't change for some reason...

[Princess]

I shall explain more precisely what I have done.

I have searched for every file where :

case (SHOW_NEW_PRODUCTS_LIMIT == '30'):
$display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) <= 30';
break;

was in,

I have changed that to

case (SHOW_NEW_PRODUCTS_LIMIT == '3'):
$display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) <= 3';
break;

But the admin doesn't change, it still shows

Limit the New Product Listing to
0= All desc
1= Current Month
30= 30 Days
60= 60 Days
90= 90 Days
120= 120 Days

When I choose 30 days hoping that that will be 3 days, then the box shows all products randomly

[Ajeh]

The choices do not change just because you changed the code ...

You would need to manually edit the configuration_key for that from 30 to 3 in phpMyAdmin and see if that works for you ...