🔥 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 Stock Sync for WooCommerce with Google Sheet, manage your WooCommerce stock in a snap and keep your sheet synced with your store. 🤠
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 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 most smart inventory management system on the market.
Our 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 your time and boosts work efficiency. 📈
🚀 It is a hard job to manage the store inventory as a store owner. For this, stock Sync for WooCommerce is a new thought. Sync stock with Google Sheet and keep an updated track record of all time managing a SpreadSheet is easier and organized. Save your time, boost up work efficiency. 🔥
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. 💪
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 name, details, pricing, on-sale updates, product type, stock status, etc., in one go.
Export products: Get all your store product details in one place in an organized way. 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: 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.
💪 ||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. 🥳
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 Sheet. Like other data, it will auto-sync on WooCommerce.
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.
Show product category (upcoming): Enable this feature to view product categories on the connected spreadsheet.
Show total sales count (upcoming): WooCommerce stock management has never been this easy. Take smart decisions from the total sales column within the Google Sheet.
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.
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.
It’s quite simple and easy. You’ll get directions in every step after activating the plugin. Check our tutorial.
Can I add any product from the Google Sheet?
Yes! With Stock Sync 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?
Click the sync button from your site dashboard. It’s as simple as that. Also, you can follow Google Sheets > Stock Sync > 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.
Whom do I contact for any kind of support?
For instant support, please reach us through contact.
Contributors & Developers
“Stock Sync for WooCommerce with Google Sheet – Easy Stock Management and Inventory Management System for WooCommerce” is open source software. The following people have contributed to this plugin.Contributors
Interested in development?
- Fixed: Fixed turning sale price forcefully zero
- Fixed: Fixed connecting custom Sheet Tab
- Added: Added SKU column
- Fixed: Fixed creating new products from Google Sheet
- 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
- Added: Loader if server is too busy.
- Updated: Setup wizard steps design
- Fixed: minor bugs
- Updated: Installation video link
- Updated: Links & Labels
- Updated: Plugin title
- Updated: readme.txt & readme.md
- Updated: App Script video documentation link.
- Updated: Video documentation link.
- Small bug fixes
- Updated: FluentApi
- Small bug fixes
- fixed: Despite not being connected to Google Sheet, the export button shows “%d products exported in google sheet”.
- Small bug fixes
- Update readme.txt
- Update readme.txt
- Introduced new UI
- Small bug fixes.
- Initial release