bsmither Posted November 4, 2013 Share Posted November 4, 2013 If you are having the occasional difficulty with a shipping or payment processor refusing to accept data submitted to it, the cause may be due to that data having other than the official two-letter USA state abbreviation. For example, the data submitted may have Illinois, but the processor requires IL. To find the proper abbreviation from the database Geo Zones table, the Addressbook must have the state ID number. Having updated the database from CubeCart3/4's Customer table, which held whatever the customer entered for a state name, the CC5 Addressbook now has those phrases. Also, due to a bug, CC5 may have recorded into the Addressbook, the full state name, or allowed the customer to manually enter something that looked like a state name, from a form during checkout. Instructions are provided on how to repair the contents of the Addressbook table at: http://www.cubecartforums.org/index.php?showtopic=18320 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.