Automatically Export WooCommerce Orders to Google Sheets

In this tutorial, we will show you how to automatically export WooCommerce orders to Google Sheets. Instead of exporting WooCommerce orders to Google Sheets instantly, let’s schedule the export to run at a later date and time.

For example, imagine you want to share a Google Sheet containing the details of your WooCommerce orders with your customer or your dispatch and shipping team. BUT you don’t want to do it now, you want to wait to export tomorrow’s orders as well. The best option is to schedule an export to run tomorrow at the time you want. This way you can spend your time doing other things, without the risk of forgetting to export your orders.

We will use the WP Sheet Editor – WooCommerce Orders plugin. It allows you to view and manage your WooCommerce orders in a spreadsheet. You can do advanced searches, apply bulk changes, export orders and import orders.

We will also use the Google Sheets Sync service, provided by wpsheeteditor.com. It allows you to export and import content between WordPress and Google Sheets. It works with all spreadsheets from the WP Sheet Editor plugin suite running in the backend.

When you subscribe to this service, you will receive a helper plugin that will allow you to connect your WordPress site to your Google account, to the Google API, and to the WP Sheet Editor API. You can follow this guide to install and set up the plugin.

After setting everything up, you need to follow the steps below in order to schedule an automatic export of your WooCommerce orders to Google Sheets.

1- Open the WooCommerce orders spreadsheet

Go to WP Sheet Editor > Edit orders to view all your WooCommerce order details in a spreadsheet.

You will see all your orders displayed as rows of the spreadsheet, and every field as a column. This plugin accepts custom fields!

2- Open the “Export” tool

Now you need to open the Export tool, which will allow you to save your WooCommerce order data to Google Sheets.

3- Automatically export WooCommerce orders to Google Sheets

Now let’s schedule an export to Google Sheets to run automatically at a later date and time.

For this we need to select these values on the Export tool:

• What columns do you want to export:
  • You can select specific columns by typing the column names.
  • You can also Select active columns. Active columns are the ones that have been enabled to be displayed on the spreadsheet using the Column manager.
  • Or you can Select all columns.
• Which rows do you want to export: You can export all the rows, all the rows from a specific search, or all the rows you have manually selected in the spreadsheet.
• What app will you use to edit this file: You need to select Google Sheets.
• Name of this export: You need to add a name for this scheduled job.
• Select the date and time: Use this field to select when you want this automatic export to run.
• Notify this email address when the process finishes: Add an email address here to receive an email notification when the process finishes.
• Select the Run once option.
• You can tick the Export every product (line item) as separate rows checkbox, but this is optional. If you don’t check this checkbox, you will get the order details in one row.
• Once you’re ready, click on Start new export.

After selecting the above values, an export will be scheduled to run at the selected date and time.

You can click the “View scheduled exports” link to open the scheduled exports pop-up window.

Note: You can have multiple scheduled exports / imports simultaneously.

Here you can see that our automatic export of WooCommerce orders to Google Sheets has been scheduled and added to the list of scheduled exports.

You can follow this guide to learn how to take full control of your scheduled jobs.

4- Open your WooCommerce orders on Google Sheets

When the date and time for the automatic export to run is reached, the task will run in the background and you will receive an email notifying you when the process is finished.

This email will contain all the export details, and you can click on the View the Google Sheet link to open the exported file.

As you can see in this screenshot, our WooCommerce orders have been exported to Google Sheets.

The name of the Google Sheet is the same name we assigned to the scheduled job on WordPress.

In this tutorial we have shown you how to export your WooCommerce orders to Google Sheets automatically. We saw how to schedule an export to run at a later date and time.

The Google Sheets Sync service allows you to export and import content between your WordPress site and your Google Sheets account.

It works with all spreadsheets in the WP Sheet Editor plugin, so you can automate exports and imports of posts, pages, products, orders, coupons, downloads, events, courses, etc.