=== FlexStock - Product Stock Sync with Google Sheets for WooCommerce ===
Contributors: wppool, iamjafran, mahfuz01, naeemkhan25, farhanmullick
Tags: stock management, bulk editor, inventory manager, woocommerce stock management, woocommerce inventory management
Requires at least: 5.4
Tested up to: 6.9
Requires PHP: 5.6
Stable tag: 3.15.8
License: GPLv2 or later
License URI: http://www.gnu.org/licenses/gpl-2.0.html

WooCommerce inventory and stock management plugin with real-time Google Sheets sync. Track, manage, and bulk edit products instantly.

== Description ==

**🔥 Product Stock Sync, Bulk Edit Products, Price, SKU, Categories, Images & Create New Products in WooCommerce from Google Sheets in a two-way sync**

**[FlexStock - WooCommerce Stock Sync with Google Sheet](https://wppool.dev/stock-sync-with-google-sheet-for-woocommerce/)** lets you manage your entire store inventory directly from Google Sheets - in real-time, both ways.

**No more logging into your dashboard** for every product update. FlexStock brings WooCommerce bulk editing, SKU syncing, image sync, variable product control, and more to your fingertips via Sheets.

👉 FlexStock provides a complete inventory management system that enables **bidirectional sync between WooCommerce and Google Sheets**.

**Recommended by WordPress Professionals!**

https://youtu.be/BKuQQMIf4-o

👁️ [View Demo](https://lnk.wppool.dev/v9XuVSI) | 🚀 [Get ULTIMATE](https://lnk.wppool.dev/Y2sgfXQ) | 🤝 [Join Our Facebook Community](https://lnk.wppool.dev/b7mMOHs)

Whether you run a simple store or a high-volume multi vendor marketplace, FlexStock is your inventory control command center. Experience a **reliable and efficient online store inventory manager** for WordPress.  

**Let’s grow, connect, and thrive together**

* **🤝 Join Our [Facebook Community](https://lnk.wppool.dev/b7mMOHs)**
* **🌐 Follow Us on [X (Twitter)](https://x.com/wppool_)**
* **🎥 Subscribe on [YouTube](https://www.youtube.com/@WPPOOL)**
* **👍 Like Our [Facebook Page](https://www.facebook.com/wppool.dev)**

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 G-Sheets is easier than entering your site dashboard repeatedly for each product.

Our stock manager plugin is two-directionally synchronized. You update the sheet and the data auto-syncs on the site dashboard. Or update the site dashboard and the data auto-syncs on the G-Sheets. It saves your time and boosts work efficiency. This is an **effective Commerce Console bulk edit plugin** for WooCommerce. 📈

👁️ [View Demo](https://lnk.wppool.dev/v9XuVSI) | 🚀 [Get ULTIMATE](https://lnk.wppool.dev/Y2sgfXQ) | 🤝 [Join Our Facebook Community](https://lnk.wppool.dev/b7mMOHs)

== 🔥 Bulk Edit WooCommerce Products ==

Create and quickly edit eCommerce 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. Try Stock Sync for WooCommerce with G-Sheets now. 

**Synced Product Data:**

FlexStock supports syncing a wide range of WooCommerce data directly with Google Sheets.

**✅ Core Product Fields**

- Product Name  
- Stock Quantity  
- Regular Price  
- Sale Price  
- Product Type  
- Stock Status  
- Product Status (Published, Draft, Pending, Trash)  
- SKU (Stock Keeping Unit)
- Product Visibility  
- Backorder Status  

**🔥Advanced Fields**

- Short Description  
- Long Description  
- Product Image  
- Product URL  
- Total Sales Count  
- Product Tags  
- Product Categories  
- Product Attributes  
- Custom Fields (ACF & WooCommerce metadata)  

**📦 Variation Product Support**

- Variation Name  
- Variation Stock  
- Variation Pricing  
- Variation SKU  
- Variation Attributes  
- Grouped Variation Rows  

== How It Works ==

FlexStock connects your WooCommerce store with Google Sheets using the Google Sheets API, so product sync and WooCommerce stock sync happen from one live spreadsheet.

1. **Set up Google credentials** - Start the setup wizard, create or connect a Google Cloud project, enable the Google Sheets API, and upload your service JSON file.
2. **Connect your Google Sheet** - Paste your Google Sheet URL and sheet tab name, then grant editor access to the generated service account email.
3. **Sync WooCommerce product data** - FlexStock syncs stock, price, SKU, status, images, and other supported product fields between Google Sheets and WooCommerce in both directions.

== 😍 FlexStock FREE Features  ==

* **Real-Time Auto Sync (WooCommerce → Google Sheets)**: Stop exporting data manually. FlexStock automatically syncs WooCommerce orders, product details, and stock updates to Google Sheets in real time, so your team always has accurate sales and inventory data they can access anytime.

* **Two-Directional Product Sync**: The Flex Stock 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 500 products. WP eCommerce Site Stock management is getting simpler. 💪

* **Edit Product Details**: Easily update your stock status from the connected live spreadsheet; 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 eCommerce bulk edit to the next level with this inventory manager.

* **Scheduled Auto Sync (WooCommerce → Google Sheets)**: Keep your Google Sheets data updated automatically. In the free version, FlexStock syncs WooCommerce data to Google Sheets every 10 minutes, making it easier to handle reporting, accounting, and sales monitoring without working with outdated data.

* **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 useful 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 formatted spreadsheet with all your products for your convenience (up to 500 products on the free version).

* **Variable Product Sync**: Get different rows for your store's variable products. Variable products won't confuse you anymore while making updates. Insert different data on the 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 eCommerce Dashboard 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.

* **WooCommerce Backorder Manager**: FlexStock's backorder management feature helps you to increase sales by enabling customers to place orders out of stock products.

* **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 connected sheet.

* **Product Status Sync:** You can seamlessly sync and manage product statuses (Published, Pending Review, Draft, Trash, Custom Statuses) bi-directionally between your platform and G-Sheets.

👁️ [View Demo](https://lnk.wppool.dev/v9XuVSI) | 🚀 [Get ULTIMATE](https://lnk.wppool.dev/Y2sgfXQ) | 🤝 [Join Our Facebook Community](https://lnk.wppool.dev/b7mMOHs)

== 🔥 FlexStock ULTIMATE Features ==

* **Unlimited Two-Directional Product Sync**: Keep all your store products synced between your store and live spreadsheets without any limit. The free version allows sync for up to 500 products. 

* **Advanced Scheduled Auto Sync Options**: Get more control over your sync timing. With FlexStock Ultimate, you can schedule WooCommerce and Google Sheets syncs every 30 minutes, hourly, daily, or weekly based on your workflow.

* **Unlimited Product Editing from Google Sheets**: Edit important product details (Name, Stock, Short Description, Price, SKU, Custom Fields) from the connected Google Sheets. Experience the full functionality of the inventory management system for your online store.

* **Unlimited New Product Addition from Google Sheets**: Add new products to your eCommerce store from the connected spreadsheet. They are added to your site dashboard automatically.

* **Expanded Sync Modes (Reverse + Bi-Directional)**: Sync data your way. Use Reverse Sync (Google Sheets → WooCommerce), One-Way Sync, or Bi-Directional Sync to match your store operations. This is especially useful for high-volume stores that need faster, more flexible inventory control.

* **Unlimited WooCommerce Bulk Editing and Bulk Product Addition**: Edit product details in bulk and create new products without limits. An extensive inventory management tool to manage your business efficiently 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 connected 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 digital store product SKU from Google Sheets.

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

* **Sync Google Sheets Formulas**: If you use formulas to organize data on your spreadsheet, this feature will be extremely helpful. Your formulas will work perfectly and be synced with WooCommerce.

* **Multiple Sheet Formula**: FlexStock supports formulas across multiple spreadsheets, making it easier to connect data between sheets and manage more advanced workflows in Google Sheets.

* **Sync Product Long Description**: In WooCommerce, long descriptions are displayed inside the “Description” tab. With long description sync, you can view and manage your descriptions from Sheets.

* **View Product URL**: Keep track of all product URLs from the connected spreadsheet. Easily view and navigate to your desired store products from anywhere.

* **Display Total Sales Count**: Storefront inventory control is simple with total sales data visible in your sheet. Take smart decisions from the total sales column within the Sheets.

* **Sync Product Category**: Sync and edit or bulk edit product categories on the connected spreadsheet to easily categorize your products.

* **Sync Product Attributes**: Sync and edit or bulk edit view product attributes on the connected spreadsheet.

* **Separated Attributes**: Product attributes are placed into separate columns in Google Sheets, so you can view, manage, and edit each attribute more easily.

* **Attribute Terms Creation** Create product attribute terms directly from Google Sheets, so you can add and manage attributes faster without going back to WooCommerce.

* **Enhanced Filtering:** Now, you can customize your Google Sheets view to display only the products that match your selected status (Published, Pending Review, Draft, Trash, Custom Statuses).

* **Integration with ATUM WooCommerce Inventory Management**: Through integration with the ATUM inventory management plugin, you can also sync custom ATUM fields created with that plugin.

* ** Display Shop/Vendor Name**: Show each product’s shop or vendor name in a dedicated column for clearer visibility and better organization in multi-vendor stores.

**🔥🔥🔥 ADDONS 🔥🔥🔥**

**💪 Multi-Vendor Sync for FlexStock**
Take control of your WooCommerce marketplace with vendor-specific Google Sheets and real-time sync. **[Start Managing Vendors Smarter!](https://wppool.dev/flexstock/addons/multivendor-for-flexstock/)**

- 📦 **Full Product Management via Sheets**  
  Vendors can manage categories, attributes, images, and inventory - all directly from their Google Sheet. No need to access the WordPress dashboard. 

- 🧑‍💼 **Vendor-Specific Google Sheets**  
  Each vendor gets their own private Google Sheet to manage only their products - with no access to others’ data.

- 🔁 **Real-Time Two-Way Sync**  
  Any changes made in a vendor’s sheet (like stock, price, name, SKU, etc) are instantly synced with your WooCommerce store - and vice versa. Edits from WooCommerce (by vendor or admin) reflect back to the sheet in real-time.

- ➕ **Create Products from Sheets**  
  Vendors can add new products just by filling out rows in their sheet - products are automatically created in the store.

- ⚡ **One-Click Sheet Setup**  
  Vendors can link their Google Sheet in a single click from their vendor dashboard - fast, easy, and secure.

- 🧩 **Built for Any Marketplace**  
  Whether you have 5 vendors or 500, the system runs smoothly with full data separation. No more messy or shared spreadsheets. Fully compatible with top multivendor plugins like **WCFM**, **Dokan**, **WC Vendors (upcoming)**, and more.


== 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:

https://youtu.be/9KJCbed6N8U

== 🔥 More Awesome Plugins ==
If you like FlexStock, then consider checking out our other awesome projects:

* 🛒 **[Manage Order with Google Sheets](https://wordpress.org/plugins/order-sync-with-google-sheets-for-woocommerce/)**: 
Try FlexOrder - Bulk Order Sync with Google Sheet for WooCommerce | Manage WooCommerce orders from Google Sheets. WooCommerce order sync, e-commerce order management, and sales order management with Google Sheets. Try Flex Order now!

* 🟢 **[Google Sheets to WP Table](https://wordpress.org/plugins/sheets-to-wp-table-live-sync/)**: 
Try FlexTable - 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. Try Flex Table now!

* 🎁 **[Boost Sales with a Smart Referral System](https://wordpress.org/plugins/echo-rewards/)**: 
Try EchoRewards | With Echo Reward, you can refer a friend for WooCommerce to launch your customer referral program. Echo Rewards Referral Plugin is a WooCommerce referral plugin to boost your sales. Generate coupons, reward customers, and launch the ideal refer-a-friend program for your store.

* 🌓 **[WP Dark Mode](https://wordpress.org/plugins/wp-dark-mode/)**: 
Use WP Dark Mode plugin to create a stunning dark version for your WordPress website. WP Dark Mode works automatically without going into any complicated settings.

* 💬 **[Form to Chat](https://wordpress.org/plugins/social-contact-form/)**: 
Try FormyChat | Connect Form to Chat Apps with Contact Form 7, WPForms, Gravity Form | Welcome Popup & Multi-agent Live Chat

== Privacy Policy ==
Flex Stock uses [Appsero](https://appsero.com) 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](https://appsero.com/privacy-policy/).

== Frequently Asked Questions ==

= Why can't I sync my store all my products with Google Sheet?
If your store product is more than 500 then you'll need to upgrade to the [ULTIMATE version](https://go.wppool.dev/Kr7y) to sync all your store product.

= What to do with the variable products of my store?
FlexStock 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 bulk edit WooCommerce products with Google Sheets? = 
Yes. FlexStock lets you bulk edit WooCommerce products from Google Sheets.

= Can I add any product from the Google Sheet?
Yes. With FlexStock 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 G-Sheets and it will be live synced with your online store.

= Can I manage product categories with the plugin?
Yes. By enabling this feature, the plugin will automatically sync product categories with your existing categories.

= Can I manage product attributes with the plugin?
Yes. When this feature is enabled, the plugin will automatically sync product attributes with your existing ones.

= Does FlexStock support product quick edit from Google Sheets? =
Yes. FlexStock works like a spreadsheet-based product quick edit system for WooCommerce, so you can update multiple product fields faster without opening each product manually.

= How can I add the newly added product to the Google Sheet?
Newly added products are supposed to Sync with Connected 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'.

= Is any technical setup required to use this tool?
Nope. No coding knowledge is required for using this plugin.


== Changelog ==

= 3.15.8 – 09 April, 2026 =
- **New:** Added bidirectional sync support for WooCommerce **product brands**.
- **New:** Added bidirectional sync for **Upsells** and **Cross-sells**.
- **New:** Added bidirectional sync support for **Custom Badge**.
- **New:** Added a **Book a Call** CTA to the setup wizard.
- **New:** Added full bidirectional sync support for **Image ALT Text**.
- **Improved:** Related columns now appear in Google Sheets only when the feature is enabled.
- **Improved:** Numeric values now keep their original formatting instead of forcing `.00` decimals.

= 3.15.7 – 25 January, 2026 =
- **New:** Automatically pause live Google Sheet sync during WooCommerce default or bulk imports to improve performance.
- **New:** Added batch sync functionality that triggers after the import process completes.
- **Performance:** Optimized import speed by reducing real-time Google API calls for each product.

= 3.15.6 – 12 January, 2026 =
- **New:** Separated attributes in Google Sheet columns.
- **New:** Added feature to create attribute terms from Google Sheet.
- **Fix:** Fixed meta fields sync issue when key contains hyphens (e.g., fields-test-mode).
- **Fix:** Fixed Google Sheet header color format issue if the column is more than 26.
- **Fix:** Fixed date format mismatch issue in Google Sheet for meta fields.

= 3.15.5 – 14 December, 2025 =
- **Improvement:** Product Sync limit (WordPress to Google Sheet) increased from 100 to 500 for enhanced large-scale data synchronization reliability.

= 3.15.4 – 9 December, 2025 =
- **New:** Implemented support for advanced formula features.
- **New:** Added comprehensive hooks and compatibility functions for multi-store plugin support.
- **Compatibility:** Achieved full compatibility with WordPress 6.9.

= 3.15.3 – 24 Nov, 2025 =
- **Enhancement:** Regular update & maintenance release

= 3.15.2 – 12 Nov, 2025 =
 - **Fix:** Removed the unwanted/obsolete setting page that was mistakenly left over from a previous version.


= 3.15.1 – 9 Nov, 2025 =
 - **New:** Added Shop/Vendor name display across product listings for better clarity in multivendor environments.
 - **New:** Added deep linking support for better navigation and shareability.
 - **Improvement:** Filter Feature: Completely redesigned filter feature with improved user experience and intuitive workflow.
 - **Improvement:** Product Sync Performance: Enhanced product synchronization performance when updating products from the WordPress site to the sheet.
 - **Improvement:** Info Tips: Updated and improved all tooltips and information tips for better user guidance.
 - **Fix:** Google Listings & Ads Compatibility: Fixed conflicts with "Google Listings & Ads" plugin for seamless integration.
 - **Fix:** Sale Price Validation: Added validation to prevent sale prices higher than regular prices. Users now receive the message: "Sales Price cannot be higher than Regular Price."
 - **Fix:** Variation Filters: Resolved issue where sheet filters were not working correctly for product variations.
 - **Fix:** Variation Sales Display: Fixed "Number of Sales" not displaying for product variations on Google Sheet.
 - **Fix:** Null Sale Price: Resolved issue where null sale price values were not updating correctly when saved.
 - **Fix:** License Page URL: Updated License page URL in plugin notices.

= 3.15.0 – 3 Nov, 2025 =
- **New:** Introduced **Sync Settings** - you can now choose between **Real-Time Live Sync** and **Scheduled Auto Sync**.  
- **New:** Added **Sync Direction** control with **Bidirectional**, **WooCommerce → Sheets**, and **Sheets → WooCommerce** options.  
- **New:** Added **Scheduled Sync Frequency** to set custom intervals (every 10 mins, hourly, daily, weekly).  
- **Fix:** Resolved an issue where **SKU values** were being incorrectly converted into date formats during sync.  

= 3.14.8 – 28 September, 2025 =
- **New:** Added periodic sync functionality to enable automated synchronization between WooCommerce and Google Sheets at regular intervals.
- **Fix:** Resolved SKU field value conversion issue where date values were being incorrectly converted and returned to the sheet. SKU values now maintain their original format during sync operations.

= 3.14.7 – 15 September, 2025 =
- **Improvement:** Implemented real-time product synchronization to the external product sheet. All product updates in WooCommerce now sync instantly using a live hook, replacing the previous cron-based method.

= 3.14.6 – 02 September, 2025 =
- **New:** Added global date format support for meta fields, ensuring consistent formatting across all integrations and data outputs.
- **Fix:** Corrected an issue where the regular price was being auto-removed when updating the sale price. Now both values remain intact as expected.
- **Fix:** Improved API request handling by switching from wp_remote_post to direct REST API requests, preventing server-side API request blocking issues and ensuring more reliable communication.

**For older changelog entries, please see the [additional changelog.txt file](https://plugins.svn.wordpress.org/stock-sync-with-google-sheet-for-woocommerce/trunk/changelog.txt) delivered with the plugin.**
