Home > Docs > Product Import Export Plugin for WooCommerce > Bulk Update Price In WooCommerce

Bulk Update Price In WooCommerce

Last updated on September 26, 2023

When it comes to e-commerce, the price of a product is an important parameter that needs to be updated now and then. With the Product import export plugin for WooCommerce, 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 in the below shown image) can be bulk updated in just a few easy steps:

  1. Export products into CSV/XML/TSV/XLS/XLSX file formats.
  2. Update the exported file.
  3. Import products with the updated file.
Products in WooCommerce store
Products in WooCommerce store

Export products

To begin with the update process, export the WooCommerce products. Refer to How to export WooCommerce products for detailed instructions.

On successful export, you can download the exported file to your system.

Update the exported file

To update the exported file:

  1. Open the file. 
  2. Make the required changes. Here, we need to update the price of the products highlighted in the above screenshot.
  3. Save the file.
Prices updated in input file
Prices updated in input file

Import 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.
Updating existing product
Updating existing product
  • On successful import, the price of the WooCommerce products will get updated as shown below.
WooCommerce Products with updated prices
WooCommerce Products with updated prices