VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 General help me questions
 Make hidden categories unsearchable
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

bwalz
VP-ASP New User

USA
82 Posts

Posted - November 28 2011 :  14:09:03  Show Profile  Visit bwalz's Homepage  Reply with Quote
I have a hidden category that I don't want the products in that category to show up in search results from the cart. Currently they do show up when searched on. Does anyone know how to make a hidden category unsearchable?

Edited by - bwalz on November 28 2011 14:09:36

diegomilito
VP-ASP Expert

Argentina
723 Posts

Posted - December 14 2011 :  03:39:28  Show Profile  Reply with Quote
i can guide to do this :

- please edit file shopajaxsearchlookup.asp

- then search this code:
sSQL = sSQL & " and cc.intCatalogId=p.CatalogId and cc.intcategoryid=c.categoryid "

- please update to :
sSQL = sSQL & " and cc.intCatalogId=p.CatalogId and cc.intcategoryid=c.categoryid "
sSQL = sSQL & "AND (c.cathide is null)"

- Edit file shopproductcreatesql.asp

- Search code:
sql = sql & " AND (higherCatalogId is null)"

- update to :

sql = sql & " AND (higherCatalogId is null)"
sql = sql & " AND (c.cathide is null)"

Thanks, diego.
Go to Top of Page

bwalz
VP-ASP New User

USA
82 Posts

Posted - December 14 2011 :  14:09:13  Show Profile  Visit bwalz's Homepage  Reply with Quote
Thanks diego.
Go to Top of Page

diegomilito
VP-ASP Expert

Argentina
723 Posts

Posted - January 06 2012 :  04:03:22  Show Profile  Reply with Quote
bwalz, its ok.
Diego
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000