Table of Content

HomeBlogPlugin UsageHow to bulk edit cart discount...

How to bulk edit cart discount of WooCommerce orders?

Bulk edit cart discount of WooCommerce orders can be quickly done by using WooCommerce bulk orders editing plugin.

All store managers can benefit from our plugin for bulk editing any data related to the orders. There are a lot of useful and effective forms in our plugin to help the store managers filter their preferred orders and then bulk edit the related values just by one click.

In this tutorial, we are going to show you how to filter the orders and then bulk edit the value of “Cart discount” by two methods: “Bulk Edit” and “Bind Edit”.

Follow us to discover more about our plugin.

Filter orders

To filter orders, you can use our well-organized “Filter Form” provided for you in different categories to cover all fields related to the WooCommerce Orders.

As we described in “How to filter orders in WooCommerce bulk orders editing plugin?“, you can set a condition and get those orders you need to be bulk edited.

For example, let’s try to filter those orders that their “Shipping Company” is not “Air“:

  • Press “Filter Form” button at the top of the main page to open “Filter Form
  • Go to the Shipping tab to see “Shipping Company” field
  • Choose “Not” from the Condition box 
  • Type “Air” in the Textbox 
filter those orders in WooCommerce bulk orders editing plugin

That’s it. By clicking on “Apply to table”, those orders will be filtered.

Add columns to the order table 

To exactly observe what is going on, we recommend you to add the appropriate columns to the order table.

In this tutorial, we decided to add “Shipping Company” column to see if our filtration has been done correctly and also “Cart Discount” column to trace the result of our bulk edit actions.

We completely explained how to add columns to the order table by using “Column Profile” form in the previous tutorial, so you can refer to it, if you need more help. 

mark cart discount column in WooCommerce bulk orders editing plugin

Bulk edit cart discount of WooCommerce orders

To bulk edit “Cart discount” of WooCommerce orders, you need to open the “Bulk Edit” form by pressing the “Bulk Edit” button in the main page of our plugin.

In this tab, you can Bulk Edit “Cart Discount” of WooCommerce orders by using two boxes designed in front of this field:

  • Condition box
  • Textbox

In the Condition box, some default items were listed and you can choose one of them to instruct plugin apply it to the value typed in the Textbox. These items include:

  • Set New
  • Clear Value
  • Formula
  • Increased by value
  • Decrease by value
  • Increase by %
  • Decrease by %
bulk edit order cart discount value

Now, let’s try to use these conditions in the below examples:

Set a new value for cart discount

By choosing “Set New” in the condition box, any value you type in the opposite text box will be assigned to the “Cart Discount” of those filtered orders.

For example, we typed “20” in the Textbox and after choosing “Set New”, clicked on “Do bulk edit”:

Set new value to order count discount

As illustrated below, all values of “Cart Discount” would be replaced by “20“:

The result of set new values to order cart discount

Use formula to bulk edit cart discount value

Formula is one of the amazing features of our plugin for assigning a new value to the “Cart Discount” based on the current value.

When you want to use Formula for bulk editing any value in our plugin, you have to consider below points:

  • You can type any kind of equation in the textbox by using mathematical signs such as -, +, ×, /, …
  • X (capital letter) defined as a variable for the current value

So, if we choose Formula from the Condition box and type the below equation in the textbox:


It means we want to increase the current value by “20” then divide the result value by “5″:

Use Formula to bulk edit Cart Discount value

By considering this fact the current value of “Cart Discount” is “20” as we assigned in the previous step, we expected to see the below result in the table after clicking on “Do bulk edit”:

(X+20)/5 = 40/5 = 8

The result of changed cart discount value by formula

Clear all values of cart discount

By choosing “Clear Value” from the dropdown list of Condition box, all values assigned to the “Cart Discount” of the filtered orders will be removed:

Clear all values of Cart Discount

As shown below, all values were set to “0”:

The result of cleared values of order cart discount

Increase cart discount amount by 20

If you want to Increase or decrease “Cart Discount” amount by a specified value, you just need to:

  • Choose “Increase / decrease by value” from the Condition box list
  • Type the specified amount in the Text box
  • Click on “Do bulk edit

For example, when we selected “Increase by value”, then typed “20”, all “Cart Discount” amount were set to “20” as the result because the initial value was “0”:

Increase order Cart Discount amount by value

Increase / Decrease cart discount amount by percentage 

Increase or Decrease Cart Discount amount by % is almost like the previous example, the only difference is that the current value will be increased or decreased by the percent of the new value typed in the Text box.

For example, if we choose “Increase by %” from the dropdown list of Condition box and type “20” in the text box:

Increase / Decrease Cart Discount amount by percentage

We expected to all “Cart Discount” amounts increased by “20%”, which means:

Current value: 20

Increased value by 20% = 20 × 20/100 = 4

Current Value + 20% = 20 + 4 = 24

The result displayed in the Order table after clicking on “Do bulk edit” is exactly the same as the amount we have calculated:

result of changed order discount value

Bulk edit cart discount of WooCommerce orders by bind edit

Bind Edit” option is another powerful tool designed in our plugin to allow you to Bulk Edit “Cart Discount” of WooCommerce orders directly from the table.

This option is only available for the columns displaying in the order table, so, if you want to bulk edit “Cart Discount” of WooCommerce orders by “Bind Edit”, you have to add this column to the table as we described at the beginning of this tutorial.

After adding the “Cart Discount” column, follow the below instructions to “Bind Edit” their values:

  • Mark the check box of those orders you need to be bulk edited
  • Mark “Bind Edit” on the top of the page
  • Use one of the below methods to change the “Cart Discount” value of one of the selected orders 

bulk edit cart discount by inline edit

To change the values by “Inline Edit”:

Click on the cell and type a number, for example we typed 15 then press enter on the keyboard

change cart discount value by inline edit

As illustrated below, the plugin changed the value of all selected orders:

the result of changed cart discount value

bulk edit cart discount by using calculator

To use Calculator, click on “Calculator” icon to see the calculator pop up page

change cart discount by “Calculator”

There are two boxes in the calculator page:

  • Condition box
  • Textbox
calculator pop up page in WooCommerce order bulk edit plugin

In the condition box, you can select one of the below actions:

  • Plus (+)
  • Minus (-)
  • Replace

In the text box, you can type the value that the chosen condition must apply to it.

By clicking on “Apply Changes”, all values of those selected WooCommerce orders will be changed at the same time.

For example, we selected “-“, then typed “7” and finally, clicked on “Apply changes”:

calculator pop up in WooCommerce bulk order editing

Remember that we have changed the value to “15” at the previous step, so we expected the plugin show “8” as the new value of those selected orders, because:

Current value -7 = 15 – 7= 8

Which is exactly what we are observing in the table:

result of change value by calculator in WooCommerce bulk order editing plugin
Like this tutorial?

Do you still have a problem?

If you still have unanswered questions or need custom work for your plugin, contact iThemeland Support.


Notify of
Inline Feedbacks
View all comments