Export WordPress Users & WooCommerce Customers

Including all the users in your new website or updating each user’s information manually, can be dawdling! The WordPress User & WooCommerce Customers Import Export Plugin helps you to export a CSV file that includes all the WordPress user’s data and import the same to the website much more quickly. To export the Users/Customers:

1. Select the post type as Users/Customers.
2. Select an export method.
3. Filter data.
4. Map and reorder export columns.
5. Use advanced options/ batch export and scheduling.

To export WordPress users / WooCommerce customers, click on WebToffee Import/Export(Pro) > Export.

As a first step, you need to choose the post type as Users/Customers.

Choose from the below options to continue with your export:

•  Quick export from DB
•  Based on a pre-saved template 
•  Advanced export

Let us have a look at each of these export methods:

• exports the basic/standard fields of the respective post type. 
• To include fields from Meta(custom fields) and Hidden meta select the respective group’s checkboxes.
•  Click the Export button to complete the action or proceed to Step 3 for advanced options.
• Navigate to Step 5 to know more about Advanced options/ Batch export/ Scheduling.

• exports data as per the specifications(filters, selective column, mapping.. etc) from the previously saved file.
• By selecting this option, one can choose a previously saved template from the Export template drop-down.
  Note: The template will be listed in the drop down only if you have saved it in previous exports, if you go through the Advanced export, at Step 5 you will get an option to save the template. Once you save that, next time when you want to export a pre-saved template, it will be populated within the drop down.
•  Click the Export button to complete the action or proceed to Step3 to filter data.
• Navigate to Step 3 to know more about filtering options.

• This option will take you through a detailed process of filtering/column selection/advanced options that may be required for your export.

Click on Step 3, to view the following window where one can filter data on the basis of:

1. Total number of users to export : The actual number of users you want to export. e.g. Entering 500 with a skip count of 10 will export users from 11th to 510th position.
2. Skip first n users : Specify the number of users to be skipped from the beginning. e.g. Enter 10 to skip first 10 users from export.
3. User Roles : Input specific roles to export information pertaining to all customers with the respective role/s
4. User Email : Input the customer email to export information pertaining to only these customers
5. Date From : Date on which the customer registered. Export customers registered on and after the specified date.
6. Date To : Export customers registered up to the specified date.
7. Sort Columns : Sort the exported data based on the selected columns in the order specified. Defaulted to ascending order.
8. Sort by: Defaulted to ascending. Applicable to above-selected columns in the order specified.

• Click on Step 4 to proceed further.

Here, one can map and reorder the export columns under the following 3 fields:

• Default fields: The column names appearing in this section can be edited if required. The preferred names and choices that were last saved can be viewed on choosing a pre-saved template. One can also move the columns to reorder the arrangement.
• Meta(custom fields)
• Hidden meta

• Click on Step 5 to proceed.

• On reaching Step 5, the following window will appear, from where one can:

1. Export guest users: Exports information related to guest users.
2. Export file name: Specify a filename for the exported file. If left blank, the system generates a default name.
3. Export file format: Both CSV and XML are available.
4. Delimiter: Separator for differentiating the columns in the CSV file. Assumes ‘,’ by default.
5. Enable FTP export: On opting ‘Yes’, choose an FTP profile and specify the export path or use default path.

• Save the template file for future export as shown below(if needed).

• Click on Export and export or schedule the export to finish. 

Know more about WordPress Users & WooCommerce Customers Import Export Plugin.