I am facing a weird issue in magento enterprise version I have created a configurable product with SKU "CVR" but when I search in top search bar, I get no result for this SKU.

If I change the SKU value to something else like "5656" or "ABCD", it gives me the product in search.
I have reindexed every time and flushed all cache after I make any change to product even if all cache are disabled. Still I am not able to search using the SKU value "CVR". Please guide.


This is probably because the default MySQL full text function is set to 4 characters, which means you can only search words that have 4 or more characters, which is why "5656" and "ABCD" work.

You can decrease this to 3 characters, which will allow you to search on "CVR" or something.

To achieve this, you have to change the ft_min_word_len option in your MySQL settings:


More info on how to achieve this can be found in the MySQL docs:


  • Hi Maikel, I found that you are right about query length. But there is also a product with SKU "2558" and it is also not appearing in search results. Can there be any other issue?
    – John
    Mar 26 '15 at 10:39
  • As far as I'm concerned that should work.. Have you reindexed your tables? And can you update your question with the query you perform? Mar 26 '15 at 11:11

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.