Magento product search in admin product grid not working correctly. No OR functionality

[cptX]

Preconditions and environment

• Magento version
  2.4.5 and 2.4.6
• Anything else that would help a developer reproduce the bug
  In admin product list let's try the following:
  Let's say we have a product called "Erika Running Short".
  If we search with full name the product appears in the results.
  If we search for "Erika Running" the product appears.
  But if we search for "Erika Short" no product appears.

In my everyday administering I search for product names or titles and I cannot remember all the words in between. So I need to put 2 words included in the title and expecting to get the corresponding products. Now I get 0 products in the product list search results when I don't put all words in between the wanted keywords.

Steps to reproduce

1. Open a magento instance (2.4.5 or 2.4.6) which has some products.
   Let's say it has the default sample products magento 2.4.5 and 2.4.6 have.

2. Go to Catalog > Products

3. Search for "Erika Running Short". There will be several results

4. Search for "Erika Short". There will be no result!

Expected result

When searching for "Erika Short" I want the system to return all the products that include these 2 words in their title independently of the position these 2 words are placed in the products titles.
For example If a product has the title "Erika Running Short", it should appear when searching for "Erika Short"

Actual result

Now when searching for "Erika Short" no products appear, although there are many products available with the title "Erika Running Short"

Additional information

No response

Release note

No response

Triage and priority

• Severity: S0 - Affects critical data or functionality and leaves users without workaround.
• Severity: S1 - Affects critical data or functionality and forces users to employ a workaround.
• Severity: S2 - Affects non-critical data or functionality and forces users to employ a workaround.
• Severity: S3 - Affects non-critical data or functionality and does not force users to employ a workaround.
• Severity: S4 - Affects aesthetics, professional look and feel, “quality” or “usability”.

[m2-assistant]

Hi @cptX. Thank you for your report.
To speed up processing of this issue, make sure that the issue is reproducible on the vanilla Magento instance following Steps to reproduce. To deploy vanilla Magento instance on our environment, Add a comment to the issue:

• @magento give me 2.4-develop instance - upcoming 2.4.x release
• For more details, review the Magento Contributor Assistant documentation.
• Add a comment to assign the issue: @magento I am working on this
• To learn more about issue processing workflow, refer to the Code Contributions.

---

Join Magento Community Engineering Slack and ask your questions in #github channel.
⚠️ According to the Magento Contribution requirements, all issues must go through the Community Contributions Triage process. Community Contributions Triage is a public meeting.
🕙 You can find the schedule on the Magento Community Calendar page.
📞 The triage of issues happens in the queue order. If you want to speed up the delivery of your contribution, join the Community Contributions Triage session to discuss the appropriate ticket.

[m2-assistant]

Hi @engcom-Dash. Thank you for working on this issue.
In order to make sure that issue has enough information and ready for development, please read and check the following instruction: 👇

• 1. Verify that issue has all the required information. (Preconditions, Steps to reproduce, Expected result, Actual result).
• 2. Verify that issue has a meaningful description and provides enough information to reproduce the issue.
• 3. Add Area: XXXXX label to the ticket, indicating the functional areas it may be related to.
• 4. Verify that the issue is reproducible on 2.4-develop branch
     Details

     - Add the comment @magento give me 2.4-develop instance to deploy test instance on Magento infrastructure.
     - If the issue is reproducible on 2.4-develop branch, please, add the label Reproduced on 2.4.x.
     - If the issue is not reproducible, add your comment that issue is not reproducible and close the issue and stop verification process here!

---

• Join Magento Community Engineering Slack and ask your questions in #github channel.

[drinkingsouls]

I agree, the search functionality from the Admin Product Grid is annoyingly limited.
We've had the same issue since launching Magento 2.
The frontend search with Elasticsearch more helpful, I wonder why this was never integrated into the Admin side.

[engcom-Dash]

Hi @cptX

Thanks for reproting and collaboration.

Verified the issue in magento 2.4 dev instance and the issue is reproducible.

Steps to reproduce

1. Open a magento instance (2.4.5 or 2.4.6) which has some products.
2. Let's say it has the default sample products magento 2.4.5 and 2.4.6 have.
3. Go to Catalog > Products
4. Search for "Erika Running Short". There will be several results
5. Search for "Erika Short". There will be no result!

Magento product search in admin product grid not working correctly. We are not seeing results when searching with "Erika Short".

Hence, confirming the issue.

Please refer the attached screenshots.

[github-jira-sync-bot]

✅ Jira issue https://jira.corp.adobe.com/browse/AC-11757 is successfully created for this GitHub issue.