Magento – Magento 2 Elastic search 6 Fulltext search with like

catalogsearchelasticsearchmagento-searchmagento2

I am trying to customize the default Magento 2 Elasticsearch 6. Right now the default Fulltext search is not giving that good result.

For Example I have product name like ADB12355 BBB, ADB3456 AAA, etc.

I am getting proper results either when adding ADB12355 BBB or ADB3456. The problem is I also want both the products if someone just search for ADB some kind of LIKE in mysql.

Also My configuration is correct and indexes are created but So far I am not able to find the correct place to customize.

Best Answer

Give a try.

Add plugin on the below class Builder.php by making a sample module.

File: app/code/Custom/LikeSearch/etc/di.xml

<type name="Magento\Elasticsearch\Model\Adapter\Index\Builder">
        <plugin name="custom_like_search_builder" type="Custom\LikeSearch\Plugin\Model\Adapter\Index\CustomBuilder"></plugin>
</type>

File: Custom\LikeSearch\Plugin\Model\Adapter\Index\CustomBuilder.php

<?php
namespace Custom\LikeSearch\Plugin\Model\Adapter\Index;

class CustomBuilder {

    public function afterBuild(\Magento\Elasticsearch\Model\Adapter\Index\Builder $subject, $result)
    {
        $likeToken = $this->getLikeTokenizer();
        $result['analysis']['tokenizer'] = $likeToken;
        $result['analysis']['filter']['trigrams_filter'] = [
            'type' => 'ngram',
            'min_gram' => 3,
            'max_gram' => 3
        ];
        $result['analysis']['analyzer']['my_analyzer'] = [
            'type' => 'custom',
            'tokenizer' => 'standard',
            'filter' => [
                'lowercase', 'trigrams_filter'
            ]
        ];
        return $result;
    }


    protected function getLikeTokenizer()
    {
        $tokenizer = [
            'default_tokenizer' => [
                'type' => 'ngram'
            ],
        ];
        return $tokenizer;
    }
}

Once done perform the php bin/magento indexer:reindex catalogsearch_fulltext

It should give results like below:

For search term, ADB gives results of below products names

ADB12355 BBB

ADB3456 AAA

For search term, GIT gives results of below products names

ABCGIT AAA

XYZGIT BBB

Related Solutions

Magento – Magento Search: Fulltext & Combine (Like and Fulltext) in relation to Relevance

The basic answer is "Magento search doesn't work well in either mode, get another search engine system." I have done all the above except truncating the query and result tables. If you want to waste a lot of time like I wasted a lot of time trying to make a minimal function search system work, feel free to pursue anything you want, but Sisyphus didn't have much return on effort either.

Modules are available for Sphynx, Lucene, Solr. In this instance, Free is lost sales so go for one that implements one of the above and doesn't try to patch the stock Magento search.

Anything 3rd party will give you 80% relevance or better and actually let you sort by relevance.

Stock Magento is in the 20-40% range for return results and that's as good as it gets. Also the random return is based on product order, not relevance order for LIKE so 500 returns probably means the relevant ones are 2/3 the way through.

When I tried it, the Mysql "Fulltext" never added any actual relevance (separate from relevance rating) to the search and defaults to not searching for words that are shorter than 4 characters (no stop-word functions, we'll just ignore everything so that actual 3 character part name NEVER is found).

Magento – Building a custom search module for Magento adhering to Search Type configuration

I finally found the correct solution. It turned out I was using the wrong approach regarding the query.

I managed to modify my query according to Ron´s answer to this thread: What's the proper way to call CatalogSearch from a custom Block in Magento?

Here is my final query, which performs a search according to the general Magento catalog search settings in admin:

$searchQuery = 'my search';
$shopidajax = '1';

$appEmulation = Mage::getSingleton('core/app_emulation');
$initialEnvironmentInfo = $appEmulation->startEnvironmentEmulation($shopidajax);

$searchText = $searchQuery;
$query = Mage::getModel('catalogsearch/query')->setQueryText($searchText)->prepare();
$fulltextResource = Mage::getResourceModel('catalogsearch/fulltext')->prepareResult(
    Mage::getModel('catalogsearch/fulltext'), 
    $searchText, 
    $query
);

$collection = Mage::getResourceModel('catalog/product_collection');
$collection->getSelect()->joinInner(
    array('search_result' => $collection->getTable('catalogsearch/result')),
    $collection->getConnection()->quoteInto(
        'search_result.product_id=e.entity_id AND search_result.query_id=?',
        $query->getId()
    ),
    array('relevance' => 'relevance')
);

$appEmulation->stopEnvironmentEmulation($initialEnvironmentInfo);

$collection->setStore($storeId);
$collection->addAttributeToSelect('*');
$collection->addMinimalPrice();
$collection->addFinalPrice();
$collection->addTaxPercents();
$collection->addStoreFilter();
$collection->addUrlRewrite();
$collection->addCategoryIds();
$collection->setPageSize(20);
Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($collection);
Mage::getSingleton('catalog/product_visibility')->addVisibleInSearchFilterToCollection($collection);

Note that $shopidajax should be the current active shop ID and $searchQuery should of course be the actual search query string.

Best Answer

Related Solutions

Magento – Magento Search: Fulltext & Combine (Like and Fulltext) in relation to Relevance

Magento – Building a custom search module for Magento adhering to Search Type configuration

Related Topic