Blog

How to filter WooCommerce orders by product and other order details?

filter orders by product
Table of Contents

Order management is one of the most essential requirements of store managers. It is actually an important task when online stores are growing fast and receive more and more orders. To manage the orders, store owners usually need to filter and bulk edit them with a useful and powerful tool.

Unfortunately, the default WooCommerce editor has many limitations in terms of filtering orders by product and other order details. This is why most of store managers use the WooCommerce orders bulk edit plugin to manage WooCommerce orders.

In this post, we will first review the filtering options of the WooCommerce default editor and then introduce you to the WooCommerce Bulk Edit Orders plugin as one of the best tools for filtering orders.

Filter WooCommerce orders by WooCommerce default options

To use the WooCommerce default options for filtering your orders, first, you need to open the Orders page by going to the address below:

WordPress dashboard > WooCommerce > Orders

select orders menu in WooCommerce

On the Orders page, you can see a list of orders in a table view, and there are some options on the top of the table to filter the orders as below:

WooCommerce filter orders by status using the default WooCommerce order page

To filter the orders based on the order status, you can click on the items displayed at the top of the table. (1) In this part, you can see all order statuses divided into sections like Completed, on hold, processing, etc. When you click on one of the statuses, like completed, the editor will just show the completed orders in the table.

filter WooCommerce orders by status, date and customer in WooCommerce default

WooCommerce filter orders by date using the default WooCommerce order page

The next option in the default editor of WooCommerce is to filter orders by date. (2) If you open the dropdown list of All Dates, you can see a list of months that orders are placed in your online store. By choosing one of the months from the list, like April 2022, the orders that were received on that month will be displayed in the table.

WooCommerce filter orders by customers using the default WooCommerce order page

The last option that the default editor of WooCommerce provides for store owners is filtering orders by registered customers. By opening the combo box of this field, you can see a list of all registered customers on your site. So, you can select one of them to see the orders that were placed.

As we mentioned above, the filtering option of the WooCommerce default has many restrictions. For example, WooCommerce filter orders by product are not available. To have flexible options for filtering your received orders, you need to use the WooCommerce orders bulk edit plugin. Let’s see how you can use this plugin to WooCommerce filter orders by product and other details.

Filter WooCommerce orders by bulk edit orders plugin

The WooCommerce orders bulk edit plugin comes with a lot of amazing options not only for filtering but also for bulk editing. This powerful plugin supports all WooCommerce fields and meta fields both on the Filter Form and Bulk Edit form. So, you can easily filter WooCommerce orders by product list or any other details you need.

Here, you can find how to filter WooCommerce orders with this plugin:

Step 1: Install and activate the plugin

The first step to using the WooCommerce bulk edit orders plugin is to download and install it on your WordPress website. After activating the plugin, you can see the iT Bulk Editing menu in the WordPress dashboard. Then, by pressing Woo Orders, you have access to the main page of the plugin. 

select Woo orders menu in Bulk Editing WooCommerce

Step 2: Open the filter form and try various filtering options 

On the main page, you can find a list of all orders in a table with all required tools for filtering and bulk editing orders on top. 

The first tool in the toolbar is the Filtering icon, which is used to open the comprehensive Filter Form of this plugin, as illustrated below:

select filter form button in WooCommerce

By opening the Filter Form, you can observe seven different tabs, including:

  • General
  • Billing
  • Shipping
  • Pricing
  • Items
  • Other Fields
  • Custom Fields

By opening each tab, you can find the WooCommerce field related to the title. 

Now, let’s review the filtering options available in this form for WooCommerce filter orders by product and other details.

Filter WooCommerce orders by ID

In the General tab, there is an option for filtering orders by ID. Here, you can use several methods for filtering orders by ID, which are:

  • Filter some orders individually by writing the ID number and “,” as a separator.
  • Filter a series of orders continuously by writing the first and last ID and “–” as a separator.
  • Combine both methods by adding | between them.

For example, in the below picture, we tried to filter orders whose IDs are 12, 25, and 42 in addition to orders whose IDs are from 2 to 7.

filter orders by ID in WooCommerce

WooCommerce filter orders by paid date

Another option in the General tab of the Filer Form is to limit some orders based on the paid date. To make this filtering option easier for you, we designed a built-in calendar allowing you to set a date range in the Date from and Date to fields.

It is also possible to filter the orders based on a specific time.

For example, we tried to filter orders placed in October 2023.

filter orders by paid date in WooCommerce

WooCommerce filter orders by billing details

The Billing tab in the Filter Form contains all customer information available in the billing form. So, you can easily filter the orders based on any billing information of the customers like billing first name, billing last name, billing address, billing country, billing phone, etc.

You can find different types of filtering options based on the item you choose.

filter orders billing details in WooCommerce

For example, suppose you want to filter the orders by billing last name. In that case, there is a box listing different operators, including:

  • Like: To filter orders whose billing last name contains the letters you insert in the following field.
  • Exact: To filter orders whose billing last name is exactly like the name you insert in the following field.
  • Not: To filter orders whose billing last name is not like the name you insert in the following field.
  • Begin: To filter orders whose billing last name begins with the letters you insert in the following field.
  • End: To filter orders whose billing last name ends with the letters you insert in the following field.
select options in billing last name field in WooCommerce

WooCommerce filter orders by shipping details

The items available in the Shipping tab are almost the same as the Billing tab. So, you can filter orders by any information that customers insert in the shipping form. 

Let’s suppose that you want to filter the orders that are not shipped to New York. So, you can easily open the dropdown list of operators in front of Shipping City and choose Not. Then, by writing New York in the next box, the task is completed. 

filter orders by shipping details in WooCommerce

WooCommerce filter orders by pricing

In the Pricing tab of the Filter Form, you are able to filter the WooCommerce orders by their total amount, discount, or discount tax.

Let’s filter WooCommerce orders whose total amount range from $150 to $300 by following the below instruction:

  • Open the Order Currency dropdown list and choose United States (US) dollar ($).
  • Write 150 and 300 in the From and To fields of Order total, respectively. 
filter orders by pricing in WooCommerce

WooCommerce filter orders by product

WooCommerce filter orders by product is the most useful filter option that stores managers usually need. Filtering orders by product is really easy when you use the WooCommerce bulk edit orders plugin. 

To do this, first, you need to open the Items tab in the Filter Form. Now, you can see different fields like products, categories, tags, and attributes to filter your orders based on.

To make this task easier for you, we also designed some operators allowing you to filter the orders exactly as you expected.

Let’s make some examples to see how.

WooCommerce get all orders for product

To get all orders for some products, you can proceed as follows:

  • Open the operator list of Product field and choose OR.
  • Select some products like Sunglasses and Hoodie in the product selection text box.
get all orders for product in WooCommerce

Now, you can see a list of WooCommerce orders that Sunglasses or Hoodie are one of their items.

filter sunglasses or hoodie products in WooCommerce

WooCommerce filter orders by product list

To filter orders by product list in the WooCommerce bulk edit orders plugin, you can set some product categories in the Item tab of the Filter Form

Let’s suppose that you want to see the orders for the list of products that are not in the Accessories category, so you need to:

  • Open the operator list of Product categories and choose Not In. 
  • Select Accessories from the list of Categories in the next box.
filter orders by product list in WooCommerce

Now, by pressing the Get Orders button, all orders whose items are not included in the products in the Accessories category are displayed to you.

WooCommerce filter orders by product attribute

This is an awesome option for filtering the orders that contain specific product attributes. 

For instance, let’s try to filter those orders that have Blue Large and Red Large products in their items:

  • Open the Product color operator and choose “And”, then select Red and Blue from the list of colors in the next box.
  • Do the same for the Size field and choose Large.
filter orders by product attribute in WooCommerce

Finally, press Get Orders to see the orders with the specified attributes in the order table.

Filter WooCommerce orders by payment method

Sometimes, you offer different payment methods to your customers, and you want to filter orders by specific payment methods like cash on delivery or PayPal.

To make this happen, you can easily open the Other tab in the Filter Form and choose the payment method you want to see the related orders from the list of Payment method fields.

filter orders by payment method in WooCommerce

WooCommerce quick search orders in WooCommerce orders bulk edit plugin

In addition to comprehensive filter options in the WooCommerce orders bulk edit plugin; there is also the WooCommerce quick search orders option available in the toolbar at the top of the order table.

If you click on the Search icon in the toolbar, a Quick search box is displayed. You can search and filter orders based on the Title and ID as illustrated below:

search orders in WooCommerce

There is also an option for filtering orders based on status to help you see the orders with specific statuses like Completed, Processing, Canceled, etc. Just with one click. 

Conclusion

WooCommerce filter orders by products and other details are one of the most common requirements of online store managers. As the default options for filtering orders in WooCommerce are not as flexible as the manager needs, we introduced the WooCommerce orders bulk edit plugin with an easy-to-use filter form for you.

By getting help from the filter form of this plugin, you can quickly filter the orders in your online store by products and many other details.

You can also find more information about the amazing options provided in this plugin for bulk editing orders in the following links.

Leave a Reply

Your email address will not be published. Required fields are marked *

Shopping cart
Sign in

No account yet?

We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies.

Start typing to see products you are looking for.