Rank: Member
Joined: 4/30/2007(UTC)
Posts: 383
|
www.promomanagers.com search pens Search returns hats among other things. The hat does not have the word pen anywhere in the descript ion or admin. I have no idea where it's getting a hat is related to a pen but it's the #2 search item. I'd work on amending the search. Because the keyword search is busted we only found these problems by watching customers come and go on sightmax.
|
|
|
|
|
|
Rank: Member
Joined: 12/11/2006(UTC)
Posts: 3
|
This low profile anvil cap is an inexPENSive cap with a high quality feel. Great as a giveaway to employees or clients attending a sporting event.
|
|
|
|
|
|
Rank: Member
Joined: 4/30/2007(UTC)
Posts: 383
|
Yep we caught that later, we were looking for the word pen or pens. Obviously that's not really the way this should work in picking up fragments of whole words.
Is there a possible fix BV?
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
C,
The "way it should work" depends on the merchant, their products and their customers. Partial matching covers the broadest amount of our customer base at this time but we're always open to suggestions.
|
|
|
|
|
|
Rank: Member
Joined: 4/30/2007(UTC)
Posts: 383
|
Marcus but why would it pick out a combination of letters? I've never been to an ecommerce site that does that. Shouldn't it look and place complete matches before partial?
By that logic if our site sold nuts and donuts and someone searched for nuts they'd get donuts first.
|
|
|
|
|
|
Rank: Member
Joined: 1/3/2004(UTC)
Posts: 1,497
|
Perhaps an option in the Admin Search settings to select whole words only or select word fragments. |
|
|
|
|
|
|
Rank: Member
Joined: 3/3/2006(UTC)
Posts: 1,737
|
Maybe search could automatically append searched terms with a space before and after each word or words in a string.
A search for 'pens' would become '_pens_' and wouldn't find inexpensive, but would still find 'gift pens'.
A search on my site for 'vase' returns results for vases and wall shelves, because they make a nice spot to place a vase, but returns nothing for 'vases'. Jeesh! |
Optimists invent airplanes,
Pessimists buy parachutes. |
|
|
|
|
|
Rank: Member
Joined: 4/30/2007(UTC)
Posts: 383
|
The search is workable now but it's in need of work.
Right now if a customer searches for a sku, say 123 every other item.... HBC123C ABC123 NOT123 will return before 123 alone. That's just not the norm.
|
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
Here is a new stored proc that adds some better whole word matching, please try this out on your store and let me know how it works for you. If we feel that this is a significant improvement, then I will release it as a hotfix and we will include it in SP3.1
**** REMOVED AND UPDATED ***** |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
Oh, and I am still working on the empty search issue. |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
Here is the latest version of the search stored proc. It should have resolved the blank search terms issue now as well
*** removed and updated below *** |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Rank: Member
Joined: 3/24/2005(UTC)
Posts: 311
|
Applying this Stored Procedure works fine but, I am having a problem that is a little wonky in relation to this. If we do a search of a keyword that has multple pages and the user clicks beyond the first page it results in a blank page?? Example: http://www.tvps.com/Search.aspxIn Keyword type in 3750 Click on Go. It shows multiple pages. Click on the next page button and it results in a blank second page? |
|
|
|
|
|
|
Rank: Member
Joined: 3/3/2006(UTC)
Posts: 1,737
|
Jon,
3750 - Search page 1 shows 11 items, page 2, 8 items, page 3, blank.
If you go straight to 'last page', it's blank.
A search for 'cassette' shows 10+ pages, only the first shows results. |
Optimists invent airplanes,
Pessimists buy parachutes. |
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
Sorry, here is the same stored proc that shouldn't have the weird paging issues, I believe it has to do with inactive products....
*** updated further down **** |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Rank: Member
Joined: 3/24/2005(UTC)
Posts: 311
|
It still having the same problem after applying your new Stored Procedure. |
|
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
Sorry, I just deleted that because I believe I just found the issue playing around in my database. I deleted it before I saw your post. |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Rank: Member
Joined: 3/24/2005(UTC)
Posts: 311
|
I saw your last post. If you want I can email you access to my sql DB to look around too? |
|
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
Yes, that would actually be quite useful. |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Rank: Member
Joined: 3/24/2005(UTC)
Posts: 311
|
I just sent you the info. |
|
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
I'm looking into it now, thank you. |
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.