Table of Content

HomeBlogPlugin UsageHow to filter WooCommerce orde...

How to filter WooCommerce orders, in WooCommerce bulk orders editing plugin?

WooCommerce filter orders according to various fields such as β€œorder status” or β€œorder date” or β€œorder price” is simply possible on WooCommerce bulk orders editing plugin by using the β€œFilter Form”.

In this tutorial, we are going to introduce all fields provided in the β€œFilter Form”. It help you filter the custom orders you need to be bulk edited in less than a few minutes. 

To open the β€œFilter Form” and use its options for filtering custom orders, you need to navigate to the below address after installation of our plugin on your website:

WordPress Dashboard > Pro bulk bundle > Woo Orders 

We designed the β€œFilter Form” button at the top of the main page of our plugin. So you have easy access to it for starting multi order bulk editing. 

filter form in WooCommerce bulk orders editing plugin

By clicking on the β€œFilter Form” button, this form with all of your required fields for filtering custom orders will be displayed. 

As illustrated below, to help you find the preferred fields easier, we divided β€œFilter Form” into seven categories including:

  • General
  • Billing
  • Pricing
  • Items
  • Other fields 
  • Custom Fields 
opening the β€œFilter Form” button in WooCommerce bulk orders editing plugin

Now, let’s find out which fields are supported in each category. 

General tab

The most popular fields related to the orders are provided in the β€œGeneral tab”. It helps enable you to filter orders accordingly which are:

Filter orders by ID

To filter orders according to the β€œFilter ID”. You just need to type one or more β€œID numbers” like the below examples in the Text box.

If the β€œID numbers” are not in order, you can separate them by β€œ,” such as 1, 17, 33.

If the β€œID numbers” are in order. For example, when you need all β€œID numbers” between 2 and 5, you can type them as a range by using β€œβ€œbetween two numbers like β€œ3-5”.

Filter orders by date / modified date / paid date

These fields are useful when you need to filter orders according to their β€œOrdered date, Modified date or Paid date”. The interesting option that our plugin supported is the possibility of filtering orders in a period of time by using the provided calendar and also the time sheet.

General tab in filter form

For example, we tried to filter those orders received from 2021/01/13 20.00 to 2021/01/24  21.00 by using the β€œCalendar” as shown below. 

Filter orders by customer IP address 

β€œCustomer IP address” is another field that you can filter orders regarding to it by choosing one of the below conditions:

  • Like: The value entered in the text box is included in the β€œCustomer IP Address” 
  • Exact: The β€œCustomer IP Address” is exactly the same as value entered in the textbox 
  • Not: The β€œCustomer IP Address” is not the same as value entered in the textbox
  • Begin: The value entered in the text box is at the beginning of the β€œCustomer IP address”.  
  • End: The value entered in the text box is at the end of the β€œCustomer IP address”.  
filter orders by customer IP address

Filter orders by status

In the β€œStatus” field, you can filter custom orders according to one of the conditions listed in the combo box in front of it including:

  • Pending payment
  • Processing
  • On hold
  • Completed
  • Cancelled
  • Refunded

If you define any other order status in the WooCommerce, the condition will be added automatically to this list. Then you can choose it to filter the orders accordingly.  

Status” field, you can filter custom orders according to one of the conditions listed

Billing tab

In the β€œBilling” tab, we have listed all fields related to the order billings that you have set before in the WooCommerce.

As shown below, the most popular fields in the order billings are provided in this tab such as:

  • The Billing first name / last name
  • Billing Address 1/ 2
  • And Billing City / Company / Email / Phone / postcode
Billing tab in woocomerce order bulk edit

You can enter a value in the text box in front of each one and choose a condition from the β€œCondition box”. This let the plugin filter the orders according to them.

The items provided in the β€œCondition box” are the same as the items we described for the β€œCondition box” of β€œIP address” in the β€œGeneral” tab.

Filtering orders by billing name, address, city and etc

To make it clear for you, let’s try using some of them for filtering our orders: 

For example, if we choose β€œLike” from the β€œCondition box” of β€œBilling Name” field and type β€œCustomer” in the text box in front of it, as illustrated below:

filter orders by billing name

All the orders that their β€œBilling Name” include β€œCustomer” will be filtered after clicking on β€œGet Orders” button:

The result of filtered orders by billing name

We can also filter all orders that are received from β€œSmith” by typing β€œSmith” in the text box of β€œBilling Last Name” and choosing β€œExact” from the Condition box:

filter orders by billing last name

So, the result is exactly according to our expectation after clicking on β€œGet Orders” button:

The result of filtered orders by billing last name

This is also possible to exclude β€œArizona” from the list of cities which are going to be filtered for us by:

  • Choosing β€œNot” from the β€œCondition box” of β€œBilling City”
  • Type β€œArizona” in the textbox in front of it
  • Click on β€œGet Orders” 
Choosing β€œNot” from the β€œCondition box” of β€œBilling City”

Which will result in:

The result of filtered orders by billing city

Filter orders by billing country and billing state fields

One of the most advantages of our plugin is providing a complete database of all countries with their states in the world. This means if you are developing your business internationally and your customers are sending their orders from all over the world to your ecommerce website. You can easily and quickly filter their orders according to their countries and even their states.

To show you how this field can filter the orders for a special state in a country, consider you have received some orders from β€œNew South Wales, Australia” and you need to filter them.

To do this, click on the combo box in front of β€œBilling Country” and find β€œAustralia”.

As soon as choosing β€œAustralia”, our plugin will automatically make a list from the states of that country in the combo box in front of β€œBilling State” field. 

filtering woocommerce orders by billing country fields

Then you can find β€œNew South Wales” and select it.

filtering woocommerce orders by Billing state field

Finally, by clicking on β€œGet Orders”, these orders will be filtered as you expected.

Shipping tab

The fields supported in the β€œShipping” tab enable you to filter the orders according to the shipping information which are:

  • The shipping First Name / Last Name
  • Shipping Address 1 / 2
  • Shipping City / Company / postcode
  • And the Shipping Country / State

You can use β€œCondition” boxes, β€œtext boxes” and β€œCombo boxes” in front of each field to filter the orders exactly as we described for the fields provided in the β€œBilling” tab.

Shipping tab in woocommerce bulk orders editing

For example, if you choose β€œUnited State” from the β€œShipping Country” dropdown list: 

filtering orders by Shipping Country

A list of β€œUS states” will be available in the β€œShipping State” and you can choose one of them to filter orders that must be shipped to that state.

filtering woocommerce orders by shipping state
WooCommerce filter orders by shipping method

Pricing tab

In the Pricing tab, you have access to the below fields and you can filter orders regarding them:

Pricing tab in woocommerce order bulk edit plugin

Filter orders by currency

β€œOrder currency” is another amazing feature in our plugin which is a complete list of all currencies available all around the world that you may invoice the orders according to them. 

All currencies are supported in our plugin and you can choose each one from the combo box in front of β€œOrder Currency” to filter orders.

set Order currency for filtering

There are also other fields in the pricing tab which are:

  • Cart discount
  • Cart discount tax
  • Order Total

As all of these fields are related to a number, we provided two text boxes in front of each one to set minimum and maximum amounts. So, you can easily set a range of numbers to filter the orders that met that criteria.

For example, as you can see we tried to filter those orders with total price from 100 to 2000 US dollars:

set order total for filtering

Items tab

In the β€œitems” tab, all products, categories, taxonomies and the related attributes are listed to help you filter the orders with regard to them.

To take the most advantages of these fields, we provide two boxes in front of each field including:

Condition box

In the β€œCondition box” you can choose one of the below items:

  • Or
  • And
  • Not In

Selection box

In the β€œSelection Box”, a list of all items related to that field will be displayed and you can choose as many items as you need among them.

Let’s see how these conditions will filter the order in our plugin by some examples:

Example 1: WooCommerce filter orders by Products

In this example, we are going to filter orders received for β€œV-Neck-T-Shirt-Blue” or β€œLogo Collection”.

To do this, we simply choose β€œOR” from β€œCondition box” in front of β€œProduct” field:

Filter order by Products

Type some part of the β€œProduct title” in the text box:

filtering orders by product name

To see a list of Products with that letters:

show products name

Choose our prefered products from the list:

Choose prefered products from the list

By clicking on the β€œGet Orders” button, the orders received for both products will be filtered and displayed in the order table.

Example 2: WooCommerce filter orders by product categories

We can do the same for β€œProduct Categories” for example, to filter order which are not in β€œDecor” category:

  • Choose β€œNot in” from the β€œCondition box” in front of β€œProduct Category”
  • Select β€œDΓ©cor” from the category list in the β€œSelection Box”
Filter orders by Product categories

Example 3: WooCommerce Filter orders by product attributes

The good news about our plugin is displaying all β€œAttributes” you have already assigned to your products in the β€œFilter Form”, automatically. So, you can easily filter those orders received for some special products with different attributes.

Filter orders by Product Attributes

For example, let’s try to add an extra filter for Attributes to those products filtered in the previous example:

  • Choose β€œAnd” for the β€œCondition Box”
  • Select β€œGrey” and β€œYellow” from the β€œProduct Color” field
  • Select β€œNot in” for β€œCondition box” of β€œProduct Size”
  • Choose β€œLarge” from the list of β€œSelection Box”
add an extra filter for Attributes to those products filtered in the previous example

Filter orders by other fields

The remained items that we haven’t mentioned them in the previous tabs are provided here which are:

  • Create Via

You can filter the filter created by β€œCheckout or Amin” after choosing your prefered option from the combo box.

filtering orders by create via field
  • WooCommerce filter orders by payment method

Two options are provided in the combo box of this field. So you can filter orders by β€œCash on Delivery” or β€œOther” payment methods.

filtering orders by Payment Method field

For the rest of Items provided in the β€œOther Items” tab, you can choose β€œYes” or β€œNo” from the combo box in front of each field to filter your orders. These fields are:

  • Shipping Tax
  • Order Shipping 
  • Coupon Usage Counts
  • Order Stock Reduced
  • Prices Index Tax
  • Recorded Sales
filtering by shipping tax

WooCommerce filter orders by custom fields

The fields of the β€œCustom Fields” tab will be displayed to you just after you add some fields from the β€œMeta Fields” section to it as we described in β€œHow to add custom field / meta key to WooCommerce bulk edit plugin?”.

filtering orders by Custom Fields

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.

Comments

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments