前言介紹
- 這款 WordPress 外掛「Export Order, Product, Customer & Coupon for WooCommerce to Google Sheets」是 2020-11-11 上架。
- 目前有 400 個安裝啟用數。
- 上一次更新是 2025-05-01，距離現在已有 1 天。
- 外掛最低要求 WordPress 5.3 以上版本才可以安裝。
- 外掛要求網站主機運作至少需要 PHP 版本 5.6 以上。
- 有 22 人給過評分。
- 論壇上目前有 2 個提問，問題解答率 0%
外掛協作開發者
arpitgshah | creativewerkdesigns |
外掛標籤
google sheet | WooCommerce export | export woocommerce orders | export woocommerce products | export woocommerce customers |
內容簡介
使用 Google 試算表管理 WooCommerce 訂單 - 每當有新訂單時添加新行，並在 Google 試算表中更改訂單狀態時自動移動訂單行。
演示 | 文檔 | 24/7 支援 | 專業版
免費版功能:
WPSyncSheets Lite For WooCommerce 是管理 WooCommerce 訂單的插件中最受歡迎的版本。它可以在單一試算表中管理所有訂單，並包含七種不同的訂單狀態。每個狀態都會創建單獨的工作表並自動訂單 ID 排序。
管理訂單 - 它可以輕鬆地在 Google 試算表中管理您的所有訂單，使您的業務更有效率。Google 試算表可以管理您的庫存訂單。
新試算表和工作表 - 當用戶選擇使用名稱創建新試算表時，它會自動在設置頁面的訂單狀態基礎上創建新的試算表和工作表。
訂單狀態工作表 - 它會自動創建標準 WooCommerce 訂單狀態工作表。它會根據訂單狀態將新訂單保存在 Google 試算表中。
按訂單 ID 排序的行數據 - 有一種新的選項叫做按訂單 ID 排序的行數據。用戶可以輕鬆地按訂單行數據管理訂單。
凍結頁眉 - 用戶可以通過設置頁面選項輕鬆地凍結工作表的頁眉行（第一行）。
自動訂單 ID / 編輯訂單 - 用戶可以在管理員端編輯訂單，這將自動影響 Google 試算表。它可以輕鬆地基於所有訂單的訂單 ID 更新和設定。
多語言 - 本插件支持法語、德語和中文等多種語言。
WPSyncSheets For WooCommerce 專業版功能
同步訂單 - 點擊「點擊同步」將自動按訂單狀態工作表同步所有現有訂單。它還可以與 WooCommerce 中的現有訂單一起工作。
一體式工作表 - 通過啟用「一體式」選項，您可以啟用 Google 試算表中的所有工作表。所有客戶訂單狀態工作表將自動在試算表中創建一個工作表。
按產品為行的數據 - 有一個新的選項叫做按產品為行的數據。用戶可以輕鬆地按產品行數據管理訂單。
啟用/禁用工作表標題 - 它將根據設置頁面中用戶定義的設置工作表標題行。用戶可以輕鬆地在設置頁面選項中啟用/禁用工作表標題。
工作表標題排序 - 它將按照設置頁面中用戶定義的設置對工作表標題行進行排序。
產品名稱作為工作表標題 - 用戶可以在試算表中創建值為產品數量的列，並在下拉列表中選擇「添加所有產品名稱」將所有產品名稱添加到試算表中。
允許複製相同的列 - 用戶可以將相同的列複製到行中，例如帳單姓名、帳單姓氏等。
自定義靜態標題 - 用戶可以靜態地添加標題名稱。單擊「添加」，它將自動在 Google 試算表中生成標題。
導出訂單 - 在新的試算表中導出特定產品類別的所有訂單。按照指定日期範圍導出所有訂單或特定日期範圍內的訂單到新的試算表中。
原文外掛簡介
WPSyncSheets For WooCommerce lite is a powerful export plugin designed to seamlessly migrate WooCommerce products, orders, customers & coupons to Google Sheets.
With its user-friendly ‘Click to Sync’ feature, you can effortlessly transfer all your product, order, customer, and coupon data into a spreadsheet, making it easy to back up information, migrate data between websites, or share insights with team members and stakeholders for analysis and reporting.
The WooCommerce exporter plugin organizes your data by sorting orders, products, customers, and coupons into separate sheets within the same Google Sheets document. You have the flexibility to enable, disable, or create custom sheet headers and export data into specific sheets tailored to your needs.
As a powerful automated and run-time solution, WPSyncSheets updates your data in real-time, eliminating the need for manual intervention and ensuring that your information is always updated.
Plugin Features & Description
Here’s a list of features that our plugin offers
WooCommerce export orders to Google Sheets
WooCommerce export products to Google Sheets
WooCommerce export coupons to Google Sheets
Export customers from WooCommerce to Google Sheets
Bulk export WooCommerce orders
Bulk export WooCommerce products
Bulk export WooCommerce coupons
Bulk export customers WooCommerce to Google Sheets
Supports all product types export (simple, variable, grouped, external/affiliate)
Create, preview, or download Google Sheets
Download export orders to excel, export products to excel, export customers to excel and export coupons to excel
Generate order status-wise Google Sheets
Tested OK with WooCommerce 9.2.1
Tested OK with WordPress 6.6.1
Tested OK with PHP 8.3
HPOS Compatible
Support multiple languages (French, German, & Chinese)
Download Sample Sheets
Sample Sheets of Exported Orders
Sample Sheets of Exported Products
Sample Sheets of Exported Customers
Sample Sheets of Exported Coupons
How to Export Orders & Products From WooCommerce (With Images)?
Exporting WooCommerce orders and products (with images) into Google Sheets using the WPSyncSheets For WooCommerce Lite is easy.
All you need to do is install and activate the plugin and connect the plugin with your Google GDrive through API integration. Generate a Client ID, Client Secret Key, and Client Token from your Google Clouds Platform account and add it to the plugin.
WooCommerce Export Orders & Products
Proceed to the plugin’s Order Settings or Product Settings page, review the various options that allow you to specify what kinds of data you want to export, and then export the data from WooCommerce to Google Sheets. That’s it.
Live demo of exporting orders into Google Sheets: Click Here
Instructions for testing demo:
Select ‘Add to Cart’ → ‘View Cart’ → ‘Proceed to Checkout’ button.
Add a (real or fake) billing address and hit the ‘Place Order’ button
Select ‘View Your Orders in Spreadsheet’ for sample WooCommerce orders export in Google Sheets
How to Import Orders & Products From WooCommerce (With Images)?
To import WooCommerce orders and products (with images) into Google Sheets you need WPSyncSheets For WooCommerce Pro. It’s a paid plugin.
Install the plugin then add your paid license to activate the paid plugin. Proceed to connect the plugin with your Google GDrive through API integration. Generate a Client ID, Client Secret Key, and Client Token from your Google Clouds Platform account and add it to the plugin.
WooCommerce Import Orders & Products
Go to the plugin’s Order Settings or Product Settings page, and generate a sample Google Sheets. Add new data, modify or delete data (orders, products, customers, coupons, and events) on the sample Google Sheets, and then proceed to import the data from the spreadsheet. That’s it.
How to Export WordPress Users & WooCommerce Customers?
To export WordPress users and WooCommerce customers into Google Sheets you need the WPSyncSheets For WooCommerce Lite.
Just install and activate the plugin, and connect it with your GDrive using API integrations. Generate a Client ID, Client Secret Key, and Client Token from your Google Clouds Platform account and add it to the plugin. Then go to the plugin’s Customer Settings page, enable the Import Customers option, scroll down, and hit the Import Customer button and that’s it.
How to Export WooCommerce Coupons?
To export coupons from WooCommerce to Google Sheets you need the WPSyncSheets For WooCommerce Lite.
All you need to do is install and activate the plugin and connect it with your GDrive using API integrations. Generate a Client ID, Client Secret Key, and Client Token from your Google Clouds Platform account and add it to the plugin. Then go to the plugin’s Coupon Settings page, enable the Import Coupons option, scroll down, and hit the Import Coupons button and that’s it.
Documentation & Support
Check these help docs
Reach out to our support team
Import Export For WooCommerce (Pro Version) Features
✅ All the features in the free plugin (data export, bulk export, etc)
✅ Import orders from Google Sheets to WooCommerce
✅ Import products from Google Sheets to WooCommerce
✅ Import coupons from Google Sheets to WooCommerce
✅ Import customers from Google Sheets to WooCommerce
✅ Import export events from Google Sheets to WooCommerce
✅ Bulk Import orders, products, coupons, customers, & events
✅ Auto field mapping in Google Sheets
✅ Enable, disable, or custom-create sheet headers
✅ Add, modify, delete order, product, customer, coupons and events data within Google Sheets
✅ Schedule automatic imports of data from Google Sheets
✅ Schedule automatic export from WooCommerce to Google Sheets
✅ Schedule auto-export data from WooCommerce to Google Sheets
✅ Advanced filters to selectively import or export data
✅ Generate visual graphs into Google Sheets
✅ Import export custom field data from ACF Lite or Pro
✅ Import export WooCommerce products category-wise
✅ Import export product attributes
✅ Export data from WooCommerce to Google Sheets data within a date range
✅ Freeze headers & change row background color in Google Sheets
✅ Compatible with 45+ popular WooCommerce & WordPress plugins
✅ Supports multisite
Download Sample Sheets Pro
Sample Sheets of Products Sold Bar Graph
Sample Sheets of Total Orders Line Graph
Sample Sheets of Sales Orders Bar Graph
Relevant Import-Export Google Sheets Plugins
Other useful plugins from WPSyncSheets to import and export data from WordPress websites to Google Sheets.
WPSyncSheets For Gravity Forms: Sync Gravity Forms entries to Google Sheets allowing form data transfer to specified spreadsheet columns in real-time.
WPSyncSheets For Elementor: Migrates Elementor form entries to Google Sheets, maps form fields to the spreadsheet columns, and automatically updates sheets when form entries are submitted.
WPSyncSheets For Core: Enables import export WordPress posts and pages to and from Google Sheets, allowing users to bulk edit content in the spreadsheet and sync changes back to WordPress.
WPSyncSheets For Document Library Pro: Sync Document Library Pro entries with Google Sheets allowing for two-way updates between the plugin entries and spreadsheet data.
WPSyncSheets For Contact Form 7: Transfers Contact Form 7 entries to Google Sheets, maps form fields to spreadsheet columns, and updates sheets upon form submission.
WPSyncSheets For WPForms: Adds WPForms entries to Google Sheets and transfers form data to specified spreadsheet columns when forms are submitted.
WPSyncSheets For Ninja Forms: Migrates Ninja Forms entries to Google Sheets, maps form fields to spreadsheet columns, and updates sheets in real-time.
WPSyncSheets For Fluent Forms: Sync Fluent Forms entries to Google Sheets, and automatically transfer form data to designated spreadsheet columns upon submission.
WPSyncSheets For Formidable Forms: Adds Formidable Forms entities to Google Sheets maps form fields to spreadsheet columns and automatically updates sheets when forms are submitted.
About WPSyncSheets
WPSyncSheets specializes in developing plugins designed for seamless data synchronization between various Google Sheets and WordPress forms or WooCommerce.
The brand offers a growing lineup of over 9+ data synchronization plugins, continuously developing more plugins to meet user demands.
These tools export form submissions, product data, and website information to Google Sheets for accurate analysis and better data management. It also supports importing data from Google Sheets back into WordPress and WooCommerce websites, enabling bulk updates and much more.
By integrating WordPress and WooCommerce with Google Sheets, WPSyncSheets aims to streamline data handling processes for small businesses.
各版本下載點
- 方法一：點下方版本號的連結下載 ZIP 檔案後，登入網站後台左側選單「外掛」的「安裝外掛」，然後選擇上方的「上傳外掛」，把下載回去的 ZIP 外掛打包檔案上傳上去安裝與啟用。
- 方法二：透過「安裝外掛」的畫面右方搜尋功能，搜尋外掛名稱「Export Order, Product, Customer & Coupon for WooCommerce to Google Sheets」來進行安裝。
（建議使用方法二，確保安裝的版本符合當前運作的 WordPress 環境。
1.0 | 1.1 | 1.2 | 1.3 | 1.4 | 1.5 | 1.6 | 1.7 | 1.8 | 1.9 | 1.6.1 | 1.7.1 | 1.8.1 | 1.8.2 | 1.9.1 | 1.9.2 | 1.9.3 | 1.9.4 | 1.9.5 | 1.9.6 | trunk |
延伸相關外掛（你可能也想知道）
暫無相關外掛推薦。