BV Commerce Forum
»
BV Commerce Support
»
General Support
»
preventing a product from showing up in a search
Rank: Member
Joined: 6/1/2004(UTC)
Posts: 720
|
I have a few products that are really only for those that have been provided a direct link. Is there a way to hide a certain product from the search?
Thanks,
Derek |
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
I can't think of anything outside of a customization. There are many ways to do this, but here's a pretty simple one:
Define a new Product Type and assign these hidden products to that Product Type. Then modify the stored procedure that performs the searches to exclude that Product Type. |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 6/1/2004(UTC)
Posts: 720
|
Thanks Aaron,
I will give that a shot.
Derek |
|
|
|
|
|
|
Rank: Member
Joined: 8/16/2007(UTC)
Posts: 27
|
Aaron,
Would it be possible to be more specific with your suggestion? ... for those of us that are not seasoned programmers. How do I find the stored procedure that performs the searches and how do I modify it? |
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
Shelly,
You need to modify the bvc_Product_StoreSearch_s stored procedure and add something like " ProductTypeId <> 'bvin of hidden Product Type' " to the WHERE clause. |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.