Using Evaluation Field in WooCommerce Product Import Export Plugin

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

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:sample csv 3

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:Import-Products-settings
  2. Click Choose File to browse a required CSV file from your computer.
  3. Click Upload file and Import.
  4. Map the fields (Woocommerce fields) with column headings( CSV file header) or use the mapping file to map the field.
  5. Use 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:evalution-fieldThe 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 Evaluation field, write =cotton mixed in attribute:pa_fabric row as shown below:equal-fieldClick Submit to import the products into your online store. The modified attribute gets imported as shown below:applied-contstant-value
    • Add any required value to the field
      For example, you want to add 2 to length. Under Evaluation field, write +2 in Dimension: length row as shown below:add valueClick Submit to import the products into your online store. The modified value gets imported as shown below:added value
    • Reduce any required value from field
      For example, you want to reduce 1 from the width. Under Evaluation field, write –1 in Dimension: width row as shown below:reduce valueClick Submit to import the products into your online store. The modified value gets imported as shown below:reduced-value
    • Multiply by any required value to the field
      For example, you want to multiply the weight by 1.15. Under Evaluation field, write *1.15 in Dimension: Weight row as shown below:multiply-valueClick Submit to import the products into your online store. The modified value gets imported as shown below:multiplied value
    • Divide by any required value to the field
      For example, you want to divide sale price by 2. Under Evaluation field, write /2 in Price: Sale Price row as shown below:divide valueClick Submit to import the products into your online store. The modified value gets imported as shown below:divided-value
    • Append any field by the required value
      For example, you want to append By HikeForce to Product Title. Under Evaluation field, write &By HikeForce in Product Title row as shown below:append fieldClick Submit to import the products into your online store. The modified value gets imported as shown below:appended field 1
    • Prepend any field with the required value
      For example, you want to prepend Description to Product Description: . Under Evaluation field, write &Description[VAL] in Product Description row as shown below:prepend field 1Click Submit to import the products into your online store. The value gets imported as shown below:prepend-field

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

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

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

Leave a Reply

Your email address will not be published. Required fields are marked *