How to Schedule WooCommerce Price Changes (One-Time or Recurring)

You can schedule WooCommerce price changes with the Automations add-on for WP Sheet Editor. It updates your regular prices in bulk on a schedule you set, either once at a future date and time or on a recurring basis (every few minutes, hours, days, weeks, or months), so you don’t have to make the change manually. This guide shows you how to set up both one-time and recurring scheduled price updates.

Step 1: Install the plugins you need

Note. We assume your already have the WooCommerce plugin on your WordPress site.

First, install the WP Sheet Editor Products Spreadsheet plugin. It lets you view and manage your WooCommerce products in a spreadsheet, run advanced searches, and update thousands of products at once.

Second, install the Automations extension for WP Sheet Editor. This is the add-on that lets you schedule bulk edits, exports, and imports to run once or on a recurring basis.

For step-by-step installation instructions, see the guide on installing and setting 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 will see all your product data displayed in rows and columns.

Step 3: Choose which products you’ll automate

Skip this step if you want to schedule a price change for all your WooCommerce products.

Otherwise, you can search for products that match specific criteria, or select them manually.

Search for the products you want to schedule a price change for

Open the Search tool.

For example, to schedule a price change only for products in the Clothing category, priced at $50 or less, and with a Published status, follow these steps:

1. Enter the product category.
2. Tick Enable advanced filters.
3. Add the status filter:
   • Field: Status
   • Operator: =
   • Value: Published
4. Click Add new to add another advanced filter.
5. Add the price filter:
   • Field: Regular price
   • Operator: <=
   • Value: 50
6. Click Run search.

The spreadsheet will refresh to show only the products that match your search filters, and the applied filters will be displayed above the spreadsheet.

Manually select the products

You can also use the checkbox picker on the left side of the spreadsheet to manually select the products you want to schedule a price change for. This works even after you run a search, so you can manually select from your search results.

Step 4: Schedule the price update

Whether you searched for products, selected them manually, or want to edit all your products, open the Bulk Edit tool to schedule the price change.

Option 1: Schedule a one-time price change

Use this option to schedule a single bulk price update that runs automatically at a later date and time.

In the Bulk Edit tool, select these values:

• Select the rows that you want to update: choose to edit all the rows from your current search.
• What field do you want to edit: Regular price
• Select type of edit: choose one of these options:
  • Set value: assign a new price and overwrite the current price
  • Clear value: remove the product prices
  • Increase by number: increase all prices by a specific amount (example: increase $5)
  • Increase by percentage: increase all prices by a specific percentage (example: increase 5%)
  • Decrease by number: decrease all prices by a specific amount (example: decrease $10)
  • Decrease by percentage: decrease all prices by a specific percentage (example: decrease 3%)
• Enter the new price, or the amount or percentage to increase or decrease.

Now tick the Run this in the future checkbox and select these values:

• Select the date and time: choose when you want this price automation to run.
• Notify this email address when the process finishes: enter an email address to be notified once the price update is complete.
• Select the Run once option.
• Name: enter a name for this scheduled change.
• Choose whether to Edit only parent products or Edit only variations.
• Click Execute now.

Your one-time scheduled price update is now added to the scheduled tasks list. Click View scheduled bulk edits to see it. You can follow the guide on managing scheduled bulk edits to learn how to review, edit, or cancel scheduled tasks.

When the scheduled price update finishes, you’ll receive an email notification.

Option 2: Set up recurring price updates

Use this option to update prices automatically and repeatedly, every X minutes, hours, days, weeks, or months. This is a good way to gradually increase or decrease prices over time.

Select these values in the Bulk Edit tool:

• Select the rows that you want to update: choose to edit all the rows from your current search.
• What field do you want to edit: Regular price
• Select type of edit: choose one of these options:
  • Increase by number: increase all prices by a specific amount every X minutes, hours, days, or months (example: increase $5 every 6 months)
  • Increase by percentage: increase all prices by a specific percentage every X minutes, hours, days, or months (example: increase 5% every 3 months)
  • Decrease by number: decrease all prices by a specific amount every X minutes, hours, days, or months (example: decrease $10 every 12 months)
  • Decrease by percentage: decrease all prices by a specific percentage every X minutes, hours, days, or months (example: decrease 3% every month)
• Enter the amount or percentage to increase or decrease.

Now tick the Run this in the future checkbox and select these values:

• Select the date and time: choose when the first run should happen.
• Notify this email address when the process finishes: enter an email address to be notified after the initial run and every recurring run.
• Select the Run in recurring intervals option.
• In the Run every field, enter a number and choose the time unit from the drop-down: Minute(s), Hour(s), Day(s), Week(s), or Month(s).
• Name: enter a name for this recurring price change.
• Choose whether to Edit only parent products or Edit only variations.
• Click Execute now.

Your recurring price update schedule is now active. Click View scheduled bulk edits to review it.

You’ll receive an email notification after the first run and every time a new recurring interval runs.

Related guides

• Bulk edit WooCommerce product prices right now (without scheduling)
• Bulk increase WooCommerce prices by a percentage
• Bulk increase or decrease prices in pending orders
• Bulk update WooCommerce subscription prices

Start automating your WooCommerce products

With WP Sheet Editor and its Automation add-on, you can automate your WooCommerce product management. Schedule mass changes and manage your products on autopilot.