Magento 2 Search Query – How to Optimize

magento2search

I have faced the problem in using Magento2 with search result commonly search based on SKU but I want to search product using the name of the product so I want to change the search query in Magento2 but I am not found any option in admin section and code file so can anybody help me to change search query.

Best Answer

For that, i suggest you to override the core catalog_search and search module first and then you can get solution inside the model folder.

Check this 2 files: vendor/magento/module-catalog-search/Model/Layer/Search/Plugin/CollectionFilter.php afterFilter(){}

vendor/magento/module-search/Model/Query.php getSuggestCollection(){}

Hope this can be helpful.

Thanks

Related Solutions

Magento 1.8 – Search by Product ID

You need to edit the Mage_CatalogSearch_Model_Resource_Search_Collection resource model.

Particularly the _getSearchEntityIdsSql function

I'm not yet sure how to add your code here, I'll search and update my post, except if one expert can help you replacing this resource model.

Edit. Apparently there is a foreach on each searchable attribute that append the results in a $selects[] array.

Try adding your request in the $selects array just after the end of foreach.

Magento – Where I can modify Magento search query

You can find the execute function at

/vendor/magento/module-search/Controller/Ajax/Suggest.php


public function execute()
{
    if (!$this->getRequest()->getParam('q', false)) {
        /** @var \Magento\Framework\Controller\Result\Redirect $resultRedirect */
        $resultRedirect = $this->resultFactory->create(ResultFactory::TYPE_REDIRECT);
        $resultRedirect->setUrl($this->_url->getBaseUrl());
        return $resultRedirect;
    }

You can modify the query by your module Ref

Hope this helps.

Best Answer

Related Solutions

Magento 1.8 – Search by Product ID

Magento – Where I can modify Magento search query

Related Topic