I have two products

  1. Product name : Test Product and sku: dp-2200
  2. Product name : Test Product2 and sku: dp-3000

When I search for: "dp-2200 test" then it will return both products in the results. After some RnD I changed search_request.xml file and changed the clause="must" instead of "Should" in the XML file but after that I have showing no result.

So this above solution is check full string but I need to check all attribute value in product.

I just need to show first product only when searching for "dp-2200 test" keyword.

Any idea please share.

2 Answers 2


@Camit1dk, Have you fixed the issue? I am facing same issue after migrating website from Magento 1.9 to Magento 2.3

  • no, i have use 3rd party extension for that. Commented Sep 19, 2019 at 12:00
  • your issue was resolved by extension? Can you please share extension name or vendor name? Commented Sep 19, 2019 at 12:12
  • i am not sure but i think we have use mirasvit Sphinx Search Ultimate extension. you can also test your search criteria on this extension demo link . Commented Sep 19, 2019 at 12:15
  • 1
    one more thing is , this issue is not generate because of migration. its default magento behaviour. Commented Sep 19, 2019 at 12:16
  • You mean, this is magento bug, But I didn't get question related this, if it is magento bug. Commented Sep 19, 2019 at 12:19

It's working if want not Exact SKU Search then find this code in the vendor/magento/module-catalog-search/etc/search_request.xml

Find :

Replace with



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.