外掛標籤
開發者團隊
② 後台搜尋「Spreadsheet Sync for WooCommerce」→ 直接安裝（推薦）
原文外掛簡介
Google Sheets Sync for WooCommerce enables seamless, real-time synchronization of your WooCommerce product and order data with Google Sheets. Effortlessly export, update, and manage your product catalog and orders from a Google Sheet, streamlining reporting, automation, and third-party integrations. The included Google Sheets Add-on provides advanced features for managing your store data directly within Google Sheets.
Features
🔹 Real-time and scheduled sync of WooCommerce products and orders to Google Sheets.
🔹 Export product fields: title, SKU, price, stock, categories, images, and custom fields.
🔹 Export order fields: order ID, status, customer details, products, totals, and more.
🔹 Supports simple and variable products.
🔹 Manual sync option.
🔹 Map WooCommerce fields to custom Google Sheet columns.
🔹 Secure OAuth 2.0 authentication with Google.
🔹 Google Sheets Add-on for enhanced management and automation.
🔹 Error logging and sync status notifications.
🔹 Compatible with major WooCommerce extensions.
🔹 Multisite and WPML support.
External Services
This plugin works with a Google Sheets Add-on service provided by the plugin owner. The Add-on uses a custom API created for this product to move data between the specific Google spreadsheet you configure and your WooCommerce store.
Service: Google Sheets Add-on service and custom API provided by the plugin owner, plus Google authentication and Google Sheets infrastructure used by the Add-on.
What it is used for: to sync and update selected WooCommerce product and order fields for the specific configured spreadsheet, and to validate the connection securely before passing data to the store.
What data is sent: configured spreadsheet ID, connection/authentication metadata, and selected WooCommerce product/order fields. Product fields sent by the Add-on include type, parent_id, name, sku, attributes, regular_price, sale_price, stock, and status. Order fields sent include customer_name, customer_email, total_amount, status, and items.
When it is sent: when you connect the Google Sheets Add-on, save the sheet settings, authorize access, run manual syncs, or when scheduled / automatic syncs occur.
Where it is sent: to the Google Sheets Add-on service and the plugin owner’s central server, which checks the data and then forwards it only to the specific configured WooCommerce store for the selected spreadsheet.
Conditions: this external service access only occurs after you configure a Google Sheet ID and connect the Google Sheets Add-on. The custom API is limited to the configured spreadsheet and store, and it does not poll or access other Google Sheets or stores.
Google terms of service: https://acowebs.com/terms-conditions
Google privacy policy: https://acowebs.com/privacy-policy
Source Code
The source code for the compiled JavaScript and CSS files in the admin/build/ directory is included in this plugin and can be found in the app/ directory.
Building from Source
This plugin uses Vite as a build tool. To rebuild the assets from source:
Navigate to the app/ directory
Install dependencies: npm install
Build for production: npm run build
The build process will generate the compiled files in the admin/build/ directory.
For development with hot module replacement:
npm run dev
