Prevent Doc-Gen from 'New Products'

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...

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 :)

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 ... :smile:

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 ... :smile:

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

Backup database first ...

Next, backup the database ...

Followed by repeat step 1 and 2 ... :smartalec:

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

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

Voila! :cool:

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 :)

Only if you don't want then to show under New Products ...

Or, you could customize the code to skip products_type 3 on the SELECT statements ...

Ajeh:

Or, you could customize the code to skip products_type 3 on the SELECT statements ...

Man... you are a TEASE!