You can search and replace WooCommerce prices in bulk using WP Sheet Editor – WooCommerce Products. Instead of opening products one by one, you can find the products you need and update their prices directly from a spreadsheet.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
The process has two steps:
- Filter your store catalog to find products with a specific price.
- Use the bulk editor to replace that price with a new value for all the matching products.
Step 1: Search for products by price
First, open the WP Sheet Editor spreadsheet from your WordPress dashboard by going to WP Sheet Editor > Edit Products.
Next, click the Search tool in the top toolbar.
This tool allows you find the products you want to update based on their current price.
In the search panel, configure the following options:
- Tick the Enable advanced filters checkbox.
- Field: Select Regular price (
_regular_price) or Sale price (_sale_price), depending on which type of price you want to find. - Operator: Select
=(equals). You can also use operators such as>or<when you want to find products above or below a particular price. - Value: Enter the price you want to find, such as
45. - Click Run search.
The spreadsheet will refresh and show only the simple products and variation rows that match the price you searched for.
Step 2: Replace the old price with the new price
After filtering the products, click Bulk Edit in the top toolbar. Enter the following settings:
- Select the rows that you want to update: Choose Edit all the rows from my current search. This ensures that the change is applied only to the products returned by the search in Step 1.
- What field do you want to edit: Select Regular price or Sale price, depending on the price you searched for.
- Select type of edit: Choose Set value.
- Replace existing value with this value: Enter the new price, such as
15.99. This value will replace the old price on the selected products. - Select what you will edit: Choose the product level you want to update based on how your catalog is set up:
- Edit only parent products
- Edit only variations
- Click Execute Now.
WP Sheet Editor processes the updates in batches to avoid timeouts. Once the process finishes, the new prices will be reflected on your WooCommerce products.