Hi, we're about to go live with our site http://carla.sg-host.com/index.php/
However we have noticed a problem with the quick search at the top. It appears to bring up all products no mater how precise the search is. Even a direct product sku now brings up all products. We're not sure how long this has been happening but it was working when we started development. The advanced search works no problem at all.
Any suggestions will be welcome.
Many thanks M&S
You could try to change the "like" to "full text" or "combine"..
Shero Design has a very good post about it here:
But I would recommend you to invest in a search module/extension, with search dropdown functionality, like Solr or Sphinx.
A great extension could be - Sphinx search from Mirasvit:
But be sure to clear with your hosting, that they support Sphinx / Solr before buying, there could also be an additional cost in setting up the search servers.
If you dont want "additional servers" have a look at e.g Aheadsworks: