OFF daily product (OPF) sync didn't happen

[serpico]

What

See, for example 3450971461701 :

• https://world.openfoodfacts.org/product/3450971461701/vinaigre-d-alcool-cristal-10-eco
• https://prices.openfoodfacts.org/api/v1/products/code/3450971461701 : updated 2024-03-19
• https://world.openfoodfacts.org/api/v2/product/3450971461701.json : last_modified 2024-11-06

[raphodn]

I'm not 100% sure how the sync exactly works in terms of timestamps, there are a couple of parameters involved :

• when the product was last modified in OFF
• when the OFF product dump happens
• when the OP product sync happens (daily at 15:30 server time)

Let's wait one more day :)

[raphodn]

This sync is temporary.
The v2 is to sync with the live changes (openfoodfacts-events ?).
The v3 is to plug directly to the OFF database ^^

[raphodn]

hmm wait @serpico I see on OFF that you updated the quantity on the 6/11, and it's correctly reflected in OP. Don't know when exactly the sync happened. And indeed the product's updated field was not updated...

[raphodn]

I dug into the code, and realized we store this info in another field (not returned by the API)

'source_last_synced': datetime.datetime(2024, 11, 7, 16, 59, 52, 884000, tzinfo=datetime.timezone.utc)

Two options here :

• return source_last_synced in the API
• update the updated field (I think I didn't want to do it here to separate syncs and actual changes, though there's no actual product change in OP... even the price_count increment does not update this field...)

[raphodn]

Linked, created an issue in the OFF server: openfoodfacts/openfoodfacts-server#11118 10 days ago. regarding not-up-to-date datadumps. fixed 5 days ago.