Zen Cart Logo
Forums / Setting Up Categories, Products, Attributes / Selecting which products are new for the current month

Selecting which products are new for the current month

Locked

Views: 1,855

Results 1 to 10 of 10
This thread is locked. New replies are disabled.
30 Oct 2006, 3:56 AM
#1
jeanmichel avatar

jeanmichel

New Zenner

Join Date:
Oct 2006
Posts:
43
Plugin Contributions:
0

Selecting which products are new for the current month

Hi,

I'm starting to build a new site so i'm in the process of uploading all of my images to the server with the "create new product" button.

But all of those product arent necessarily good to fit in the "New for the current month" centerbox.

I want to be able to select only the pertinent products to be shown in this "New for the current month" centerbox.

How do i do that?

Thanks for the help.

30 Oct 2006, 4:48 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Selecting which products are new for the current month

The "new" status is based on the date the product was added to your catalog.

To change that info, you would have to get your hands dirty with raw database editing for each individual product ... the "products_date_added" field in the "products" table.

https://www.zen-cart.com/tutorials/index.php?article=3

30 Oct 2006, 4:58 AM
#3
jeanmichel avatar

jeanmichel

New Zenner

Join Date:
Oct 2006
Posts:
43
Plugin Contributions:
0

Re: Selecting which products are new for the current month

mmm, i was anticipating it.

Thanks doc. I suddenly have another plan to get to what i want. I'll try and then i'll post back.

16 Mar 2011, 1:32 AM
#4
dansault avatar

dansault

New Zenner

Join Date:
Mar 2011
Location:
Detroit Area
Posts:
3
Plugin Contributions:
0

Re: Selecting which products are new for the current month

DrByte:

The "new" status is based on the date the product was added to your catalog.

To change that info, you would have to get your hands dirty with raw database editing for each individual product ... the "products_date_added" field in the "products" table.

I cannot believe that this fundamental function cannot be done through a module or a control panel. This is a shining example of why ZenCart is NOT user friendly. Furthermore, your remedy of where this database editing is done is vague. How about taking the time to carefully walk us through how and where it is done? As it stands, the new products displayed for a month appears to be a random selection that is based on questionable criteria. Why would one older item continue to show as new, when newer items do not display? Has no one found an easy remedy for this oversight in thoughtless engineering?

16 Mar 2011, 2:20 AM
#5
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,611
Plugin Contributions:
0

Re: Selecting which products are new for the current month

So you had to find a 4 year old post to express your displeasure?

We are happy you joined us.

16 Mar 2011, 1:49 PM
#6
ajeh avatar

ajeh

Oba-san

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

Re: Selecting which products are new for the current month

Did you try to use the built in settings for defining what New Products are 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

16 Mar 2011, 3:28 PM
#7
dansault avatar

dansault

New Zenner

Join Date:
Mar 2011
Location:
Detroit Area
Posts:
3
Plugin Contributions:
0

Re: Selecting which products are new for the current month

So, this issue has remained unresolved for four years? Immagine the "displeasure" of the original person posting their call for help.

The New Product Listing, when expdanded (to 30 days for example), often chooses older products first; disregarding newer entries. I wish to select specific items whether older or new that are featured as "New for Month". This does not work for me.

Is there a thread that describes clearly how to "get my hands dirty" editing the "raw database?

16 Mar 2011, 3:37 PM
#8
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,611
Plugin Contributions:
0

Re: Selecting which products are new for the current month

If you want to pick and choose then rename the featured products display and go to town.

27 Mar 2011, 10:11 PM
#9
crbsmith avatar

crbsmith

New Zenner

Join Date:
Dec 2010
Posts:
11
Plugin Contributions:
0

Re: Selecting which products are new for the current month

thanks Ajeh, for the maximum values info - I needed to get older products off my New Products section and would never have found it!!

27 Mar 2011, 10:41 PM
#10
ajeh avatar

ajeh

Oba-san

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

Re: Selecting which products are new for the current month

You are most welcome thanks for the update that this helped you out ... :smile: