[Product] Open database of Products

Wed Jan 8 07:31:20 UTC 2014

Sachin,

For contribution, you can leave your information (email address,
development skills) on this Github issue :
https://github.com/okfn/product-browser-web/issues/6

Regards,
Nicolas

On Wed, Jan 8, 2014 at 4:06 AM, Sach Kangovi <sachk2003 at gmail.com> wrote:

>  Hi Nicolas;
>
>                   Thank you for your prompt response. It is very helpful.
> Yes, I would be interested to contribute to accelerate the process of
> having the link between a GCP and a BSIN. Please let me know the details.
>
>
>
> Regards;
>
> Sach
>
>
>
>
>
>
>  ------------------------------
>
> *From:* Nicolas Pieuchot [mailto:nls.pct at gmail.com]
> *Sent:* Tuesday, January 07, 2014 5:50 PM
> *To:* Sach Kangovi
> *Cc:* OKFN Mailing List
> *Subject:* Re: [Product] Open database of Products
>
>
>
> 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/20140108/2452ca8f/attachment-0002.html>