Plugin features

Easy to Use

Just activate the plugin, connect it with your Google Sheets account, and this is it, after that the stock will be synced automatically.

Real-Time Auto Sync

Activate a checkbox in the plugin settings if you want the stock to be synced instantly after it gets changed in your WooCommerce store.

HPOS Compatibility

The plugin is fully compatible with High Performance Order Storage (a.k.a. HPOS), which is recommended for use in the latest versions of WooCommerce.

Custom Column Mapping

It is not necessary to have column names “Stock” and “SKU” in your Google Sheets. You can name them whatever you want, and then map them in the plugin settings.

WooCommerce sync stock with Google Sheets — WooCommerce > Settings > Products > Stock Sync with Sheets

From WooCommerce to Google Sheets or from Google Sheets to WooCommerce

The plugin supports two directions of product stock synchronization – you can easily sync WooCommerce stock to a Google spreadsheet, and the other way around – sync stock from Google sheets to WooCommerce.

To switch between these two modes, all you need to do is to use a specific option in the plugin settings.

Google Sheets live stock sync WooCommerce — WooCommerce > Settings > Products > Stock Sync with Sheets

Real-Time or Scheduled Sync

By default, the WooCommerce stock sync with Google Sheets is happening in the background, every 15 minutes (or within a given time interval you set in the plugin settings).

However, if the “Sync stock instantly” checkbox is checked, the synchronisation in the direction of Google Sheets will happen instantly (every time product stock levels have been changed; maybe when a product is updated or a new order is placed).

How to sync stock with Google Sheets
1. Activate the plugin
2. Connect Google Sheets account
3. Configure plugin settings
4. Start syncing stock with Google Sheets

How to Start WooCommerce Stock Sync with Google Sheets?

1. Install and Activate the Plugin

First of all, you need to install the “Stock Sync with Sheets for WooCommerce” plugin in your store and activate it from the admin menu “Plugins > Installed Plugins”.

How to activate the stock sync with sheets plugin on a WooCommerce store

2. Connect your Google Sheets account

Second, connect your Google Sheets account in the plugin settings. To do so, you need to navigate to “WooCommerce > Settings > Stock Sync with Sheets”, and then scroll down just a little bit:

Connect the plugin to Google Sheets API — WooCommerce > Settings > Stock Sync with Sheets

Once you have provided the Client ID and Client Secret from your Google account, you need to click the button below “Connect to Google Sheets API” and follow the necessary steps. If everything is done correctly, then it will show you an appropriate connection status.

3. Configure plugin settings

Once your Google Sheets account is successfully connected, it is time to configure the plugin.

Stock Sync with Sheets WooCommerce plugin settings page

The following plugin settings are currently available:

Sync direction – allows you to decide whether you would like to sync your store’s stock to a Google spreadsheet, or the other way around, to sync stock from a Google spreadsheet back to your WooCommerce store.
Real-time sync – this option is only available when you’re syncing your store’s stock to Google Sheets. It allows you to perform the synchronization instantly, at the same moment, when stock levels of a product have been changed (because either a product was updated or a new order was placed).
Sync interval – when using scheduled synchronization, you can choose its interval (15 minutes, 1 hour, 12 hours, or 24 hours).
Google Sheet URL – copy and paste your Google spreadsheet URL into this field (and this is the only setting here that requires your attention, configuring other settings here is optional).
Columns mapping – this option allows you to decide which column in your Google Sheet will serve a purpuse of a stock quantity.

The goal is to keep the plugin as simple as possible; however, more options are coming in the next plugin releases.

4. Start syncing stock with Google Sheets

No more configuration is needed – the plugin will perform automatic stock synchronization of the products (and product variations) with the Google Sheet provided in the plugin settings.

Sync mode	Description
Instant stock sync	The synchronization will happen instantly at the moment when product stock levels change.
Scheduled stock sync	Synchronization will happen automatically at the time interval specified in the settings.

However, if you have difficulties with configuring the plugin, of have some questions on how it is working, feel free to contact me anytime.

FAQ

Do you offer a lifetime developer license?

A lifetime developer license for this plugin (one-time purchase), which comes with 1 year of support and lifetime plugin updates is currently available via this link.

Although we stopped offering new lifetime licenses a while ago, this option is now available again (temporarily), since we received many requests to bring it back.

Do you offer support if I need help?

Yes, of course!

You will receive 2 weeks of support if you purchase a personal license of the plugin. But you can purchase a developer license and receive unlimited support.

You can get support on this page.

What happens if I cancel my subscription?

You can still use the plugin as usual; the only thing is that you will be unable to receive more support or to get the latest version of the plugin. Sometimes it is important to keep your website fast and secure, but it is not necessary.

Are synchronization logs available in the plugin?

Yes, the plugin uses the standard WooCommerce logging, which means all the logs are available in “WooCommerce > Status > Logs”.

Have more questions? Feel free to contact me.