Facet mixes food and beauty

[aleene]

What

The food facet search mixes food and beauty products. When I click on a beauty product I am referred to the obf site

Steps to reproduce the behavior

1. https://nl.openfoodfacts.org/status/voedingswaarden-invullen/status/foto-van-de-voedingswaarden-geselecteerd
2. See error

Expected behavior

no beauty products

Screenshot/Mockup/Before-After

Type of device

• Browser: Safari

[teolemon]

• We have a PR that will allow moving a lot of cosmetics to Open Beauty Facts.
• Meanwhile, the safest bet is to add "Open Beauty Facts" as a category whenever you spot one.

[teolemon]

@john-gom @stephanegigandet I can reproduce, on a year old product, edited in 2024.

[aleene]

The product are already on OBF or OPF! It seems just a facet issue.

[john-gom]

What redis event do we generate when a product is moved from OFF to OBF, etc.? It might be the off-query is not being updated when that happens. Can I have specific examples of a product and facet that aren't right?

[aleene]

This one turns op in my food facet: https://nl.openbeautyfacts.org/product/3337875816809

[aleene]

The facet: https://nl.openfoodfacts.org/status/ingredienten-invullen/status/foto-van-de-ingredienten-geselecteerd

[baslia]

Will the product manually labeled as "Open Beaty Facts" via the hunger game website, be moved as well to the correct website ?

[stephanegigandet]

The product is in both the off and obf mongodb databases, with product_type "beauty". We'll need to investigate how it happened.

12k products are in the same case

off> db.products.find({code: "3770017359053"}, {code: 1, id: 1, product_type: 1})
[
  {
    _id: '3770017359053',
    id: '3770017359053',
    code: '3770017359053',
    product_type: 'beauty'
  }
]
off> db.products.count({ product_type: "beauty"})
DeprecationWarning: Collection.count() is deprecated. Use countDocuments or estimatedDocumentCount.
12566

[stephanegigandet]

off> db.products.count({ product_type: "petfood"})
1402
off> db.products.count({ product_type: "product"})
4138