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:
it's weird because catalogsearch_results show product id
Any idea how to fix this?
What is the Search Type set to in admin -> system -> configuration -> catalogue -> catalogue -> catalog search?
Try delting your var/cache folder using an FTP program. All SQL queries are hard cached and cannot be refreshed without deleting this folder.
I noticed that if SKU is AV50F, search works. Instead if SKU is AV-50F, search is not working. Any suggest?
@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:
I'm using Magento 184.108.40.206.
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.