UPC lookup

UPC lookup

Postby TimStone » Mon Apr 11, 2022 5:46 pm

A barcode reader inputs what it sees into a text field. On products, what is "seen" is the UPC ( Universal Product Code ). I have no problem retrieving this with a barcode reader and inserting it into the right field for use and saving.

My question: Has anyone tried working with a decoding option for UPC codes that looks up the item, and returns the descriptive data ? I know this is commonly available in many apps, so I assume there may be some existing API to do this. Perhaps someone has already found a solution for this with FWH.

Again, I read and use the barcode with no problem. The issue is finding a resource database for decoding the UPC data itself which likely uses a web based database.

Thanks for any input.
Tim Stone
http://www.MasterLinkSoftware.com
http://www.autoshopwriter.com
timstone@masterlinksoftware.com
Using: FWH 23.10 with Harbour 3.2.0 / Microsoft Visual Studio Community 2022-24 32/64 bit
User avatar
TimStone
 
Posts: 2945
Joined: Fri Oct 07, 2005 1:45 pm
Location: Trabuco Canyon, CA USA

Re: UPC lookup

Postby Antonio Linares » Mon Apr 11, 2022 6:05 pm

Dear Tim,

Please google for "UPC rest api" (without the quotes) and you will find several services that provide it, in example:

https://upcdatabase.org/api
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42122
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Re: UPC lookup

Postby James Bott » Mon Apr 11, 2022 6:09 pm

Tim,

Just search for "UPC API" on the web.

I tried to do this many years ago but at that time UPC's were new and I never found a universal database nor an API for access. Things have changed a lot since then.

James
FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
User avatar
James Bott
 
Posts: 4840
Joined: Fri Nov 18, 2005 4:52 pm
Location: San Diego, California, USA

Re: UPC lookup

Postby Marc Venken » Mon Apr 11, 2022 6:10 pm

Not 100% sure what you need :

Like this ?

https://stevesie.com/apps/barcodelookup ... igQAvD_BwE

You are looking for a online database for retrieving random data ?
In my case I get the data from manufacturers and generate my own database from all of them, but this you have/can do...
Marc Venken
Using: FWH 23.04 with Harbour
User avatar
Marc Venken
 
Posts: 1442
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium

Re: UPC lookup

Postby TimStone » Mon Apr 11, 2022 6:27 pm

Marc,

When using a barcode reader, if you scan the printed code on a package, it returns the UPC ( Universal Product Code ) for that item. Those are stored in massive online databases. You can query a database and it will return a great deal of detail on that item, ie. the manufacturer, description, physical details, retail price, and more. Often it also provides a list of stores where you can obtain the product.

My clients use and sell parts. They all have UPC codes on them which is just a series of letters and numbers. I was thinking of adding the ability to lookup that code in a universal database. Many companies do offer an API to do this ( or web based query that returns a JSON response ). I was looking to see if anyone knew of a provider that does a better job of this than others.

I have a number of 3rd party interfaces built into my application. This would be another option that they could subscribe to for daily lookups. So far, the companies I see want the app developer to carry the subscription fee. I'd prefer that it be a client option.

Tim
Tim Stone
http://www.MasterLinkSoftware.com
http://www.autoshopwriter.com
timstone@masterlinksoftware.com
Using: FWH 23.10 with Harbour 3.2.0 / Microsoft Visual Studio Community 2022-24 32/64 bit
User avatar
TimStone
 
Posts: 2945
Joined: Fri Oct 07, 2005 1:45 pm
Location: Trabuco Canyon, CA USA


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Otto and 47 guests