Are you looking for a way to update product field values in bulk, such as product prices and quantities? If so, you are at the right place. This article will show you how to update product field values using the Product import action.
Updating product field values in bulk is not just a convenience; it’s a time-saving necessity for effective store management. It streamlines the process of making changes across your product catalog, ensuring consistency in pricing, descriptions, and other essential details.
Besides, these bulk updates not only aid in scaling your store but also play a crucial role in keeping your product listings competitive and current. By swiftly adapting to market changes, you can ensure your store remains a top choice for customers.
Here, we will show you how to update product field values in bulk using the free version of the WooCommerce Product Import plugin by WebToffee.
Key Takeaways
- Bulk updating product field values is an excellent way to make changes to multiple products simultaneously, reducing time and effort and ensuring consistency.
- Specialized plugins like WebToffee’s Product Import plugin allow you to make bulk updates to product field values with minimal effort, giving you the confidence to manage your store effectively.
Follow the below steps to update product field values in bulk using the Product Importer plugin.
Step 1: Install WebToffee Product Import Export Plugin
- From the WordPress dashboard, go to Plugins > Add New.
- Search for WebToffee Product Import Export Plugin. Click Install Now and then activate the plugin.
Step 2: Select Product as Post Type to Update
- From the dashboard, go to WebToffee Import Export (Basic) > Import.
- Choose the post type to import as Product and click the Select import method.
Step 3: Select Advanced Import Method for Updating Products
- Select the import method as Advanced import, which allows you to import data with filters, column selection, and other advanced options.
- To import a product, upload a CSV file. After uploading your file, click the Map import column button.
You can also save these settings for future use.
Step 4: Update Product Field Values
The column names of your CSV file will map to the product field names.
Note: Columns are automatically mapped only if a matching header name is discovered in the input file. If not, the value is left blank.
This is how you carry out the import mapping column.
- Select the drop-down icon next to the product field. The CSV file references each column.
- From the drop-down menu, select the column you want to correspond with the product field.
While importing the map columns, clicking the pencil icon opens a pop-up to set the value for the product fields.
Here, update the value to an existing product field value during import. For e.g.: [{stock} + 10].
In short, it maps a column in the input file with a product field, carries out the specified computation task, and then updates the current field value with the new one (result after computation).
- Expression: The field value can be changed using any of the operators +, *, /, -, (), &, @, or string constants. Eg: [{regular_price}+10]
- Input file columns: Select the column you need to change from the dropdown.
- Output/ Preview: The plugin will generate a sample value based on the first record from the input file. For example, if the regular price is initially 30, and you add 10, the sample value will be 40.
Note: Columns with null values in the input file may cause syntactic issues when used in an expression. It’s important to ensure that all columns have valid values to avoid errors during the import process.
1. Assign Any Constant Value You Need
For example, Say you want to assign the value- ‘flat rate’ to the product field ‘tax:product_shipping_class.’
Click on the pencil icon corresponding to the product field, and set the field value to‘ flat rate.’
Upon import, the shipping class of all the products imported via the CSV will be changed to ‘Flat rate’ (as shown below).
2. 2. Increase Product Price
For example, increase the cost by ten dollars.
Enter ‘[{regular_price}+10]’ in the Set value for column window corresponding to the ‘Price: Regular Price’ row:
If the initial price is 30, the regular price will change to 40.
3. Decrease the Value of a Sale Price
For example: Taking 10 off the selling price.
As seen below, enter ‘[{sales_price}-10] in the Set value for column window for the product field ‘Price: Sale Price’:
The revised sale price (if the initial price was 25) will now be as follows upon import:
4. Appending a Value
For example: Add the term ‘By Sonadora Cafe’ at the end of the product title.
Put ‘{post_title}& By Sonadora Cafe’ in the Product Title row under the transform window:
The updated value will display as follows upon import:
5. Prepend a Value
Add the constant text ‘Description:’ before the original Product Description.
Enter ‘Description: {post_content}’ in the Product Description row in the transform window.
When imported, the value will show up as follows:
6. Combine Two Columns
There can be times when you want to combine two or more columns into one during import. Using the Transform option, you may easily integrate them.
Example: Use the expression, ‘[{sku} {post_title}]’ to combine the two columns “SKU” and “Product name.”
When imported, the values of the merged columns will show up as:
7. Increase the Price by a Percentage
Example: If the original regular price during import is 40, and you want to increase the price by 5%, the product price will be 42.
Use the equation ‘[{regular_price}*1.05]’ in the column ‘Price: regular price.’
(To increase a value by 5%, you multiply the original value by 1.05x)
Make sure to put square brackets around the expressions.
The changed normal price value will be displayed as:
8. Updating the Stock
If you want to update the inventory quantity by 10 units, use the expression ‘[{stock}+10]’ corresponding to the field ‘Inventory: Stock column’.
The updated stock value will show up as:
Using these logical expressions, you can bulk update all the products and product field values on your WooCommerce store. Be aware that any changes you make will apply to all the products in the input file.
If you want to update a specific category of products, use the same Product Import Export plugin to export the required products in a CSV file using custom filters. Then, use the exported file as input to update the product field values.
The transform option allows you to edit or change the file columns during importing. This feature is very useful when updating or fixing mapping data for bulk products.
The Product Import Export Plugin we mentioned in this article also has a premium version with advanced import export options. You can check it out to learn more about its capabilities.
I hope this article has guided you in the right direction. If you have any questions, please mention them below.
Hope this article led you in the right direction. We encourage you to read how to update specific WooCommerce product prices using CSV. If you have any queries, please mention them below.
