Skip to main content

Finding orders with rules

Go to WooCommerce > Orders and click Advanced filters. The panel has two parts: Order contents, where you build rules about the products in the order and Order details, for status, dates and the customer.

The Advanced filters panel with two rules, two statuses and the summary line above the orders list

The example above shows orders that contain the Gift Box, have nothing from the Clothing category and are Processing or On hold.

Build a rule​

  1. Under Order contents, click + Add rule.
  2. Pick what the rule looks at:
FieldValues
ProductsProducts or single variations, searched by name
CategoriesProduct categories
TagsProduct tags
BrandsWooCommerce brands
SKU starts withThe first characters of a SKU, such as HOOD-
AttributeAttribute values such as Size: L, across every product
Quantity of productsHow many units of the chosen products the order holds
Items in the orderHow many items the order holds in total
  1. Pick how it matches:
MatchShows orders where
contain any ofat least one of the chosen values is in the order
contain all ofevery chosen value is in the order
contain onlynothing else is in the order
contain none ofnone of the chosen values is in the order

For the two quantity fields, choose at least, at most or exactly and a number, for example "3 or more of this product".

  1. Choose the values.
  2. Add more rules if you need them. Under Show orders that match, choose all of these rules or any of them.
  3. Click Apply filters.

The Advanced filters button shows how many filters are on. The panel stays open while any of them is set.

Rules work together with the free plugin's filters, the status tabs and the search box. Clear all removes the rules and the order details; it keeps the status tab you are on, the free plugin's filters and the search box.

Examples​

You wantRule
Orders to pack that hold only the gift boxProducts, contain only, Gift Box. Statuses: Processing
Every order with size L, whatever the productAttribute, contain any of, Size: L
Orders with the hoodie but no socksProducts, contain any of, Classic Hoodie. Add rule: Products, contain none of, Wool Socks
Large wholesale ordersItems in the order, at least, 10. Customer role: Wholesale

Narrow by order details​

Under Order details you can also filter by:

  • several Statuses at once;
  • a Date range;
  • an order Total range;
  • a Coupon code;
  • Customer: guests or registered customers;
  • Customer role.

Read the summary​

When a rule names products, a line above the list shows how many orders match, the units of the chosen products in them and what those items are worth. The numbers cover every page of the list, not only the one on screen.

The summary uses WooCommerce Analytics' order data. On a store whose Analytics history has not been imported, it reads the orders themselves for up to 5,000 orders. Above that it shows the order count and a link to Analytics > Settings, where you can import historical data.

Show only the matching items​

In the summary line, click Show matching items only. The Purchased column then lists only the items that matched your rules, so the list works as a pick list. Show all items switches back.

The orders list showing only the Gift Box lines, with "+ 1 other item" for the rest of each order

Subscriptions​

With WooCommerce Subscriptions active, the Advanced filters panel also appears on the Subscriptions list, with the same rules. Saved views, export and bulk status change work on the orders list only.