In this quick entry, we’ll show you how to search for all your orders created by guests or not registered users in just some seconds and following some really simple steps. You don’t need to spend hours trying to find them not use PHP snippets to do it.
This can be wonderful if you have to give your client a report on how many orders have been created by customers with no registered accounts or when you want to come up with a new email marketing campaign for non-registered users.
You’ll use the WooCommerce Orders Spreadsheet plugin, which allows you to filter and edit thousands of orders in minutes. You can do advanced searches, apply massive changes, export/import orders’ info using CSV files, etc.
Once installed and activated, open the plugin by going to Sheet Editor > Edit Orders. You’ll see a spreadsheet containing all your orders and their complete information.
1- Open the “Search” tool to filter your orders
The Search tool allows you to do advanced searches in seconds. You just need to open it on the toolbar, and you’ll be able to search for all your orders by keyword in the title, status, customer, product list, date range, billing/shipping info, IP address, etc.
2- Search for your orders created by non-registered users
Once you open the Search field, you need to tick the Enable advanced filters checkbox and select the following values:
- Field key: customer user (_customer_user)
- Operator: =
- Value: (empty). You need to select this option because you’re searching for all orders created by non-registered users.
- Click on Run search
After this, the plugin will filter all the orders matching this search parameter and display them on the spreadsheet.
3- Export your filtered orders to a CSV file
After filtering your orders, you’ll be ready to export them to a CSV file. For this, click on Export on the top toolbar.
Now select these values:
- Click Select All to select all the columns to export or select specific columns.
- Tick the I understand it will export the posts from my current search
- Optional: Tick the I will edit this file with Microsoft Excel
- Finally, click on Start new export.
Do you see? It is really simple to filter all your orders created by guests and export them to a CSV file. You didn’t have to spend lots of hours nor use any PHP snippets. Just some simple values, some clicks, and done!