Zen Cart Logo
Forums / Templates, Stylesheets, Page Layout / Excluding items from "New Products"

Excluding items from "New Products"

Locked

Views: 1,148

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
11 Aug 2008, 1:52 PM
#1
thorcusmodee avatar

thorcusmodee

New Zenner

Join Date:
Nov 2007
Posts:
20
Plugin Contributions:
0

Excluding items from "New Products"

Hi Folks, I have added a new product range but don't want it to dominate my "new products" section. I have found a previous thread where it was suggested the product date field could be altered in the database to make the products appear older. Is this the best way to do it? Is it possible to exclude a category from the new products section? I have no idea how to edit the database - any ideas?
Thanks in advance.

11 Aug 2008, 3:13 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Excluding items from "New Products"

Changing the products_date_added to be older than your setting on the New Products would block these from being seen, and is the most effective method to do this ...

12 Aug 2008, 7:48 AM
#3
thorcusmodee avatar

thorcusmodee

New Zenner

Join Date:
Nov 2007
Posts:
20
Plugin Contributions:
0

Re: Excluding items from "New Products"

Hi there, thanks for the response, unfortunately it means nothing to me :cry:
I assume this is a field in the database? If so how do I get in there to change it?
I am sorry to say I know nothing about software, it has been an enormous challenge to get this far but this issue has me beaten.
Best Regards,
Dave.

12 Aug 2008, 3:07 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Excluding items from "New Products"

The field products_date_added is put into the products table when you create a new record ...

This date is the current date and more or less gets the New Product placed into the New Products definition for sideboxes and New Products Centerbox and New Product Listing ...

When you don't want a New Product to be part of the New Products, because of this date, you have to change the date ...

Another way to do this is in the Zen Cart Admin with a bit of care given to running the following command from the Tools ... Install SQL Patches ...

UPDATE products SET products_date_added ='2008-07-15 11:07:13' WHERE products_id = XXX;

You need to know the products_id for the Product you want to change and replace the XXX ...

You may also need to change the date used for this, depending on how you have defined the New Products ...

It is a good idea to backup your database until you get use to using this ...