I have to update the information of 1500 members of my clients Wordpress site. I'm using a membership to manage paidd subscriptions and I have to update the custom fields generated by this Plugin.
I have looked in the MySQL database and found the following meta keys in the wp_usermeta table:
paypal_user, paypal_status, paypal_custom_fields
Pyapal_user and paypal_custom_fields have a several bits of information in each one that need updating.
I know how to import to MySQL using a CSV, but I'm not too sure how to set the data out in the CSV file as I'm not to familiar with MySQL.
Would anyone know?
Thanks in advance.