How to Bulk Edit WooCommerce Product Prices (3 Methods)

You can bulk edit WooCommerce product prices with WP Sheet Editor, a spreadsheet plugin for managing your store’s catalog. It handles regular prices, variation prices, and wholesale prices across hundreds or thousands of items at once using three workflows: updating cells directly in a spreadsheet, applying bulk price rules (fixed value, increase, or decrease by amount/percentage), or exporting your catalog to CSV for offline editing and reimporting it.

Important:This tutorial covers updating regular prices across your catalog. If you need to set promotional discounts and schedule date ranges, see our step-by-step guide on how to bulk edit WooCommerce sale prices and discount dates.

3 methods to bulk update WooCommerce product prices

WP Sheet Editor provides three workflows for updating product pricing in WooCommerce:

• Direct spreadsheet editing: Edit prices directly inside spreadsheet cells within your WordPress dashboard. This method works best for fast, manual adjustments to regular prices.
• Bulk editing formulas: Apply batch adjustments across entire categories, filtered search results, or manually selected items. You can increase or decrease prices by fixed amounts or percentages, or set uniform flat rates in one execution.
• CSV export and import: Export pricing columns to CSV for offline updates in Microsoft Excel or Google Sheets. Once external formulas or supplier changes are applied, re-import the file to sync updated prices using product IDs or SKUs.

Method 1: Edit prices directly in the spreadsheet

You can update multiple prices directly in the spreadsheet interface. This method allows you to view and manage your entire catalog on a single screen without opening individual product pages.

Follow these steps:

1. Locate the Regular price column.
2. Enter your updated price values directly into the cells.
3. Click Save in the top toolbar to store your changes.

Method 2: Apply bulk pricing formulas across multiple products

In addition to editing individual cells, you can apply bulk price updates across your entire catalog, specific categories, or custom filtered lists.

Available pricing actions include:

• Setting a uniform fixed price across multiple products
• Increasing prices by a specific numeric amount or percentage
• Decreasing prices by a specific numeric amount or percentage
• Replacing specific values across your catalog

Step 1: Select the products you want to update

Before applying a bulk change, specify which products should be modified. You have three ways to target products:

Option 1: Update all products catalog-wide. If you want to modify your entire catalog at once, skip the search filters and proceed directly to Step 2.

Option 2: Manually select specific products. Use the checkboxes in the leftmost column of the spreadsheet to pick specific rows. This works best when updating a small group of items that do not share a common category, tag, or attribute.

Option 3: Filter products using the Search tool. This approach is ideal for large stores where the target products share specific attributes or taxonomy terms, such as:

• Keyword
• Category
• Attribute
• Tag
• Regular price range
• Sale price status
• Stock status
• Shipping class
• Product status
• Custom fields
• Any other available product field

For example, you can target items within a specific category, products below a target margin, items from a particular vendor, or products currently on sale.

Click Search on the top toolbar to open the filter options.

To filter products by keyword (for example, shoes), enter shoes in the Contains keyword field and click Run search.

The spreadsheet will refresh to show only the matching rows.

Once your target products are displayed, click Bulk Edit in the top toolbar.

Step 2: Configure the bulk price adjustment

After opening the Bulk Edit tool, select the type of pricing adjustment you want to perform.

Bulk update 1 – Set a uniform price for all selected products

To apply the exact same price across all selected or filtered items, configure the following fields:

• Select the rows that you want to update: Choose Edit all the rows from my current search (for catalog-wide or filtered updates) or Edit all the rows that I selected manually in the spreadsheet.
• What field do you want to edit: Regular Price (or any other pricing field).
• Select type of edit: Set value
• Replace existing value with a new value: Enter the fixed price amount.
• Select Edit only parent products (or include variations depending on your catalog structure).
• Click Execute Now.

Once the process finishes, the spreadsheet will display the updated prices across all selected rows.

Bulk update 2 – Increase prices by a percentage

For a detailed walkthrough on applying percentage increases to specific categories, variations, or price ranges, see our full guide on how to bulk increase WooCommerce prices by a percentage.

To add a percentage increase across your selected items, set the following parameters:

• Select the rows that you want to update: Choose Edit all the rows from my current search or Edit all the rows that I selected manually in the spreadsheet.
• What field do you want to edit: Regular Price
• Select type of edit: Increase by percentage
• Increase by: Enter the percentage number to add (e.g., 15 for 15%).
• Select Edit only parent products.
• Click Execute Now.

Bulk update 3 – Increase prices by a fixed numeric amount

To add a specific dollar amount to current prices, configure the tool as follows:

• Select the rows that you want to update: Choose Edit all the rows from my current search or Edit all the rows that I selected manually in the spreadsheet.
• What field do you want to edit: Regular Price
• Select type of edit: Increase by number
• Increase by: Enter the numeric amount to add.
• Select Edit only parent products.
• Click Execute Now.

Bulk update 4 – Decrease prices by a fixed numeric amount

To subtract a specific monetary value from current prices, use these settings:

• Select the rows that you want to update: Choose Edit all the rows from my current search or Edit all the rows that I selected manually in the spreadsheet.
• What field do you want to edit: Regular Price
• Select type of edit: Decrease by number
• Decrease by: Enter the amount to subtract.
• Select Edit only parent products.
• Click Execute Now.

Bulk update 5 – Decrease prices by a percentage

To apply a percentage discount across selected items:

• Select the rows that you want to update: Choose Edit all the rows from my current search or Edit all the rows that I selected manually in the spreadsheet.
• What field do you want to edit: Regular Price
• Select type of edit: Decrease by percentage
• Decrease by: Enter the percentage to subtract.
• Select Edit only parent products.
• Click Execute Now.

Method 3: Bulk edit product prices via CSV export and import

Exporting and importing pricing data allows you to work offline. You can download current prices into a CSV file, make adjustments in Excel or Google Sheets, and re-import the file to update your store.

Step 1. Export product prices to a CSV file

Click Export on the WP Sheet Editor toolbar.

The Export tool lets you customize which products and fields to include in the exported file.

Configure the export settings:

• What columns do you want to export: Select product name and Regular price. You can also include product ID, category, SKU, or stock status for reference.
• Which rows do you want to export: Export all products, apply search filters to target a specific subset, or export manually selected rows.
• What app will you use to edit this file: Choose your spreadsheet application (e.g., Microsoft Excel, Google Sheets, or other CSV editors).
• Name of this export (optional): Save this export configuration if you plan to run it regularly.
• Click Start new export.

Step 2. Modify prices in the CSV file offline

Open the downloaded file in your spreadsheet software and update the values in the Regular price column.

You can modify numbers manually, use spreadsheet formulas, calculate percentage adjustments, or apply supplier price sheets.

Step 3. Import updated prices back to WooCommerce

Once adjustments are complete, save the CSV file and return to WP Sheet Editor in WordPress.

Click Import in the top toolbar to launch the import wizard.

Configure the source file:

• Source: CSV file from my computer
• Click Choose File and select your edited CSV file.
• Click Next.

Select the columns to import:

• Import all the columns
• Select individual columns to import (e.g., matching field and Regular Price)

Set matching and update rules:

• Select the option to update existing items.
• Ignore new items if you are only updating existing product data.
• Set the matching field to Product ID or Product SKU so the plugin accurately maps updates to existing products.
• Click Next.

Before executing the import, WP Sheet Editor displays a preview comparing current product values against incoming data from the CSV.

Review the preview to verify that product rows and pricing fields align correctly.

If the mapped values are correct, click The preview is fine, start import.

The plugin will process the file and update the matching items. Once complete, a confirmation screen displays the total number of items updated. Reload the spreadsheet to verify the new prices in the Regular price column.

Related pricing tutorials

• Bulk edit variation prices
• Manage WooCommerce wholesale prices in bulk
• Bulk remove decimals from product prices
• Add 99-cent pricing to product prices in bulk

Schedule automated price changes

To automate promotional schedules or recurring price updates, use the Automations add-on:

• Schedule price updates in bulk
• Automate price and stock changes
• Import prices and stock from FTP servers