Imagine your client asks you to give him a detailed report of the WooCommerce orders in your store. You need to export them quickly to a CSV file that you can print or edit using Microsoft Excel or Google Sheets.
For this, you’ll need to use the WooCommerce Orders Spreadsheet plugin, which displays all your orders and their complete information on a spreadsheet, where you can edit your orders quickly.
These are some features you can find in this spreadsheet.
- Bulk Edit – You can apply massive changes to all your orders in seconds.
- Search – You can filter all your orders in minutes and apply changes to them.
- Import – You can import a lot of orders from a CSV created with Excel or Google Sheets.
- Export – You can export all your orders and their complete information to a CSV from Google Sheets or Microsoft Excel.
- Duplicate – You can quickly duplicate orders to create thousands of copies.
- Locate column – You can enter values to find the exact cell where those values are.
This plugin will completely simplify your orders management.
Once installed and activated, you need to open the plugin by going to Sheet Editor > Edit Orders.
Now you’re ready to export all your orders. Just follow these simple steps.
If you don’t want to filter your orders, go to step two.
1- Optional: Filter the orders you’ll export
To filter your orders, you need to open the Search tool, which is located on the plugin’s toolbar.
Once you open the search tool, you’ll find these search options.
- Contains keyword – Enter a keyword to search for all the orders containing it on the title.
- Status – You can search for all your orders with these statuses: Pending Payment, Processing, On hold, Completed, Cancelled, Refunded, Failed, Trash.
- Find orders containing these products – You can search for orders containing specific products.
- Order notes – You can search for all orders containing a specific keyword in the order notes.
- Enable advanced filters – This checkbox enables the filters you need to search for your orders by billing and shipping info, order total, date range, etc.
Whatever option you select, click on Run search to filter all your orders. Then, you’ll see all your filtered orders displayed on the spreadsheet.
2- Export your orders to a CSV file
The Export tool is located on the top toolbar. So you need to click to open it, and select these values.
- Click on Select all to export all the columns, or select specific columns
- Tick the I understand it will export all the posts from my current search
- OPTIONAL: Tick the I will edit this file with Microsoft Excel
- Click on Start new export to start the export process.
After these simple steps, the CSV file will be downloaded to your computer. You can print it, edit it and import it again to WooCommerce using the Import tool, etc. It’s really simple and fast.