Create a script adding "Countries where sold" to products as prices are added

[teolemon]

Problem

• Create a script adding "Countries where sold" to products as prices are added
• This requires
• deducing the country from the associated stores
• checking whether the product already has this country in "Countries where sold"
• if not adding it.

Why

• We currently add countries yearly using scan statistics
• Prices allow us doing that in almost real time, much more aggressively and reliably than scan statistics

Related

discussion "Send data to Open Food Facts" : https://github.com/openfoodfacts/open-prices/discussions/223

[raphodn]

These contributions to OFF would be attributed to which user ? Is there a good practice ?

[teolemon]

• We could attribute them to the user adding the price (there's a mechanism build for Robotoff to do that)
  • https://github.com/openfoodfacts/robotoff/pull/350/files (sorry, at this point, I couldn't find a convincing auth method guide in the API ref or in the python package doc: https://openfoodfacts.github.io/openfoodfacts-python/usage/)
• We could add a comment to the edit ("added France because a price point was added in Open Prices")

[teolemon]

Here's an example: https://prices.openfoodfacts.org/app/products/8711200454464

[raphodn]

We could add a few rules :

• City, state & country where purchased : real-time
• Stores : real-time
• Countries where sold : after at least X prices in Y different locations in a given country ?

[raphodn]

For the auth, we could also create an openprices user, and pass a uuid per user in the comments.

I feel its simpler, and also better because the user didn't actually edit the product, its done in the background, so it would be weird for many users to have these products pop up in their "recently modified" list

foodvisor seems to have this mecanism