Improve simple search relevance

[Chocobozzz]

What

• When using simple search, it's difficult to find a product that is also an ingredient because it's lost in many transformed products.
• For example, if I search in french parmesan I see many meals that contain parmesan (PastaBox etc). But almost no parmesan cheese in the first page. I think it's because results are sorted by popularity instead of relevance (that could be calculated including the popularity).

Proposed solution

• Improve search relevance, for example by calculating a score for each products. We could consider than PastaBox - Tortellini Ricotta Epinards Sauce au parmesan - Sodebo - 280 g (https://fr.openfoodfacts.org/produit/3242272250050/pastabox-tortellini-ricotta-epinards-sauce-au-parmesan-sodebo) has a lower score than Parmesan Reggiano AOP 28 % MG (https://fr.openfoodfacts.org/produit/0208959032404/parmesan-reggiano-aop-28-mg) because the name is bigger (parmesan has less weight in the product name).
• I don't know if it's "easy" using mongo. I just know it's possible using elastic search, that automatically calculates this score field. You can also search against other product fields, and adapt the weight of each field.

Part of

• 🔎 Search (Tracking bug) #5492

[github-actions]

This issue is stale because it has been open 90 days with no activity.

[alexgarel]

@Chocobozzz for your information @simonj2 is working on a new project for search: https://github.com/openfoodfacts/openfoodfacts-search :-)

[github-actions]

This issue has been open 90 days with no activity. Can you give it a little love by linking it to a parent issue, adding relevant labels and projets, creating a mockup if applicable, adding code pointers from https://github.com/openfoodfacts/openfoodfacts-server/blob/main/.github/labeler.yml, giving it a priority, editing the original issue to have a more comprehensive description… Thank you very much for your contribution to 🍊 Open Food Facts