BV Commerce Forum
»
BV Commerce Support
»
General Support
»
** REPLACED BY SP3-J ** HOTFIX SP3-D - Fix for category relevance sort issues
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
***** THIS WAS REPLACED BY SP3-J **********
The sorting for the search stored proc was not taking relevance into account. This has been fixed. Also, some of you have questioned why we have changed the searching at this point in the software. Well, the reason is that some customers with larger stores have had issues with the searching. We needed to have a more flexible search stored proc in order to do this. We also had complaints that the searching was no longer paged (which led to some performance issues as well), we have hopefully addressed these issues.
In order to run this file you will need to run SQL Server Management Studio and open the file, then select the database you want to patch from the "Available Databases" drop down list. You can hit F5 to run the patch or click "Execute" on the menu. |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Rank: Member
Joined: 11/25/2007(UTC)
Posts: 13
|
Better, but we're getting repeated products in the same search. I'd use the same example as earlier with the wine opener at www.promomanagers.comsearch for leeds vineyard wine opener - good results now search for wine opener - pretty good But at times we seem to be adding records. search leeds wine opener and we get the same product listed 3 times. Also, usually the search will allow users to click NEXT or to page two even if there is no page two. Once there they are in the dead zone. The search no longer works and returns zero no matter what is entered. |
|
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
I have updated the stored proc in this service pack. It had only been downloaded once, so you are the only person to use it thus far. Please download it again and see if it fixes your issue. |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Rank: Member
Joined: 11/25/2007(UTC)
Posts: 13
|
That seems to handle the multiple products issue. Was that also correcting the extra pages?
I'm curious if we can customize this ourselves to return "leeds wine opener" to return items that have leeds+wine+opener in the results first. It still returns products with just "opener" first. |
|
|
|
|
|
|
Rank: Member
Joined: 6/26/2006(UTC)
Posts: 351
|
I downloaded it and applied it almost an hour ago! So I'll download it again tonight. :)
Thank you for coming out with the hot fixes so quickly! |
|
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
It should be returning any results with all search terms first. Are you still not seeing this behavior? |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
Oh, I believe I see what you are talking about. You want it to split it up and then return items with more than one search term higher in the list. We will look into this to see if it is possible with the current setup that we have. Thanks for the feedback. |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Rank: Member
Joined: 11/25/2007(UTC)
Posts: 13
|
Justin I'm not really sure about the terminology but that sounds about right.
On the site search for leeds opener. The first one that is returned isn't even from Leeds which is weird. I just checked the product itself, nowhere is the word leeds occuring which is why we can't figure out why that's the first one on the list?
There are leeds openers though, yes they are returned, but behind terms with less relevance.
I'm sure this will help everyone refine their searches and we appreciate the quick responses. It's useful now, but I think we're a step away from a very, very efficient search.
Updated, with just product name and sku as search fields it's still not putting the most relevant terms first. We figured you would want to know only SKU and Product Name are being searched. When long description and keywords were enabled the results were the same. |
|
|
|
|
|
|
Rank: Member
Joined: 1/3/2004(UTC)
Posts: 1,497
|
I'm not seeing an error message when no results are returned. I'm also not seeing anything in the Reports/Keyword Searches. |
|
|
|
|
|
|
Rank: Member
Joined: 3/15/2007(UTC)
Posts: 126
|
Is this download not available now? The link will not let me download the update. |
|
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
It should be, I was able to download it from the link above. |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
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.