How do I exclude some products from showing up in New Products listing?

[stargre]

Hi! I am not sure whether this would work. Any ideas?

I want to keep the 'new products for the current month' and 'Bestseller' showing on my website frontpage. But I want to exclude some items from showing up in these listings? How do I do that? The reason is that I have multiple gift certificates for sale, in different face values. But they are essentially the same thing. I don't want all of them to show up at the same time to bother customers. Any ideas? Thanks!

[Ajeh]

You would need to change the products_date_added to older than the limit on your New Product definition in the Configuration ... Maximum Values ...

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

[stargre]

You would need to change the products_date_added to older than the limit on your New Product definition in the Configuration ... Maximum Values ...

That's a great idea! Thanks!

[Crooked_Halo]

I need to exclude a whole categorie from showing in the New Products on the front page. Is the above fix the only way I can do this as I have over 60 items I would need to change?

[Ajeh]

IF the master_categories_id is the same on all 60 products, then you could do a global replace on the products_date_added to be older so that they are not included in the mix ...

Otherwise, you would need to customize the code to ignore products where master_categories_id = 1313 or what have you ...

[Crooked_Halo]

Oh my. I am sorry Ajeh - but that does not make much sense to me. I have only been using Zen for a couple of months and have no prior experience with css and php.

So how do I do a global replace? As all the items I want excluded from the front page New products for ** are all in the Adult Products categorie.

[onelove5683]

this is a great question

[zcnb]

this is a great question

Indeed. I have the same exact problem now. I read Linda's tip and I was able to change the "Limit New Products Listing to" to 7, but for the life of me I can't find where that "products_date_added" parameter is.

It's not the "Date Available" field in the product's main definition page, is it?

I tried to see if changing it would do the trick, but it doesn't.

I would appreciate any tip in this matter.

Thanks,
Daniel

[DrByte]

Indeed. I have the same exact problem now. I read Linda's tip and I was able to change the "Limit New Products Listing to" to 7, but for the life of me I can't find where that "products_date_added" parameter is.

It's a raw data field directly in the products table of your MySQL database ... a place one you probably don't want to go if you're not familiar with MySQL and databases.
There is no admin-area facility for editing the products_date_added field, as it's not intended to be changed in normal circumstances.

[zcnb]

It's a raw data field directly in the products table of your MySQL database ... a place one you probably don't want to go if you're not familiar with MySQL and databases.
There is no admin-area facility for editing the products_date_added field, as it's not intended to be changed in normal circumstances.

Thank you for this information - it is a great time saver.

I am familiar with databases and SQL (not so much in MySQL details but the principles are similar). However, I believe that in order to maintain future compatibility (e.g. in case of an upgrade), I should avoid any hacking not specifically intended by the developer(s) of a software product.

I guess that my only recourse is to turn off the "New Products For This Month" box completely.