Blu-ray Forum - View Single Post - Done HTDB/Wiki submissions and solved issues

rdodolak · 10-15-2011, 12:27 AM

Iceman,

There seems to be a problem with the UPC/EAN fields in the database as I'll explain below.

As another example, I added a new DVD entry (101 Dalmatians: Limited Edition) which was approved several days ago. Since that time the EAN has been automatically updated. The database still shows that I made the current change to the EAN field which I did not.

For US releases, a '0' is added to the beginning of a UPC-A (UPC-12) code which doesn't have an EAN-13 (also known as GTIN). See the following links from GS1:

http://www.nepc.gs1.org.sg/html/Data...ry/EANCode.htm

http://www.gs1.org/barcodes/support/...git_calculator

GS1 has reserved 000-019, 030-039, or 060-139 (basically 00-13 for the first two digits) for the first three digits of a US EAN-13 code. '978' is reserved for the first three digits of bookland (or ISBN) numbers.

http://www.gs1.org/barcodes/support/prefix_list

I contributed the following info:

UPC: 7-17951-00397-3
EAN: 0-717951-003973

The database was automatically updated to:

UPC: 7-17951-00397-3
EAN: 9-780788-817250

This release also has a 10-digit ISBN (ISBN-10) number of 0-7888-1725-6.

Basically, '978' was added to the first 9 digits of the ISBN-10 number '078881725' and the last digit of the ISBN-10, '6', was replaced by a '0'.

Basically, this new number is a valid 13-digit ISBN (ISBN-13) which now appears in the EAN-13 field. Converting a ISBN-10 of 0-7888-1725-6 results in an ISBN-13 of 978-0-7888-1725-0.

It's true that a ISBN-13 number is equal to the EAN-13. However, '978' is usually reserved for books. It's probably more appropriate to use the '0' + UPC-A for the EAN-13 code for video releases.

Info on the Bookland EAN: http://en.wikipedia.org/wiki/Bookland

A UPC that starts with 071 would be identified as a product released from the US; not necessarily so with a product that starts with 978.

The title in this example can be found here:

https://www.blu-ray.com/dvd/101-Dalmatians-DVD/20932/

Are the UPC/EAN numbers being updated from another source?

EDIT: Couple of european comparisons:

Again for reference, http://www.gs1.org/barcodes/support/prefix_list

The UK Julia's Eyes blu-ray has an EAN-13: 5-055201-814807; the 505 identifies this as a product released from the UK.
https://www.blu-ray.com/movies/Cargo-Blu-ray/15329/

The DE Cargo blu-ray has an EAN-13: 7-613059-401105; the 761 identifies this as a product released from Switzerland.
https://www.blu-ray.com/movies/Cargo-Blu-ray/15329/

The MX Dumbo blu-ray has an EAN-13: 7-509656-301330; the 750 identifies this as a product released from Mexico.
https://www.blu-ray.com/movies/Dumbo-Blu-ray/10385/

10-15-2011, 12:27 AM	#2010
rdodolak Blu-ray Prince Top contributor Member since:Jul 2007 4K collection:880 Blu-ray collection:3733 DVD collection:939 MA collection:338 Digital collection:1099 iTunes collection:75 Prime collection:11 Trading Score:20	Iceman, There seems to be a problem with the UPC/EAN fields in the database as I'll explain below. As another example, I added a new DVD entry (101 Dalmatians: Limited Edition) which was approved several days ago. Since that time the EAN has been automatically updated. The database still shows that I made the current change to the EAN field which I did not. For US releases, a '0' is added to the beginning of a UPC-A (UPC-12) code which doesn't have an EAN-13 (also known as GTIN). See the following links from GS1: http://www.nepc.gs1.org.sg/html/Data...ry/EANCode.htm http://www.gs1.org/barcodes/support/...git_calculator GS1 has reserved 000-019, 030-039, or 060-139 (basically 00-13 for the first two digits) for the first three digits of a US EAN-13 code. '978' is reserved for the first three digits of bookland (or ISBN) numbers. http://www.gs1.org/barcodes/support/prefix_list I contributed the following info: UPC: 7-17951-00397-3 EAN: 0-717951-003973 The database was automatically updated to: UPC: 7-17951-00397-3 EAN: 9-780788-817250 This release also has a 10-digit ISBN (ISBN-10) number of 0-7888-1725-6. Basically, '978' was added to the first 9 digits of the ISBN-10 number '078881725' and the last digit of the ISBN-10, '6', was replaced by a '0'. Basically, this new number is a valid 13-digit ISBN (ISBN-13) which now appears in the EAN-13 field. Converting a ISBN-10 of 0-7888-1725-6 results in an ISBN-13 of 978-0-7888-1725-0. It's true that a ISBN-13 number is equal to the EAN-13. However, '978' is usually reserved for books. It's probably more appropriate to use the '0' + UPC-A for the EAN-13 code for video releases. Info on the Bookland EAN: http://en.wikipedia.org/wiki/Bookland A UPC that starts with 071 would be identified as a product released from the US; not necessarily so with a product that starts with 978. The title in this example can be found here: https://www.blu-ray.com/dvd/101-Dalmatians-DVD/20932/ Are the UPC/EAN numbers being updated from another source? EDIT: Couple of european comparisons: Again for reference, http://www.gs1.org/barcodes/support/prefix_list The UK Julia's Eyes blu-ray has an EAN-13: 5-055201-814807; the 505 identifies this as a product released from the UK. https://www.blu-ray.com/movies/Cargo-Blu-ray/15329/ The DE Cargo blu-ray has an EAN-13: 7-613059-401105; the 761 identifies this as a product released from Switzerland. https://www.blu-ray.com/movies/Cargo-Blu-ray/15329/ The MX Dumbo blu-ray has an EAN-13: 7-509656-301330; the 750 identifies this as a product released from Mexico. https://www.blu-ray.com/movies/Dumbo-Blu-ray/10385/ Last edited by rdodolak; 10-15-2011 at 12:57 AM.