[v4.2] Fix search by variant on stock items

[github-actions[bot]]

Backport

This will backport the following commits from main to v4.2:

• Merge pull request #5660 from nvandoorn/5506-fix-search-by-variant-on-stock-items

Questions ?

Please refer to the Backport tool documentation