WooCommerce – Export Orders Containing Specific Products

In this tutorial, we will show you how to export WooCommerce orders containing specific products. This can be useful when you want to see which products are selling the most, or to see data such as locations where more of a certain product is purchased, etc.

You will be able to search for orders that contain exactly the products you search for, or those that contain at least one of the products you search for. For example, we’ll show you how to search for orders that exactly contain the “Nike Shirt” product or orders that, among other products, contain that shirt.

For this, we’ll use the WooCommerce Orders Spreadsheet plugin. This tool displays all your orders together with their complete information on a spreadsheet. You can save a lot of time because the plugin allows you to do advanced searches and apply changes to thousands of orders at once.

Once installed, you need to go to Sheet Editor > Edit orders to open the spreadsheet.

After that, just follow these steps to find and export your orders by product.

1- Open the “Search” tool

This tool helps you save a lot of time by allowing you to quickly filter your orders in several ways. Open it by clicking on Search on the toolbar.

2- Search for orders by product

Now let’s see how to search for WooCommerce orders by product. You have at least two options here.

Option 1: Search for products containing all selected products

You can use this option to search for WooCommerce orders containing exactly the products you choose.

Just select these values in the search tool:

• Find orders containing these products: Select It must contain all the products selected, and then enter the products in the field below.
• Click on Run search.

You can see that all the orders containing our “T-Shirt” product have been filtered and displayed on the spreadsheet.

Option 2: Search for products containing at least one of the selected products

You can use this option to search for WooCommerce orders containing at least one of the products selected. Orders can have other products, but they must contain at least one of the products you choose.

Just select these values in the search tool:

• Find orders containing these products: Select It must contain at least one product selected, and then enter the products in the field below.
• Click on Run search.

You can see that all the orders containing our “T-Shirt” product have been filtered, but these orders contain other products as well.

3- Export WooCommerce orders containing specific products

After finding all your orders containing the selected products, open the Export tool by clicking on it on the top toolbar.

Now you need to select these values in order to export your WooCommerce orders containing specific products:

• What columns do you want to export: You can select all active columns, all columns, or specific columns only.
• Which rows do you want to export: All the rows from my current search.
• What app will you use to edit this file: You can select any of the options you have here:
  • Microsoft Excel (Office 365)
  • Older versions of Microsoft Excel
  • Google Sheets (learn about our new Google Sheets Sync service)
  • Other
• Name of this export: This is optional.
• You can Export every product (line item) as separate rows.
• Click on Run search.

Once the process is finished, this is what your CSV file containing orders with specific products will look like:

With the WooCommerce Orders Spreadsheet plugin, you don’t need to spend many hours trying to find your orders by product. You can quickly filter and export them to a CSV file that you can edit with Microsoft Excel or Google Sheets.