Stock Sync for WooCommerce with Google Sheets – WooCommerce bulk edit, Stock Management, Inventory Management System & more

Description

SYNC, BULK EDIT AND CREATE NEW PRODUCTS IN WOOCOMMERCE FROM GOOGLE SHEETS

WooCommerce Stock Sync with Google Sheets is the easiest and most powerful inventory management system to handle your WooCommerce products. It helps you manage your WooCommerce store on the go from Google Sheets.

With the help of this stock manager plugin, manage your WooCommerce stock in a snap and keep your sheet synced with your store. Experience the best WooCommerce inventory manager in WordPress!

Recommended by WordPress professionals! 🤩

👁️ View Demo | 🚀 Get The ULTIMATE Version

Stock Sync for WooCommerce with Google Sheets is the most advanced inventory management system that enables bidirectional sync between WooCommerce and Google Sheets.

Whether you are running an eCommerce business or own a WooCommerce store, one of the main things you want to ensure is keeping track of your inventory. Managing product stock and other data from Google Sheets is easier than entering your site dashboard repeatedly for each product.

👁️ View Demo | 🚀 Get The ULTIMATE Version

Our stock manager plugin is two-directionally synchronized. You update the sheet and the data auto-syncs on the site dashboard. Or if you update the site dashboard and the data auto-syncs on the Google Sheets. It saves your time and boosts work efficiency. This is the best WooCommerce bulk edit plugin on the market. 📈

Bulk Edit WooCommerce Products

Create and edit WooCommerce products in bulk with our stock management plugin. You can bulk edit most of the product details from Google Sheets. Working with products in bulk is incredibly easy when you use our bulk editor plugin!

Perform the following WooCommerce bulk edit operations:

  • Bulk edit product names
  • Bulk edit product stock
  • Bulk edit regular price
  • Bulk edit sales price
  • Bulk edit product image (Ultimate)
  • Create new products in bulk (Ultimate)
  • Bulk edit custom fields (Ultimate)

🔝 STOCK SYNC FOR WOOCOMMERCE WITH GOOGLE SHEETS FREE FEATURES

  • Two-Directional Product Sync: The WooCommerce stock sync plugin automatically syncs product stock and other details (name, regular price, sales price) in a two-directional way between WooCommerce and Google Sheets. You update your spreadsheet, and your website dashboard gets auto-updated. Also, if you update details on the site dashboard, your Google Sheets gets an automatic update. In the free version, you can sync up to 100 products. WooCommerce Stock management is getting simpler. 💪

  • Edit Product Details: Easily update your stock status from the connected Google Sheet; they’ll be updated instantly on your WooCommerce store/WordPress site. You can edit product names, pricing, on-sale updates, product type, stock status, etc., from anywhere you want as long as you are connected to the internet. Take the WooCommerce bulk edit to the next level with this inventory manager.

  • Bulk Edit WooCommerce Products: Take full benefits of our bulk editor as you edit your product stock, name, and other details in bulk. This is a powerful feature for any business owner.

  • Export Products on Google Sheets: Get all your store product details in one place in an organized way with this stock manager plugin. All you need to do is activate and configure the plugin. And you will find a gorgeous and organized spreadsheet, pre-formatted with all your products for your convenience (up to 100 products on the free version).

  • Variable Product Sync: Get different rows for variable products of your store. Variable products won’t confuse you anymore while making updates. Insert different data on the expertly crafted rows for variable products. Manage every type of variable product (simple, variable, and group) stock in one place.

  • Manual Sync From WooCommerce and Google Sheets: Once you configure the plugin, you’ll find three buttons (Sync on Google Sheets, Fetch from WooCommerce, Sync on WooCommerce) to sync your product manually from both WooCommerce and the connected spreadsheet. Although every change on the spreadsheet reflects instantly on WordPress and vice versa, you can use these buttons if auto-sync does not happen correctly due to server issues.

  • Product removal restriction: You cannot remove products from the connected Google Sheet. We added this feature to avoid potential mistakes while working on the spreadsheet. To remove any product from your WooCommerce site, you’ll need to do it manually from the dashboard.

  • Freeze Google Sheet Header: Once you activate the plugin and complete the setup wizard, it will automatically format the spreadsheet. This formatting includes freezing the spreadsheet header. You can remove it from Google Sheets > View > Freeze > No rows.

  • Compatibility with Translation plugins: With WPML and Loco Translate compatibility, you can translate the plugins’s strings and access the settings in your local language. Also, using the WPML compatibility you can sync your translated products with Google Sheets.

👁️ View Demo | 🚀 Get The ULTIMATE Version

🔝 STOCK SYNC FOR WOOCOMMERCE WITH GOOGLE SHEETS ULTIMATE FEATURES

  • Unlimited Two-Directional Product Sync: Keep all your store products in synced between WooCommerce and Google Sheets without any limit. The free version allows sync for up to 100 products.

  • Unlimited Product Editing from Google Sheets: Edit most important product details (Name, Stock, Short Description, Price, SKU, Custom Fields) from the connected Google Sheets. Enjoy the full potential of the unique inventory management system for your WooCommerce store.

  • Unlimited New Product Addition from Google Sheets: Take stock management to the next level and add new products to your WooCommerce store from the connected spreadsheet. It gets added to your site dashboard automatically, instantly.

  • Unlimited WooCommerce Bulk Editing and Bulk Product Addition: Edit product details in bulk and create new products without thinking about the limit. The ultimate inventory management tool to supercharge your business from one place.

  • WooCommerce Custom Fields Sync: WooCommerce custom fields or metadata lets you display additional product data (size, color, etc.). With custom fields sync, you can edit your custom field data from Google Sheets and keep them in sync with your store.

  • Stock Keeping Unit (SKU) Sync: SKU helps keep track of your inventory and is a unique identifier for each product. You can update your WooCommerce product SKU from Google Sheets.

  • 🔥 Product Image Sync: You can now easily synchronize your store product image with Google Sheets and also update the image directly from the connected spreadsheet.

  • Display Total Sales Count: WooCommerce stock management has never been this easy. Take smart decisions from the total sales column within the Google Sheets.

  • Display Product Category: View product categories on the connected spreadsheet to easily categorize your products.

  • Display Product Attributes: View product attributes on the connected spreadsheet.

🔥 More Awesome Plugins

If you like Stock Sync for WooCommerce, then consider checking out our other awesome projects:

  • 🌓 WP Dark Mode – Use the WP Dark Mode plugin to create a stunning dark version of your WordPress website. WP Dark Mode works automatically without going into any complicated settings.

  • 🔄 Sheets To WP Table Live Sync – Google Sheets allows you to input data on your Google sheet and show the same data on WordPress as a table effortlessly.

  • 📽️ Webinar & Video Conference with Jitsi Meet – Experience the best WordPress video conference plugin and live video chat solution. Get shortcode support with WooCommerce and BuddyPress integration.

Privacy Policy

Stock Sync with Google Sheet for WooCommerce uses Appsero SDK to collect some telemetry data upon user’s confirmation. This helps us to troubleshoot problems faster & make product improvements.

Appsero SDK does not gather any data by default. The SDK only starts gathering basic telemetry data when a user allows it via the admin notice. We collect the data to ensure a great user experience for all our users.

Integrating Appsero SDK DOES NOT IMMEDIATELY start gathering data, without confirmation from users in any case.

Learn more about how Appsero collects and uses this data.

Screenshots

Installation

  1. Upload ‘stock-sync-with-google-sheet-for-woocommerce’ to the ‘/wp-content/plugins/’ directory.
  2. From the WordPress Plugins menu, activate the plugin.
  3. Follow along the support wizard to connect your WooCommerce store and start flawless syncing.

You can also follow our video tutorial:

FAQ

Why I can’t sync my store all my products with Google Sheet?

If your store product is more than 100 then you’ll need to upgrade to the ULTIMATE version to sync all your store product.

What to do with the variable products of my store?

Stock Sync with Google Sheet for WooCommerce plugin will automatically create rows for your variable products in the sheet and you can manage them smoothly.

How can I link my site with Google Sheet?

It’s quite simple and easy. You’ll get directions in every step after activating the plugin. (Check our tutorial)[https://youtu.be/frwhDkk6sa4].

Can I add any product from the Google Sheet?

Yes! With Stock Sync with Google Sheet for WooCommerce Ultimate, you can instantly add new products to your store from Google Sheet.

Can I remove any product from the Google Sheet?

No. You’ll need to update the data from your site dashboard to remove a product from your store. We are adding this restriction to prevent unwanted changes from the spreadsheet.

Can I manage the product SKU with the plugin??

Yes. The plugin will automatically sync SKU, just like other product data. Even you can edit it from Google Sheets and it will be live synced with WooCommerce.

How can I add the newly added product to the Google Sheet?

Newly added products are supposed to Sync with Google Sheet automatically. Unless, click the ‘Sync with Google Sheet’ button at ‘Products’ page from your website dashboard. It’s as simple as that. Also, you can follow Google Sheets > Find the tab ‘Stock Sync’ > Click on ‘Fetch from WooCommerce’.

Do I need to know any programming language for using this plugin?

Nope! No coding knowledge is required for using this plugin.

Reviews

دسمبر 22, 2023 1 reply
It does what it says it does. Some weird interaction happened on installation the first time. I didn't set up the sheet properly before hand and some sku codes started to convert into dates. But it's good.
اکتوبر 31, 2023
I`ve used this plugin nearly a year now and it was very good. It help me to easily monitor and update our stock from outsite the dashboard seemlessly. This week i had problem with the plugin(not sync), but the support team was very good and responsive. Hope your business will grow and giving more joy to others.Thanks a lot ^_^
اگست 13, 2023 1 reply
The plugin (pro version) failed from day one. Constant crashes of the whole website, slowdowns, etc. The way the support was also slow and shady did not give me the confidence of giving access to my website for debugging. The issues were thus never resolved, and when asking for refund apparently the "policy" does not allow it. I encourage you to find something else.
جنوری 19, 2023
Setting up this plugin is... well, let's say, not easy, if you're neither familiar with WooCommerce (the easier bit) nor with Google Cloud Services (the much harder bit). The good news? You get outstanding information via text and video to help you set up things correctly — there is no way anything will go wrong, the authors of this plugin have it covered, and they set you up with the bare minimum of fuss so that you can start experimenting. And it will work straight out of the box indeed, as others have described. Granted, it's not just point & click, and depending on the complexity of your own setup (in my case, Google Sheets is just 'middleware' to allow my customer's internal database to keep in sync with WooCommerce — so it meant some extra coding on my side), it may take you an afternoon — or just five minutes. YMMV! Sadly, however, the free/demo version has extremely limited functionality: just 20 products, and there is no real 'sync' — rather, WooCommerce will just export the products you've got to Google Sheets, using a very strictly limited number of columns (the barest of bare minimums). This is hardly enough to get a proof of concept — you'd need the full version for that. And you will have to deal with all sorts of errors along the way, which do not come from the plugin itself, but rather from the way the several layers of software must communicate to reach across the wide gap between WordPress + WooCommerce and whatever database backend you're integrating with via Google Sheets. For instance, the following error (coming from Google AppScripts) left me baffled: SyntaxError: Unexpected token '<', "<!DOCTYPE "… is not valid JSONat ssgsw_sync_data(Integration with WooCommerce.gs:341:18)at ssgsw_sync_all(Integration with WooCommerce.gs:324:2) It took me a while to understand that this is related to my several layers in front of WP/WooCommerce. At some point, the plugin will give an error because I did have indeed more than 20 products. This error hits the nginx webserver, which gets confused (because it's a JSON error, not an application error), and emits the code as part of a regular web page, with the JSON embedded in it. This, in turn, is shielded by the protection layer above it: Cloudflare, which will add their own headers and embed some cookies and so forth. When the error finally hits the Google AppScript engine, it has been gone through so many transformations that the AppScript (note: it's automatically generated by the plugin itself) cannot figure out what kind of reply it got. To deal with this particular environment, therefore, I would need to add some more wrapper code along the way — letting a JSON error to go through the many layers unscathed — or, optionally, have the AppScript add a few more checks before reading whatever it received, and not automatically assume that it'll get something precisely formatted as expected... Granted, my environment may be a bit odd here and there, and rather not exactly what most people have installed. But you should take into account that, except for the simplest of online shops, 'real' shops or online marketplaces will have several levels of complexity, and whether this plugin will do its magic or not will depend on a lot of factors... for which you might not be able to get a workaround. At least not with the demo/free version — it's simply too limited for that. On the other hand, without being able to show my customer a proof of concept using this plugin, they hardly will be impressed, or give the go-ahead to use this particular solution. There are a few alternatives around — most with some sort of free or demo or trial versions — and, in my case, I had no choice but to remove the plugin and try with something different. Which is a pity, really; as said, the plugin is not only very polished and well-coded, it includes the fantastic documentation (with tutorial videos!), which turns a difficult task into a reasonably easy way to set things up.
Read all 8 reviews

Contributors & Developers

“Stock Sync for WooCommerce with Google Sheets – WooCommerce bulk edit, Stock Management, Inventory Management System & more” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

3.8.1 – 23 Jan 2024

  • Fix: Resolved simple product and variable product 0 stock update issue

3.8.0 – 21 Jan 2024

  • New: Added function of recovery variation product
  • Fix: Resolved variation product price range showing issue

3.7.1 – 20 Jan 2024

  • Fix: Resolved auto short description update issue
  • Fix: Resolved auto SKU update issue

3.7.0 – 14 Jan 2024

  • New: Added product image feature. Users can display the WooCommerce products in Google Sheet.
  • New: Compatibility with Loco Translation plugin.
  • New: Compatibility with WPML plugin.
  • New: Allowed any of the tabs of a spreadsheet to sync products.
  • New: Introduced our own token for validation requests.
  • Improvement: Performance update when creating and updating products from Google Sheets.
  • Fix: Resolved conflicting issues with JWT Authentication for WP-API Plugin.
  • Fix: Resolved issues with unlimited bulk product creation.
  • Fix: Resolved the issue of inserting a price of 0 in Google Sheets.
  • Fix: Resolved CSS conflicting issues.

3.6.1 – 4 Dec 2023

  • Fix: Resolved “SyntaxError: Unexpected end of JSON input” error while clicking on “Sync on WooCommerce” CTA

3.6.0 – 29 NOV 2023

  • New: Full compatibility with WooCommerce High-Performance Order Storage

3.5.1 – 23 Nov 2023

  • Improvement: Font size fixing and UI improvement

3.5.0 – 20 Nov 2023

  • New: Feature to add support popup
  • New: Build pot files for translation
  • Improvement: UI improvement for dashboard changes in step1
  • Improvement: Updated popup design when sync

3.4.1 – 13 Nov 2023

  • Fix: Fixed variation product name update issue

3.4.0 – 8 Nov 2023

  • New: Added user friendly notices with new design
  • Improvement: Enhanced AppScript and license top bar notice design
  • Improvement: Updated the admin dashboard B&W plugin icon

3.3.4 – 2 Nov 2023

  • Fix: Fixed an issue that caused a fatal error when calling the set_campaign method on null due to a conflict between the SDK and some plugin

3.3.3 – 25 OCT 2023

  • Improvement: Updated popup design

3.3.2 – 22 OCT 2023

  • Fix: Enhanced performance and fixed minor issues

3.3.1 – 9 OCT 2023

  • Fix: Resolved bulk edit popup issue.
  • Fix: Updated readme file with “Installation” tab

3.3.0 – 9 OCT 2023

  • New: Introduced bulk edit feature in Google Sheet.
  • New: Added top bar notice to notify users about the new Appscript updates.
  • New: Implemented a popup in Google Sheet to display loading during bulk changes.
  • New: Added a popup in Google Sheet after modifying view-only data.
  • Improvement: Increased the product sync limit from 20 to 100 in the free plan.
  • Improvement: Enhanced product syncing by updating specific products based on their index number in Google Sheets.
  • Fix: Resolved a fatal error that occurred when installing another plugin from the WordPress dashboard if the stock sync plugin was already installed.

3.2.1 – 14 SEP 2023

  • Improvement: Enhanced performance and fixed minor issues

3.2.0 – 14 SEP 2023

  • Fix: Resolved the product type conflict for “variation” and “variable”
  • Fix: Fixed “Invalid Access! Call undefined method GuzzleHttp\Utils::chooseHandler()”
  • Improvement: Enhanced performance by reducing the time complexity by transitioning Google SDK to Rest API.
  • Improvement: Updated the WPCS to version 3.0

3.1.4 – 14 AUG 2023

  • Improvement: Enhanced compatibility to support WordPress 6.3

3.1.3 – 12 Jul 2023

  • Fix: SKU setting not working issue

3.1.2 – 26 June 2023

  • Improvement: Enhanced performance and fixed minor issues

3.1.1 – 22 June 2023

  • New: Syncing support of text-based custom fields of Advanced Custom Field
  • Fix: Custom field syncing issues
  • Improvement: Reserved keyword restriction for custom field

3.1.0 – 22 June 2023

  • New: WooCommerce Custom Fields can be now synced and updated from Google Sheets
  • New: Added notice bar for old users to update the new AppScript

3.0.5 – 7 June 2023

  • Improvement: Enhanced performance and fixed minor issues

3.0.4 – 10 May 2023

  • Improvement: Enhanced performance and fixed minor issues

3.0.3 – 17 April 2023

  • Improvement: Enhanced performance and fixed minor issues

3.0.2 – 28 MAR 2023

  • Improvement: Checked compatibility with WordPress 6.2
  • Improvement: Enhanced performance and fixed minor issues

3.0.1 – 28 JAN 2023

  • Improvement: Enhanced performance and fixed minor issues

3.0.0 – 30 JAN 2023

  • Fix: Security issues and patches
  • Improvement: Improved code quality and standard
  • Improvement: Enhanced performance and fixed minor issues

2.1.4 – 15 DEC 2022

  • Improvement: Enhanced performance and fixed minor issues

2.1.3 – 15 DEC 2022

  • Fixed: Fixed total sales count
  • Fixed: Fixed syncing products on activating/deactivating license
  • Fixed: Added redirection on activating ultimate plugin
  • Improved: Fixed some minor UX issues
  • Improved: Enhanced performance and fixed minor issues

2.1.2 – 03 NOV 2022

  • Improvement: Enhanced performance and fixed minor issues

2.1.1 – 04 OCT 2022

  • Improvement: Enhanced performance and fixed minor issues

2.1.0 – 05 SEP 2022

  • Improvement: Enhanced performance and fixed minor issues

2.0.9 – 25 AUG 2022

  • Improvement: Enhanced performance and fixed minor issues
  • Fixed: Class “Google\Auth\Cache\TypedItem” not found

2.0.8 – 22 AUG 2022

  • Improvement: Enhanced performance and fixed minor issues

2.0.7 – 16 AUG 2022

  • Improvement: Enhanced performance and fixed minor issues

2.0.6 – 2 AUG 2022

  • Improved: readme file
  • Improvement: Enhanced performance and fixed minor issues

2.0.5 – 1 AUG 2022

  • Fixed: Error: No product data

2.0.4

  • Improvement: Enhanced performance and fixed minor issues

2.0.3

  • Improvement: Enhanced performance and fixed minor issues

2.0.2

  • Fixed: Fixed turning sale price forcefully zero
  • Fixed: Fixed connecting custom Sheet Tab

2.0.1

  • Added: Added SKU column
  • Fixed: Fixed creating new products from Google Sheet

2.0.0

  • Fixed: Revamped plugin backend.
  • Fixed: Minor bugs.
  • Fixed: Server is too busy
  • Added: Revamped UI/UX
  • Added: Revamped setup wizard.
  • Added: Product addition from GS.
  • Added: Display product short description.
  • Added: Notifications on sync, add, update

1.2.1

  • Added: Loader if server is too busy.
  • Updated: Setup wizard steps design
  • Fixed: minor bugs

1.2.0

  • Updated: Installation video link

1.1.9

  • Updated: Links & Labels

1.1.8

  • Updated: Plugin title
  • Updated: readme.txt & readme.md

1.1.7

  • Updated: App Script video documentation link.

1.1.6

  • Updated: Video documentation link.

1.1.5

  • Improved performance and fixed minor issues

1.1.4

  • Updated: FluentApi
  • Improved performance and fixed minor issues

1.1.3

  • Fixed: Despite not being connected to Google Sheet, the export button shows “%d products exported in google sheet”.
  • Improved performance and fixed minor issues

1.1.2

  • Update readme.txt

1.1.1

  • Update readme.txt

1.1.0

  • Introduced new UI
  • Improved performance and fixed minor issues.

1.0.0

  • Initial release