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:

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.



Submit a Comment

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

elan creative

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

Elan Creative
UK: +44 (0)121 288 3449
NL: +31 (0)20 893 2923

freelance-website-designer s


Get a free quote for your website design project: