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