Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

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.

share|improve this question
add comment

2 Answers

As far as I know there is nothing native in WP to parse CSV files and stuffing this into database directly doesn't seem like a good idea either.

  1. You can parse your CSV with PHP, see fgetcsv() for starters.

  2. Then use update_user_meta() to create those values.

share|improve this answer
add comment

You should write a custom importer and register the custom fields before the import if WP doesn’t know them.

I’ve written an importer for a CSV table with user data and custom user meta fields some time ago. It is quite old and all messages are in German – but it is still working. If you need just an example, I could put it online despite its embarrassing quality.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.