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 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
UK: +44 (0)121 288 3449
NL: +31 (0)20 893 2923

freelance-website-designer s

INSTANT QUOTE

Get a instant quote for your website design project with our cost calculator:

LATEST DESIGNS

 

dental practice website design

LR Smiles

Website design for brand new dental practice LR Smiles

 

LATEST DESIGNS

 

hypnotherapy website design

 

Nalam Hypnotherapy

Website design for brand new hypnotherapy practice, Nalam Hypnotherapy