Rating 0 stars - 0 votes

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.


Note The possibility to save orders from WooCommerce to Google Sheets was added in Store Manager for WooCommerce v.1.22.0.1089 (released in November, 2019) .

Following are the steps to export WooCommerce Orders to Google Sheets

  1. Download a free trial version of Store Manager for WooCommerce and establish connection to your store.
  2. Launch the orders export wizard.
  3. Connect to your Google Drive account.
  4. 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:


WooCommerce Orders Tab
Go to the Ordes Tab to See All 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:


WooCommerce Filter Orders to Export
Filter Orders You Want to Export

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:


WooCommerce Export to Google SpreadSheet Add Account
Select Google Spreadsheets as a Location

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.


WooCommerce Product Export to Google Sheets Add Cloud Storage
Add Cloud Storage

In the Google Authentication window, sign in to your Google account:


WooCommerce Export to Google SpreadSheet Google Authentication
Sign In to Your Google Account to Connect to Google Sheets

You will be asked to grant eMagicOne Store Manager permission to access Google Drive files. Click Allow:


Grant eMagicOne Access to Google Account
Grant eMagicOne Access to Your Google Account

On the last step of the authentication confirm your previous actions pressing Allow:


WooCommerce Export to Google Sheets Confirm Choices
Confirm your Choices to Connect to Google Sheets

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:


WooCommerce Google Sheets Export Add New Sheet
Add New Sheet to Export Orders

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:


Select Order Datails to Export
Select Which Fields You Want to Export

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:


WooCommerce Orders Export to Google Sheets Select Orders to Export
Export Selected or All Orders

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:


Finish Orders Export to Google Sheets
Save Export Configuration and View Exported File

Here is the list of the exported orders on Google Drive:


WooCommerce Orders Exported to Google Sheets
View WooCommerce Orders Exported to Google Sheets

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!

Export Orders into Google Sheets with Store Manager for WooCommerce

Export Orders Free

COMMENTS
Be the first to comment.