🐦 Early Bird BFCM Sale is here! Save Up to 50% · Lifetime Deals from $79 Ends in 00d00h00m00s Grab My Deal ➜
Articles

Announcing Stock Sync with Google Sheet for WooCommerce plugin

Stock Sync with Google Sheet

Last updated: November 15, 2026

With the new Stock Sync with Google Sheet for WooCommerce plugin, you can now manage all your WooCommmerce stock from the google sheet.

Yes, it takes time to manage stocks. Visiting the WooCommerce dashboard and editing each product stock manually every time is super boring and time-consuming. Well not anymore. Using the Stock Sync with Google Sheet for WooCommerce plugin, you can sync all your product data to the google sheet automatically and manage them efficiently from there.

You don’t need to do manual labor anymore. Today we are going to show you the features and usage of this amazing plugin.

Keep reading till the end.

Table of Content

Stock Sync with Google Sheet for WooCommerce features

Here are the features you will get using the Stock Sync with Google Sheet for WooCommerce plugin,

Easily export products to Google Sheet

You can get all your store products details in one place in an organized way on a simple spreadsheet and sync stock. All you have to do is just activate the plugin, open a Google SpreadSheet, connect the sheet to your site dashboard and follow the steps for exporting all the stock details. Simple, organized, and hassle-free.

Support for variable product

You can also get different rows for variable products of your store. There are no complications in uploading Variable products. You can put different data on the created different rows for your variable products. Manage simple, variable, and group each type of product of your stock in one place.

Update almost everything

You will get not only export data, you can easily update all the stock data from the sheet to your site dashboard. You’ll get edit access to the site dashboard from the sheet both in one place. Edit product name, details, pricing, on-sale updates, product type, stock status, etc. in one go. Managing your store is easier now.

Auto-sync with a two-directional path

Editing the sheet and syncing with the site is not all. Stock Sync for WooCommerce with Google Sheet plugin automatically syncs in a two-directional path. You update your sheet and the site dashboard gets auto-updated. You update details on the site dashboard your Google Sheet gets an automatic update. Stock management is getting simpler.

Manually edit or remove products from the sheet

For maintaining a new product launch in your store or to remove one you’ll not get edit access from the sheet. So, products won’t be overlapped mistakenly which happens on sheet management often. This feature is for managing the store avoiding major mistakes while you’re in rush. For placing or removing any product from your WooCommerce site you’ll need to do it manually from the dashboard, not from the sheet.

One-click manual sync button

Get a backup button for sync data. If anything happens on the Google Sheet unexpectedly like the existence of unnecessary content and If you want to manually sync the products and replace the old data in the sheet with unnecessary content then you can update manually with the new change on the site on your sheet with just one click.

How to install and use the Stock Sync with Google Sheet for WooCommerce

To use the Stock Sync with Google Sheet for WooCommerce plugin, you need to follow the below steps,

Step 1: Install and activate the plugin

Go to your WordPress admin dashboard and navigate to Plugins–> Add New. There type the plugin name, install and activate the plugin.

install and activate the plugin stock sync with google sheet for WooCommerce
install and activate the plugin

Note that you need to activate the WooCommerce plugin in order use the stock sync with google sheet for WooCommerce plugin.

Step 2: Configure the settings

Now, go to the stock sync with google sheet for WooCommerce dashboard and click on the Get Started button,

dashboard
dashboard

Now, copy the URL link of your Google Spreadsheet where you want to copy your product details,

copy URL stock sync with google sheet for WooCommerce
copy URL

Paste the URL in the next page and also paste the Tab name of the Google Sheet just like the image below,

Paste URL
Paste URL

Now, copy the ID in the text box to give editor access,

Copy ID
Copy ID

You need to paste the ID in the share section,

share section stock sync with google sheet for WooCommerce
share section

Now, paste the ID on your Google Sheet share section and give the Editor access,

give editor access  stock sync with google sheet for WooCommerce
give editor access

Check the “I’ve given this ID “editor” access option, click on Next,

checkbox
checkbox

Step 3: Copy the script

Now, you need to copy the copy the script from the Set Script Code section,

copy script
copy script

Click on the Extensions button of your Google Sheet and click on the App Scripts,

app scripts
app scripts

Paste the code here and save the project,

paste the script
paste the script

Now you need to add a trigger, click on the Trigger button,

trigger
trigger

Click on the Add Trigger button, choose my function and on edit option, and save the trigger,

save triggger
save triggger

You might have to give some permission to save the trigger.

Choose your account,

choose account
choose account

Check the checkbox like the image below,

checkbox again
checkbox

Step 4: Sync with Google Sheet

Now, click on the Sync with Google Sheet button,

sync
sync

If it is successful, you will get a message,

succesfull
succesfull

You can see in the spreadsheet that the products are copied,

copied
copied Sheet

Frequently Asked Questions

What is Stock Sync with Google Sheet for WooCommerce called now?

The plugin is now called FlexStock. It still does what this post describes. It syncs your WooCommerce products to a Google Sheet so you can update stock, prices and other details from the spreadsheet instead of editing products one at a time.

How do I connect WooCommerce to Google Sheets for stock management?

Install the plugin, set up your Google Sheet in its settings, copy the provided script into the sheet, and run the first sync. From then on your products show up in the sheet, and the changes you make there go back to the store.

Can I update WooCommerce stock from Google Sheets?

Yes, that’s the whole point of the plugin. Change a stock number in the sheet and it updates in WooCommerce. With hundreds of products, that’s much faster than opening each product page in the dashboard.

Is a Google Sheets stock sync worth it for a small store?

It pays off once you have more products than you want to edit by hand, or when several people manage stock. A spreadsheet is easier to share with a team than WordPress admin access, and you can sort and filter it however you like.

Does the stock sync work with variable products?

Yes. Variations get their own rows in the sheet, so you can update stock and prices for each size or color separately. That’s one of the main reasons stores move stock management into a spreadsheet.

What happens if two people edit the sheet at the same time?

Google Sheets handles simultaneous editing, and the plugin syncs whatever is in the sheet. To avoid confusion, give each person their own set of products or columns, and use the sheet’s version history if something gets overwritten.

Conclusion

So, here it is.This is how you can use Stock Sync with Google Sheet for WooCommerce plugin with ease. Now you can manage your stocks quite easily and run your WooCommerce store efficiently as well. If you have any queries do let us know in the comment section.

Add your first comment to this post

Subscribe to get product updates

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

WPPOOL Subscription form