Magento 2 – Fix Search Not Working Properly

catalogsearchmagento2

In my Magento 2 setup, I have products called something like 'Xxxx 1 DS'. When I search for 'xxxx', the product pops up. But when I search for '1 ds', there are no search results. Is this because the search starts with a number? I have set the minimun search characters to 1..

Best Answer

I do not know your search engine, I suppose that you use Mysql. I cannot comment your question.

But you may try to use SolR or Elastic Search if you want to affine your search experience. It is EE feature, but you can find community module.

You need also to see which raw data is indexed to Mysql / SolR / ElasticSearch to know if the problem occurs on the index level or in the query level.

I test it with ElasticSearch and it works on my side.

I reproduice your error with Mysql search engine.

Resolution :

The data indexed (catalogsearch_fulltext_scope1) is :

*************************** 1. row ***************************
   entity_id: 45
attribute_id: 73
  data_index: Xxxx 1 DS

The SQL query for 'xxxx' request :

SELECT `main_select`.`entity_id`, MAX(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, ((0) + LEAST((MATCH (data_index) AGAINST ('xxxx*' 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 ('xxxx*' IN BOOLEAN MODE))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC LIMIT 10000

The SQL query for '1 ds' request:

SELECT `main_select`.`entity_id`, MAX(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, ((0) + LEAST((MATCH (data_index) AGAINST ('1 DS' 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 ('1 DS' 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.

Related Solutions

Magento 1.7 Catalog Search – Fix Search Not Working

With the help of @Axel I was able to fix the issue.

After digging into the Attributes and comparing the settings of the SKU since I could search by that and the settings of Name and Desc. I noticed a few differences.

here is what the SKU was set to

enter image description here

Here is what name was set to before I changed it

enter image description here

This is what I changed Name to

enter image description here

After that I re-indexed the site and then cleared the cache manually via ftp var/cache and deleted all folders in the cache then refreshed the site and tried to search and sure enough it works now.

Thank you Axel for pointing me in the right direction.

I also hope this helps anyone else having an issue with the search.

Magento – My Search result not showing relevance products properly Magento 2

I had similar issue when I tried to use curl command with search query, it was giving me proper result and not in Magento listing. Try below code by overriding Block file.

di.xml

<?xml version="1.0" encoding="UTF-8"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../../../lib/internal/Magento/Framework/ObjectManager/etc/config.xsd">
    <preference for="Magento\CatalogSearch\Block\Result" type="Vendor\Module\Block\Result" />
</config>

Result.php

<?php 
namespace Vendor\Module\Block;

use Magento\Framework\View\Element\Template;

class Result extends \Magento\CatalogSearch\Block\Result
{   
    protected function _construct()
    {
        $this->setModuleName('Magento_CatalogSearch');
        parent::_construct();
    }

    protected function _getProductCollection()
    {
        if (null === $this->productCollection) {
            $this->productCollection = $this->getListBlock()->getLoadedProductCollection();
        }
        try {
            $block = $this->getLayout()->createBlock('Magento\Catalog\Block\Product\ProductList\Toolbar');

            $dir = $this->getRequest()->getParam('product_list_dir');
            if(!isset($dir)){ $dir = 'DESC'; }
            if ($block->getCurrentOrder()) {
                switch ($block->getCurrentOrder()) {
                case 'relevance':
                    $this->productCollection->setOrder('relevance', $dir);
                    break;
                case 'name':
                    $this->productCollection->setOrder('name', $dir);
                    break;
                case 'price':
                    $this->productCollection->setOrder('price', $dir);
                    break;
                default:
                    $this->productCollection->setOrder('relevance', $dir);
                    break;
                }
            }
            return $this->productCollection;
        } catch (\Exception $e) {
            $this->logger->error('Fault Code: ' . trim($e->getCode()));
            $this->logger->error('Fault Reason: ' . trim($e->getMessage()) . "\n");
        }
    }
}

Best Answer

Related Solutions

Magento 1.7 Catalog Search – Fix Search Not Working

Magento – My Search result not showing relevance products properly Magento 2

Related Topic