Magento CE 22.214.171.124
Our store was recently migrated from Volusion to Magento. For customers in the United States, Volusion would store their country information as "US" however Magento refuses to recognize it because it doesn't store this data as "United States" in the database. This has resulted in a number of errors; the predominant one being USPS shipping method erroring out when it attempts to process a registered customer's address.
For customers who have "US" in there country field, it appears as if they don't have a country at all in the account section or in Magento's customer management area.
I need an efficient way to bulk update these customers with incorrect country data. I attempted to do this with the Import/Export option in Magento (not Data Profiles) and it seems to have never finished. I left it on for hours and it continued to say "Please Wait". I also looked into Magmi but it seems they don't have a customer plugin for importing/exporting.
What is the best way to bulk update customer addresses in Magento CE 126.96.36.199? Thank you.