Using Evaluation Field in WooCommerce Product Import Export Plugin

The evaluation field is used to fix/update the required value for a particular mapping field. 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. With this, you can also append or prepend a text, or fix the mapping field to a constant value.

Now, let’s understand adding Evaluation fields during the Product Import through example.

Suppose, your CSV file is as shown below:

Note: Click the Sample CSV of Evaluation field to download it.

1. Navigate to Admin settings (WooCommerce > Product Im-Ex) of the Plugin. Under the Product tab, the Import window appears as shown below:
2. Click Choose File to browse a required CSV/XML file from your computer.
3. Click Upload file and Import.
4. Map the fields (Woocommerce fields) with column headings( CSV file header or XML tag header). Instead, use an existing mapping file to map the field if present.
5. Use the Evaluation field to fix/update the required value for the particular field. Hover the mouse on? (Help), you can see the information about Evaluation field as shown below:
6. The options to modify the field with examples  are as given below:
   • Assign any required constant value to field
     For Example: Suppose, you want to assign cotton mixed to attribute:pa_fabric. Under the Evaluation field, write =cotton mixed in attribute:pa_fabric row as shown below: Click Submit to import the products into your online store. The modified attribute gets imported as shown below:
   • Add any required value to the field
     For example, you want to add 2 to length. Under the Evaluation field, write +2 in Dimension: length row as shown below: Click Submit to import the products into your online store. The modified value gets imported as shown below:
   • Reduce any required value from a field
     For example, you want to reduce 1 from the width. Under the Evaluation field, write –1 in Dimension: width row as shown below: Click Submit to import the products into your online store. The modified value gets imported as shown below:
   • Multiply by any required value to the field
     For example, you want to multiply the weight by 1.15. Under the Evaluation field, write *1.15 in Dimension: Weight row as shown below: Click Submit to import the products into your online store. The modified value gets imported as shown below:
   • Divide by any required value to the field
     For example, you want to divide the sale price by 2. Under the Evaluation field, write /2 in Price: Sale Price row as shown below: Click Submit to import the products into your online store. The modified value gets imported as shown below:
   • Append any field by the required value
     For example, you want to append By HikeForce to Product Title. Under the Evaluation field, write &By HikeForce in Product Title row as shown below: Click Submit to import the products into your online store. The modified value gets imported as shown below:
   • Prepend any field with the required value
     For example, you want to prepend Description to Product Description: Under the Evaluation field, write &Description[VAL] in Product Description row as shown below: Click Submit to import the products into your online store. The value gets imported as shown below:

   The plugin adds the product to your online store by using the Evaluation field by modifying the field value in CSV/XML.

To know more about other features of the plugin, read the documentation.