Update existing values on import using evaluation field

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.

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.

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:
   
   
   On import, the modified attribute will appear as:
   
   
   
2. Incrementing a value
   
   Adding 10 to the regular price. Under the Evaluation field, write +10 in Price: Regular Price row as shown below:
   
   
   On import, the modified regular price value will appear as:
   
   
   
3. Decrementing a value
   
   Reducing 2 from the sale price. Under the Evaluation field, write -2 in Price: Sale Price row as shown below:
   
   
   On import, the modified sale price will appear as:
   
   
   
4. Appending a value
   
   Appending the value, By HikeForce to Product Title. Under the Evaluation field, write &By HikeForce in Product Title row as shown below:
   
   
   On import, the modified value will appear as:
   
   
   
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:
   
   
   On import, the modified value will appear as:
   
   

Refer to other related articles:

• Importing Products
• Importing WooCommerce Products with Attributes.