Sticker Sticker
Sticker Sticker
  • 00 :

    Days
  • 00 :

    Hours
  • 00 :

    Minutes
  • 00

    Seconds
Sticker Sticker
Stock Sync with Google Sheet for WooCommerce

Experience more scalable and reliable syncing with Google Cloud from Stock Sync for WooCommerce plugin V2.0.0

Stock Sync with Google Sheet for WooCommerce - Best WooCommerce Stock Sync Plugin for WordPress

Recently we received some complaints about the stock sync feature of our Stock Sync for WooCommerce with Google Sheet plugin. Thanks to the patience of our lovely community, we’ve figured out the issue and are now ready to meet your daily eCommerce inventory management needs. Keep reading this blog to learn about the issue, how we’ve solved it and how to get started with the updated version.

Table of Content

Overview

After the tremendous success of Sheets to WP Table live Sync, our users were demanding a plugin that will ensure swift WooCommerce inventory control. We loved this concept and that’s how the journey of Stock Sync for WooCommerce began. After months of development, we were finally ready. It was time to deliver what our users have longed for quite some time.

With the plugin’s initial launch, We received a tremendous response from the WordPress community. Our speculations came true – the community was searching for a reliable WooCommerce stock manager. Unfortunately, then we faced a rough start.

What went wrong?

The previous version of our plugin was using Google Apps Script, which is a JavaScript platform from Google that allows users to automate Google products. The Apps Script has a limitation of receiving 300 requests/day. So our users were facing the “server busy” issue when they were trying to import more than 300 products at once which is higher than the daily limit.

How did we solve the issue?

Thanks to our extremely talented group of developers, the server busy issue is fully fixed now. We’ve now switched to the Google Cloud Platform to generate your service account which will allow you to reliably sync as many products as you want (on the Ultimate version).

Get started with fast and reliable stock management

First of all, install and activate the plugin. Then from the WordPress dashboard, select the plugin and get started with the setup wizard. The setup page will redirect you to the Google Cloud Platform, where you’ll be required to create a project.

Stock Sync for WooCommerce with Google Sheet Setup (Step-1)
Google Cloud Platform interface

Once you’ve created a project, navigate to Create Credentials -> Service account. Here add your preferred service account name and click on Create and Continue. Finally, click on Confirm to grant access to your service account.

Stock Sync for WooCommerce with Google Sheet Setup (Step-2)
Service account creation

Now, select your service account and head on to the Keys section. Choose Add Key and download the generated JSON file. Now select the JSON file (or drag & drop) to complete this step. Make sure to enable Google Sheets API, which you’ll find from the search option of the Google Cloud Platform.

Stock Sync for WooCommerce with Google Sheet Setup (Step-3)
Adding credential file

If you are finding these steps complex, you can check our step-by-step tutorial on YouTube.

How to get started with Stock Sync for WooCommerce with Google Sheet

Next, create a spreadsheet from Google Sheets and share the URL from the address bar. Also, copy the tab name from the bottom of the spreadsheet and paste it during this step.

Stock Sync for WooCommerce with Google Sheet Setup (Step-4)
Connecting your Google spreadsheet

Next, you need to add editor access to the plugin to control spreadsheet products from WordPress. Copy the ID from this section and provide editor access from the spreadsheet by clicking on the Share button.

Stock Sync for WooCommerce with Google Sheet Setup (Step-5)
Steps for providing editor access to the plugin

You’re almost ready! Navigate to Google Sheets -> Extensions -> Apps Script. Remove the existing code from the editor and paste the code that you’ve just copied from the plugin and click on Save Project. From the left panel, go to Triggers and select Add Trigger. Find the dropdown for Choose which function to run and select onEdit. Similarly for Select event type, select On edit. Click on Save to save changes. If you are trying these steps for the first time Google will ask for your permission. Click on Allow to create the trigger.

Stock Sync for WooCommerce with Google Sheet Setup (Step-6)
Configuring Apps Script

Finally, click on Sync with Google Sheet to enjoy reliable and fast live sync for WooCommerce products.

Conclusion

Every single one of our plugins is made while keeping your comfort in mind. Still, we face complications from time to time. We want to take this moment to thank you for your patience once again!

Take your WooCommerce store to another step with next-generation live sync. If you have any queries or suggestions regarding our products, feel free to let us know via comments.

Leave a Reply

Your email address will not be published.

Subscribe to get product updates

Get exclusive updates on discounts, product updates, WordPress news & tips

Easy Video Reviews

{{startingCount}}
{{time(finishingCount)}}
{{trans(`You have no camera installed on your device or the device is currently being used by other application`)}}
{{trans(`Please try visiting this page with a valid SSL certificate`)}}
{{trans(`You can record up to %s minutes, don't worry you will review your video before sending`, time(preference.max_video_length))}}
{{trans('Seconds')}}
{{trans(`You can record up to %s minutes, don't worry you will review your video before sending`, time(preference.limits))}}
{{trans('Uploading video...')}}
{{send.message}}

{{trans('Upload video')}}

{{trans('Drag your files here or click in this area')}}
{{uploader.file}} {{uploader.size}} x