Setting up WordPress Users and WooCommerce Customers Import-Export Plugin

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:

  

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?

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

Import Users/Customers

The Import screen appears as shown below:

Click on Import Users button, the window appears as shown below:

Step1: Import Settings

Basically, there are two methods for importing. You can choose any one method from the two for importing users/customer details.

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:

   

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:
   • Select the checkbox to enable FTP import/export.
   • Enter FTP Server Host/IP.
   • Enter FTP User Name.
   • Enter FTP Password.
   • Enter FTP Server Path.
   • 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 on Upload file and Import to proceed further to Step 2.

Step 2: Import Mapping

1. The import window appears as shown below:
2. 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:

   

   Select a required option from the drop-down list. Here, a 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

   

   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 as the 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 the evaluation field.
     For Example: In CSV,  If you have entered the date incorrect 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 the 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 the 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.

3. Enter the filename in the field provided to save the mapped field to reuse it later.
4. Click on the Submit button.
5. The users/customers will be imported from the CSV into your online store. The window appears as shown below indicating successful import.

   

6. You can see the imported user under the Users Page as shown below:

   

Steps to Update Users

Select Update User if exists checkbox for modifying users as shown below:

Step 1: Import Settings

1. Click Import Users button, you will get Merge Users window as shown below:
2. Choose file: Browse the updated CSV file by clicking on Choose file or by FTP settings.
3. 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:

   

4. Delimiter: Enter the delimiter which separates the values.
5. Send Email to New Users: Select the checkbox to send an Email to a user on updating details.
6. Click Upload file and Import.

Step 2: Merge Users

1. Re-Map the fields if required as shown below:
2. Click on the Submit button.
3. The updated details of the users/customers will be imported from the CSV into your online store. The window appears as shown below indicating successful import.

4. 

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

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.

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:
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: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:

• 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

FTP Settings for Exporting Users

The FTP Settings for Export Users appears as shown below:

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

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

WebToffee