WooCommerce provides the ability to update every single aspect of a product very easily. But what if you need to update the details of hundreds or thousands of products? Editing and updating products one by one is exhausting and impractical.
When it comes to e-commerce, the price of a product is an important parameter that needs to be updated now and then. With our product import-export plugin, you can bulk update product prices of both simple and variable products without having to do it manually one by one.
In this article, let us see how the price of products(highlighted ones) can be bulk updated in just a few easy steps:
- Exporting products into a CSV/XML
- Updating the CSV/XML file
- Importing products with the updated file
Exporting products into a CSV/XML
To begin with the update process, export the WooCommerce products to a CSV/XML file. Refer to How to export WooCommerce products for detailed instruction.
On successful export, you can download the exported file to your system.
Updating the CSV/XML file
To update the exported file:
- Open the file.
- Make the required changes. Here, we need to update the price of the products highlighted in the above screenshot.
- Save the file.
Importing products with the updated input file
Now, you can update the product price in WooCommerce by importing the input file. For which you have to navigate to: WebToffee Import/Export(Pro) > Import and follow the steps mentioned in How to import WooCommerce products.
On reaching step 4, choose Update for the option: If product exists in the store and import.
On successful import, the price of the WooCommerce products will get updated as shown below.