Magento search for 3 letter word produces no results

by | Dec 2, 2013 | 0 comments

You can set the Magento search in admin>system>configuration>catalog>search to min of 3 characters. However you’ll probably find that after changing this setting you still get NO results for a 3 letter word.

You’ll probably also need to change the mySQL full text word length variable ft_min_word_len. By default this value is 4, resulting in 3 character words not being indexed.

To change the full text word length variable to 3 add this to your my.cnf:

ft_min_word_len=3
Restart mysql

# service mysqld restart
Finally reindex the magento catalog, you can do this via GUI or command line.

$ php magento/shell/indexer.php reindexall
After the reindex completes you should be able to search your magento store succesfully with 3 character search terms.

Source: https://www.linuxconsultantsireland.com/content/magento-product-search-using-search-term-less-4-characters-returns-no-results

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

elan creative

We’re like the in-house website design and support team you always dreamed of, able to tell your story like nobody else, and focus on your bottom line along with you….

Elan Creative
hello@elancreative.studio

freelance-website-designer s

QUOTE

Get a free quote for your website design project:

Privacy Overview
Elan Creative webdesign Haarlem

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

Strictly Necessary Cookies

Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.