I am working on magento 2.1.3.
Is there any possibility to search with 2 characters using catalog search?
Now i can't able to search terms like tv.
magento-2.1magento2search
I am working on magento 2.1.3.
Is there any possibility to search with 2 characters using catalog search?
Now i can't able to search terms like tv.
Best Answer
I do not know your search engine, I suppose that you use Mysql. It works out of the box with ElasticSearch.
Resolution :
First set the minimun search characters to 1 in Magento configuration :
Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search
The data indexed (catalogsearch_fulltext_scope1) looks like :
The SQL query for 'tv' request:
If you check Mysql documentation, there are two parameters for Configuring Minimum and Maximum Word Length :
http://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
So edit your my.cnf file, add these parameters :
Restart mysql
Rebuild your index
Then you will see your product on the search result page.