Home > Docs > Product Import Export Plugin for WooCommerce > Using Evaluation field in WooCommerce Product Import Export Plugin

Using Evaluation field in WooCommerce Product Import Export Plugin

Last updated on November 1, 2023

Evaluation field is used to fix and update a particular mapping field with the required value. This field is of great help when you need to fix/update any mapping field for bulk products. You can modify any numerical field by using calculation modes like addition, subtraction, multiplication, and division. Other functions include, appending and prepending a text, or fixing the mapping field to a constant value. This article explains the functions carried out by the evaluation field in detail.

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.

Using Evaluation Field

1. Assign any required constant value

To assign the value, dry clean to attribute:Instructions. Under the Evaluation field, write dry clean in attribute:Instructions row as shown below:
attribute-value-modified
On import, the modified attribute will appear as:
attribute-value-in-product

2. Incrementing a value

Adding 10 to the regular price. Under the Evaluation field, write +10 in Price: Regular Price row as shown below:
add-value-in-expression

On import, the modified regular price value will appear as:
increased-regular-price

3. Decrementing a value

Reducing 2 from the sale price. Under the Evaluation field, write -2 in Price: Sale Price row as shown below:
reduce-value-in-expression

On import, the modified sale price will appear as:
reduced-sale-price

4. Appending a value

Appending the value, By WebToffee to Product Title. Under the Evaluation field, write &By WebToffee in Product Title row as shown below:
appending-value-in-product-title

On import, the modified value will appear as:
appending text with post title

5. Prepending a value

Prepending the value, Description: to the Product Description. Under the Evaluation field, write Description:  in Product Description row as shown below:
prepending-value

On import, the modified value will appear as:
prepend-description

6. Merging 2 columns

During import, there may be scenarios where you want to merge two or more columns into one. You can easily merge them in the evaluate field.

Example: To merge 2 columns, SKU and Product name, you can use the following expression: {sku} {post_title}.
merging two columns while mapping during import

On import, the merged columns values will appear as:
merged sku and post title columns

7. Increasing price by percentage

To increase the regular price by 5%, you have to multiply the regular price by 1.05.

Example: During import, if the value of original regular price is: 11.99, and you want to increase the price by 5%, then, while mapping, use the expression: [{regular_price}*1.05] in the Price:regular price column.

Ensure to enclose the expressions in square brackets.

increasing-price-by-percentage-while-mapping

On import, the modified regular price value will appear as:
increamented price percentage value after import

8. Updating stock

To increase the stock quantity of all imported products by 5 units, use the expression: [{stock}+5] in the Inventory: Stock column while mapping.

Ensure to enclose the expressions in square brackets.Updating stock via importing products

On import, the modified stock value will appear as:update stock value after import

Related articles: