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.
- Was this article helpful?
- Yes, thanks!Not really
July 20, 2021
HI there i have the basic plug in where i edit csv files to import vias your plug in and works great but wan to buy the premium at a stage soon but i have a question.
I get feeds from suppliers directly etc and i save and work on them. can this plug in work out the cost from supplier and automatically add a margin to this? or must i do that manually?
July 26, 2021
Using the pro version plugin you can modify the price value while importing without actually changing them in the CSV file.