Prevent Doc-Gen from 'New Products'

**robinstl** · 1 Dec 2007, 06:15 PM

I am attempting to create a simple gallery of items that are NOT for sale by specifying them as 'documents - general', but they show up in 'New Products' and 'New Products for December', etc and I'd like to prevent this.

I posted this before and I got this response...

Code:

Make them OLD and not NEW ... 

Change the field in the database for the products_date_added to an older date than your definition of New Products that you have Naturally set in the Maximum Values ...

Quote:
New Product Listing - Limited to ...
Limit the New Product Listing to
0= All Products
1= Current Month
7= 7 Days
14= 14 Days
30= 30 Days
60= 60 Days
90= 90 Days
120= 120 Days

I can figure out the Maximum Values part but am a little unclear on 'Change the field in the database for the products_date_added to an older date'

Could someone clarify how to go about this or have any ideas that may help? I appreciate all input.

Thanks :)

**Ajeh** · 1 Dec 2007, 06:51 PM

If you browse your database products table in phpMyAdmin you will find there is a field called products_date_added ...

This is the physical date that you added the Product to the database ...

If all Products that are products_type 3 had a products_date_added of:
2003-02-21 06:08:17

Then those Products are outside the range of the New Product definition that you set and will not show in the New Product sidebox, centerbox nor New Product Listing ...

**robinstl** · 1 Dec 2007, 08:04 PM

Originally Posted by Ajeh

If you browse your database products table in phpMyAdmin you will find there is a field called products_date_added ...

This is the physical date that you added the Product to the database ...

If all Products that are products_type 3 had a products_date_added of:
2003-02-21 06:08:17

Then those Products are outside the range of the New Product definition that you set and will not show in the New Product sidebox, centerbox nor New Product Listing ...

Okay... I'm there. Do I have to manually edit the date for each 'type 3' product or is there a way to automatically do this via PHP?

Thank you

**Ajeh** · 2 Dec 2007, 06:52 AM

Backup database first ...

Next, backup the database ...

Followed by repeat step 1 and 2 ...

Next, you can run this either in phpMyAdmin or in your Zen Cart Admin in the Tools ... Install SQL Patches ...

PHP Code:


UPDATE products SET products_date_added = '2003-02-21 06:08:17' WHERE products_type = 3;

Voila!

**robinstl** · 3 Dec 2007, 02:50 PM

Thanks for responding back Ajeh. I am correct in assuming that I'm going to have to update the DB everytime something is added as a 'document-general'?

Thanks :)