How to Sync WooCommerce Orders with Google Sheets
Wordpress tools How to

How to Sync WooCommerce Orders with Google Sheets

AliDropship is the best solution for drop shipping

Person Scores:

[Total: 0   Average: 0/5]

This tutorial explains the way to sync WooCommerce orders with Google Sheets. To do that, I’ll use a easy Google Apps Script that integrates WooCommerce instantly in Google Sheets. The script may be run at automated intervals and it fetches particulars of all of the orders and present them to you. For every order its shows info like order id, first title, final title, billing tackle, cell phone quantity, amount, value, order key, and order standing. You can too decide to run this script manually at your will anytime to sync the Google Sheet with the orders listed in your WooCommerce dashboard. It could possibly additionally replace an order’s standing within the sheet when its standing modifications within the retailer’s dashboard.

There are some providers to do the very same factor mechanically corresponding to Zapier. However they aren’t free and has a really restricted free plan. For a free and limitless different to Zapier’s WooCommerce-Google Sheets integration, you possibly can depend on the Google Apps Script that I’ve talked about right here. This script principally makes use of the remainder API already offered by WooCommerce put in in your web site. With a view to arrange this, you want a WooCommerce retailer hosted on an internet site that has HTTPS enabled, a Google account, and just a little information of Google Sheet. This easy script is open supply as nicely and it’s out there on GitHub. If you wish to enhance it then you’re free to take action and in later updates there could also be some extra options.

How to Sync WooCommerce Orders with Google Sheets

Tips on how to Sync WooCommerce Orders with Google Sheets?

I’ve already talked about the necessities wanted for the setup of the Google Apps Script. So, with out losing a lot time, let’s simply get began. The very very first thing that it’s important to do is generate REST API keys out of your WooCommerce dashboard.

To generate API keys, you go to WooCommerce > Settings > Superior part. Within the REST API tab, add a brand new key.

WooCommerce Generate API Key

Click on “Generate API key“. Your keys can be proven there and just remember to don’t shut the tab but. You should copy down each; the API key and the API secret.

WooCommerce API Keys generated

Now, you simply make a duplicate of this Google Sheet from here. This sheet is already configured with the Google Apps Script that can be answerable for fetching the orders out of your WooCommerce Retailer and show them within the sheet. This sheet has some fields on the highest left aspect that it’s important to fill out.

make a copy of the sheet

Within the Google Sheet that you simply simply copied, enter the API key and the API secret that we generated earlier. Together with this, you additionally need to enter the URL of your retailer and a date. The date parameter can be used as a beginning date to fetch the orders particulars from the shop.

Add API parameters in the sheet

Now all the pieces has simply arrange and use the “SYNC ORDERS” button to run script for the very first time. Within the first run, you’ll have to authorize the script. Click on on the Proceed button, after which select your Google account from the checklist after which click on on the Enable button. Since this script is just not approved by Google so it provides you with a warning. To get round with that, you simply click on on the “Superior” after which click on on “Proceed anyway” choice.

Authorize Google Apps Sript

Lastly, click on on the “SYNC ORDERS” button yet one more time. It would now begin fetching your orders and can show them within the Google Sheet. Relying on variety of orders out there in your retailer, it could take a while. The ultimate sheet with all of the orders will appear like the one within the following screenshot.

WooCommerce Orders in Google Sheets

Tips on how to Replace Google Sheet with WooCommerce Orders Particulars Robotically?

At this level this script is working and you need to use it anytime to sync your orders with the Google Sheet. Nonetheless, you’ll have to run the script manually each time you need to sync the orders. However you possibly can go away it to autopilot to mechanically run the script at specified intervals. The “Triggers” characteristic of Script Editor can be utilized to realize this. Click on on Instruments > Script editor. The script editor will now open up and also you go to the Edit > Present initiatives triggers menu and create a time pushed set off.

Project Triggers

You’ll have to choose “start_syncv2” because the operate to run after which configure the corresponding time interval primarily based in your wants. There are alternatives to replace sheet each day, hourly, month-to-month, and even by minutes.

Trigger properties

That’s it. On this method, you need to use this easy and highly effective Google Apps script to at all times hold your WooCommerce orders and a Google sheet in sync with all the required particulars. It is a nice different to the Zapier integration as you get the limitless variety of runs. The perfect half is that, each time when the cheat runs it fetches all of the orders from the shop time and again. So that is useful as you’ll at all times get the up to date checklist of orders and their statuses.

Closing ideas:

I’m merely amazed by the performance of this script that I’ve talked about. It really works completely and can assist you at all times hold your WooCommerce orders synced in a Google Sheet. After you have all of your orders within the spreadsheet, you may make use of different options of Google Sheet to govern the information. Or, or you can even export order particulars in quite a lot of codecs corresponding to excel, PDF, CSV, TSV, and ODT. So, if you happen to’re searching for free different for Zapier-WooCommerce integration then you’re on the proper place. trustworthy undergo the step-by-step information above and get it achieved very quickly.