Jump to content

Repair Addressbook State Data


bsmither

Recommended Posts

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...