前言介紹
- 這款 WordPress 外掛「Sync Master Sheet – Product Sync with Google Sheet for WooCommerce」是 2024-03-03 上架。
- 目前有 300 個安裝啟用數。
- 上一次更新是 2025-04-24，距離現在已有 10 天。
- 外掛最低要求 WordPress 4.0.0 以上版本才可以安裝。
- 外掛要求網站主機運作至少需要 PHP 版本 7.2 以上。
- 有 6 人給過評分。
- 還沒有人在論壇上發問，可能目前使用數不多，還沒有什麼大問題。
外掛協作開發者
外掛標籤
bulk editor | stock management | woocommerce-stock-sync | Woocommerce Stock Management | woocommerce inventory management |
內容簡介
```html
總結：
使用我們的外掛 - Product Stock Sync with Google Sheet for WooCommerce，輕鬆管理和同步您的 WooCommerce 產品庫存，並借助 Google Sheets 的強大功能。這個直覺式解決方案讓您輕鬆地精簡庫存管理。
問答：
這個外掛的主要功能是什麼？
主要功能包括：
- Google Sheet 整合
- 輕鬆更新
- 簡化庫存管理
- 自動化
如何使用這個外掛？
使用方式：
- 建立安全連接
- 更新產品庫存與價格
- 即時同步
為什麼選擇 Product Stock Sync？
選擇原因：
- 節省時間
- 提高準確性
- 使用者友好
如何開始？
設定 Google Sheet API 連接：
- 以下列步驟來連接 WooCommerce 商店與 Google Sheets：
1.教學 - 設定指南
2.連結 Google Sheet
3.建立 Google 項目
4.建立服務 JSON 憑證等等
```
```
原文外掛簡介
Documentation | Get Premium | Try Demo
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
* 🔥🔥🔥 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 – Checkout and follow step by step guideline. How to configure with Google Sheet – explained here.
Link Google Sheet – 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 – Navigate to the “APIs & Services” and select “Dashboard”. Click on “+ CREATE PROJECT” and fill in the necessary details.
Credentials to make a Service JSON – 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 – In your project dashboard, go to “APIs & Services” > “Library”. Search for “Google Sheets API” and enable it for your project.
Check Enable Sheet API – 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 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 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 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, empowering online businesses with a feature-rich and flexible e-commerce solution for WordPress.
WordPress: 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
How to create JSON file and API key
Google Sheets API Connector Overview
Sheet API Method: values.batchUpdate
Sheet API Method: 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"
各版本下載點
- 方法一：點下方版本號的連結下載 ZIP 檔案後，登入網站後台左側選單「外掛」的「安裝外掛」，然後選擇上方的「上傳外掛」，把下載回去的 ZIP 外掛打包檔案上傳上去安裝與啟用。
- 方法二：透過「安裝外掛」的畫面右方搜尋功能，搜尋外掛名稱「Sync Master Sheet – Product Sync with Google Sheet for WooCommerce」來進行安裝。
（建議使用方法二，確保安裝的版本符合當前運作的 WordPress 環境。
1.0.0 | 1.0.1 | 1.0.2 | 1.0.3 | 1.0.4 | 1.0.5 | 1.0.6 | 1.0.7 | 1.0.8 | 1.0.9 | 1.1.0 | 1.1.1 | 1.1.2 | trunk |
延伸相關外掛（你可能也想知道）
WOLF – WordPress Posts Bulk Editor and Manager Professional 》WOLF – WordPress Posts Bulk Editor and Manager Professional (舊稱 WPBE) 是一個 WordPress 外掛程式，可強大而靈活地管理和批量編輯 WordPress 發佈的文...。
WPC Variation Bulk Editor for WooCommerce 》WPC Variation Bulk Editor for WooCommerce是一個用於管理在線商店變異產品的工具，讓使用者能夠批量編輯變異的所有屬性，包括圖片、庫存、價格（常規和促銷...。
Bulk Meta Editor 》這個 WordPress 外掛可批次更新網頁的標題、描述、canonical url 以及索引等元數據，專為網頁開發人員和 SEO 專家進行網站審查而製作。目前只支援 Yoast。, ...。
Setary — Bulk Edit WooCommerce Products 》, 注意：此外掛需要您擁有Setary帳號。現在開始使用7天免費試用。, , Setary 讓您能夠在電子表格環境中大量編輯 WooCommerce 產品，更新庫存、價格、標題、自...。
SkySEOManager – Bulk SEO Editor 》, , , 外掛總結:
,SkySEOManager是一個強大的批量SEO編輯器，幫助您有效管理網站的SEO元數據。從單...。