In this tutorial, we will show you how to bulk edit WooCommerce product prices using a spreadsheet.
These are some of the things you will be able to do when bulk updating prices automatically in WooCommerce:
- Auto increase product prices in bulk every X days, weeks, or months
- Auto decrease product prices in bulk every X days, weeks or months
- Increase prices by specific amount every X months (example: increase $1 every 1 month)
- Increase prices by specific percentage every X months (example: increase 10% every 3 months)
- Gradually increase product prices every month or every year
- Decrease prices by specific amount every month (example: decrease $1 every 6 months)
- Decrease prices by specific percentage every month (example: decrease 5% every year, 12 months)
To be able to bulk update the prices of your WooCommerce products, you need to follow these steps:
Step 1. Install the necessary plugins
First, you need the WP Sheet Editor – WooCommerce Products plugin. It allows you to view and manage your WooCommerce products using a spreadsheet on WordPress. You can do advanced searches, bulk update thousands of products, export your products to CSV, and import products from CSV.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
Second, you need the Automations extension for WP Sheet Editor. This extension allows you to automate your WP Sheet Editor tasks. You can schedule bulk edits, exports, imports and changes made in the cells. The scheduled tasks can run once or in recurring intervals.
You can get the add-on here:
Click here to read a guide on how to install and set up the Automations add-on.
Step 2. Open the WooCommerce products spreadsheet
Go to WP Sheet Editor > Edit products to open the products spreadsheet.
You’ll see all your products data displayed in the spreadsheet:
Step 3. Optional – Select the products you want to edit
Important: You can skip this section if you want to edit all products.
WP Sheet Editor allows you to run advanced searches, using any field of your products as a search filter. The best thing is that you can edit all the products that match the search filters.
It also allows you to select the products you want to edit manually. Let’s see both options:
a) Search for the products you want to bulk edit
Open the Search tool.
In this example, we will search for all the products within the Clothing category, whose regular price is less than or equal $50, and with status = published.
For this you need to select these values:
- Enter the product category
- Tick the Enable advanced filters
- Add the status filter:
- Field: Status
- Operator: =
- Value: Published
- Click on Add new to add another advanced filter.
- Add the price filter:
- Field: Regular price
- Operator: =
- Value: Published
- Click on Run search.
Once you run the search, you’ll see all the products that match the search filters diplayed in the spreadsheet.
You’ll see all the search filters you have applied displayed above the spreadsheet.
b) Manually select the products you want to bulk update
You can use the checkbox picker on the left side of the spreadsheet to manually select the products whose regular prices you want to bulk update automatically.
The manual selection works even when you have run a specific search. You can manually select from the search results.
Step 4. Bulk update WooCommerce prices automatically
Whether you have run an advanced search or a simple search, or if you have selected the products manually, or even if you want to edit all the products, you need to open the Bulk Edit tool to auto update your regular prices.
Option 1: Schedule automatic price updates
The first option we want to show you is how to schedule a bulk edit to the regular price field once. This bulk edit will be run at a later date and time, and will run automatically in the background.
You need to select these values in the Bulk Edit tool to schedule a one-time price bulk update:
- Select the rows that you want to update: We will edit all the rows from our current search.
- What field do you want to edit: Regular price
- Select type of edit: You have some options here:
- Set value: Select this to assign a new price and overwrite the current price
- Clear value: Select this if you want to remove the product prices
- Increase by number: Select this if you want to increase a specific amount (example: increase $5 to all prices)
- Increase by percentage: Select this if you want to increase a specific percentage (example: increase 5% to all prices)
- Decrease by number: Select this if you want to decrease a specific amount (example: decrease $10 to all prices)
- Decrease by percentage: Select this if you want to decrease a specific percentage (example: decrease 3% to all prices)
- After selecting the previous field, you need to add the new price, percentage/amount to increase, percentage/amount to decrease
Now you need to tick the Run this in the future checkbox and select the following values:
- Select the date and time: Use this field to select when you want to run this bulk edit
- Notify this email address when the process finishes: Add an email address here to notify you when the bulk edit process runs and is complete
- Select the Run once option.
- Name: You need to add a name for this scheduled bulk edit here
- You can select if you want to Edit only parent products or if you want to Edit only variations
- Click on Execute now
After selecting these values, the automatic one-time bulk edit will be scheduled to run on the selected date and time.
You can click on the View scheduled bulk edits link.
As you can see below, our automatic price bulk update has been added to the scheduled bulk edits list. You can follow this guide to understand how to take complete control of your scheduled tasks.
Once the automatic bulk edit of product prices is completed, you’ll receive an email to notify you that the process is complete.
Option 2: Schedule recurring automatic price updates
The second option you have to automate bulk edits to the price of your products is to bulk edit the prices dynamically every X minutes, days, weeks or months.
This is an great way to increase or decrease prices automatically and at recurring intervals. You can gradually increase or decrease product prices.
You need to select these values:
- Select the rows that you want to update: We will edit all the rows from our current search.
- What field do you want to edit: Regular price
- Select type of edit: You have some options here:
- Increase by number: Select this if you want to increase a specific amount every X minutes, hours, days or months (example: increase $5 to all prices every 6 months)
- Increase by percentage: Select this if you want to increase a specific percentage every X minutes, hours, days or months (example: increase 5% to all prices every 3 months)
- Decrease by number: Select this if you want to decrease a specific amount every X minutes, hours, days or months (example: decrease $10 to all prices every 12 monts)
- Decrease by percentage: Select this if you want to decrease a specific percentage every X minutes, hours, days or months (example: decrease 3% to all prices every 1 month)
- After selecting the previous field, you need to add the percentage/amount to increase, percentage/amount to decrease
Now you need to tick the Run this in the future checkbox and select the following values:
- Select the date and time: Use this field to select when you want to run this bulk edit
- Notify this email address when the process finishes: Add an email address here to notify you when the bulk edit process runs and is complete, and every time a recurring interval is run
- Select the Run in recurring intervals option
- Add the number in the Run every field, and select the time unit in the drop-down field. You can select Minute(s), Hour(s), Day(s), Week(s), or Month(s)
- Name: You need to add a name for this recurring bulk edit here
- You can select if you want to Edit only parent products or if you want to Edit only variations
- Click on Execute now
After selecting these values, the automatic recurring bulk edit will be scheduled.
You can click on the View scheduled bulk edits link.
Once the automatic recurring bulk edit is completed, you’ll receive an email to notify you that the process is complete. We will also notify you when a new recurring interval runs.
In this tutorial, we have shown you how to bulk edit WooCommerce prices automatically. You can schedule a bulk edit to run once, or you can schedule a recurring bulk edit to increase or decrease prices automatically every X minutes, hours, days, weeks or months.
The Automations extension allows you to automate the tasks of the WP Sheet Editor plugin. It works with all WP Sheet Editor spreadsheets running in the background, and allows you to automate exports, imports, bulk edits and changes made in the spreadsheet.