Bulk Increase or Decrease Prices in WooCommerce Pending Orders

To bulk increase or decrease product prices in WooCommerce pending orders, install the WP Sheet Editor – WooCommerce Orders plugin, filter your orders by status “Pending payment” using the Search tool, then apply the Bulk Edit tool to raise or lower prices by a fixed number or by percentage across every filtered order at once. This updates the price of every product line item inside the selected pending orders in a single action, without editing each order individually.

Quick Summary

Managing pricing on pending orders is a common task for WooCommerce store owners. Prices sometimes need to be lowered because of a miscalculation, a discount code that was applied incorrectly, a limited-time offer that needs to be honored after the fact, or a customer support decision made to resolve a complaint. On the other side, prices sometimes need to be raised on pending orders because of a supplier cost increase, a shipping surcharge that was missed at checkout, a currency fluctuation, or a correction to an order that was placed before a scheduled price update went live.

Doing this manually inside the default WooCommerce orders screen means opening each order, editing each line item, and saving the changes one order at a time. But when a store has dozens or hundreds of pending orders that need the same adjustment, this becomes slow and error-prone.

The WP Sheet Editor – WooCommerce Orders plugin solves this by displaying all WooCommerce orders in a spreadsheet, where every row is an order and every column is a field. From that spreadsheet you can search, filter, and bulk edit hundreds of orders at once, including increasing or decreasing prices by percentage or by a fixed amount. The plugin also supports advanced searches and lets you export or import orders using CSV files.

Video Guides

Video: Bulk Decrease Prices in Pending Orders

Video: Bulk Increase Prices in Pending Orders

Getting Started: Open the Orders Spreadsheet

After installing and activating the plugin, go to Sheet Editor > Edit Orders. This opens the orders spreadsheet, where every row represents one order and every column represents a field on that order, including status, customer, products, and prices.

From here, the next step is the same whether you plan to raise or lower prices: filter the spreadsheet down to only your pending orders.

1. How to Search for WooCommerce Pending Orders

Open the Search tool on the plugin’s toolbar. This tool lets you find orders using several filters, including order status.

Select the following values to filter all orders with the “pending payment” status:

• Tick the Enable advanced filters checkbox
• Field: Status
• Operator: =
• Value: Pending payment
• Click on Run search

Once you run the search, the spreadsheet updates to display only your pending payment orders, and the active filters are shown above the spreadsheet.

With the pending orders filtered, you’re ready to bulk edit prices. The steps differ slightly depending on whether you need to decrease or increase prices, covered separately below.

2. How to Bulk Decrease Prices on Pending Orders

Hover over the Bulk Edit tool to see the available one-click bulk changes. For lowering prices, you have two options:

• Decrease product prices by percentage
• Decrease product prices by number

Select these values to complete the decrease:

• Select the rows that you want to update: Edit all the rows from my current search
• Select type of edit: “Decrease product prices by percentage” or “Decrease product prices by number”
• Decrease by: Enter the number or percentage to decrease
• Click Execute Now

Once applied, the product prices on every order included in your search are decreased in one pass.

3. How to Bulk Increase Prices on Pending Orders

The process for raising prices uses the same Bulk Edit tool, with the increase options instead:

• Increase product prices by percentage
• Increase product prices by number

Select these values to complete the increase:

• Select the rows that you want to update: Edit all the rows from my current search
• Select type of edit: “Increase product prices by percentage” or “Increase product prices by number”
• Increase by: Enter the number or percentage to increase
• Click Execute Now

Once applied, the product prices on every order included in your search are increased in one pass.

Should You Increase or Decrease Prices?

Frequently Asked Questions

Can I bulk edit prices on orders with a status other than pending?

Yes. The Search tool filters by any order status, including processing, on-hold, completed, or cancelled. Change the Value field in the search filter from “Pending payment” to the status you need, then run the same Bulk Edit steps.

Can I undo a bulk price change after running it?

The plugin does not include a built-in bulk undo for price edits. Before running a large bulk edit, it’s a good practice to export the affected orders to CSV first, so you have a backup of the original prices in case you need to restore them.

What’s the difference between decreasing by percentage and decreasing by number?

Decreasing by percentage reduces each product’s price proportionally, so a product priced at $100 with a 10% decrease becomes $90, while a product priced at $50 becomes $45. Decreasing by number subtracts a fixed amount from every product price regardless of its original price, so a $5 decrease makes a $100 product $95 and a $50 product $45. The same logic applies to increases.

Does this bulk edit change the price of the product itself, or just the price on the order?

The Bulk Edit tool for pending orders updates the price recorded on the order’s line items, not the product’s base price in your store catalog. To change the product’s catalog price instead, use the products spreadsheet in WP Sheet Editor rather than the orders spreadsheet.

Can I combine a price change with other bulk edits on the same orders?

Yes. Once you’ve filtered your pending orders, you can run multiple Bulk Edit actions in sequence on the same filtered set, such as updating order status, adding order notes, or editing shipping costs, in addition to adjusting prices.

Conclusion

Whether you need to lower prices to resolve a customer issue or raise them to reflect increased costs, the process starts the same way: filter your WooCommerce orders down to “Pending payment” status using the Search tool, then apply the Increase or Decrease option in the Bulk Edit tool by percentage or by a fixed number. This lets you update pricing across dozens or hundreds of pending orders in a single action instead of editing each order by hand, keeping your store’s pricing accurate and your customers taken care of.