I have exported my customers to a csv file to move them over to a new e-commerce platform. The customer "country_id" is exported as a 3 digit number. I need to change this to a country name or 2 letter country code such as CA for Canada or US for United States before I can import my customers into the new platform. I cannot find a list of what countries these 3 digit numbers correspond to.
I also cannot figure out how to get a State or Province. I see that "zone_id" (a 4 digit number) was exported but I cannot figure out what these mean.
If I go to the customer profiles Country and state are listed. Is there a way to have country and state end up in the csv export file. or is there a list somewhere of what these country and region codes mean.
Most of my customers are US customers. If I can just figure out State I don't mind entering all the foreign customers manually if I have to.