WordPress.org

Plugin Directory

Export Order, Product, Customer & Coupon for WooCommerce to Google Sheets

Export Order, Product, Customer & Coupon for WooCommerce to Google Sheets

Description

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:

  1. Select ‘Add to Cart’ ‘View Cart’ ‘Proceed to Checkout’ button.
  2. Add a (real or fake) billing address and hit the ‘Place Order’ button
  3. 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

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.

Screenshots

  • Google API Integration Settings
  • WooCommerce Order Export Settings
  • WooCommerce Product Export Settings
  • WooCommerce Customer Export Settings
  • WooCommerce Coupon Export Settings
  • General Settings
  • Google Spreadsheet Orders

Installation

  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.

FAQ

Can the plugin export WooCommerce products with images?

Yes, the plugin can export WooCommerce products with images from your WooCommerce store to Google Sheets.

Does the plugin support the export of variation products?

Yes, the plugin supports the export of variation products from your WooCommerce store into Google Sheets.

Does the plugin support multisite?

Yes, the plugin supports multisite exports to Google Sheets.

Does the plugin export WooCommerce customers and coupons?

Yes, the plugin can export WooCommerce customers and coupons into Google Sheets.

Does the plugin export posts, pages, and custom post types?

No, the plugin does not export posts, pages, and custom post types. However, we have a different plugin called WPSyncSheets For Core that can export those in Google Sheets.

Can the plugin import orders in WooCommerce?

No, it’s a WooCommerce exporter plugin and cannot import orders in WooCommerce. However, we have a paid plugin called WPSyncSheets For WooCommerce Pro that allows the import of orders into WooCommerce.

Can the plugin import WooCommerce product?

No, it’s a WooCommerce exporter plugin and cannot import products in WooCommerce. However, we have a paid plugin called WPSyncSheets For WooCommerce Pro that allows the import of orders into WooCommerce.

Reviews

September 5, 2024 1 reply
The plugin and all its variants, including the Core version that I use, are of very high quality and very well crafted. Customer support is responsive and attentive. Synchronisation is reliable, fast and requires no action once everything has been configured. The help on their website is well done and this plugin worked without a hitch. Thanks to the devs !
August 28, 2024 1 reply
This plugin’s author went above and beyond to help me after I faced an issue with it, and he managed to solve the problem very quickly and professionally. The plugin itself works wonderfully and it really helps manage orders and keep track of things on Google Spreadsheet, which is much more convenient than WooCommerce dashboard in my opinion. I sincerely thank you Arpit and wish you & your plugin nothing but the best.
August 25, 2024 1 reply
I’m still getting set up with using the product but the support have been incredibly helpful, making additions to the plugin to meet our needs.
Read all 18 reviews

Contributors & Developers

“Export Order, Product, Customer & Coupon for WooCommerce to Google Sheets” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

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