WordPress Membership

Easy to use WordPress Membership plugin

  • Documentation
  • WP eMember Plugin
  • Projects
  • Home

How to Bulk Upload/Import Member Details from a CSV File

Update: You should use the bulk member data importer addon to import member data.

You can use the WP CSV to DB plugin to upload member details from a CSV file into the WP eMember’s database.

Before you use this method please note that if you want to import your WordPress users into eMember then there is an easier option for you. Simply browse to the “Import WP Users” tab from the “Members” menu and you will be able to import all your WordPress users into eMember.

Setup/Preparation

  • Install the WP CSV to DB plugin.
  • Download the members.csv template file and open it using Microsoft Excel.
  • Fill up the member details; One member per row (There are two example entries in that file so replace them with actual details).
  • Once you are done entering all your member details then save the file as a CSV file.

Specify the General Options

  • Enter 2 in the “Starting Row” field. This is the row number in the CSV file where you want the plugin to start reading from (the first row is the column titles so you want to read from the 2nd row)
  • Enter “wp_wp_eMember_members_tbl” in the “Database Table Name” field (this is the database table name for the WP eMember’s member table given you haven’t change the default database prefix of wordpress)
  • Enter the content of this text file in the “Column Names” field:

Specify the Input CSV file

Use the upload option to upload the CSV file created in the setup/preparation step.

Import into the Database

Hit the “Import to DB” button which will dump the member details from the CSV file into the database.

Now if you browse to the “Member” menu of WP eMember, you should see all the new members that you just added.

Note

This tool can’t handle importing of eMember custom fields. The primary purpose of this tool is to allow importing of some core member data.

Filed Under: Additional Resources Tagged With: Bulk Upload, emember addon, import, WP eMember

Comments

  1. admin says:

    @Anne, Try out bulk member import addon for that:
    http://www.tipsandtricks-hq.com/wordpress-membership/bulk-member-data-importer-addon-853

  2. Anne Pouch says:

    If you add custom fields to the member database – can you run the bulk upload/import with this method and if so how do you modify the members.csv template?

  3. admin says:

    @Barbara, the password fields are encrypted using an one way encryption for security. When you directly import the passwords into the database it doesn’t go through the encryption process which is why you are seeing this issue. Simply instruct your members to reset their password and after the reset it will work as normal.

  4. Barbara says:

    I’ve imported all the entries and everything looks great…but I’ve noticed that the values in the “password” column are not encrypt into the database so the user cannot login.
    Did I miss something?

  5. admin says:

    You have specified incorrect values in the “Column Names” field of the plugin.

    You need to enter the content of this file in the “Column Names” field:

    http://www.tipsandtricks-hq.com/wordpress-membership/wp-content/uploads/2010/08/eMember_column_names.txt

    Please, watch the video on this page (the video is for eStore but the concept is the same):

    http://www.tipsandtricks-hq.com/ecommerce/how-to-bulk-upload-estore-products-from-a-csv-file-775

  6. Tanya says:

    I got an error message:

    Error occured while trying to import after I hit the ‘Import to DB’ button. The only fields I have in my .csv file are username and email. Help!

    Insert into the Database failed for the following Query:
    INSERT INTO () VALUES (‘UserName’,’First Name’,’Last Name’,’Password’,’Member Since’,’Membership Level’,’Account State’,’Last Accessed’,’Last Accessedd from IP’,’Email’,’Phone’,’Address Street’,’Address City’,’Address State’,’Address Zipcode’,’Address Country’,’Gender’,’Referrer’,’Extra Info’,’Reg Code’,’Subscription Starts’,’Transaction ID’,’Subscriber ID’,’Company Name

  7. admin says:

    It should import all the entries. I suspect you have some special characters on your row 30 and it’s exiting when processing that record.

  8. Joe says:

    Good stuff and thanks .. these instructions are very clear.

    I did notice that only the first 30 rows get imported. Anything csv file with more than 32 rows will ignored the remainder of rows. Also if you repeat the process you end up with duplicate user entries.

Leave a Reply

Your email address will not be published. Required fields are marked *

Get the WP eMember Plugin

Get WP eMember

Categories

  • Additional Resources
  • Content Protection
  • Design & Usage
  • eMember Addon
  • Installation
  • Integration
  • License
  • Testing
  • Uncategorized
  • Video Tutorial

Recent Comments

  • Chris Brown on API – Querying A Member Profile Using HTTP GET or POST
  • admin on API – Updating A Member Account Using HTTP GET or POST
  • Chris Brown on API – Updating A Member Account Using HTTP GET or POST
  • admin on API – Updating A Member Account Using HTTP GET or POST
  • Andrea on API – Updating A Member Account Using HTTP GET or POST

Featured WordPress Plugins

WP Express Checkout Plugin
wordpress_estore_icon
wordpress membership plugin icon
wordpress_affiliate_plugin_icon

Copyright © 2025 | WP Membership Plugin