Bulk Edit/Update WooCommerce Orders

This blog post explains how to bulk update orders in WooCommerce using WebToffee WooCommerce Order Import Export plugin.

Do you struggle with manually updating order data in your WooCommerce store? As a WooCommerce store owner, you likely deal with a large number of orders each day, which includes the task of updating order information.

However, manually doing this is time-consuming and prone to errors, so most store owners seek more efficient ways to transfer and manage their orders.

While WooCommerce has built-in options for importing and exporting orders, you will require a reliable plugin if you need more control, such as updating field values.

In this article, we will walk you through the process of easily updating WooCommerce orders in bulk using a plugin. Before we start, let’s look at why frequently updating order field values can benefit your online store.

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 gone up or tax rates have changed, you can adjust the order totals to match.

• 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:

• A CSV file exported by using the same plugin for a smooth, hassle-free import.
• 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:

• d/m/yy H:i
• m/d/yy H:i:s
• yy/m/d H:i:s
• yy/d/m H:i:s

For Example:

Let’s say you wish to change an order date in the d/m/yy H:i format. As illustrated below, on the Order Date row, place @ d/m/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, just 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 offers several premium order import export features in addition to those offered by the basic version.

This allows you to effortlessly migrate your store orders to and from and update their values. You can perform import and export actions in different file formats, such as CSV, XML, TSV, and Excel. The plugin provides multiple methods for performing import/export actions and powerful filters for custom exporting specific orders. During import, you can make bulk edits or updates to existing orders.

• Multiple methods for faster order data migration
• Bulk update WooCommerce orders
• Map and reorder export columns
• Set automated order import/export actions using Server Cron
• Developer logs for easy debugging of errors in failed orders
• Compatibility with major third-party 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.

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.

I 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.