Discount Sale
  • Days
  • Hrs
  • Mins
  • Secs
30% Off

Use coupon code 'MDS30' Limited Offer!!

Star

Home > Docs > Bulk Update Numerical Fields While WooCommerce Product Import/Export

Bulk Update Numerical Fields While WooCommerce Product Import/Export

Last updated on May 14, 2025

The Product Import Export Plugin for WooCommerce includes an evaluation field that allows you to fix and update a particular mapping field with the required value. This feature is especially useful when updating or correcting mapping fields for bulk products. Using the plugin, you can modify any numerical field with calculation modes such as addition, subtraction, multiplication, and division. Additional functions include appending or prepending text or setting a mapping field to a constant value. This article explains in detail how the evaluation field works and how it can streamline your product import and export process.

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:


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:

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. Update single field

  • From the Product fields listing, one can map the required single field with the column. Then select the corresponding mapping.
  • If the field needs to append a value/expression to an existing item while importing, Click on the transform Icon and enter the expression. It basically selects/maps the particular 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 input file.
mapping single field
Mapping single field
Adding expressions while mapping
Adding expressions while mapping

7. 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 column values will appear as:
merged sku and post title columns

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

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