{"id":225308,"date":"2024-03-04T08:00:00","date_gmt":"2024-03-04T08:00:00","guid":{"rendered":"https:\/\/www.weixiaoduo.com\/plugins\/product-sync-master-sheet\/"},"modified":"2025-10-09T20:29:00","modified_gmt":"2025-10-09T20:29:00","slug":"product-sync-master-sheet","status":"publish","type":"post","link":"https:\/\/www.weixiaoduo.com\/plugins\/product-sync-master-sheet\/","title":{"rendered":"Sync Master Sheet \u2013 Product Sync with Google Sheet for WooCommerce"},"content":{"rendered":"<p><a href=\"https:\/\/codeastrology.com\/sync-master-sheet\/\" rel=\"nofollow ugc\">Features<\/a>  | <a href=\"https:\/\/codeastrology.com\/sync-master-sheet\/pricing\/\" rel=\"nofollow ugc\">Get Premium<\/a> | <a href=\"https:\/\/codeastrology.com\/docs\/plugin\/product-sync-master-sheet\/\" rel=\"nofollow ugc\">Documentation<\/a><\/p>\n<p>Easily manage and synchronize your WooCommerce product stock with the power of Google Sheets using our plugin \u2013 Product Stock Sync with Google Sheet for WooCommerce. This intuitive solution empowers you to streamline your inventory management effortlessly.<\/p>\n<p><iframe loading=\"lazy\" title=\"Sync Master Sheet \u2013 Product Sync with Google Sheet for WooCommerce\" width=\"750\" height=\"422\" src=\"https:\/\/www.youtube.com\/embed\/IVW_UseTK8k?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p><strong>Features:<\/strong><br \/>\n* \u2705 <strong>Two-Way Product Synchronize<\/strong> with <strong>Google Sheets<\/strong><br \/>\n* \u2705 <strong>Edit Product Details<\/strong> directly from Google Sheets, including Name\/Title, Price, Regular Price, SKU, and Custom Fields<br \/>\n* \u2705 <strong>Add Unlimited New Products<\/strong> from Google Sheets<br \/>\n* \u2705 <strong>Bulk Edit Products<\/strong> using Google Sheets<br \/>\n* \u2705 <strong>Manage WooCommerce Custom Fields<\/strong> (Meta Data) with seamless sync<br \/>\n* \u2705 <strong>Integration with Secure Custom Fields<\/strong> Columns (previously known as ACF Plugin)<br \/>\n* \u2705 <strong>Update Product Status<\/strong> easily via Google Sheets<br \/>\n* \u2705 <strong>Quick Edit Options<\/strong> available directly in the plugin settings (including Table Title)<br \/>\n* \u2705 <strong>Show\/Hide Columns<\/strong> in Google Sheets for a customized view<br \/>\n* \u2705 <strong>Export Unlimited Products<\/strong> to Google Sheets<br \/>\n* \u2705 <strong>Full Support for Variable Products<\/strong> in Google Sheets<br \/>\n* \u2705 <strong>Filter by Category<\/strong> (multiple filters supported) in Google Sheets<br \/>\n* \u2705 <strong>Column Sorting<\/strong> for better data management in Google Sheets<br \/>\n* \u2705 <strong>Display Product<\/strong> URLs in Google Sheets<br \/>\n* \u2705 <strong>View Product Edit Links<\/strong> directly from Google Sheets<br \/>\n* \ud83d\udd25\ud83d\udd25\ud83d\udd25 <strong>Stock Synchronize for Multiple Sites<\/strong> from a single Google Sheet using SKU<br \/>\n* and Many more features available.<\/p>\n<p><strong>Key Features:<\/strong><\/p>\n<ul>\n<li><strong>Google Sheet Integration:<\/strong> Seamlessly connect your WooCommerce store with Google Sheets via the Google Sheets API.<\/li>\n<li><strong>Effortless Updates:<\/strong> Update product stock levels directly from your Google Sheet, ensuring accurate and real-time inventory information on your WooCommerce store.<\/li>\n<li><strong>Simplified Stock Management:<\/strong> Take control of your stock effortlessly within the familiar and user-friendly Google Sheets interface.<\/li>\n<li><strong>Automation:<\/strong> Say goodbye to manual updates! Our plugin automates the synchronization process, saving you time and reducing the risk of errors.<\/li>\n<\/ul>\n<p><strong>How It Works:<\/strong><\/p>\n<ul>\n<li><strong>Connect:<\/strong> Establish a secure connection between your WooCommerce store and Google Sheets using the Google Sheets API.<\/li>\n<li><strong>Update:<\/strong> Effortlessly update product stock levels, prices, and other details directly from your Google Sheet.<\/li>\n<li><strong>Real-time Sync:<\/strong> Enjoy real-time synchronization between your WooCommerce store and Google Sheets, ensuring your inventory is always up-to-date.<\/li>\n<\/ul>\n<p><strong>Why Choose Product Stock Sync<\/strong><\/p>\n<ul>\n<li><strong>Time-Saving:<\/strong> Streamline your workflow with automated stock updates, freeing up time for more strategic business activities.<\/li>\n<li><strong>Accuracy:<\/strong> Eliminate discrepancies and maintain accurate stock levels across your WooCommerce store and Google Sheets.<\/li>\n<li><strong>User-Friendly:<\/strong> No technical expertise required! Our plugin is designed for easy setup and hassle-free stock management.<\/li>\n<\/ul>\n<p><strong>Getting Started: Setting Up Google Sheet API Connection<\/strong><\/p>\n<p>Ensure a smooth setup process by following these steps to connect your WooCommerce store with Google Sheets using our plugin.<br \/>\nPlease follow, following steps:<\/p>\n<ul>\n<li><a href=\"https:\/\/codeastrology.com\/how-to-setup-product-sync-master-plugin\/\" rel=\"nofollow ugc\">Tutorial \u2013 Setup Guideline<\/a> \u2013 Checkout and follow step by step guideline. How to configure with Google Sheet \u2013 explained here.<\/li>\n<li><a href=\"https:\/\/docs.google.com\/spreadsheets\/\" rel=\"nofollow ugc\">Link Google Sheet<\/a> \u2013 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.<\/li>\n<li><a href=\"https:\/\/console.cloud.google.com\/projectcreate?previousPage=\/apis\/credentials\" rel=\"nofollow ugc\">Create Google Project<\/a> \u2013 Navigate to the \u201cAPIs & Services\u201d and select \u201cDashboard\u201d. Click on \u201c+ CREATE PROJECT\u201d and fill in the necessary details. <\/li>\n<li><a href=\"https:\/\/console.cloud.google.com\/apis\/credentials\" rel=\"nofollow ugc\">Credentials to make a Service JSON<\/a> \u2013 Still in the \u201cAPIs & Services\u201d section, navigate to \u201cCredentials\u201d. Click on \u201cCreate Credentials\u201d and choose \u201cService Account Key\u201d. Create a new service account, download the JSON key file, and keep it secure.<\/li>\n<li><a href=\"https:\/\/console.cloud.google.com\/apis\/library\/sheets.googleapis.com\" rel=\"nofollow ugc\">Enable Sheet API<\/a> \u2013 In your project dashboard, go to \u201cAPIs & Services\u201d > \u201cLibrary\u201d. Search for \u201cGoogle Sheets API\u201d and enable it for your project.<\/li>\n<li><a href=\"https:\/\/console.cloud.google.com\/apis\/api\/sheets.googleapis.com\/metrics\" rel=\"nofollow ugc\">Check Enable Sheet API<\/a> \u2013 Checkout existing API which enabled or not.<\/li>\n<li><strong>Authentication<\/strong> \u2013 For generate access tocken, we have sent request to https:\/\/oauth2.googleapis.com\/token.<\/li>\n<li><strong>WooCommerce required<\/strong> \u2013 Ensure that, <a href=\"https:\/\/wordpress.org\/plugins\/woocommerce\/\" rel=\"ugc\">WooCommerce<\/a> is already installed. Then install this plugin.<\/li>\n<\/ul>\n<p>Take control of your WooCommerce inventory like never before with <em>Product Stock Sync with Google Sheet for WooCommerce<\/em>. Experience seamless integration and efficient stock management today!<\/p>\n<p><strong>Credits<\/strong><\/p>\n<p>We believe in giving credit where it\u2019s due. Our plugin utilizes the following third-party resources to enhance its functionality:<\/p>\n<ul>\n<li>Fontello Icons: We express our gratitude to <a href=\"https:\/\/github.com\/fontello\/fontello#developers-api\" rel=\"nofollow ugc\">Fontello<\/a> for providing the icon font used in our plugin\u2019s user interface. Beautiful and customizable icons make the user experience more visually appealing.<\/li>\n<li>Google Sheet API: A big thank you to the <a href=\"https:\/\/developers.google.com\/sheets\/api\/reference\/rest\" rel=\"nofollow ugc\">Google Sheets API<\/a> for enabling seamless integration between our plugin and Google Sheets. This API plays a pivotal role in automating the synchronization of product data.<\/li>\n<li>WooCommerce: Our plugin is built upon the robust foundation of <a href=\"https:\/\/wordpress.org\/plugins\/woocommerce\/\" rel=\"ugc\">WooCommerce<\/a>, empowering online businesses with a feature-rich and flexible e-commerce solution for WordPress.<\/li>\n<li><a href=\"https:\/\/wordpress.org\/\" rel=\"ugc\">WordPress<\/a>: 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.<\/li>\n<\/ul>\n<p>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.<\/p>\n<p><strong>Important Links<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/codeastrology.com\/how-to-setup-product-sync-master-plugin\/#sheet-details-here\" rel=\"nofollow ugc\">Tutorial for Sheet Details<\/a><\/li>\n<li><a href=\"https:\/\/codeastrology.com\/how-to-setup-product-sync-master-plugin\/#service-key-api-help-section\" rel=\"nofollow ugc\">How to create JSON file and API key<\/a><\/li>\n<li><a href=\"https:\/\/cloud.google.com\/workflows\/docs\/reference\/googleapis\/sheets\/Overview\" rel=\"nofollow ugc\">Google Sheets API Connector Overview<\/a><\/li>\n<li><a href=\"https:\/\/cloud.google.com\/workflows\/docs\/reference\/googleapis\/sheets\/v4\/spreadsheets.values\/batchUpdate\" rel=\"nofollow ugc\">Sheet API Method: values.batchUpdate<\/a><\/li>\n<li><a href=\"https:\/\/developers.google.com\/sheets\/api\/reference\/rest\/v4\/spreadsheets.values\/clear\" rel=\"nofollow ugc\">Sheet API Method: spreadsheets.values.clear<\/a><\/li>\n<\/ul>\n<p><strong>Used Request in Code<\/strong><\/p>\n<ul>\n<li>Token Gen: <code>$token_url = 'https:\/\/oauth2.googleapis.com\/token';<\/code><\/li>\n<li>Scope: <code>['scope' => 'https:\/\/www.googleapis.com\/auth\/spreadsheets']<\/code><\/li>\n<li>Insert Data in Sheet: <code>$api_url = \"https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/$spreadsheet_id\/values\/$sheet_name!$range?valueInputOption=RAW&key=$API_KEY\";<\/code><\/li>\n<li>Update Sheet: <code>$api_url = \"https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/$spreadsheet_id\/values:batchUpdate?valueInputOption=RAW&key=$API_KEY\"<\/code><\/li>\n<li>Clear Sheet: <code>$api_url = \"https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/$spreadsheet_id\/values\/$sheet_name:clear?key=$API_KEY\"<\/code><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Help you to connect your WooCommerce website with Google Sheet as well as Manage your Stock easy from one menu with Advance Filter<\/p>\n","protected":false},"author":65,"featured_media":426536,"comment_status":"open","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"slim_seo":{"title":"Sync Master Sheet \u2013 Product Sync with Google Sheet for WooCommerce - \u8587\u6653\u6735\u63d2\u4ef6\u76ee\u5f55","description":"Help you to connect your WooCommerce website with Google Sheet as well as Manage your Stock easy from one menu with Advance Filter"},"footnotes":""},"categories":[1],"tags":[10703,27092,6251,48994,49093],"class_list":["post-225308","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-bulk-editor","tag-stock-management","tag-woocommerce-inventory-management","tag-woocommerce-stock-management","tag-woocommerce-stock-sync"],"_links":{"self":[{"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/posts\/225308","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/users\/65"}],"replies":[{"embeddable":true,"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/comments?post=225308"}],"version-history":[{"count":0,"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/posts\/225308\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/media\/426536"}],"wp:attachment":[{"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/media?parent=225308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/categories?post=225308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/tags?post=225308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}