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}.
