[WordPress] 外掛分享： Export WooCommerce Orders, Products, Customers & Coupons to Google Sheets

內容簡介

使用 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, real-time export plugin that lets you automatically sync WooCommerce orders, products, customers, and coupons to Google Sheets — without manual work.
With its intuitive ‘Click to Sync’ feature, you can effortlessly back up store data, share business insights with your team, or migrate WooCommerce content between sites. Each data type is organized in its own tab inside a single Google Sheet for clarity and easy access.
Whether you’re running a small store or managing a complex WooCommerce setup, this plugin simplifies your data management by offering a clean and customizable export system with automated syncing and advanced features.
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.
🔑 Key Features

Export WooCommerce Orders to Google Sheets
Export Products, Customers, and Coupons
Supports bulk export of all data types
Export all product types: simple, variable, grouped & external
Automatically create and manage separate sheets for each data type
Enable/disable data types or customize headers
Download data as Excel files (orders, products, customers, coupons)
Export order data based on status
Compatible with WooCommerce 9.8.5, WordPress 6.8.1, PHP 8.3
100% HPOS Compatible
Supports French, German, Dutch & Chinese

🚀 Why Use This Plugin?

Real-time sync: No more manual exports — your sheets update automatically
Data backup: Keep a live copy of your store data in Google Sheets
Collaboration ready: Easily share sheets with team members or stakeholders
Customizable sheets: Control what you export and how it’s formatted

📂 Sample Export Sheets
Sample Sheets of Exported Orders
Sample Sheets of Exported Products
Sample Sheets of Exported Customers
Sample Sheets of Exported Coupons
How to Export WooCommerce Orders?

How to Export WooCommerce Products?

How to Export WooCommerce Coupons?

How to Export WooCommerce Customers?

How to Import WooCommerce Orders? (Pro)

How to Import WooCommerce Products? (Pro)

How to Import WooCommerce Coupons? (Pro)

How to Import WooCommerce Customers? (Pro)

📷 Live Demo
Test the plugin in action here:
Easily Export WooCommerce Data to Google Sheets: Live demo
📋 Instructions for testing demo

Add any product to ‘Add to Cart’ → ‘View Cart’ → ‘Proceed to Checkout’ button
Fill out billing info (real or test) and place the order
Click on ‘View Your Orders in Spreadsheet’ to see WooCommerce data in Google Sheets

📌 Setup Instructions

Install and activate the plugin
Connect your Google account via API (Client ID, Secret Key & Token)
Configure the export settings (orders, products, customers, coupons)
“Click to Sync” — your existing WooCommerce data will be sent to Google Sheets
Every new order, product, customer, or coupon is instantly added to your connected Google Sheets.

📘 Documentation & Support

Check these help docs
Reach out to our support team

🔒 Need Imports Too? Upgrade to Pro
The Pro Version lets you import orders, products, customers, coupons, and events from Google Sheets to WooCommerce — in addition to all the export features.
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
📣 Trusted by Over 10,000+ Customers
Trusted by online retailers, developers, and marketing teams globally to streamline WooCommerce data management.
🔔 Stay Updated
Subscribe to the WPSyncSheets Newsletter and get tips, updates, and exclusive discounts delivered straight to your inbox!
Relevant Import-Export Google Sheets Plugins by WPSyncSheets
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 is a leading plugin suite built to connect WordPress and WooCommerce platforms with Google Sheets. Our mission is to help businesses automate data transfer, simplify operations, and reduce repetitive tasks through real-time, two-way data synchronization.
With over 9+ purpose-built plugins, WPSyncSheets enables:

Smooth export/import of WooCommerce and WordPress data
Bulk content updates through spreadsheets
Live syncing of form submissions across popular form plugins
Easy spreadsheet-based product management

Whether you’re running an eCommerce store, collecting leads, or managing blog content, WPSyncSheets lets you automate your workflow—no code required.
👉 Learn more on our Official Website
📈 Upgrade to WPSyncSheets Pro for the full automation suite
💬 Have questions? Contact Our Support Team