Upcoming in 2 months shows in current month new products why and how can I remove

[nwironsales]

When I add a new item and schedule it to arrive on December 1, 2006 it shows up in new products for October. I would rather it now show up under New products since it has not arrived yet. Is there anyway to change this?

[Ajeh]

In the products table is the field:
products_date_added

This is the field used by the New Products ...

While you cannot change this date via the Zen Cart Admin, as that is the real date that the Product was added ... you can edit the date via phpMyAdmin to make it older than the date on your New Products setting ...

Or, you can change all of your settings for New Products to not allow for products_date_available when set to in the future ...

[nwironsales]

Thanks for the reply but I am not sure I can do this. What would you suggest is the best method?

I am a novice with Zen Cart and your help still confuses me some.

In the products table is the field:
products_date_added

This is the field used by the New Products ...

While you cannot change this date via the Zen Cart Admin, as that is the real date that the Product was added ... you can edit the date via phpMyAdmin to make it older than the date on your New Products setting ...

Or, you can change all of your settings for New Products to not allow for products_date_available when set to in the future ...

[Ajeh]

The easiest method is to use phpMyAdmin and fix the products_date_added field to be older than your New Product setting so the upcoming do not show in the New Products ...

Otherwise this would require code changes that you may not be prepared to customize on your own ...