WooCommerce – Advanced Search for Orders

When it comes to saving time, WooCommerce doesn’t give you enough options. You can’t save time when searching for your WooCommerce orders because the search options are so limited.

That’s why we want to show you how to do advanced searches in seconds. You won’t use any PHP snippets; you’ll do it using an intuitive and easy-to-use spreadsheet containing an advanced search tool.

Just follow these simple steps.

Install the WooCommerce Orders Spreadsheet plugin

This plugin brings all the benefits from spreadsheets to WooCommerce orders management. You’ll be able to do advanced searches in seconds and even edit a lot of your orders fields and values in a spreadsheet.

You can export all your orders to a CSV document to give reports to clients or print them. Besides, you can import info using CSV documents.

You can download the plugin here:

Download WooCommerce Orders Spreadsheet Plugin - or - Read more

After installing and activating the plugin, go to Sheet Editor > Edit Orders to open the spreadsheet.

Open the “Search” tool

This tool is located on the toolbar, so you need to click on Search to open it.

It allows you to do advanced searches in seconds. We’ll show you 10 advanced searches you can do with this tool.

Important

Before going on to show you the advanced searches, we want to tell you that you can save any of these searches for future sessions and thus save a lot of time.

Just enter a name for each of them in the Save this search field before applying the search filter.

To search for your orders by payment method, you need to tick the Enable advanced filters checkbox and then use these values:

  • Field key: payment_method_title
  • Operator: CONTAINS
  • Value: PayPal, for example. You decide which method you’ll use: Stripe, Alipay, BACs, Direct debit, etc.
  • Click on Run search to filter your orders.

Once you filter your orders by payment method, you’ll see them displayed on the spreadsheet.

You can quickly search for all your orders by their total. For this you need to tick the Enable advanced filters checkbox and use the following values:

  • Field key: order total (_order_total)
  • Operator: You can search for orders by exact amount (=), less than (<), higher than (>), higher or equal (>=), less or equal (<=).
  • Value: Enter the total amount you want to search.
  • Click on Run search to filter your orders.

Once you do that, you’ll see all your orders filtered and displayed on the spreadsheet.

When one coupon is applied to your orders, the discount amount becomes > 0, so you’ll search for all your orders with that search parameter. Just tick the Enable advanced filters checkbox and use the following values:

  • Field key:cart discount (_cart_discount)
  • Operator:>
  • Value:0
  • Click on Run search to filter your orders

Now you’ll see all the orders that fulfill the selected search parameter displayed on the spreadsheet.

To search for all your orders containing a specific shipping method, you need to tick the Enable advanced filters checkbox and select these values:

  • Field key: shipping method (_shipping_method)
  • Operator: =
  • Value: Enter your shipping method here. For example, free shipping.
  • Click on Run search to filter the orders.

Now you’ll see all the orders displayed on the spreadsheet.

You can search for all your orders by VAT status. Just tick the Enable advanced filters checkbox and select the following values.

  • Field key:is vat exempt (is_vat_exempt)
  • Operator:=
  • Value: Enter Yes or No.
  • Click on Run search to filter them.

Now you’ll see the orders displayed on the spreadsheet.

Searching your orders by payment date takes just some minutes. Tick the Enable advanced filters and select these values:

  • Field key:date paid (_date_paid)
  • Operator:=
  • Value:Enter the date using this format: YYYYMMDD. No spaces; no hyphens.
  • Click on Run search to filter the orders

Now you’ll see all the orders displayed on the spreadsheet.

You can search for all orders by customer IP address by ticking the Enable advanced filters and selecting these values:

  • Field key: customer IP address (_customer_ip_address)
  • Operator: =
  • Value: Enter the IP address in this field.
  • Click on Run search to filter the orders.

After that, you’ll see all the orders made from that IP address displayed on the spreadsheet.

You can quickly search for all orders created during a specific date range. For this you need to tick the Enable advanced filters checkbox and select these values:

  • Date range from: Enter the range initial date
  • Date range to: Enter the range final date
  • Click on Run search to filter all your orders by date range.

Now you’ll see all the orders displayed on the spreadsheet.

To find all orders created by non-registered users, you need to tick the Enable advanced filters checkbox and select these values:


  • Field key:customer user (_customer_user)
  • Operator:=
  • Value:(empty)
  • Click on Run search

Now you’ll see all orders by non-registered users displayed on the spreadsheet.

Search for all your orders by discount amount by ticking the Enable advanced filters checkbox and selecting these simple values:

  • Field key: cart discount (_cart_discount)
  • Operator: You’ll have these options: exact amount(=), less than (<), higher than (>), higher or equal (>=), less or equal (<=)
  • Value: Enter the amount. 10 for example.
  • Click on Run search to filter the orders

After that, all your WooCommerce orders with discounts will be displayed on the spreadsheet.

 

Advanced searches are easy!

We know that saving time is crucial for you, so we’ve shown you these 10 advanced searches that you can do in seconds using the WooCommerce Orders Spreadsheet plugin. Of course, there are a lot of other searches you can make. Just visit our blog for more tutorials.

You can download the plugin here:

Download WooCommerce Orders Spreadsheet Plugin - or - Read more

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.

Close Menu