Country data

  • Resolved webcart

    (@webcart)


    1 year, 6 months ago

    Hi,
    I export the users from a woocommerce website but the “country” column is empty.
    I edit the user data and can see that the country is there but not in the export file.

Viewing 15 replies - 1 through 15 (of 16 total)
  • Plugin Author Javier Carazo

    (@carazo)

    The meta key for this is billing_country and shipping_country and include the iso code of the country.

    Thread Starter webcart

    (@webcart)

    billing_country and shipping_country?columns appear in the CSV files but are empty as well.

    Plugin Author Javier Carazo

    (@carazo)

    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.

    Thread Starter webcart

    (@webcart)

    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

    Plugin Author Javier Carazo

    (@carazo)

    I export all.

    If you are using WooCommerce you should fill billing_country and shipping_country.

    Thread Starter webcart

    (@webcart)

    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.

    Plugin Author Javier Carazo

    (@carazo)

    It should be exported… are this saved as meta in usermeta table?

    Thread Starter webcart

    (@webcart)

    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

    Plugin Author Javier Carazo

    (@carazo)

    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).

    Thread Starter webcart

    (@webcart)

    I understand.
    Ok. I will dig into thoses tables to check it.
    Thanks for now.

    Thread Starter webcart

    (@webcart)

    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.

    Plugin Author Javier Carazo

    (@carazo)

    Could you show me an example?

    Thread Starter webcart

    (@webcart)

    Sure.
    https://file.io/ckEHaZgnKllA

    Plugin Author Javier Carazo

    (@carazo)

    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.

    Thread Starter webcart

    (@webcart)

    Hi,
    I did not filter anything.
    I will try to to investigate it on a dev site.
    Will keep you updated.

Viewing 15 replies - 1 through 15 (of 16 total)
  • The topic ‘Country data’ is closed to new replies.

Tags