Turning on 'Button' or 'Link' to show just 'New Products'

I have searched thru pages of posts looking for info on how to offer customers a chance to click somewhere, to just see the New Products that have been added in the past 30 or 60 days.

Is there a way for customers to just see what's new instead of having to find the new products in the whole store?

I have New Products for the Month of "?" turned on that will show them a few at a time on various pages. I just changed that to display the new products for 60 days instead of just the current month.

Now I'd like to make it easier for the customers to find just the new products. Could someone please point me in the right direction, if it is even possible? Thank you.

Using 1.3.8a, has not been upgraded from a previous version, only add on is Free Red template.

By default ...

In the Categories sidebox is a link for New Products ...

In the New Products sidebox is a link for New Products ...

In the Site Map is a link for New Products ...

You could add a link to the New Products centerbox as well ...

Ajeh:

By default ...

In the Categories sidebox is a link for New Products ...

In the New Products sidebox is a link for New Products ...

In the Site Map is a link for New Products ...

You could add a link to the New Products centerbox as well ...

Thank you Linda.

I checked the Categories box, the link is turned ON.

When I click on the Site Map link on my site, I get a syntax error with lots of code that I would need a programming degree to interpret.

In the Admin area, I have not been able to find the New Products sidebox or the Site Map area to try to configure them. I know I've seen those before but cannot find them now. Could you please point me to them? Sorry for being thick but after looking at all the cryptic choices in each drop down my eyes are not seeing the things I need to that you're telling me are there. Thanks.
George

actionjackson57:

Thank you Linda.

I checked the Categories box, the link is turned ON.

When I click on the Site Map link on my site, I get a syntax error with lots of code that I would need a programming degree to interpret.

In the Admin area, I have not been able to find the New Products sidebox or the Site Map area to try to configure them. I know I've seen those before but cannot find them now. Could you please point me to them? Sorry for being thick but after looking at all the cryptic choices in each drop down my eyes are not seeing the things I need to that you're telling me are there. Thanks.
George

Hi again Linda. I miss typed the above line. When I clicked on the New Products link in the site map on my site, I got the syntax error, not when I clicked on the Site Map link. Funny thing is that when I went back to look at it after, the link was gone altogether.

Could you post the error that you are getting?

Do you get it from both the sidebox and the site map?

If you try to change the URL manually to:
/index.php?main_page=products_new

do you get the error?

Ajeh:

Could you post the error that you are getting?

Do you get it from both the sidebox and the site map?

If you try to change the URL manually to:
/index.php?main_page=products_new

do you get the error?

Yes, I do get the error, as below.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, 0' at line 11
in:
[SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status, p.master_categories_id FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id), products_description pd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 and p.products_date_added >=20100401 order by p.products_date_added DESC, pd.products_name limit -0, 0]

Linda, I had also put the following into my last email but there was no response to it. I'd appreciate it if you could even tell me where to look in the manual or in Admin. Thanks again.

"In the Admin area, I have not been able to find the New Products sidebox or the Site Map area to try to configure them. I know I've seen those before but cannot find them now. Could you please point me to them?"

Look in your Maximum Values ... it looks like you have settings set to 0 related to New Products ...

Ajeh:

Look in your Maximum Values ... it looks like you have settings set to 0 related to New Products ...

Thanks Linda, that was it. I had the values set for every other occurrence of New Products but one. To me, there was certainly nothing in the name of it to suggest it would dictate whether or not the New Products link worked. Just asking the number of images per page which I thought meant, what would show up on every page, throughout the site. I am so grateful that this forum is available with such knowledgeable people as yourself to guide us newbies along. Thanks again so much.
George

PS Can you please tell me where to turn on the links for the New Products that would show up near the Log In, Returns or Contact Us links?

That sounds template specific from your description ...

You can look how the link is build in the Categories sidebox and add that same thing to where you need it ...

Thank you Linda. Your help is always appreciated.
George