First, install and activate “WooCommerce” if you haven’t done that yet.
Install & Activate Order Sync With Google Sheets for WooCommerce Ultimate #
Go to your WordPress admin dashboard. Navigate to the “Plugins” menu and click on the “Add New” button.
Now, search for “Order Sync with Google Sheets for WooCommerce”.
Click on the “Install Now” button and then activate the plugin by clicking the “Activate” button.
After activating the plugin, Now, you’ll need to activate the Ultimate version of the plugin and the license key. To do that go to https://wppool.dev/my-account/.
Login to your account to find a similar interface. From here you can download the Ultimate plugin’s zip and get your License Key.
Now, go back to the WordPress dashboard and navigate to the Plugin menu. Click on Add New and select Upload Plugin.
Upload the premium plugin file you just downloaded from your account and then hit “Install Now”. Also, activate the plugin in the next step.
In the next step, go to the “Order Sync with Google Sheet” plugin menu in your dashboard and click on “License”. Here enter your license key and activate the license.
Now Order Sync with Google Sheet Ultimate is ready for you to set up.
How To Set Up Order Sync with Google Sheets For WooCommerce #
Set Up Credentials: #
After activating the plugin, it will take you to a page to set up. Click on “Start setup”
There, click on “Google Cloud Platform” to create a service account.
Now, you need to create a new project from the option shown below and you can skip this step if you’ve already created one.
Next, click on the Service account under the Create credentials button.
Here, set your account information by clicking on the Continue button and then finish with the Done button.
Now click on the service account you created.
Then go to the KEYS tab to click on the ADD KEY.
Next, click on the Create new key.
Now, set the key type to JSON and click on “CREATE”.
Upon clicking, the credentials will be downloaded to your PC.
Now go to your plugin section and upload the JSON file
Then click on the link that says click here so that you can enable the API for Google Sheets.
Enable the Google Sheets API
Now go back to the plugin and check the box to confirm that you have enabled the Google Sheets API and hit next.
Add Google Sheet URL & Sheet Tab Name #
To add Google Sheets to the plugin, create a new spreadsheet, set a title, and copy the URL of the spreadsheet.
Paste the sheet URL in the URL field of the plugin.
Also, copy the sheet tab and paste the tab name. Finally, click on “next”
Add Editor Access to The Plugin #
In the next step, copy the provided ID to share editor access to this ID from your Google spreadsheet.
Share the editor access of the spreadsheet to the ID.
Now, go back to your plugin and confirm that you’ve provided the editor access.
Add Script Code on Editor #
In this step, copy the Apps Script code.
Then go to “App Script” under the extensions menu of the Google Sheet you created.
Remove the existing code and paste the code you just copied and hit save and then the “Run” button.
Now, give permission by setting your email.
Click on Advanced and click on Go to the untitled project.
Then, allow Google to access your account.
Now go back to your plugin and confirm that you have added the code script.
Add The Triggers #
To set the trigger, go to the app script and under trigger click on “add trigger”.
Now, Set the function to “onEdit” and then set the event type to “On Edit” and hit save.
Go back to your plugin and confirm the trigger and the permission and hit next.
Complete The Setup #
Finally, click on “Sync orders on Google Sheet” to complete the setup.
And your WooCommerce orders will be synced on Google Sheets.
