Magento – Search catalog with less than 3 characters

catalogsearchmagento2

What is the solution to be able to search Magento 2 catalog with less than three characters.

This is what i have done so far from looking at Magento 1 info regarding this issue.

Setting "Max Query Lengt" in backend to 2
Changed the mysql setting ft_min_word_len=2 and restarted the server.
reindex and clear cache.

I have also tried to move the following indexing tables to MyISAM and then run a REPAIR QUICK on them and update the indexes

catalogsearch_fulltext_scope1
cms_block
cms_page
customer_grid_flat
sales_creditmemo_grid
sales_invoice_grid
sales_order_grid
sales_shipment_grid
catalogsearch_fulltext

The tricky thing with this is that bin/magento indexer:reindex changes them back to InnoBD. Don't know if they are dropped and recreated or how that happens but that's my result after a magento reindex.
The enginge change, repair, flushing and so on is done after magento reindex.

If anyone have an idea where to go from here i would be quite happy?

Thanks in advance
Thomas

Best Answer

I had also this problem. I resolved it adding

[mysqld]
innodb_ft_min_token_size=1
ft_min_word_len=1

(in your case equal to 2) to /etc/mysql/my.cnf inside the [mysqld] section, restart mysql daemon and then run:

php bin/magento indexer:reindex

inside magento root directory. With the innodb global variable which I wrote earlier the settings value also for the innodb engine.

Related Solutions

Magento – Ignoring special characters during catalog search

Need to some change in helper file app\code\core\Mage\CatalogSearch\Helper\Data.php

from

public function getQueryText()
{
    if (!isset($this->_queryText)) {
        $this->_queryText = $this->_getRequest()->getParam($this->getQueryParamName());   
        if ($this->_queryText === null) {
            $this->_queryText = '';
        } else {
            /* @var $stringHelper Mage_Core_Helper_String */
            $stringHelper = Mage::helper('core/string');
            $this->_queryText = is_array($this->_queryText) ? ''
                : $stringHelper->cleanString(trim($this->_queryText));

            $maxQueryLength = $this->getMaxQueryLength();
            if ($maxQueryLength !== '' && $stringHelper->strlen($this->_queryText) > $maxQueryLength) {
                $this->_queryText = $stringHelper->substr($this->_queryText, 0, $maxQueryLength);
                $this->_isMaxLength = true;
            }
        }
    }
    return $this->_queryText;
}

 public function getQueryText()
    {
        if (!isset($this->_queryText)) {
            $this->_queryText = $this->_getRequest()->getParam($this->getQueryParamName());   
           $this->_queryText =  preg_replace('/[^A-Za-z0-9\-\']/', '', $this->_queryText);  // escape apostraphe
            if ($this->_queryText === null) {
                $this->_queryText = '';
            } else {
                /* @var $stringHelper Mage_Core_Helper_String */
                $stringHelper = Mage::helper('core/string');
                $this->_queryText = is_array($this->_queryText) ? ''
                    : $stringHelper->cleanString(trim($this->_queryText));

                $maxQueryLength = $this->getMaxQueryLength();
                if ($maxQueryLength !== '' && $stringHelper->strlen($this->_queryText) > $maxQueryLength) {
                    $this->_queryText = $stringHelper->substr($this->_queryText, 0, $maxQueryLength);
                    $this->_isMaxLength = true;
                }
            }
        }
        return $this->_queryText;
    }

We have add only one line code in above function $this->_queryText = preg_replace('/[^A-Za-z0-9\-\']/', '', $this->_queryText);

Note: first move core file to local app\code\local\Mage\CatalogSearch\Helper\Data.php after add above change or rewrite a helper class Mage_CatalogSearch_Helper_Data to local click here to rewrite helper steps

Magento – magento 2 : catalog search with less than 3 characters

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 :

*************************** 1. row ***************************
   entity_id: 45
attribute_id: 73
  data_index: tv

The SQL query for 'tv' request:

SELECT `main_select`.`entity_id`, MAX(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, ((0) + LEAST((MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS `score` FROM `catalogsearch_fulltext_scope1` AS `search_index` LEFT JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id LEFT JOIN `cataloginventory_stock_status` AS `stock_index` ON search_index.entity_id = stock_index.product_id AND stock_index.website_id = 0 WHERE (stock_index.stock_status = 1) AND (MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC LIMIT 10000

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 :

ft_min_word_len = 1
innodb_ft_min_token_size = 1

Restart mysql

service mysql restart

Rebuild your index

bin/magento indexer:reindex

Then you will see your product on the search result page.

Best Answer

Related Solutions

Magento – Ignoring special characters during catalog search

Magento – magento 2 : catalog search with less than 3 characters

Related Topic