How to Bulk Edit or Update WooCommerce Orders

Looking for a faster way to manage order updates in WooCommerce? Using bulk edit tools, you can bulk update orders in WooCommerce, saving hours of manual work and making it easier to stay on top of your store’s operations.

Managing orders one by one in WooCommerce can quickly become overwhelming, especially during peak sales periods or when you need to apply the same update across dozens (or hundreds) of orders. Whether it’s changing order statuses, updating shipping information, or adding custom notes, doing it manually is not only tedious but also a productivity killer.

That’s where bulk editing comes in. While WooCommerce offers built-in options for importing and exporting orders, you will need a reliable plugin if you require more control, such as updating field values. In this guide, we’ll show you how to bulk update orders in WooCommerce using a plugin to save time, reduce errors, and streamline your store’s order management process.

Let’s simplify your workflow and make bulk order updates feel effortless.

Updating WooCommerce orders in bulk can save you time and make it easier to modify several orders simultaneously. Here are a few typical situations where a bulk update might be necessary:

Pricing Changes

When running promotions or sales, you can easily update order prices in bulk to show the discounted amounts. If product costs have increased or tax rates have changed, you can adjust the order totals accordingly.

Order Status Changes

Bulk updates are especially beneficial when you want to change the status of several orders simultaneously, like moving them from processing to shipped. They can also be used to update refunds or cancellations.

Shipping Address Corrections

If you’ve found many orders with incorrect shipping addresses or if customers have relocated, you can make bulk updates and change the shipping addresses across all applicable orders.

Product Changes

If a product has been discontinued or if a product variation was mistakenly assigned to orders, you can update its details in all related orders.

Coupon Applications

If you want to apply a coupon code to several orders that were made before the coupon became available, you can perform a bulk update.

Before importing your orders to another site, make sure you’ve got two essentials in place:

1. A CSV file exported by using the same plugin for a smooth, hassle-free import.
2. The WooCommerce Order import export plugin installed on your new platform.

Once you have the export file ready, let’s see how we can import it using the import export plugin.

Step 1: Install & Activate WebToffee Order Import Export Plugin

To apply the transform option during the order import process, you must install the Order import export plugin by WebToffee. If you have already installed the plugin, skip to Step 2. To install the plugin,

• Go to Plugins > Add New.
• Search for the ‘Order Import Export Plugin.’ Then, install and activate the plugin.

Step 2: Select Order for Import

Once the plugin is installed and activated,

1. Navigate to WebToffee Import Export (basic) > Import.
2. As a first step to import order data, select Order as post type you want to import.

Step 3: Set Advanced Import for Orders

1. Choose Advanced Import as the import method. This way, you can filter, map columns, and customize other advanced options.
2. Next, upload the CSV file of the Order list and click the Map Import Columns button.

Step 4: Map & Update Order Field Values

In this step, we’ll map the columns to import and use the transform option to change/edit any columns.

When you click the pencil-shaped icon next to the file column, a pop-up will appear, allowing you to enter a value for the order fields.

The supported operators are as follows:

Below are some options for changing the order field values using the Transform option, along with examples:

1. Update Order Data Fields

For example, let’s say you wish to change the Order Status to Completed.

Enter ‘Completed’ in the Order Status row under the transform option and click Apply as shown below:

Upon import, the status of the order will be changed to Completed. The modified status gets imported as shown below:

2. Add Any Required Value to the Field

For example, let’s say you wish to increase the shipping total by 10. Enter ‘+10’ in the Shipping Total row’s transform option.

Eg: [{shipping_total}+10]

If you hadn’t assigned a shipping total before exporting, you can add the value to your shipping total.

The modified value upon importing is shown below:

Added Value (10.00 + 10)

3. Reduce Any Required Value to the Field

For example, if you want to reduce the order total by 5, enter “-5” in the Order Total field under the transform option like this:

Eg: [{order_total}-5]

The modified value upon importing is shown below:

Reduce by Value(90.00-5)

4. Change the Date Format in WooCommerce

To import it into your online store, the date format must match WooCommerce’s format (yyyy-mm-dd H:i:s, e.g., 2016-07-13 4:24:25).

Make sure the dates in your CSV file follow this format. You can also use the transform option to convert your dates to WooCommerce format. Dates in PHP format in the CSV can also be converted into WooCommerce formats.

The following are a few formats:

• dd/mm/yy H:i
• mm/dd/yy H:i:s
• yy/mm/dd H:i:s
• yy/dd/mm H:i:s

For Example:

Let’s say you wish to change an order date in the dd/mm/yy H:i format. As illustrated below, on the Order Date row, place @ dd/mm/yy H:i using the transform option:

The imported order date is adjusted as indicated below:

The updated date and time is 2022-11-07 at 11:40

5. Append Any Required Value to the Field

For example, if you want to add “Pvt Ltd” to the Billing Company, simply go to the Billing Company row, click the pencil icon at the end, and type “&Pvt Ltd” as shown below.

The modified company data upon importing is adjusted as indicated below:

The appended value is XXXX &Pvt Ltd

6. Prepend any Required Value to the Field

For example, if you want to add “Mr/Mrs” before the billing name, go to the billing name row and use the transform option. Simply type “Mr/Mrs [your billing name]” as shown below.

The modified billing name upon importing is adjusted as indicated below:

The appended Billing name will be Mr/Mrs. Maple John.

The Pro version of the WooCommerce Order Export plugin unlocks a powerful set of premium features that go beyond the basic version, designed to simplify order migration, bulk updates, and automation.

With this version, you can:

• Effortlessly migrate WooCommerce orders to and from your store.
• Import and export orders in multiple formats, including CSV, XML, TSV, and Excel.
• Bulk update existing orders during import. Ideal for modifying statuses, customer info, or shipping details.
• Customize exports using advanced filters to export only specific orders.
• Map and reorder columns to match your desired file structure.
• Automate import/export tasks with Server Cron for hands-free scheduling.
• Access developer logs for quick and easy debugging of failed order operations.
• Enjoy seamless compatibility with popular third-party WooCommerce plugins.

With the WooCommerce Order Import Export plugin, managing and updating your orders has never been simpler. Whether you’re moving data, adjusting field values, or making sure everything is formatted correctly, the Transform option provides you with complete control, making it easier than ever to bulk update orders in WooCommerce with precision and ease.

You can effortlessly customize imports, modify information, and even convert the dates of your orders. The automatic column mapping saves you time, making the process smoother and more efficient.

The Order Import Export plugin mentioned in this article has a premium version with advanced features. You can check it out to learn more about its capabilities.

Hope this article has guided you in the right direction. If you have any questions, please comment below, and we’ll be happy to assist you.