VP-Cart Shopping Cart

Welcome, Guest ( Customer Panel | Login )

All Forums

VPCart Forum

Customization

New products, from specific Category

New Topic

Reply to Topic

Printer Friendly

Author

Topic

bengreen1980
Starting Member

27 Posts

Posted - January 21 2011 : 09:31:20

Hi Forum,

Any quick way to display only new products from a certain category?

I was trying this: shopdisplayproducts.asp?search=yes&cat=New%20Products&id=5

But has no effect...

support
Administrator

4679 Posts

Posted - January 24 2011 : 04:54:30

Hi Ben,

What you need to do is to create a category and then add the new products to this category.

We do not currently have a module where you can display on a page the latest products although it is in the wings.

Thank you.

Cam Flanigan
VP-ASP Cart Support

Follow us on Twitter:
http://www.twitter.com/vpasp

Mark Priest
VP-CART Expert

United Kingdom
580 Posts

Posted - January 24 2011 : 20:21:52

Would be nice, I've been asking for this for about 5 years! Not exactly rocket science is it.

Get from prodcuts where createddate = today minus x days = NEW

Regards,

Mark
Fireworks

carfin
VP-CART Expert

United Kingdom
948 Posts

Posted - January 25 2011 : 04:15:12

Or you can just create a link to a page that has this code:


'display all new products within the last 3 months
<%
newdate=date()-90
newdate=datedelimit(newdate)
sql="select * from products where hide=0 and cdateavailable>=" & newdate
debugwrite sql
setsess "sql", sql
response.redirect "shopdisplayproducts.asp?search=yes"
%>

This could easily be adapted to display products from only certain categories eg
response.redirect "shopdisplayproducts.asp?id=624&search=yes"

Regards,
Carrol
www.deanston-electrical.co.uk

support
Administrator

4679 Posts

Posted - January 25 2011 : 04:23:15

Genius!!!!!