Export WooCommerce Orders to Google Sheets
When you export WooCommerce orders to Google Sheets you get more functionality to filter, sort and analyze data, get insights, create reports. It is also a fast way to provide quick access to the orders data to partner or supplier. Just copy a link and send it.
Following are the steps to export WooCommerce Orders to Google Sheets
- Download a free trial version of Store Manager for WooCommerce and establish connection to your store.
- Launch the orders export wizard.
- Connect to your Google Drive account.
- Follow the steps in the wizard to export orders to Google Sheets.
1. Download a free trial version of Store Manager for WooCommerce and establish connection to your store
If you don’t have a Store Manager installed yet, download it free here. Use quick connection wizard to connect to your store database step by step. When connection is established, you will see all store data. Switch to the "Orders" tab to see your store orders:
2. Launch the Orders Export Wizard
Use filters on the right to filter orders by date they were created, status or customer, click Apply. Then select filtered orders and press the "Export Data" button on the toolbar:
3. Connect to your Google Drive account
In the Wizard, under Select export target switch to Google Sheets. To connect to your Google Drive press Add Account:
You can connect to several Google accounts for example your personal account and your supplier’s account. Therefore, give your connections meaningful names to distinguish them quickly.
In the Google Authentication window, sign in to your Google account:
You will be asked to grant eMagicOne Store Manager permission to access Google Drive files. Click Allow:
After you connected to your Google account you will be redirected back to the Wizard.
4. Follow the steps in the Wizard to export orders to Google Sheets
If you already have the file to export orders to you can choose among the following options:
- Replace sheet values
- Append sheet values
- Insert a new sheet in a file (with the date)
Click the Browse button to select the file. If you want to export orders into a new file press Plus, specify a filename and click OK:
The Google Spreadsheet file is now selected so press Next. On this step, you can choose which fields you want to export. Use single arrow to move certain fields to the right pane or click the button with three arrows to select all fields:
On the Export options step you should specify whether to export all orders or those you selected before. Switch to the corresponding option and press Export:
On the final step you can save export configuration and just load it next time you need to send orders to Google Drive.
Copy the URL to a clipboard if you want to send it to your supplier or client, for example. Or go directly to the file pressing View Export File:
Here is the list of the exported orders on Google Drive:
Use Store Manager to record WooCommerce orders to Google Sheets flawlessly. Let the software do the routine and use saved time to develop your online business!