Setting up WordPress Users & WooCommerce Customers Import Export Plugin

This tuto know more about the plugin features.

Overview

WordPress Users & WooCommerce Custore.

You can import users/customers details using one file which saves your effort and time of manually adding user information.

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

You can map your import columns to your computer.

For importing users/custore.

Plugin easily exports users/customatically 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 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 WooCommerce Admin Menu

WooCommerce Admin Menu

User/Customer Import/Export tab

The plugin takes CSV file as input. It maps each field of CSV file tomers.

For example: custo 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.

To get started you must have CSV file. You can create the one by exporting the Users/Custo get the format of CSV, download Sample User CSV.
You must enter the Users/Customers details in CSV file in structured format as given below:
  • The first row must contain the column headers which are used for mapping the fields. The details about mapping field is 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 tor 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 the single user.

The Import Screen appears as shown below:

Import Window

Import Window

You can import 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 Users

Import Users

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

    Mapping File

  3. Method 2: Provide FTP Details. If your CSV file is on server, then 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 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

    It is used to modify the field are as given below:

    Settings for Evaluation fields

    Settings for Evaluation fields

    • Assign any required constant value to field (=)
      For Example : Suppose, you want 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 tore. The import window appears as shown below:
    User Import Window

    User Import Window

  10. You can see the imported user under the Users Page as shown below:
    Imported User

    Imported User

Update Users

Suppose your existing user details got modified. To reflect that modified details intore, 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:
    Mapping File

    Mapping File

  5. Delimiter: Enter the delimiter which separates the values.
  6. Send 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:
    Merge Users Window

    Merge Users Window

    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.

You can export all the required Users by using the Export Users option. The window appears as shown below:

WordPress Users & WooCommerce Customers Import Export Plugin - Export Settings

Export Users in CSV Format

  1. User Roles: Select user roles for which you want to export details from the given list:
    User Roles

    User Roles

  2. Offset: Enter the user row number at which you wish to start the export.
  3. Limit: Enter the maximum number of users that you wish to export.
  4. Start Date: Select the date of registration from which you want to export the users by clicking on the calendar icon.
  5. End Date: Select the date of registration till which you want to export the users by clicking on the calendar icon.
  6. Delimiter: With this field, you can change the comma separated file to your requirement.
  7. 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.
  8. 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 CSV file. To do that, simply enter the required column name for the specific column.
  9. Save the export mapping: Enter a mapping filename for exporting.
  10. Click Export Users, the CSV file gets auto your computer. The sample users CSV file is as shown below:
    Exported Users

    Exported Users

    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 CSV file.

Settings tab

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

FTP Settings for Exporting Users

The FTP Settings for Export Users appears as shown below:

FTP Settings for Export Users

FTP Settings for 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. Select Use FTPS checkbox to connect securely.
  6. Choose Enabled option tomatically Export Users from FTP Server Host/IP.
  7. Enter the required Export Start time for exporting the Users.
  8. Enter the time Interval in minutes for exporting Users.
  9. Choose Enabled option tomatically Import Users from FTP Server Host/IP.
  10. Enter the required Import Start time for importing the Users.
  11. Enter the time Interval in minutes for importing Users.
  12. Select Update Users if exist checkbox tore. Otherwise, the User is imported as a new one.
  13. Select a required mapping file from the Select a mapping file drop-down list.
  14. Click Save Settings to save settings.
    For more information about corn job, please refer Setting Up The Cron Job.

Check out our 

Comments (2)

  • MakeOnlineShop

    Hello,

    I only have a list of emails in a text file, 1 email on each line, how can I import it with your plugin ?

    Thank you.

    February 28, 2017 at 4:28 pm
    • Anindo

      You can just use one column user_email in CSV to import users with this plugin.
      If you want to assign any roles, you can use one more column roles , there you can put customer for Customer user

      Only user_email column is mandatory for creating user.

      Hope that helps!

      February 28, 2017 at 8:22 pm

Leave a Reply