Export WooCommerce Orders, Products, Customers & Coupons to Google Sheets

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

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

📌 Setup Instructions

1. Install and activate the plugin
2. Connect your Google account via API (Client ID, Secret Key & Token)
3. Configure the export settings (orders, products, customers, coupons)
4. “Click to Sync” — your existing WooCommerce data will be sent to Google Sheets
5. 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

1. Upload the entire wpsyncsheets-woocommerce folder to the /wp-content/plugins/ directory.
2. Activate the plugin through the Plugins screen (Plugins > Installed Plugins).

You will find WPSyncSheets Lite For WooCommerce menu in your WordPress admin screen.

For basic usage, have a look at the plugin’s Documentation.

1. 

   Google API Integration Settings

2. 

   WooCommerce Order Export Settings

3. 

   WooCommerce Product Export Settings

4. 

   WooCommerce Customer Export Settings

5. 

   WooCommerce Coupon Export Settings

6. 

   WooCommerce Order Enable Settings

7. 

   WooCommerce Product Enable Settings

8. 

   WooCommerce Customer Enable Settings

9. 

   WooCommerce Coupon Enable Settings

10. 

    WooCommerce Order Default Sheet Headers

11. 

    WooCommerce Product Default Sheet Headers

12. 

    WooCommerce Customer Default Sheet Headers

13. 

    WooCommerce Coupon Default Sheet Headers

14. 

    General Settings

15. 

    Google Spreadsheet Orders

2.0.6

• Add “Leave a Review” Functionality

2.0.5

• Optimized code

2.0.4

• Tested with WooCommerce 10.1.2
• Tested with WordPress 6.8.2

2.0.3

• Add “Upgrade to Pro” link

2.0.2

• Add Dashboard Tab

2.0.1

• Add Feedback Form Popup
• UI & UX Changes

2.0.0

• UI/UX changes

1.9.9

• Fix – Resolved error caused by calling get_refunds() on WC_Order_Refund object.

1.9.8

• Optimized code

1.9.7

• Tested with WooCommerce 9.8.5

1.9.6

• Country names updated to 2-letter country codes for customer setting.

1.9.5

• UI/UX changes

1.9.4

• Country names updated to 2-letter country codes.

1.9.3

• Fixed: Resolved an issue with the refresh token.

1.9.2

• Added is_plugin_active() function_exists for improved security in plugin operations.

1.9.1

• Performed user capability check for secure operation execution.

1.9

• Added nonce functionality for improved security in plugin operations.

1.8.2

• Optimized code

1.8.1

• Tested with WordPress 6.7.1
• Updated & Tested with Guzzle Library 7.9.2

1.8

• Added WooCommerce Export Customer Settings
• Added WooCommerce Export Coupon Settings
• Optimized code

1.7.1

• UI/UX changes
• Optimized code

1.7

• New Designs integration
• Tested with WordPress 6.6.1
• Optimized code

1.6.1

• Optimize Click to Sync funcationality for orders
• Tested with WordPress 6.6
• Optimized code

1.6

• Add Compatibility with HPOS WooCommerce
• Optimized code

1.5

• Optimized code

1.4

• Added Clear Spreadsheet Button
• Added WooCommerce Export Product Settings
• Optimized code

1.3

• Optimized code

1.2

• Optimized code
• Coding Standards Improvement & Security Patch

1.1

• Optimized code
• Download Spreadsheet Button
• Load Library

1.0

• Initial Version