Don't know where you are at with this problem; however, I just completed some research to try to help someone that was looking for a related address presentation issue. Their's was for an international address; however, I found that a similar solution may help without all sorts of coding as provided "above"... Get this, check the address format for United States: This would be found in the Locations/Taxes drop down of the admin panel. Then choose countries. Change to page 10. Look at the address format for United States. It probably is set to a value of 1.... This value assigns a display address with the state fully spelt. What you want is the two letter abbreviation... Change the address format to 2... This should provide an address format that has the two letter abbreviation for the state. It may be further helpful to require states to be a dropdown (as I am not sure what database lookup is performed when the state is manually typed in versus lookup from the table(s).)
If existing entries are not automatically changed to the two letter abbreviation, and there is a need to change the records, I would suggest adding a new entry with the above settings, see the differences, track down the applicable information for the change outs, then update the database through your favorite method to change all of the entered addresses desired to be modified...
Can't believe that it is/would be that easy, but there ya' go... (That said, I'm not sure how my database got populated with countries and states, if by initial installation or upload of some other data, but it does have information related to all of that.) Or upon rereading ihungil's response, I could be completely wrong regarding the order data, but possibly correct as far as the user's data...
Bookmarks