Bar codes on books

[johnwhelan]

I'm not sure if I should admit it here but I read both ebooks and real books and to keep track of what I have I use Calibre adding real books by using the ISBN to create a record.

It's useful as I can see more easily which authors I like and more importantly which books I already have or have rejected.

These days bar code scanners have come down in price enormously and my latest toy is a bar code scanner that plugs into the USB port and returns the ISBN code followed by a carriage return. Saves me pulling out the reading glasses or magnifying glass to read the ISBN number. On many books this works fine but some books have a UPC code rather than an ISBN code.

Is there a way to detect if its an ISBN code or UPC then get the author title stuff in from the UPC code?

Thanks John

[theducks]

Originally Posted by johnwhelan

Is there a way to detect if its an ISBN code or UPC then get the author title stuff in from the UPC code?

Thanks John

UPC are 10 digits and sometimes have the supplemental.

The first 5 digits are the publisher, the rest is the PRICE.
Big variety stores love this. They don't track titles, only price and vender (sales). (The jobber worries about the titles)

The supplemental as a subset (some part of the book number) of the ISBN.

Sometimes there are 2 bar codes. Always scan the one that stars with 978

[crich70]

Originally Posted by theducks

UPC are 10 digits and sometimes have the supplemental.

The first 5 digits are the publisher, the rest is the PRICE.
Big variety stores love this. They don't track titles, only price and vender (sales). (The jobber worries about the titles)

The supplemental as a subset (some part of the book number) of the ISBN.

Sometimes there are 2 bar codes. Always scan the one that stars with 978

Interesting. I never knew it was divided up like that. Of course it makes sense. Far easier to keep track of things from publisher, to warehouse, to bookstore I imagine. Banks do something similar. Their 'routing number' on checks that depositors get from them identify which bank issued them. Not which branch but the bank overall. So Bank One has a different routing # than First Federal for example. So that if I write you a check you can take it to your bank where they scan the routing number and find my account from the account # which is also on the check. Otherwise I can't imagine how hard it would be to do any banking. It makes sense that books do something similar.

[theducks]

Originally Posted by crich70

Interesting. I never knew it was divided up like that. Of course it makes sense. Far easier to keep track of things from publisher, to warehouse, to bookstore I imagine. Banks do something similar. Their 'routing number' on checks that depositors get from them identify which bank issued them. Not which branch but the bank overall. So Bank One has a different routing # than First Federal for example. So that if I write you a check you can take it to your bank where they scan the routing number and find my account from the account # which is also on the check. Otherwise I can't imagine how hard it would be to do any banking. It makes sense that books do something similar.

In magazines, the supplemental is 2 digits of Issue (month)

(Can you tell I worked with POS back office configuration )
The Bar code system was pretty well thought out (they did miss in a few places). The current 6-pak of soda/beer is a problem. There is no barcode on that plastic carrier. the barcode is on the can... SO... it cause problems with 'singles' as the code on the can commonly represents 6 cans

[Kirtai]

Books with a UPC should also have an ISBN barcode, quite likely inside the front cover.

I don't know of anything that would work with an external barcode scanner but I do know that the Goodreads android app can scan barcodes and is able to distinguish between UPC and ISBN codes so it should be possible.

[johnwhelan]

Originally Posted by theducks

Always scan the one that stars with 978

So 978 introduces the ISBN number. Interesting combined with the information that the inside cover often has an ISBN bar code I think that covers things nicely.

The 978 bit started the idea in my head as I noticed that Calibre was quite happy searching for books that weren't what I recognised as an ISBN number but obviously Calibre recognised the 978 prefix.

Thanks John

[Divingduck]

Something like this would be a nice extension for Calibre. Using a webcam for scanning the bar code of a book will save a lot time for build up a existing library.
I start to dream again
... but too late for me. I have done the work long time ago.

[theducks]

Originally Posted by cindy313

what 's the differences between them ?

UPC barcode only has the publisher (5 digits) and the price (5digits). this is for retail that does not want to maintain the PLU table for every title (eg. Walmart). Sometimes ther is a suplemental second section that may complete the ISBM, but I have not seen a retailer that uses that)

The register reads the first part and knows to decode the second part as money. (similar to the series 2 UPC, variable weight, codes used for Meat and deli)

UPC does NOT start with 97x
EAN (ISBN13) may also have a suplemental code, this is for money, but not all code it and set it to 90000