Stock Sync for WooCommerce with Google Sheet – Easy Stock Management and Inventory Management System for WooCommerce

Lýsing

🔥 Auto-sync WooCommerce products from Google Sheets. An easy, powerful and simple inventory management system to handle your WooCommerce products.

Ever thought of managing your WooCommerce store stock from a spreadsheet? Visiting the WooCommerce dashboard and manually editing each product stock every time is boring and time-consuming. It kills your productivity. So, why not make it simple? 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 #1 WooCommerce inventory manager in WordPress.

👁️ View Demo | 🚀 Get The ULTIMATE Version

Stock Sync for WooCommerce with Google Sheet is the most advanced inventory management system with two-directional sync with 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 a Google Sheet is easier than entering your site dashboard repeatedly for each product.

With the help of the stock manager plugin, you can edit almost everything from your linked spreadsheet, and it gets auto-updated on your main eCommerce site. In addition, it helps your customers be engaged with your updated site with inventory updates. This is the smartest inventory management system on the market.

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 Sheet. It saves time and boosts work efficiency. This is the best WooCommerce bulk edit plugin on the market. :chart_with_upwards_trend:

Loved by WordPress professionals! 🤩

👁️ View Demo | 🚀 Get The ULTIMATE Version

🔝 Features of Stock Sync for WooCommerce with Google Sheet:

  • Two-directional auto-sync: The stock sync plugin automatically syncs product stock and other information (name, SKU, details) in a two-directional way. You update your sheet, and the site dashboard gets auto-updated. Also, if you update details on the site dashboard, your Google Sheet gets an automatic update. WooCommerce Stock management is getting simpler. :muscle:

  • Update almost everything: Easily update all your stock data from the connected Google Sheet; they’ll be updated instantly on your WordPress site dashboard. You can edit product names, details, pricing, on-sale updates, product type, stock status, etc., in one go. Take the WooCommerce bulk edit to the next level with this inventory manager.

  • Export products: Get all your store product details in one place in an organized way with this stock manager. All you need to do is activate and configure the plugin. You will find a gorgeous and organized spreadsheet, pre-formatted for your convenience.

  • 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.

  • 1-click manual sync from WooCommerce: Sync your WooCommerce products with a single click of the manual sync button. This button can be super handy for situations where you’ve made some unwanted changes on the spreadsheet.

  • Manual sync from Google Sheets: Once you configure the plugin, you’ll find two new options on the spreadsheet: „Fetch from WooCommerce“ and „Sync on WooCommerce.“ Although every change on the spreadsheet reflects instantly on WordPress, you can use these buttons when 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.

👁️ View Demo | 🚀 Get The ULTIMATE Version

💪 ||Get ULTIMATE|| 😎

  • Sync unlimited products: Enjoy amazing features for unlimited products with the ULTIMATE version of the plugin. The free version allows store product sync with Google Sheets for up to 20 products. Get unlimited product sync with Google Sheets with the ULTIMATE version of the plugin. Enjoy the flexibility of the unique inventory management system for your WooCommerce store. :partying_face:

  • Add new products from Google Sheet: 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.

  • Display and edit short description: Find useful product info within Google Sheets. This option allows you to view and edit product descriptions from Google Sheets. Like other data, it will auto-sync on WooCommerce.

  • 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.

  • 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: Enable this feature to view product categories 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.

Skjámyndir

SOS

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

If your store product is more than 20 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.

Umsagnir

13. ágúst, 2023
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. janúar, 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.
5. júní, 2022 3 replies
Tried it out and works really good! We're using WPML in multilingual shop, and our products are translated. This means all products show up in the table multiple times. It would be great if this would work with the SKU's so we only need to change this in the sheet once. Although it really syncs very fast between all languages (stocks update in Woocommerce for all translations through the sku's) A negative comment on here was that it had nothinng to do with stock keeping, but I believe that was incorrect: it does work with stock numbers. On initial you do get In Stock or Out of stock, but when you change the numbers in your sheet this updates on Woocommerce as well. haven't tested this thoroughly bjt this looks very promising. Would be great to hear if there is a way to sync the same Google sheet with multiple shops that would tick all the boxes for my use case. I'm giving it 4 stars because there's product names instead of SKU's in the columns of the sheet. SKU's would be a more logic to me.
10. apríl, 2022 1 reply
I've been looking for something like this for a while. Very easy step-by-step set up instructions. Changes sync instantly unlike some other tools I've looked at. Free version very limited due to number of products, so looking forward to the pro version release.
Skoða 4 umsagnir

Þátttakendur & höfundar

“Stock Sync for WooCommerce with Google Sheet – Easy Stock Management and Inventory Management System for WooCommerce” er opinn hugbúnaður. Eftirfarandi aðilar hafa lagt sitt af mörkum við smíði þessarar viðbótar.

Höfundar

Breytingarsaga

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