Quick search by SKU not working

[skyw4lker86]

Hello,

i just upgraded to 1.9.1 from 1.7 and quick search with a SKU does not work.

Advanced search is working.

I already set attribute sku enabled both for advanced and quick search, reindex but no luck.

My database shows this:

catalogsearch_query

http://www.awesomescreenshot.com/image/55123/6bd3a73db17b744fb745bbd33a047dbb

catalogsearch_fulltext

http://www.awesomescreenshot.com/image/55136/6cbe00aca171abed6f0ac4b7b40208f3

catalogsearch_results

http://www.awesomescreenshot.com/image/55141/e840ed3fb578bda05b632ecbc52456f9

it's weird because catalogsearch_results show product id

Any idea how to fix this?

thanks

[skyw4lker86]

any help with this problem?

[Saggitator]

What is the Search Type set to in admin -> system -> configuration -> catalogue -> catalogue -> catalog search?

Cheers

S

[jonathonbyrd]

Try delting your var/cache folder using an FTP program. All SQL queries are hard cached and cannot be refreshed without deleting this folder.

[k4net]

I noticed that if SKU is AV50F, search works. Instead if SKU is AV-50F, search is not working. Any suggest?

[track_23]

@k4net I'm finding the same thing: that if there is a hyphen in the SKU it is not searchable; no hyphen it works just fine.

@Saggitator My search settings are:

• Minimal Query Length = 2
• Maximum Query Length = 128
• Maximum Query Words Count = 10
• Search Type = Fulltext
• Apply Layered Nav... = 2000
• Show Autocomplete Results Count = Yes

I'm using Magento 1.9.2.3.

[track_23]

I changed my Search Type setting to "Combine (Like and Fulltext)" and that seems to have fixed the problem of hyphenated SKUs not being searched. I imagine "Like" would also work, but I didn't try it.

[vishal_rathod]

I'm having the same issue with SKU such as "st-up" in my Magento 2.3.0. Any idea how to fix it?

---

@k4net wrote:

I noticed that if SKU is AV50F, search works. Instead if SKU is AV-50F, search is not working. Any suggest?

---