Is there a way to change all state names in customer accounts to the abbreviated version?

My address verification service has changed their algorithms such that now all state names must be abbreviated to the two character version for it to run properly. Not exactly a forward step with their service as it used to take full name or abbreviation and convert all to proper abbreviation. Now it only looks at the first two characters of the state name so now states such as Nevada, New York, New Mexico, etc are all revised to NE or Nebraska. They then try to verify the address which always fails.

I added "usestateabbrev=TRUE" to my includes file so this catches all new customers. BUT - if a customer created their account prior to the usestateabbrev being added then it remains the original full name. Without going through thousands of accounts - is there an easy way to convert all US state names from full name to an abbreviation?

Hi ekrzycki
I see the problem and I've added some code to the Admin Client Login page which should help. Now when you go to that admin page you will get a notification of state names / abbreviations that don't match and the ability to match them. The changes are in the v7.5 updater in the incclientlog.asp file. You can use this file just fine with v7.4 but not with v7.3

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Running 7.3.7 now so will update and try this coming weekend.
Thanks