I found a product using a specific search in my store at #5 in the middle of my product grid. I'm using "Combined" for search. All but "Name" attribute is searchable....why is it #5 and not #1 on the top row?

Our site has really funky search results. Ideas?


The native MySQL search engine indexes all attributes you have configured to be indexed for search. On top of that, it runs an OR operation on matching words. So, you'll get all kinds of results if you let attributes like description be indexed.

This has some bullet points you might find useful: http://www.demacmedia.com/magento-commerce/5-tips-improving-on-site-search-results-using-magento-and-apache-solr/

  • I found one thing on that link useful. I used the search terms redirect to get some specific keywords to specific page. – Daniel Mar 11 '15 at 14:21
  • Is there a way to change the OR operation to an AND operation? – Michael Yaeger Feb 21 '17 at 18:41
  • @MichaelYaeger, I haven't looked at this in a while, but yes, you can do this if you overwrite some methods. I believe there were articles on how to do it on the Internet. – musicliftsme Feb 21 '17 at 18:48
  • Is this directly related to the "Like" and "Fulltext" options in the "Catalog Search" settings? – Michael Yaeger Feb 23 '17 at 6:16

Simply because the internal search is terrible, the most accurate we have come across is Solr. There are other extensions but they, although better than internal, also have inconsistencies.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.