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.
- Navigate 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. - Install the to your WordPress / WooCommerce Site.
- You get Activation Key and Activation Email at My Account -> API Keys.
- 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
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.
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 UpdateColumn 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 Users/Customers
You can import all the required users by using Import Users. Click Import Users, the window appears as shown below:
[caption id="attachment_8313" align="aligncenter" width="577"]
Import Users- Method 1: Select a file from your computer. Click Choose File to browse a required CSV file from your computer.
- You get the mapping file option(s) for audown list as shown below:
Mapping File
- Method 2: Provide FTP Details. If your CSV file is on server, then 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.
- Enter the delimiter which separates the mapping values.
- Send Email to a new user on importing details.
- Click Upload file and Import. The import window appears as shown below:
Mapping of Fields
- You can map the fields(Woocommerce fields) with column headings ( CSV file header). Map a particular field of Map down list as shown below:
Mapping the Field
Select a required option from the drop-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
- 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.
- Assign any required constant value to field (=)
- Click Submit.
- According dow appears as shown below:
![User Import Window[/caption]</li srcset=](https://www.xadapter.com/wp-content/uploads/2016/10/import2.png)
- You can see the imported user under the Users Page as shown below:
[caption id="attachment_8346" align="aligncenter" width="1209"]
Imported User - You can see the imported user under the Users Page as shown below:
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
- Select Update User if exists checkbox for modifying users as shown below:
![Update Users Window[/caption]</li srcset=](https://www.xadapter.com/wp-content/uploads/2016/10/update_users.png)
- Click Import Users, you will get Merge Users window as shown below:
[caption id="attachment_8328" align="aligncenter" width="573"]
Merge Users - Click Import Users, you will get Merge Users window as shown below:
- Choose file: Browse the updated CSV file by clicking on Choose file or by FTP settings.
- Select a mapping file: You get the mapping file option(s) for audown list as shown below:
Mapping File
- Delimiter: Enter the delimiter which separates the values.
- Send Email to a user on updating details.
- Click Upload file and Import.
- Re-Map the fields if required as shown below:
Mapping the fields
- Click Submit.
- According dow appears as shown below:
![Merge Users Window[/caption]
<strong srcset=](https://www.xadapter.com/wp-content/uploads/2016/10/merge_user2.png)
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:
[caption id="attachment_51943" align="aligncenter" width="981"]
Export Users in CSV Format- User Roles: Select user roles for which you want to export details from the given list:
User Roles
- Offset: Enter the user row number at which you wish to start the export.
- Limit: Enter the maximum number of users that you wish to export.
- Start Date: Select the date of registration from which you want to export the users by clicking on the calendar icon.
- End Date: Select the date of registration till which you want to export the users by clicking on the calendar icon.
- Delimiter: With this field, you can change the comma separated file to your requirement.
- 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.
- Columns: Select the checkbox for required columns if you want do that, simply enter the required column name for the specific column.
- Save the export mapping: Enter a mapping filename for exporting.
- Click Export Users, the CSV file gets auto your computer. The sample users CSV file is as shown below:
Exported Users
Note: You can tomer-Export-2016_10_21_14_24_11.csv” target=”_blank” rel=”noopener noreferrer”>Sample Exported CSV.
Export User(s) from Users Page
You can directly to Dashboard > WooCommerce > Users. The Users page appears as shown below:
Users Page
- To export Users, select them. From Bulk Action drop-to 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
- Select the checkbox to enable FTP import/export Users.
- Enter FTP Server Host/IP.
- Enter FTP User Name.
- Enter FTP Password.
- Select Use FTPS checkbox to connect securely.
- Choose Enabled option tomatically Export Users from FTP Server Host/IP.
- Enter the required Export Start time for exporting the Users.
- Enter the time Interval in minutes for exporting Users.
- Choose Enabled option tomatically Import Users from FTP Server Host/IP.
- Enter the required Import Start time for importing the Users.
- Enter the time Interval in minutes for importing Users.
- Select Update Users if exist checkbox tore. Otherwise, the User is imported as a new one.
- Select a required mapping file from the Select a mapping file drop-down list.
- Click Save Settings to save settings.
For more information about corn job, please refer Setting Up The Cron Job.
- User Roles: Select user roles for which you want to export details from the given list:
Comments (2)
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.
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!