Page 1 of 1

ISBN requires 13 characters, not 12

Posted: Fri Feb 24, 2012 11:18 pm
by lcanter
For books with ISBN number, there is a problem. The only place to put an ISBN number is in the UPC field, but the last digit gets truncated (and thus is rejected by Googlebase). If a separate ISBN field can't be added, then the structure of the products table needs to be modified to allow 13 characters for the UPC field. I have changed it in my installation and that seems to fix the problem.

Re: ISBN requires 13 characters, not 12

Posted: Sat Feb 25, 2012 6:14 am
by mikejshaw
Just curious why you would use the isbn in the UPC field, rather than model number.
Cheers ...
.

Re: ISBN requires 13 characters, not 12

Posted: Sat Feb 25, 2012 6:29 am
by lcanter
Books require an ISBN, in place of UPC in both Google and Amazon (plus virtually all retail stores). The standard ISBN is 13 digits, but the UPC field in OC is restricted to 12.

Re: ISBN requires 13 characters, not 12

Posted: Sun Feb 26, 2012 2:02 am
by rph
You'll need to modify g:upc to g:tin if you're doing that.

Re: ISBN requires 13 characters, not 12

Posted: Sun Feb 26, 2012 2:10 am
by GoGo OpenCart
lcanter wrote:the UPC field in OC is restricted to 12.
You can change the length of it in the database ;)