UPC Character length not enough

Post by noidea » Sun Jul 31, 2011 7:06 am

When adding in UPC codes opencart 1.5.1.1 cuts out the Characters at the end if the length is more then 12 long, for example- 0740617148367,7406171483674,0000 becomes 074061714836 once it has saved, when that is submitted to google it comes back as invalid.

This is a problem because-

Note: As of May 3rd, 2011, unique product identifiers are required for all products submitted to the United States, United Kingdom, France and Germany, except those products in the apparel category and custom made goods. We encourage you to provide unique product identifiers whenever possible. Please consult the information in this article for information about the requirement.

The maximum allowed Characters for the UPC input needs to be increased 'a lot'

This is not only a note for future patching, but if possible is the a temporary fix for this?

Thank's

Post by nosecret » Sun Jul 31, 2011 8:45 am

Post by noidea » Sun Jul 31, 2011 9:01 am

nosecret wrote:To UPC character more length you can this method below:
1. Log in to phpmyadmin
2. Select your database
3. Select product table
4. Edit field upc, change length/values as you need.

n'da ha... I just learnt how to edit the SQL database and why its actually there, thanks to your instructions, and it worked thank you

So its nothing to do with OC, my apologies for jumping to conclusions. As my name states i know little of web coding or management, other then basic HTML and installing databases,- setting them up.

But I'm learning all the time.

Again thank you

Post by uksitebuilder » Sun Jul 31, 2011 2:36 pm

Post by Bugsafari » Tue Aug 30, 2011 5:39 am

Bugsafari.co.uk
Specialist stick insect breeders and suppliers of educational science products. Find us on Facebook and Twitter

Post by Bugsafari » Fri Sep 02, 2011 10:15 pm

Bugsafari.co.uk
Specialist stick insect breeders and suppliers of educational science products. Find us on Facebook and Twitter

Post by uksitebuilder » Fri Sep 02, 2011 11:51 pm

Post by evanmorgan » Wed Oct 26, 2011 11:02 pm

Post by uksitebuilder » Wed Oct 26, 2011 11:30 pm

Post by evanmorgan » Wed Oct 26, 2011 11:53 pm