I have a product named C.I.D

However, I am not able to search it in Magento 2.0

I guess it's related to the dot character.

Anyone got idea on how to fix it?


2 Answers 2


Are you trying to search for it via the admin view? If so, that might be a bit more complex to solve. (I might recommend you search by SKU instead in the admin.)

Or, are you trying to search on the front end of the site? If so, I'd recommend trying to set up a search term in the admin area of the site:

Custom Search Term

In this case, this would allow someone who searches on "C.I.D" to auto-magically redirect to the proper page, http://domain.com/cid.html

I did just test this, and it did redirect me over to the http://domain.com/ site (but it gave an error 404 message):

Domain.com - error 404 page

Let me know if this works.

  • Thanks for your support. I am trying to search in front-end. Your solutions seem not supporting partial keyword search? Actually I need to enter many combination to support a correct search (e.g. C.I , C.I. , I.D , etc)
    – Leo Chiu
    Feb 21, 2017 at 10:05
  • Leo - Sure... if you need to do partial searches, I'd add them each in as a term. That way you're covered. Feb 21, 2017 at 15:16
  • But for those catalog without "dot" (e.g. tshirt, jeans, etc), I am able to get correct result with partial searches. Do you think maybe the SQL query cannot handle dot?
    – Leo Chiu
    Feb 22, 2017 at 4:02

This is a limitation of the MySQL fulltext search engine. You may be more lucky by using a real search engine module.

If using Enterprise, give a try to ElasticSearch (or SolR but it is deprecated). If using Community or Enterprise, you may have good result using ElasticSuite (also ElasticSearch based) : https://github.com/Smile-SA/elasticsuite

Disclosure : I am the main developer of ElasticSuite.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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