Export and import WooCommerce orders, products, customers, coupons, and events seamlessly between your store and Google Sheets. Automate data imports and exports to simplify management, reduce manual work, and improve accuracy. Access and manage your WooCommerce data in real time for faster analysis and smarter business decisions.
Instantly bulk import WooCommerce orders, products, customers, and coupons from Google Sheets into your store. Eliminate manual data entry, speed up store operations, and keep your WooCommerce data perfectly synced in just a few clicks.
Instantly export and sync all your WooCommerce orders, products, customers, and coupons to Google Sheets. Automate your data workflow, get real-time updates, and simplify reporting and analysis—no manual work required.
Connect Google Sheets to WooCommerce instantly — one click, zero coding, full automation.
Fully compatible with WooCommerce HPOS for seamless performance. Prevents conflicts in order processing and management, ensuring your store runs smoothly (learn more).
Easily import and export WooCommerce ACF data—including ACF Lite and Pro custom fields. View and manage your ACF fields effortlessly for seamless content migration (view ACF fields).
WPSyncSheets automatically generates a dedicated sheets in your Google Spreadsheet for each WooCommerce order status, making your data more accessible and easily manage.
Filter products by category, attributes, and tags in Google Sheets for easy access and organized data management.
WPSyncSheets is 100% translation-ready and multisite-compatible. Use WPSyncSheets across all your sites and languages.
Automatically create Google Sheets to sync all your WooCommerce data. Manage orders, products, customers, and coupons effortlessly.
Works seamlessly with all WooCommerce product types, including simple, variable, grouped, affiliate, custom, and subscription products.
Add custom headers using metadata or static values with just one click. Easily personalize and organize your Google Sheets.
View WooCommerce orders in Google Sheets your way — product-wise with each item in a separate row, or order-wise with all items in one row.
With WPSyncSheets for WooCommerce, effortlessly update hundreds or thousands of products, orders, coupons, or users in one go — directly from Google Sheets. Apply custom rules or formulas during import to adjust prices, stock, or other fields instantly, saving hours of manual work and reducing errors.
Boost your store efficiency:
Running a site-wide sale or updating multiple entries? Simply export your products, apply your changes in Google Sheets, and re-import. Your WooCommerce store is updated in minutes, keeping your workflow fast, accurate, and stress-free.
Automate WooCommerce data imports and exports with scheduled synchronization. Set your preferred schedule and let the plugin handle everything. Syncing your store data with Google Sheets automatically, eliminating manual work, and streamlining your workflow for maximum efficiency.
With WPSyncSheets For WooCommerce, you can create orders directly from Google Sheets. Fill out the sidebar form with products, quantities, billing and shipping details, and payment method — and your order is instantly added to WooCommerce. No manual entry, just seamless order creation where you work.
Automatically generate engaging, SEO-friendly product descriptions for your WooCommerce store using ChatGPT.
Stay organized with dedicated rows for every variation of your products in one place. Easily track stock levels and manage pricing for simple, variable, and grouped products with complete clarity and control.
Over 200,000 successful syncs and counting. Effortlessly manage WooCommerce data, reduce manual work, and streamline your store operations
Buy PluginGenerate stunning visual graphs in Google Sheets to showcase key WooCommerce data such as sales, orders, products sold, and customer counts. Easily enable, customize, and regenerate charts directly from the plugin’s feed settings for instant insights and smarter business decisions.
Besides import-export, the plugin offers plenty of other useful features with granular control over sheet creation, formatting, and styling options.
The plugin comes with built-in support for the following languages:
Seamlessly manage your WooCommerce data with powerful import and export integration—effortless and efficient.
Top Rated 5/5 in 900+ reviews
Been looking for something like this now for months, and when found this plugin, it did exactly what I needed, it does exactly what it says it does, would highly recommend. Also, the support of the team who built the plugin is also very very good.
CEO, SEO Builder
Asked for help with syncing issues and some feature requests. Received a prompt reply and worked through my syncing issues with their expert guidance. They even added the requested features! Exceptional customer support and an incredibly easy-to-use plugin.
Marketing Head
We work with several plugin companies, but WPSyncSheets’ support stands out – prompt follow-up in under an hour! Their unique feature of synchronizing new editions without duplicating data in Google Sheets is a game-changer. No other plugin offers this!
CEO
If our plugin doesn’t work as promised, you’re backed by our 14-day refund policy to request your money back.
Read about our policy here
Compare the features to find the best option for your website.
General Features
Free
Pro
Automatically Create New Google Spreadsheet
Automatcailly Create New Google Sheets based on the Order Status(s)
Download Excel & CSV
Automatically Clear Google Spreadsheet
Freeze Headers (First Row of the Google Spreadsheet)
HPOS Compatibility
Reorder Sheet Headers (Spreadsheet Columns)
Update Sheet Headers Name (Spreadsheet Columns)
Schedule Auto Sync (Export)
Schedule Auto Import
ACF, MetaBox and JetEngine Custom Fields Support
Graph Generation & Formatting
Third‑Party & Multisite Compatibility
Custom Order Status as Sheets
Add Custom Headers from Metadata
Spreadsheet Row Order - ASC & DESC
Inherit Styles
Add Custom Static Headers
Row Background Color
Row Input Format Option
Date/Time Format Option
Price Format
Order Features
Free
Pro
Order Wise Manage Row Data
Product Wise Manage Row Data
Export All Orders
Import All Orders
Export Orders with Date Range
Exclude Order Status from Order Notes
Product Features
Free
Pro
Export All Products
Import All Products
Export Products with Date Range
Export Products with Product Sale Date Range
Import/Export Product Categories
Import/Export Product Attributes
Import/Export Product Tags
Product Categories as Sheets
Product Name as Sheets Headers
Customer Features
Free
Pro
Export All Customers
Import All Customers
Export Customers with Date Range
Coupon Features
Free
Pro
Export All Coupons
Import All Coupons
Export Coupons with Date Range
Yes, You can synchronize the existing WooCommerce orders by clicking “Click to Sync” button at WooSheets settings page.
There are following ways to resolved this error:
Revoke token at Google API Settings Page.
Check the Google Drive API must be Enable
Please visit link Click Here.
No, We can’t reorder/add/edit the sheet header columns because it will be miss match the orders data
Google might display a screen that says “This app isn’t verified. This app hasn’t been verified by Google yet. Only proceed if you know and trust the developer.” There’s no need to worry, though — the message is only referring to the app that you just created in your own Google account (so you are actually the developer in this case).
To bypass this message, you’ll need click Advanced and then Proceed.
Can’t find an answer to your question? Search our knowledge base or get in touch via the contact page.
We care about your data privacy policy.
