Setting up WordPress Users & WooCommerce Customers Import Export Plugin

The Best WordPress User/ WooCommerce Customer Import Export Plugin

10,000+ Active Installs as per WordPress Official Plugin Repository

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

This tutorial explains how to set up WordPress Users & WooCommerce Customers Import Export Plugin. Please refer to the product page to know more about the plugin features.

Overview

WordPress Users & WooCommerce Customers Import Export Plugin is an ideal plugin for exporting and importing user/customers details from/to your WooCommerce store for migrating an existing online store.

You can import users/customers from WooCommerce store as well as another e-commerce platform. It exports users/customers from WooCommerce store to the CSV file. You can import/export/merge(update existing users/customers) hundreds, even thousands, of users/customers details using one file which saves your effort and time of manually adding user’s information.

The plugin has the option to send an Email to the user email ID whenever admin imports/updates users details.

You can map your import columns to the appropriate WooCommerce data to import or merge users/customers details. You can also import data from a variety of sources, such as an uploaded CSV file on FTP, locally saved CSV file to your computer.

For importing users/customers details to your online store, you must create a CSV(Comma-Separated Values) file which contains information about mapping fields in a tabular form. You can create a CSV file by using a spreadsheet program, such as  Excel, or Google Spreadsheets. Save this file with the extension ‘.csv’.  After entering all details about users/customers in the spreadsheet, you can import to your online store.

Plugin easily exports users/customers details to CSV file with multiple powerful filters such as User Roles, date ranges, etc. Even the plugin automatically upload your exports via FTP.

Installation

After purchasing the WordPress Users & WooCommerce Customers Import Export Plugin, plugin Zip file is available in MY ACCOUNT.

  1. Navigate to My Account -> API Downloads tab and download the plugin.
    Note: If you have the basic/free version already installed, please Deactivate and Delete the Basic Version before installing Premium Version to avoid any conflict. Your plugin settings will be retained intact.
  2. Install the downloaded plugin zip into your WordPress / WooCommerce Site.
  3. You get Activation Key and Activation Email at My Account -> API Keys.
  4. Go to your site Admin and the Settings page of the plugin and activate it using email and key.

For detailed information about installing Plugins, See How to Download, Install, Activate & Update WooCommerce Plugin?

Navigating to WordPress Users & WooCommerce Customers Import Export Plugin

After installing the plugin, you can navigate to it as given below:

  • Navigate to Dashboard > Users > User Import Export.
  • Navigate to Plugins > Installed Plugins > WordPress Users & WooCommerce Customers Import Export Plugin > Import Export Users/Customers OR
  • Navigate to Dashboard > WooCommerce > Customer Import Export. It is as shown below:
    WooCommerce admin menu
    WooCommerce admin menu

User/Customer Import/Export

The plugin takes CSV file as input. It maps each field of CSV file to the field of a particular Users/Customers.

For example, customer_id field gets mapped to the identification number of the customer and the user_login field gets mapped to the user login name. If you want the plugin to work correctly, you must map headers of all of the column correctly and you must ensure that all of the fields you enter must be in the correct format.

Note: If there is any mistake in your import file, your Users/Customers import may not work as expected. Also, the CSV Import file must be in UTF-8 format. For more information about UTF-8 encoding, read How to save CSV / Excel File as UTF-8 Encoded?

To get started you must have CSV file. You can create the one by exporting the Users/Customers to get the format of CSV, download Sample User CSV.
You must enter the Users/Customers details in CSV file in a structured format as given below:
  • The first row must contain the column headers which are used for mapping the fields. The details about the mapping field are given as below:
    last_updatetr>Last Update

    Column Heading Explanation Accepted value or format
    ID  User ID  Numerical
    customer_id  User ID  Numerical
    user_login  Login name of the User  Text
    user_pass  Pasword for the username  Text
    user_nicename  The URL-friendly user name  Text
    user_email  The user email address  Text
    user_url  The user URL  Text
    user_registered  Date the user registered. Format is ‘Y-m-d H:i:s  Text
    display_name  The user’s display name  Text
    first_name The user’s first name. For new users, will be used to build the first part of the user’s display name if display_name` is not specified.  Text
    last_name  The user’s last name. For new users, will be used
    to build the second part of the user’s display name
    if display_name is not specified.
     Text
    user_status  The user is active or not  numerical

    e.g.0/1

    roles  Indicates the role of the user.  Text

    e.g. Author, Customer, etc.

    billing_first_name  First name of the billing address  Text
    billing_last_name  Last name of the billing address  Text
    billing_company  Company name of the billing address  Text
    billing_email  The billing email  Text
    billing_phone  The billing phone number  Text
    billing_address_1  The first line of the billing address  Text
    billing_address_2  The second line of the billing address  Text
    billing_postcode  The postcode of the billing address  Text
    billing_city  The city of the billing address  Text
    billing_state  The state of the billing address  Text
    billing_country  The country of the billing address  Text
    shipping_first_name  First name of the shipping address  Text
    shipping_last_name  Last name of the shipping address  Text
    shipping_company  Company name of the shipping address  Text
    shipping_address_1  The first line of the shipping address  Text
    shipping_address_2   The second line of the shipping address  Text
    shipping_postcode  The postcode of the shipping address  Text
    shipping_city   The city of the shipping address  Text
    shipping_state  The state of the shipping address  Text
    shipping_country   The country of the shipping address  Text
    nickname  The user’s nickname. Default is the user’s username.  Text
    description  The user’s biographical description.  Text
    rich_editing  Whether to enable the rich-editor for the user. False if not empty.  Numerical e.g. 0/1
    comment_shortcuts  Whether to enable comment moderation keyboard. shortcuts for the user. Default false.  Numerical e.g. 0/1
    admin_color  Admin color scheme for the user. Default ‘fresh’.  Text
    use_ssl  Whether the user should always access the admin over https. Default false.  Numerical e.g. 0/1
    show_admin_bar_front  Whether to display the Admin Bar for the user on the site’s front end. Default true.  Numerical e.g. 0/1

    Each row contains a single user.

The Import Screen appears as shown below:

User/customer import window
User/Customer import window

You can import Users/Customers details from CSV file or merge with already existing Users/Customers by importing updated CSV file.

Import Users/Customers

You can import all the required users by using Import Users. Click Import Users, the window appears as shown below:

Import window
Import window
  1. Method 1: Select a file from your computer. Click Choose File to browse a required CSV file from your computer.
  2. You get the mapping file option(s) for auto-mapping only if you save the mapped fields with a user-defined file name while Mapping the fields. Select the required mapping file from the Select a mapping file drop-down list as shown below:
    Select a mapping file
    Select a mapping file
  3. Method 2: Provide FTP Details. If your CSV file is on a server, then to import it,  you need to do FTP settings as given below:
    1. Select the checkbox to enable FTP import/export.
    2. Enter FTP Server Host/IP.
    3. Enter FTP User Name.
    4. Enter FTP Password.
    5. Enter FTP Server Path.
    6. Select the checkbox to use FTPS.
  4. Enter the delimiter which separates the mapping values.
  5. Send Email to New Users: Select the checkbox to send an Email to a new user on importing details.
  6. Click Upload file and Import. The import window appears as shown below:
    Mapping of fields
    Mapping of fields
  7. You can map the fields(Woocommerce fields) with column headings ( CSV file header). Map a particular field of Map to column by using Column header  drop-down list as shown below:
    Mapping the Field
    Mapping the Field

    Select a required option from the drop-down list. Here, user ID is mapped to ID.

    Note: Mapping is very helpful if you are importing CSV from some other e-Commerce platform like Magento.

    Evaluation field

    User import evaluation fields
    User import evaluation fields

    It is used to fix/update the required value for the particular field. The settings to modify the field are as given below:

    • Assign any required constant value to field (=)
      For Example: Suppose, you want to assign test@test.com to user email. Under Evaluation field, write =test@test.com in user_email row.
    • To Convert the registered date to WooCommerce format, provide your CSV date format in evaluation field.
      For Example: In CSV,  If you have entered the date in correct PHP format as @ d/m/yy H:i:s ( @ 13/07/2016 4:24:25) , then under Evaluation field, you must maintain the same date format as @ d/m/yy H:i:s  in the user_registered row. Then the plugin internally converts it in WooCommerce format as 2016-07-13 4:24:25.
    • Append any field by required value
      For Example: Suppose, you want to append role by By HikeForce. Under Evaluation field, write &By HikeForce in role row.
    • Prepend any field by required value
      For Example: Suppose, you want to prepend Billing First Name by Mr/ Mrs. Under Evaluation field, write &Mr/Mrs[VAL] in billing first name row.

    Note: Hover the mouse on? (Help), you can see the information about Evaluation field.

  8. Click Submit.
  9. According to CSV file, the user(s) gets added to your online store. The import window appears as shown below:
    User import complete window
    User import complete window
  10. You can see the imported user under the Users Page as shown below:
    Imported user on user page
    The imported user on the User page

Update Users

Suppose your existing user details got modified. To reflect that modified details into your online store, you can update the current users by importing modified CSV file.

Steps to update Users

  1. Select Update User if exists checkbox for modifying users as shown below:
    Update users window
    Update users window
  2. Click Import Users, you will get Merge Users window as shown below:
    Merge users
    Merge users
  3. Choose file: Browse the updated CSV file by clicking on Choose file or by FTP settings.
  4. Select a mapping file: You get the mapping file option(s) for auto-mapping only if you save the mapped fields in a user-defined file while Mapping the fields. Select the required mapping file from the Select a mapping file drop-down list as shown below:
    Select a mapping file
    Select a mapping file
  5. Delimiter: Enter the delimiter which separates the values.
  6. Send Email to New Users: Select the checkbox to send an Email to a user on updating details.
  7. Click Upload file and Import.
  8. Re-Map the fields if required as shown below:
    Mapping the fields
    Mapping the fields
  9. Click Submit.
  10. According to CSV file, the user gets updated. The window appears as shown below:
    User merge completed successfully
    User merge completed successfully

    Note: If user ID does not exist, then the user is imported as a new.

Export Users

If you export users using the plugin, you get the CSV file which contains the data about all the users of the WooCommerce online store.

User/customer export window
User/customer export window

You can export all the required Users in just two very simple steps. The window to export the users appears as shown below:

In the first step, you have the option to filter the data that you want to export in the CSV file. You can filter the data that are exported based on the following fields:

  1. Offset: Enter the user row number at which you wish to start the export.
  2. Limit: Enter the maximum number of users that you wish to export.
  3. User Roles: Select user roles for which you want to export details from the given list:
    Filter by user roles
    User roles
  4. From Date: Select the date of registration from which you want to export the users by clicking on the calendar icon.
  5. To Date: Select the date of registration till which you want to export the users by clicking on the calendar icon.

After you have entered the required filter click on the Apply Filter button. You will be able to see a preview of the selected users on the right-hand side of the page. Clicking on the reset button will clear all the filters that you have applied.

After the required filters have been applied, you can proceed to the second step by clicking on Step 2: Map and Transform button.  This will take you to the following screen.

  1. Select a mapping file for export: Similar to import settings, you can select an existing mapping file for export. This option is enabled only when you create your first mapping file on any of the prior user exports.
  2. Columns: Select the checkbox for required columns if you want to export specific columns. With the Column Name field, you can modify the column header in the CSV file. To do that, simply enter the required column name for the specific column.
  3. Save the export mapping: Enter a mapping filename for exporting.
  4. Delimiter: With this field, you can change the comma separated file to ‘|’ or ‘.” separated file according to your requirement.
  5. Export Guest Users: Check this option if you want to export the guest users of your website to be exported to the CSV file.
  6. Click Export Users, the CSV file gets auto-downloaded to your computer. The sample users CSV file is as shown below:
    Exported user CSV
    Exported user CSV

    Note: You can download the Sample Exported CSV.

Export User(s) from Users Page

You can directly download the export file with all the fields. To do that, navigate to Dashboard > WooCommerce > Users. The Users page appears as shown below:

Users page
Users page
  • To export Users, select them. From Bulk Action drop-down list, select Download as CSV and click Apply. All the information about selected User(s) gets auto-downloaded to CSV file.

Settings tab

Under settings of menu tab, you can set the FTP settings to export users. Also, you can auto-export / import the users periodically.

FTP Settings for Exporting Users

The FTP Settings for Export Users appears as shown below:

On clicking the Enable FTP option, you get the settings options for the automatic import and export of the users via FTP.

FTP Settings for import/export users
FTP Settings for import/export users
  1. Select the checkbox to enable FTP import/export Users.
  2. Enter FTP Server Host/IP.
  3. Enter FTP User Name.
  4. Enter FTP Password.
  5. Enter the FTP Port number.
  6. Select Use FTPS checkbox to connect securely.
  7. Enter the Export Path where the exported file should be saved.
  8. if specified, the exported file will have the name entered in the Export Filename field.
  9. Choose Enabled option to Automatically Export Users from FTP Server Host/IP.
  10. Enter the required Export Start time for exporting the Users.
  11. Enter the time interval in minutes for exporting users in the Export Interval [ Minutes ] field.
  12. Choose Enabled option to Automatically Import Users from FTP Server Host/IP.
  13. Enter the required Import Start time for importing the Users.
  14. Enter the time interval in minutes for importing users in the Import Interval [ Minutes ] field.
  15. Select Update User if exist checkbox to merge existing Users with the updated details. The Merging is possible only if the ID of User already exists in your online store. Otherwise, the user is imported as a new one.
  16. Select a required mapping file from the Select a mapping file drop-down list. The field will be available only if there is a mapping file saved in any prior exports.
  17. Click Save Settings to save settings.
    For more information about corn job, please refer Setting Up The Cron Job.

Check out our WordPress Users & WooCommerce Customers Import Export Plugin.

The Best WordPress User/ WooCommerce Customer Import Export Plugin

10,000+ Active Installs as per WordPress Official Plugin Repository

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!