Home > Docs > WordPress Users & WooCommerce Customers Import Export > Updating the Evaluation field in the WooCommerce User Import Export Plugin

Updating the Evaluation field in the WooCommerce User Import Export Plugin

Last updated on February 11, 2024

WordPress User & WooCommerce Customers Import Export Plugin  exports and imports user data from one site to another with ease. The evaluation field in the plugin is used to  update a particular  field/column with the required value during import. This functionality is of great help when you need to update any field for a bulk of users. Following are some of the use-cases of the evaluation field that you can make use of when importing users/customers to your site. 

Evaluation Field

During import, append a value/expression to an existing item using the evaluate field. It basically selects/maps any column from the input file and computes the values with expressions and creates output.

  • Expression: Any of the operators +*/-()&@ or string constants can be used along with the attributes to manipulate the respective value. 
  • Input: Select the column from the dropdown which has to be modified.
  • Output: Sample value will be created based on the first record from the input file.

Merging 2 columns using the evaluation field

During import, there may be scenarios where you want to merge two or more columns into one. You can easily merge them using the evaluate field. Example: To merge 2 columns, display name and user email, you can use the following expression: {billing_first_name} {billing_last_name}.

Merging of billing first name and billing last name.
Merging of billing first name and billing last name.