Title: Sync Master Sheet – Product Sync with Google Sheet for WooCommerce Author: Saiful Islam Published: March 4, 2024 Last modified: May 20, 2026 --- Search plugins ![](https://ps.w.org/product-sync-master-sheet/assets/banner-772x250.png?rev=3530944) ![](https://ps.w.org/product-sync-master-sheet/assets/icon-256x256.gif?rev=3530944) # Sync Master Sheet – Product Sync with Google Sheet for WooCommerce By [Saiful Islam](https://profiles.wordpress.org/codersaiful/) [Download](https://downloads.wordpress.org/plugin/product-sync-master-sheet.2.0.4.zip) * [Details](https://sa.wordpress.org/plugins/product-sync-master-sheet/#description) * [Reviews](https://sa.wordpress.org/plugins/product-sync-master-sheet/#reviews) * [Installation](https://sa.wordpress.org/plugins/product-sync-master-sheet/#installation) * [Development](https://sa.wordpress.org/plugins/product-sync-master-sheet/#developers) [Support](https://wordpress.org/support/plugin/product-sync-master-sheet/) ## Description [Features](https://codeastrology.com/sync-master-sheet/) | [Get Premium](https://codeastrology.com/sync-master-sheet/pricing/) | [Documentation](https://codeastrology.com/docs/plugin/product-sync-master-sheet/) Easily manage and synchronize your WooCommerce product stock with the power of Google Sheets using our plugin – Product Stock Sync with Google Sheet for WooCommerce. This intuitive solution empowers you to streamline your inventory management effortlessly. **Features:** * ✅ **Two-Way Product Synchronize** with **Google Sheets** * ✅ ** Edit Product Details** directly from Google Sheets, including Name/Title, Price, Regular Price, SKU, and Custom Fields * ✅ **Add Unlimited New Products** from Google Sheets * ✅ **Bulk Edit Products** using Google Sheets * ✅ **Manage WooCommerce Custom Fields** (Meta Data) with seamless sync * ✅ **Integration with Secure Custom Fields** Columns (previously known as ACF Plugin) * ✅ **Update Product Status** easily via Google Sheets * ✅ **Quick Edit Options** available directly in the plugin settings (including Table Title) * ✅ **Show/Hide Columns** in Google Sheets for a customized view * ✅ **Export Unlimited Products** to Google Sheets * ✅ **Full Support for Variable Products** in Google Sheets * ✅ **Filter by Category** (multiple filters supported) in Google Sheets * ✅ **Column Sorting** for better data management in Google Sheets * ✅ **Display Product** URLs in Google Sheets * ✅ **View Product Edit Links** directly from Google Sheets * ✅ **Auto Content Wrap** support for better readability * ✅ **Short Description** support for quick product overview* ✅ **Full Description** support for detailed product information * ✅ **Show Product Images** support for better visual identification * 🔥🔥🔥 **Stock Synchronize for Multiple Sites** from a single Google Sheet using SKU * and Many more features available. **Key Features:** * **Google Sheet Integration:** Seamlessly connect your WooCommerce store with Google Sheets via the Google Sheets API. * **Effortless Updates:** Update product stock levels directly from your Google Sheet, ensuring accurate and real-time inventory information on your WooCommerce store. * **Simplified Stock Management:** Take control of your stock effortlessly within the familiar and user-friendly Google Sheets interface. * **Automation:** Say goodbye to manual updates! Our plugin automates the synchronization process, saving you time and reducing the risk of errors. **How It Works:** * **Connect:** Establish a secure connection between your WooCommerce store and Google Sheets using the Google Sheets API. * **Update:** Effortlessly update product stock levels, prices, and other details directly from your Google Sheet. * **Real-time Sync:** Enjoy real-time synchronization between your WooCommerce store and Google Sheets, ensuring your inventory is always up-to-date. **Why Choose Product Stock Sync** * **Time-Saving:** Streamline your workflow with automated stock updates, freeing up time for more strategic business activities. * **Accuracy:** Eliminate discrepancies and maintain accurate stock levels across your WooCommerce store and Google Sheets. * **User-Friendly:** No technical expertise required! Our plugin is designed for easy setup and hassle-free stock management. **Getting Started: Setting Up Google Sheet API Connection** Ensure a smooth setup process by following these steps to connect your WooCommerce store with Google Sheets using our plugin. Please follow, following steps: * [Tutorial – Setup Guideline](https://codeastrology.com/how-to-setup-product-sync-master-plugin/)– Checkout and follow step by step guideline. How to configure with Google Sheet– explained here. * [Link Google Sheet](https://docs.google.com/spreadsheets/) – Create new spreadsheet or use existing. In the plugin settings, find the section to link your Google Sheet. Provide the required Google Sheet URL and configure additional settings as needed. * [Create Google Project](https://console.cloud.google.com/projectcreate?previousPage=/apis/credentials)– Navigate to the “APIs & Services” and select “Dashboard”. Click on “+ CREATE PROJECT” and fill in the necessary details. * [Credentials to make a Service JSON](https://console.cloud.google.com/apis/credentials)– Still in the “APIs & Services” section, navigate to “Credentials”. Click on “ Create Credentials” and choose “Service Account Key”. Create a new service account, download the JSON key file, and keep it secure. * [Enable Sheet API](https://console.cloud.google.com/apis/library/sheets.googleapis.com)– In your project dashboard, go to “APIs & Services” > “Library”. Search for “Google Sheets API” and enable it for your project. * [Check Enable Sheet API](https://console.cloud.google.com/apis/api/sheets.googleapis.com/metrics)– Checkout existing API which enabled or not. * **Authentication** – For generate access tocken, we have sent request to https:// oauth2.googleapis.com/token. * **WooCommerce required** – Ensure that, [WooCommerce](https://wordpress.org/plugins/woocommerce/) is already installed. Then install this plugin. Take control of your WooCommerce inventory like never before with _Product Stock Sync with Google Sheet for WooCommerce_. Experience seamless integration and efficient stock management today! **Credits** We believe in giving credit where it’s due. Our plugin utilizes the following third- party resources to enhance its functionality: * Fontello Icons: We express our gratitude to [Fontello](https://github.com/fontello/fontello#developers-api) for providing the icon font used in our plugin’s user interface. Beautiful and customizable icons make the user experience more visually appealing. * Google Sheet API: A big thank you to the [Google Sheets API](https://developers.google.com/sheets/api/reference/rest) for enabling seamless integration between our plugin and Google Sheets. This API plays a pivotal role in automating the synchronization of product data. * WooCommerce: Our plugin is built upon the robust foundation of [WooCommerce](https://wordpress.org/plugins/woocommerce/), empowering online businesses with a feature-rich and flexible e-commerce solution for WordPress. * [WordPress](https://wordpress.org/): We are indebted to the WordPress platform for providing the framework that powers our plugin. Its open-source nature and extensive community support make it an ideal environment for creating powerful and customizable solutions. These entities have significantly contributed to the functionality, aesthetics, and overall success of our plugin. We are proud to acknowledge and appreciate their role in making our plugin a reality. **Important Links** * [Tutorial for Sheet Details](https://codeastrology.com/how-to-setup-product-sync-master-plugin/#sheet-details-here) * [How to create JSON file and API key](https://codeastrology.com/how-to-setup-product-sync-master-plugin/#service-key-api-help-section) * [Google Sheets API Connector Overview](https://cloud.google.com/workflows/docs/reference/googleapis/sheets/Overview) * [Sheet API Method: values.batchUpdate](https://cloud.google.com/workflows/docs/reference/googleapis/sheets/v4/spreadsheets.values/batchUpdate) * [Sheet API Method: spreadsheets.values.clear](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/clear) **Used Request in Code** * Token Gen: `$token_url = 'https://oauth2.googleapis.com/token';` * Scope: `['scope' => 'https://www.googleapis.com/auth/spreadsheets']` * Insert Data in Sheet: `$api_url = "https://sheets.googleapis.com/v4/spreadsheets/ $spreadsheet_id/values/$sheet_name!$range?valueInputOption=RAW&key=$API_KEY";` * Update Sheet: `$api_url = "https://sheets.googleapis.com/v4/spreadsheets/$spreadsheet_id/ values:batchUpdate?valueInputOption=RAW&key=$API_KEY"` * Clear Sheet: `$api_url = "https://sheets.googleapis.com/v4/spreadsheets/$spreadsheet_id/ values/$sheet_name:clear?key=$API_KEY"` ### Privacy Policy Product Sync Master Sheet for WooCommerce 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/). ## Screenshots * [[ * Setting * [[ * Connection of Google Sheet * [[ * [[ * [[ * [[ * [[ * [[ * [[ * [[ * [[ * [[ * [[ * [[ * [[ * [[ * [[ * [[ * [[ * [[ * [[ * [[ * [[ * [[ ## Installation 1. Upload ‘product-sync-master-sheet’ to the ‘/wp-content/plugins/’ directory 2. Activate the plugin through the ‘Plugins’ menu in WordPress 3. Connect with Google Sheet by API Key and service json file ## FAQ ### Menu Location 🔅 Dashboard -> Product Sync with Google Sheet ### Where is Bulk edit of Product? 🔅 Dashboard -> Product Sync with Google Sheet -> Product Quick Edit ### What type of product’s stock will sync with Google Sheet? 🔅 It’s will sync with all type product with google sheet. Such: simple, variable, variation,grouped etc ## Reviews ![](https://secure.gravatar.com/avatar/4497f4c2b361cb61e36c89d4c24730924680037f633c10b4559dcc88143e5ac5? s=60&d=retro&r=g) ### 󠀁[nice](https://wordpress.org/support/topic/nice-4954/)󠁿 [Rahul](https://profiles.wordpress.org/rahul3dartist/) August 31, 2025 Good support and help… ![](https://secure.gravatar.com/avatar/8ae3bed8b2b86569c6bf0153c028b3bcd62ada72111d90b9e831f83dbece65f1? s=60&d=retro&r=g) ### 󠀁[Fast support](https://wordpress.org/support/topic/fast-support-226/)󠁿 [tnnpco](https://profiles.wordpress.org/tnnpco/) January 20, 2025 1 reply Fast support ![](https://secure.gravatar.com/avatar/0b254e8eb98f52ea03bbb1a8f0286c9fa4164e39f0e390f6403cd0b8cfe5544a? s=60&d=retro&r=g) ### 󠀁[Works great, support outstanding](https://wordpress.org/support/topic/works-great-support-outstanding/)󠁿 [roman123234](https://profiles.wordpress.org/roman123234/) May 13, 2025 1 reply This plugin is a huge timesaver! It’s very logical and if something is unclear the support is there to help. ![](https://secure.gravatar.com/avatar/b3e666888678cf7e1ec5d0bc59ccf485c6bd23efd0fc57a03adbd687de751f0b? s=60&d=retro&r=g) ### 󠀁[One of the best plugin for Bulk & Easy price update](https://wordpress.org/support/topic/one-of-the-best-plugin-for-bulk-easy-price-update/)󠁿 [shafranlive](https://profiles.wordpress.org/shafranlive/) June 26, 2024 1 reply I searched & tried lots of plugins earlier, but this one is the best & easiest to sync product prices quickly without logging into the WordPress admin via Google Sheets. It’s easy for shop managers with basic knowledge to update prices. Recommended for Everyone. ![](https://secure.gravatar.com/avatar/6c08362ee74edde0a4eab01581d80e637563d07cc9d8dafb6192e439a7bbb36a? s=60&d=retro&r=g) ### 󠀁[Brilliant Support](https://wordpress.org/support/topic/brilliant-support-91/)󠁿 [webxhut](https://profiles.wordpress.org/webxhut/) June 6, 2024 Had a problem with conflict of plugins was rectified immedialty, many thanks to Sarmin ![](https://secure.gravatar.com/avatar/d8639c1bfe459c453ffffe8d65da00b0497d2e9fe9f61e6c44efe5a24c13844e? s=60&d=retro&r=g) ### 󠀁[The best WooCommerce sync plugin out there!](https://wordpress.org/support/topic/the-best-woocommerce-sync-plugin-out-there/)󠁿 [Al Kawsar Majumder](https://profiles.wordpress.org/kawsar11/) April 21, 2024 It’s super fast and handles large amounts of data with ease, syncing seamlessly with my store through Google Sheets. The best WooCommerce sync plugin out there! [ Read all 7 reviews ](https://wordpress.org/support/plugin/product-sync-master-sheet/reviews/) ## Contributors & Developers “Sync Master Sheet – Product Sync with Google Sheet for WooCommerce” is open source software. The following people have contributed to this plugin. Contributors * [ Saiful Islam ](https://profiles.wordpress.org/codersaiful/) * [ CodeAstrology IT Firm ](https://profiles.wordpress.org/codeastrology/) * [ Bizzplugin ](https://profiles.wordpress.org/bizzplugin/) [Translate “Sync Master Sheet – Product Sync with Google Sheet for WooCommerce” into your language.](https://translate.wordpress.org/projects/wp-plugins/product-sync-master-sheet) ### Interested in development? [Browse the code](https://plugins.trac.wordpress.org/browser/product-sync-master-sheet/), check out the [SVN repository](https://plugins.svn.wordpress.org/product-sync-master-sheet/), or subscribe to the [development log](https://plugins.trac.wordpress.org/log/product-sync-master-sheet/) by [RSS](https://plugins.trac.wordpress.org/log/product-sync-master-sheet/?limit=100&mode=stop_on_copy&format=rss). ## Changelog #### 2.0.3 & 2.0.4 * Added: New action hook(pssg_reset_column_order) added for reset column order to default * Fixed: Column order reset issue fixed. * Tested with latest WordPress 7.0 * Tested with WooCommerce latest #### 2.0.2 * Added: Sheet Style/color/formatting options for better visualization for Google Sheets using batchUpdate API. * Added: batchUpdate API method for better performance. * Added: Different color formatting options for better visualization for Google Sheets using batchUpdate API. * Added: Clear Sheet API method for better performance. * Added: No of Sales column added in Google Sheet for better understanding of sales performance. * Fixed: Google Sheets column letter range issue. * Tested with latest WordPress 6.9 * Tested with WooCommerce latest * Code more optimized * Bug Fixed #### 2.0.1 * Tested with latest WordPress 6.9 * Tested with WooCommerce latest * Added: Save and Synchronize button added in settings page for quick sync with Google Sheet after change settings. * Added: Reset settings button added in settings page to reset all settings to default. * Added: Schedule Sync with Google Sheet * Added: Thumbnail image support for synced products. * Added: Short description field to synced product. * Added: Full description field for synced products. * Added: Content wrapping support * Updated: AppsScript code updated for better performance and new features. * Code more optimized * Bug Fixed #### 2.0.0 * Added: New feature – Sync Master Sheet for Multiple Sites from a single Google Sheet using SKU * New: Tested with WooCommerce latest * Tested with latest WordPress 6.9 * Code more optimized * Vendor removed. * Bug Fixed #### 1.1.4 * Added: Security improvement in AppsScript code. * Added: AppsScript code copy button added in security page. * Added: AppsScript code updated for better performance. * Added: API Log page added for debug purpose. * Added: New action hook(pssg_api_log) added. * New: Tested with WooCommerce 7.9 * Tested with latest WordPress 6.9 * Code more optimized * Bug Fixed #### 1.1.3 * Code more optimized * Bug Fixed #### 1.1.2 * Tested with latest WordPress 6.8 * Code more optimized * Bug Fixed #### 1.1.1 * Code more optimized * Bug Fixed #### 1.1.0 * Prie update issue from Quick Edit and Google Sheet has been fixed. * Code more optimized * Bug Fixed #### 1.0.9 * Checked at latest version of WooCommerce * Checked at latest version of WordPress * Faster Sync time * Code more optimized * Bug Fixed #### 1.0.8 * Faster load time * Faster Sync time * Added: Added Post URL, Edit URL, Post Status in premium version * Fixed: Speed optimized for Sync with Google * Fixed: Quick Table issue fixed. * Fixed: edit from Quick Table issue fixed. * Code more optimized * Bug Fixed #### 1.0.7 * Added: new action hook(pssg_loaded) added. * Optimization of code * Bug Fixed #### 1.0.6 * Bug Fixed: AppsScript code copy issue fixed. * Optimization of code * Bug Fixed #### 1.0.5 * Bug Fixed: Variation name issue when 3 or more variation – not showing issue fixed. * Bug Fixed: preg_replace issue fixed from Quick/Bulk edit table * Bug Fixed #### 1.0.4 * Compatibility with Latest Google Sheet URL policy * Bug Fixed #### 1.0.3 * Compatibility with Latest WordPress * Compatibility with latest WooCommerce * Compatibility with Google Sheets API v4 * Speed optimize * Bug Fixed #### 1.0.2 * Setup wizard added, where user will able to setup the plugin with Google sheet. * Speed optimize * Bug Fixed #### 1.0.1 * Column setting issue saving issue has been solved. * Code Optimization done. #### 1.0.0 * Primary released. ## Meta * Version **2.0.4** * Last updated **2 weeks ago** * Active installations **400+** * WordPress version ** 4.0.0 or higher ** * Tested up to **7.0** * PHP version ** 7.2 or higher ** * Language * [English (US)](https://wordpress.org/plugins/product-sync-master-sheet/) * Tags * [bulk editor](https://sa.wordpress.org/plugins/tags/bulk-editor/)[stock management](https://sa.wordpress.org/plugins/tags/stock-management/) [woocommerce inventory management](https://sa.wordpress.org/plugins/tags/woocommerce-inventory-management/) [Woocommerce Stock Management](https://sa.wordpress.org/plugins/tags/woocommerce-stock-management/) [woocommerce-stock-sync](https://sa.wordpress.org/plugins/tags/woocommerce-stock-sync/) * [Advanced View](https://sa.wordpress.org/plugins/product-sync-master-sheet/advanced/) ## Ratings 5 out of 5 stars. * [ 7 5-star reviews ](https://wordpress.org/support/plugin/product-sync-master-sheet/reviews/?filter=5) * [ 0 4-star reviews ](https://wordpress.org/support/plugin/product-sync-master-sheet/reviews/?filter=4) * [ 0 3-star reviews ](https://wordpress.org/support/plugin/product-sync-master-sheet/reviews/?filter=3) * [ 0 2-star reviews ](https://wordpress.org/support/plugin/product-sync-master-sheet/reviews/?filter=2) * [ 0 1-star reviews ](https://wordpress.org/support/plugin/product-sync-master-sheet/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/product-sync-master-sheet/reviews/#new-post) [See all reviews](https://wordpress.org/support/plugin/product-sync-master-sheet/reviews/) ## Contributors * [ Saiful Islam ](https://profiles.wordpress.org/codersaiful/) * [ CodeAstrology IT Firm ](https://profiles.wordpress.org/codeastrology/) * [ Bizzplugin ](https://profiles.wordpress.org/bizzplugin/) ## Support Issues resolved in last two months: 0 out of 1 [View support forum](https://wordpress.org/support/plugin/product-sync-master-sheet/) ## Donate Would you like to support the advancement of this plugin? [ Donate to this plugin ](https://donate.stripe.com/4gw2bB2Pzdjd8mYfYZ)