Country and State recording in My SQL

Hi,

What is saved in the addres_country column of the hikashop_address table is indeed something like that, which is the namekey of the zone. If you look in the hikashop_zone table, you can see the namekey there.
Then, the namekey is automatically converted to the name of the country when the system is displaying the address.
Changing that to save something else than the zone_namekey would be quite complex as the system hasn't been made to use something else (like the zone ID or the zone name).
Even payment plugins or shipping plugins expect the address_country to contain a zone namekey. If you change that to something else, then payment/shipping plugins might not work properly.
So I would recommend against it.

Hi,

That's not what I have on my end. When I click on the "export" button of the orders listing in the backend, the billing_address_country, billing_address_state, shipping_address_country and shipping_address_state columns all contain the zone name and not the namekey as it is converted automatically. The only case when it doesn't happen is when the zone has been deleted in which case you get the namekey.

But maybe we're talking about something else ? Or maybe you have a bug in the orders listing export on your website ?

Hi,

I'm not sure what you mean with your sentence "I am using CSV export as otherwise I have to click on each of the orders I wish to export and might export some twice". Do you mean that you use the "export" button of the orders listing ? Or do you use something else ?
If you have just "norway" in the database for the address_country column, it could mean that this is the namekey for the zone of the norway country in the hikashop_zone table.

Hi,

Then you need to check with the support of that extension so that they can properly convert the country / state namekey into the name when the export is running.