Is code jsonl the UPC?

BE HELPED đź’¬
1

i have downloaded the openfoodfacts-products.jsonl file and imported it into a Mysql table. I assumed that code meant UPC but NONE of the UPC codes that have worked when calling the API are found in the jsonl file.

What am I missing?

2

For instance, 014113912037 works in the api and returns “Pistachios Roasted & Salted” but that is not a code in the jsonl file

3

Hello and welcome to the forum!

The dump may be relatively outdated, but it’s strange that every code you’re querying for is returning a not found.

Which field is was it in the JSONL dump?

4

I was under the impression that the dump was updated daily. How often is it updated? The field I am using is code

5

Yes, it should be updated daily.

I’m sorry but I can’t seem to understand the issue. You take the code field from the JSONL file and then query the API with that code, right?

I don’t understand what you mean here. Where did you find the 014113912037 code? Wasn’t it in the code field of a product?

6

I am taking the JSONL payload and storing it into a Mysql 8 JSON column. I have a virtual column called upc that maps to the code value in the JSON column. the upc field is indexed. I am querying to find the record with that upc value.

7

image
image1032Ă—218 11 KB

8

Could you provide some products code that are not found in the API?

9

Here are a few: 077661174845, 850049405010, 075879251907, 810076770451

10

Here are a few more. 013562000456
850036699187
037466015859
810757010302
810757010005
620133003251
621683920258
089125250002
856069018483
678523040065
857549004217
620133003640
678523010426
857183005151
857183005373

11

Could you try using the CSV export and see if you get the same behavior?