[Product] Open database of Products

Tue Jan 7 22:49:58 UTC 2014

Hello Sach,

Thank you for your interest into product open data.

>From the database you have downloaded, once imported, you should find a
table named "GTIN", in this table, you can find a "GTIN_NM" which
corresponds to the product name.

If you look for the products pictures, you can either :
- Download the pictures archive *(recommended)* :
http://www.product-open-data.com/docs/pod_pictures_gtin_2013.08.29_01.zip
- Access the gtin_img by querying the OpenDataSoft POD API :
http://pod.opendatasoft.com/explore/dataset/pod_gtin/?tab=api
- Access the gtin_img by querying the POD API :
http://www.product-open-data.com/product/<GTIN_HERE>

About the link between brand, brand_owner and gs1_gcp, it isn't done yet.
For the time being, you can solely find the "BSIN" field (Brand Standard
Identification Number) in the "GTIN" table which will allow you to link a
GTIN to a brand.

Please, feel free to tell us if you're interested to contribute to product
open data in order to accelerate the process of having the link between a
GCP and a BSIN.

Sincerely,
Nicolas

On Tue, Jan 7, 2014 at 10:50 PM, Sach Kangovi <sachk2003 at gmail.com> wrote:

>   Hi okfn discussion group Members;
>
>                                                        I am looking for an
> open database of products that links GTIN with Product name and url that
> can show product image and description. I was reading blog by Katelyn
> Rogers <http://okfn.org/members/katelynrogers/>  dated October 14, 2013
> on www.product-open-data.com. She has mentioned that  “Philippe Plagnol,
> working independently on the database since November 2012, has begun
> building a product database <http://www.product-open-data.com/navigate/> that
> currently contains over one million product GTIN numbers of which 400,000
> are already matched to their brand, GCP and GPC, over 600,000 images and
> 4,000 brands, all open for anyone to use, reuse and redistribute”.
>
>
>
>                                                                     I
> downloaded the pod_web_2014.01.01_01 SQL file and it has tables for brand,
> brand_group, brand_owner, brand_owner_bsin, brand_type and gs1_gc. This
> database links the brand to brand owners and brand type but I could not
> find the link between brand and gs1_gc.
>
>
>
>                                                                    Could
> you please let me know where I can get the database that matches Product
> name and descriptions to GTIN that Katelyn is talking about.
>
>
>
> Thank You.
>
> Sincerely;
>
>
>
> *Sach Kangovi*
>
> email: sachk2003 at gmail.com
>
>
>
>
>
> *Sach Kangovi*
>
> email: sachk2003 at gmail.com
>
>
>
> _______________________________________________
> product mailing list
> product at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/product
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/product/attachments/20140107/51ca05e8/attachment-0002.html>