How to Update WooCommerce Product Prices Using a CSV File?

While running an online store, you may have encountered situations where you had to update the price details of several products in a single stretch. Manually updating prices is time-consuming and inefficient for large product catalogs, pointing to how limited and inconsistent the current platform is.

Bulk updating product prices is a repetitive process that takes enormous amounts of time and labor, often resulting in burnout and human errors. Such errors can have drastic impacts, especially if updating something as important as the “product price.”

Because the update process is volatile and complex, most WooCommerce store owners do not prefer manually updating their product prices. Instead, they usually use third-party plugins that offer much simpler update alternatives. The free product import export plugin for WooCommerce is one of the most common plugins used for this specific use case.

You can use WooCommerce’s default import-export settings to update product prices in bulk. However, you will need a plugin like the product import export plugin from WebToffee to export specific WooCommerce products for price updates.

In this article, we’ll guide you on updating the pricing of specific products in your WooCommerce store using a CSV file.

With the Product Import Export plugin from WebToffee, you can seamlessly update the product prices in just three simple steps.

1. Export required products from the store
2. Update the WooCommerce product price
3. Import the products back to the store

This process takes considerably less time than individually updating the prices and is relatively easy.

The only prerequisite is to install and activate the plugin in your WordPress admin console.

Step 1: Export required products from the store

With this product export plugin, you can export all or specific products in your store to a CSV file.

To export the products,

• Go to WebToffee Import Export (Basic) > Export and select Product as the export post type.

• Select which export method you want to use. You will have two options: Quick and Advanced export.

• With Quick export, you can download the CSV file by just clicking on Export at the bottom of this page. You can directly skip to Step 2 from here if this is your requirement.

In case of advanced export, proceed to filter the required products from the whole catalog.

• On the Export Product: Filter data page, select the products you want to export. Filters like Products, Exclude products, Stock status, Product categories, Product tags, and Product status help you select the exact products you want to export.

You can add specific products to the export file by selecting them in the Products field. Once done, you can proceed to rename and reorder the export columns.

• In the Map and reorder export columns page, you can select the columns you want to export.

In our case, we want to export the price columns to update them. Also, select the columns corresponding to your required product identifiers. As an example, let us select the columns Product name, ID (both to identify the products), Regular price, and Sales price.

• Now click on the Export button on the Advanced options/Batch export page.

This will download a CSV file to your system with the required products and columns.

This is a sample CSV file with the columns that we selected earlier.

Step 2: Update WooCommerce product price

Once the CSV file is downloaded, you can update the price by opening it in any spreadsheet program such as Libre Office (recommended).

The highlighted prices have been updated.

Step 3: Import the products back to the store

Now, to import the products with the updated details back to your store, you can make use of the import feature in the same Product Import Export plugin.

To import the updated CSV,

• Go to WebToffee Import Export (Basic) > Import. Select Product as the import type.

• Now choose advanced import as the import method and select the updated CSV file.

This step is to map the columns in the CSV to the standard product fields in WooCommerce. The columns will be mapped by default, so make sure the mapping is accurate before proceeding to the next step.

• In the Advanced options/Batch import page, choose Update under If products exist in the store.

You can then Import the products.

You may have to update WooCommerce product prices (sales and/or regular) after publishing the products. It may be to offer seasonal price drops, match the high demand hikes, or something else. Whatever may be your requirement, you can seamlessly update the prices of specific WooCommerce products with the free plugin Product Import Export for WooCommerce.

The premium version of this Product Import Export plugin offers several other features and customization options. If you are interested, feel free to check it out.

What do you think about this article? Comment to let us know.