The meta key for this is billing_country and shipping_country and include the iso code of the country.
billing_country and shipping_country columns appear in the CSV files but are empty as well.
If they are empty the user has no country associated.
Maybe you have countries associated to order but users has not filled it in my account.
In the user edit screen, the Country/Region under Customer billing address is empty.
I guess this is the field you export to the file and therfor I could not see any data?
The country I have in the user edit is under Extra profile information
I export all.
If you are using WooCommerce you should fill billing_country and shipping_country.
The woocommerce in this site is not for orders but for catalog so the users registration forms is not from woocommerce.
In the “Regular” user data (user-edit.php) I can see the country field under Extra profile information so I wonder why it’s not exported.
It should be exported… are this saved as meta in usermeta table?
It’s data comes from Formidable form and there is some ACF involved but I can see the country in the user edit under Extra profile information
Not sure where those plugin saves their data.
This plugin and every user plugin by default read only from wp_users and wp_usermeta the default table.
If they are not there, we have to create a new addon to make it possible (as we have done for example for BuddyPress).
I understand.
Ok. I will dig into thoses tables to check it.
Thanks for now.
Hi,
I found the country cell in the WP_USERMETA table with “United States” but in the CSV file I exported the “Country” is empty.
Could you show me an example?
If it appears there, it should appear in the export.
Do not include any filter and leave the column field empty to export all.
It should appear there. If not… there are some particular problem in your installation that I cannot solved from here.
Hi,
I did not filter anything.
I will try to to investigate it on a dev site.
Will keep you updated.
