Documentation/Import Export Suite for WooCommerce/How to import or export WooCommerce Users/Customers

How to import or export WooCommerce Users/Customers

Export Users

The users can be exported in few easy steps:

Step 1: Select a post type

With this plugin, you can export/download WordPress Users/WooCommerce customers into a CSV or XML. The exported file can be used to import users back into your WordPress/WooCommerce site.

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

WooCommerce User Export-Step 1

Step 2: Select an export method

Choose from the options below to continue with your export: quick export from DB, based on a pre-saved template or a new export with advanced options.

WooCommerce User Export-Step 2

The below sections will explain how each of the export is done.

Quick Export

Quick export only exports all the basic/standard fields of the respective post type. You do not get to selectively filter the columns with this option except for the groups based on taxonomies/attributes/meta/hidden meta.

To include fields from either meta(custom fields) or hidden meta enable the respective groups. Now you can either click the Export button to start the Export or go to the Advanced options/Batch export window to enable batch export of users.

You can go to step 5 to know more about the advanced options.

From pre-saved template

Using a pre-saved template retains the previous filter criteria and other column specifications as per the chosen file and export data accordingly. You can also edit this file in the process and export it accordingly or export straightaway.

When this option is selected you will be able to choose a previously saved template from the Export template drop-down.

Once you select the template you can either edit its filters by clicking the Filter data button or go straight with Export. Navigate to step 3 to know more about filtering options.

New Export

A new export will take you through the entire process of filtering/column selection/advanced options that may be required for your export. You can also save this file for future use.

Move on to next step to filter the data.

Step 3: Filter data

Filter data that needs to be exported as per the below criteria.
WooCommerce User Export-Step 3

  • Offset-Specify the number of users that should be skipped from the beginning. e.g. An offset of 10 skips the first 10 users.
  • Limit – The actual number of users you want to export. e.g. A limit of 500 with an offset 10 will export users from 11th to 510th position.
  • User Roles – Input specific roles to export information pertaining to all customers with the respective role/s
  • User Email– Input the customer email to export information pertaining to only these customers
  • Date from – Date on which the customer registered. Export customers registered on and after the specified date.
  • Date to – Export customers registered up to the specified date.
  • Sort Columns – Sort the exported data based on the selected columns in the order specified. Defaulted to ascending order.
  • Sort by: Defaulted to ascending. Applicable to above-selected columns in the order specified.

Step 4: Map and reorder export columns

The default export column names can be seen in the screen below. You can edit these if required. If you have chosen a pre-saved template you can see the preferred names and choices that were last saved. You may also drag the columns accordingly to reorder them within the output file.

WooCommerce User Export-Step 4

You can map the columns for export on the basis of following grouped categories:

  • Default fields
  • Meta(Custom fields)
  • Hidden meta

Step 5: Advanced Options/Batch Export/Scheduling

Use advanced options from below to export guest users, delimiter options, and schedule an export. You can also save the template file for future exports.
WooCommerce User Export-Step 5

  • Export Guest Users: Enable this option to export information related to guest users
  • Download file format: You can export the users either in CSV or XML format.
  • Delimiter: Separator for differentiating the columns in the CSV file. Assumes ‘,’ by default.
  • Enable FTP export: On opting ‘Yes’, choose an FTP profile and specify the export path.
  • Export in batches of – Here you can give the number of records that the server will process for every iteration within the configured timeout interval. If the export fails you can lower this number accordingly and try again. It has defaulted to 0 records.

Now if you wish to save the configured settings for export, you can click the Save template button. It opens a popup to add a name for the template.

After naming the template click the Save button. Now the saved template will be visible on the previous templates list for you to choose from.

Alternatively, you can click on Export to directly get the file downloaded into your system.

Import Users

Step 1: Select post type

You can import users from a CSV/XML. As a first step, you need to choose Users from the post type drop down to start the import. Now hit the Select import method button to proceed with the next step.
WooCommerce User Import-Step 1

Step 2: Select the import method

Import Method

Choose from the options below to continue with your import: quick import, based on a pre-saved template, or a new import with advanced options.

Quick Import

Quick import only imports the fields from the input file that conforms to the specific column headers as required by the plugin. You do not get to selectively filter the columns with this option except for the groups based on taxonomies/attributes/meta/hidden meta. Use this option primarily when your input file was exported using the same plugin.

After selecting Quick Import as the import method, you can either start the Import or go to Advanced Options/Batch import to import users in batches. You can go to step 4 to know more about advanced options.

From pre-saved template

Using a pre-saved template retains the previous filter criteria and other column specifications as per the chosen file and imports data accordingly. You can also edit this file in the process and import it accordingly or import straightaway.

New import

A new import will take you through the entire process of filtering/column selection/advanced options that may be required for your import. You can also save this file as a template for future use.

Import Source(CSV/XML)

The products can be imported from following file formats:

  • Import from Local
  • Import from URL
  • Import from FTP

Step 3: Map and reorder import columns

Map the standard/meta/attributes/taxonomies and hidden meta columns with your CSV/XML column names.

WooCommerce User Import-Step 3

Columns are mapped automatically only if a matching header name is found in the input file. If not the value is left blank. If your input file header does not have exact names or if you need to edit the existing mapping you can simply click on the respective value fields corresponding to each row. Furthermore you can also assign expressions based on the existing input file columns.

The columns are further grouped into following categories:

  • Default fields
  • Taxonomies
  • Meta(Custom fields)
  • Attributes
  • Hidden meta

Evaluate field

Evaluate field can be used to append a value/expression to an existing item while import. It basically selects or map any column from the input file and compute values with expressions and creates output.

  • Input: Select the column from the drop down which has to be modified.
  • Expression: Any of the operators +*/-()&@ or string constants can be used along with the attributes to manipulate the respective value. Enclose the operations within square brackets. e.g. if you want to increase the stock quantity of all imported products by 5 units during import simply use [{_stock}+5]. 
  • Output: Sample value will be created based on first record from input file.  You can use the expression as value to proceed the import with modified value.
    Note:Columns that have no values in the input file may cause syntax errors if used in an expression as above.

Step 4: Advanced Options/Batch Import/Scheduling

Use advanced options from below to update existing users, retain passwords of users, or schedule an import. You can also save the template file for future imports.
WooCommerce User Import-Step 4

You can either import users directly into your store or schedule the import using FTP.

To schedule the import, hit the schedule option, you will be taken to the cron schedule window as shown below:

The plugin supports two different schedule types:

  • WordPress Cron: This type of scheduler depends on WordPress for scheduling your job at the specified time. However, this model is dependent on your website visitors. Upon a visit, WordPress Cron will check to see if the time/date is later than the scheduled event/s, and if it is– it will fire those events.
  • Server Cron: You can use this option if you have a separate system to trigger the scheduled events.

The server cron method will generate a unique URL that can be added to your system in order to trigger the events. You may need to trigger the URL every minute depending on the volume of data to be processed.

In addition, the import/export can be scheduled on a daily, weekly, monthly, or on a custom basis. The time at which the import has to be scheduled can also be configured.

Alternatively, to straightaway proceed with the import, hit on the import option. You can see the progress of the import. Once the import is completed, a pop-up will be displayed showing import status which contains the number of successful imports and failed imports (if any).


WooCommerce User Import-Import Completed

History

You can view a list of the runs and the status corresponding to every import/export with options to re-run, view a detailed log, or delete an entry in the History section.

Here you have different filters available to sort the list. You can sort it by the action type (ie; all/export/import), status ( all/finished), date ( ascending/descending), and by the maximum records to be included in a page.

To know more about the general settings, refer here.

  • Was this article helpful?
  • YesNo