logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error

Options
Go to last post Go to first unread
judy at Web2Market  
#1 Posted : Wednesday, October 28, 2020 6:36:11 AM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 286

Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
Using 9.0.2 Sql Search, searching for "tent" brings up a product like 54 can cooler with following in description, along with other weird results. Searching for the same on their Gold site with Sql Search didn't do it.

Perfect soft cooler to bring what you need to any event
Great for a BBQ, the beach, sports events, gatherings, and more
Keeps the ice up to 3 days at temperatures up to 90F
Zippered design helps keep contents cool
Holds up to 54 standard cans
Front pocket can easily store a phone, wallet, keys, etc
Collapsible for space-saving and compact when not in use
Expands up to 15" x 15" x 9"
Adjustable shoulder strap makes it easy to take on the go

Nothing in sku, name, search keywords with "tent" in it.

Why? Maybe because of "contents"?

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.

Joe Payne2  
#2 Posted : Wednesday, October 28, 2020 6:42:52 AM(UTC)
Joe Payne2

Rank: Advanced Member

Groups: HelpDesk, Developers
Joined: 11/9/2018(UTC)
Posts: 564

Thanks: 122 times
Was thanked: 26 time(s) in 25 post(s)
the letters 'tent' are in the word 'contents' in that description, so yea I'd say that would have to be the reason. Seems like the search is doing a %tent% query perhaps?
ray22901031  
#3 Posted : Wednesday, October 28, 2020 10:04:20 AM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 826

Thanks: 3 times
Was thanked: 13 time(s) in 13 post(s)
The search options when it comes to MSSQL are quite weak in Ablecommerce, at least compared to other platforms. I am starting to rely more on the additional search keywords under the additional settings of products to better refine my results.

We have identified our top 50 products, and using Google search and some backend SEO tools, we can determine what search parameters people are using to search for products. We are making sure that the search parameters are included in the additional search keyword setting.

It's amazing to us that people still use the term "walkie-talkie" when referring to, professional two-way radios that can cost over 1K each.

I hope this helps
shari  
#4 Posted : Friday, October 30, 2020 10:51:13 AM(UTC)
shaharyar

Rank: Advanced Member

Groups: Admin, Developers, Registered, HelpDesk, Authorized User
Joined: 10/5/2018(UTC)
Posts: 703

Thanks: 5 times
Was thanked: 113 time(s) in 112 post(s)
Quote:
Searching for the same on their Gold site with Sql Search didn't do it.


There are two similar options in Gold and AC9 as search providers. In Admin - Configure - Store
I am able to see similar results in both versions.

SQL: Search keyword 'tent' will list the product with the word 'content' in the description
Full-Text Search (SQL Server): Search keyword 'tent' will not list the product with the word 'content' in the description
Users browsing this topic
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.