WooCommerce – Search for Orders With Notes from the Customer

In this tutorial, we will show you how to search for orders with notes from the customer in WooCommerce.

As you may know, WooCommerce allows your customers to add notes at checkout to give you delivery directions or ask you to drop off deliveries at a specific place in the house.

Whatever the purpose of the notes, you now need to filter out all orders that have customer notes. And that’s what we will show you in this tutorial.

Here’s what you need to search for orders with customer notes:

1- The WooCommerce plugin

2- Some orders placed at your shop

3- The WP Sheet Editor – WooCommerce Orders plugin.

This plugin allows you to manage your WooCommerce orders in an intuitive spreadsheet that allows advanced search, export, import, and bulk edits with a few clicks.

After installing and activating the plugin, you need to follow these steps to know which WooCommerce orders contain notes from the customer:

1- Open the orders spreadsheet

To view and manage your WooCommerce orders in a spreadsheet, go to Sheet Editor > Edit Orders.

woocommerce orders spreadsheet

2- View the orders with customer notes in the spreadsheet

To know which orders contain notes added by the customers on checkout, you need to find the Order note column in the spreadsheet.

woocommerce search for orders with notes from the customer

Important:

There’s an important difference between the Order note column and the Order notes column.

3- Sort orders by customer order in the spreadsheet

If you click on the Order note column, your orders will be sorted by order note from the customer.

As you see below, all the orders with notes from the customer are displayed above the ones where there are no customer notes.

This is a great way to know which orders have notes added by the customers on checkout.

woocommerce sort orders by order note

4- How to search for orders containing notes from the customer

Instead of sorting the orders by note from the customer, you can use the Search tool to find all your WooCommerce orders containing a note from the customer.

woocommerce search for orders with notes from the customer

Once in the Search tool, you need to select the following values to find all the orders where customer notes were added:

woocommerce search for orders with notes from the customer

Tick the Enable advanced filters checkbox, and select the following values:

  • Field: Order note
  • Operator: != (This means “not equal to”)
  • Value: Leave this field empty.

Now click on Run search to find all the orders where the Order note column is not empty.

As you see below, all the orders containing notes added by the customer on checkout are displayed in the spreadsheet.

woocommerce search for orders with notes from the customer

This is how you can search for WooCommerce orders where customers left a note.

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.