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:


Store Manager for WooComerce Orders Grid
Store Manager for WooComerce Orders Grid

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 Export Orders Wizard Launch
WooCommerce Export Orders Wizard Launch

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:


Adding Google Drive Account For WooCommerce Orders Export
Adding Google Drive Account For WooCommerce Orders Export

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.


Google Account Display Name for WooCommerce Orders Export
Google Account Display Name for WooCommerce Orders Export

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


Google Account Sign In for WooCommerce Orders Export
Google Account Sign In for WooCommerce Orders Export

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


Access to Google Account for WooCommerce Orders Export
Access to Google Account for WooCommerce Orders Export

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 Orders Export File Explorer
WooCommerce Orders Export File Explorer

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:


WooCommerce Order Fields for Export to Google Sheets
WooCommerce Order Fields for Export to Google Sheets

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 Options
WooCommerce Orders Export Options

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:


Result of WooCommerce Orders Export to Google Sheets
Result of WooCommerce Orders Export to Google Sheets

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


Google Sheets File with Exported Orders
Google Sheets File with Exported Orders

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.