WooCommerce

Google Sheets + WooCommerce

Query, Post and Sync Data from WooCommerce

What is Sheet Director?

Sheet Director is a Google Workspace add-on that helps to manage and control bi-directional data flow between Google Sheets and several other applications like Google Calendar, Tasks, Contacts, Sheets, QuickBooks, FreshBooks, Zoho etc.

It is available in the Google Workspace Marketplace. Please check the Installation instructions to install the add-on.

What is WooCommerce?

WooCommerce is a free, open-source eCommerce plugin for WordPress that allows you to turn a WordPress website into a fully functional online store. With WooCommerce, businesses can sell physical products, digital products, or services directly from their site. It provides features like product listings, shopping carts, secure payments, shipping options, inventory management, and order tracking. Since it is highly customizable, users can extend its functionality with themes and plugins to match their store’s design and needs. In simple terms, WooCommerce is the tool that helps you create and manage an online shop using WordPress.

WooCommerce and Google Sheets: Use Cases

> Query: Pull data from WooCommerce and present on Google Sheets

> Bulk Post: Post data from Google Sheets into WooCommerce.

> Sync: Synchronize data between Google Sheets and WooCommerce.

Setting up WooCommerce with Sheet Director

Choose the WooCommerce(Premium app) from the list and choose the service that you want to perform

If you're opening it for the first time on the sheet, then you won't be having any connections.

Don't worry Sheet director provides a way to create a connection easily

To create the connection you have to provide the following details.

Connection name - Provide a nice name for the connection you're creating
Provide the configuration details which are mandatory

Base Url: "Log in to your WooCommerce account and copy the base URL."

Test Connection

Once you have provided the credentials you can easily check the connectivity by clicking on the test connection button

Based on the credentials authenticity, you will be having the feedbacks from the test

Once after connecting successfully, you can save the connection and continue.

These connections can be reused anytime and from any services used on the same Google Sheets

Querying on WooCommerce

Once after saving the connection successfully, you can select the table and fields that you want to present on the Google Sheets

You also have a refresh button to get the updated tables list from the database

Filters

Filters can be used to query only the matching data from the tables

You can have multiple filters filters to a query

Sort

Sort can be used to sort the query results based on your interest.

You can have multiple sorts to a query

Max Result

You can limit how much no of records you want to fetch using a query

Destination Settings:

Configure the destination settings to save the records.

Scheduler Settings:

Switch on Run automatically to execute services automatically in the background.

Notification Settings:

Configure the Notification settings to set up the email templates and add attachments.

Sample Output

Without Filters and Sort

Posting on WooCommerce

Select the service to Post

Source Sheet

Choose the Source sheet where the data is located
Select the Status column
If the status column is not there, simply click the + button to add the status header on your sheet(A status column will be created in the Spreadsheet)
Select the Result column
If the result column is not there, simply click the +button to add the result header on your sheet(A result column will be created in Spreadsheet)

Mapping

You can manually map the sheet data with the WooCommerce fields

Click on execute to post the records into WooCommerce.
Click Save to save the service.
Click Execute to execute the service

After clicking on Execute you will be shown with the confirmation dialog of how many records will be posted, check that and click on "Post Now" to continue the posting

After successfully completeng the previous step you will be shown with the no successfully posted and failure records

You will also see that under the Result and the status column in the Google Sheet

Output in WooCommerce

Syncing on WooCommerce

Select Sync as a service

Synchronize settings

Synchronization Key

The keys will be used for matching rows in Google Sheets with data in WooCommerce; these keys will be your primary key. (This is identified automatically)

Conflict Resolution:

When Synchronization happens, there could be a conflict of data between Google Sheets and WooCommerce.

WooCommerce Wins
Google Sheet Wins

WooCommerce Wins: The latest data from WooCommerce will be updated in Google Sheets.

Google Sheet Wins: The latest data from Google Sheets will be updated in WooCommerce.

Note: The major requirement in synchronization is the synchronization keys. If any of the keys is not have a value in the Google Sheet, then the Sheet Director will create it in the WooCommerce

WooCommerce Wins

Select WooCommerce Wins.
The latest updated data from WooCommerce will be updated in Google Sheets.

Adding a new prodcut name in WooCommerce

Let's execute this to get the updated record from the WooCommerce

The number of records that are ready to be synchronized will be shown.
It will also show all the data that are ready to be updated.
Click on Sync Now to sync all the data and update it into Google Sheets.
Click on the Refresh icon to refresh the data.

Before Synchronizing

After Synchronizing

The value from WooCommerce is now updated on Google Sheets

Google Sheet Wins

Select Google Sheet Wins.
The latest updated data from Google Sheets will be updated into Microsoft SQL Server.

Let's execute this to Sync the updated record from Google Sheets

The number of records that are ready to be synchronized will be shown.
It will also show all the data that are ready to be updated.
Also, the number of data that needs to be updated into WooCommerce will also be updated.
No of new records found in Sheet which are not present in WooCommerce, that will be created in WooCommerce
Click on Sync Now to sync all the data and update it into Google Sheets.
Click on the Refresh icon to refresh the data.