WPSyncSheets For WooCommerce – Import & Export Orders, Products, Customers & Coupons to Google Sheets in Real-Time
| 开发者 |
creativewerkdesigns
arpitgshah |
|---|---|
| 更新时间 | 2026年10月3日 18:01 |
标签
下载
详情介绍:
WPSyncSheets For WooCommerce automatically exports and syncs your WooCommerce orders, products, customers, and coupons to Google Sheets in real time. Every new order, product, customer, or coupon is added to your connected spreadsheet the moment it is created, so your store data is always current without a single manual export.
If you are looking for a WooCommerce Google Sheets Connector that keeps each data type in its own tab inside a single spreadsheet, this plugin is built for that job. Use it to back up store data, share live reports with your team, migrate WooCommerce content between sites, or feed your accounting and analytics workflows.
Demo | Sample Sheets | Docs | Support | Pro
🚀 Why Use This Plugin?
➜ Real-time export of WooCommerce orders to Google Sheets
➜ Separate, automatically created sheet tabs for each data type
➜ Share without giving admin access — send a sheet link to your accountant, VA, or supplier
➜ Local CSV & Excel (.xlsx) import and export
➜ Bulk-friendly — read and filter thousands of rows in Sheets instead of paging through wp-admin
➜ Interactive setup wizard and one-click Google Sheets connection
➜ 100% HPOS compatible, multisite ready
WPSyncSheets For WooCommerce Features
- WooCommerce to Google Sheets Integration Connect WooCommerce with Google Sheets and export store data in real time. Create a new spreadsheet or select an existing one, and let the plugin add a dedicated tab for orders, products, customers, and coupons, each with a complete set of default columns. Data is synced using secure Google authentication, and no Google account or Drive data is stored by the plugin author.
- Export WooCommerce Orders by Status Export order data based on WooCommerce order status so processing, completed, pending, cancelled, and refunded orders can be tracked separately. The built-in "Click to Sync" action pushes all of your existing orders into the connected sheet in one go, and every new order after that is appended automatically.
- Export Product Types, Customers & Coupons Export simple, variable, grouped, and external products, including product images and variations, along with your full customer and coupon lists. Bulk export is supported for every data type, so an entire catalogue or customer base can be moved into Google Sheets in a single run.
- CSV & Excel Import Export with Validation Preview Import and export WooCommerce orders, products, customers, and coupons as local CSV or Excel (.xlsx) files. A smart validation preview shows valid versus error row counts before anything is written to your store, and chunked background processing keeps large files from triggering server timeouts (504 errors).
- Modern Dashboard & Guided Setup An interactive setup wizard walks you through the Google connection, and the dashboard inside WordPress admin shows each data type with its current sheet, header configuration, and sync status. Every sheet includes all default headers for its data type, with their default names and order.
- Step 1 – Install & Activate Install and activate the plugin. You will find the WPSyncSheets For WooCommerce menu in your WordPress admin.
- Step 2 – Connect Google Open the API Integration tab and connect your Google account, either with the one-click connection or with your own Client ID, Secret Key, and Token. Make sure to ALLOW the Google Drive and Google Sheets permissions when prompted.
- Step 3 – Configure Export Settings Create new or select existing spreadsheet to use, then enable the data types you want (orders, products, customers, coupons). Each sheet includes all default headers.
- Step 4 – Click to Sync Use "Click to Sync" to send existing WooCommerce data to Google Sheets. From that point on, every new order, product, customer, or coupon is added to the connected sheet automatically.
- How to Export WooCommerce Orders to Google Sheets Automatically
- How to Import WooCommerce Orders to Google Sheets
- Real-Time Sync of WooCommerce Order Status to Google Sheets
- Bulk Product and Order Management in WooCommerce
- How to Bulk Edit WooCommerce Product Prices for a Sale
- How to Use Google Sheets as Your WooCommerce Inventory Control Center
- Google Sheets vs the WooCommerce Default Dashboard: Which Is Better for Store Management?
- How to Automatically Sync WordPress Data to Google Sheets
- How to Build a Marketing Dashboard from WordPress Data Using Google Sheets
- How to Turn Your WordPress Data into AI-Powered Insights with Google Sheets
✅ All free features – data export, bulk export, CSV/Excel import export ✅ Import orders, products, customers, coupons & events from Google Sheets to WooCommerce ✅ Bulk import of orders, products, coupons, customers, and events ✅ Auto field mapping between WooCommerce and Google Sheets ✅ Additional sheet headers from plugins, custom fields and metadata ✅ Choose, rename and reorder sheet headers ✅ Add, modify, and delete store data directly inside Google Sheets ✅ Scheduled imports and exports at your own intervals ✅ Advanced filters to selectively import or export data ✅ Date range sync – send only the records from a selected date range ✅ Category-wise product sheets, and import of product categories, tags and attributes from Google Sheets ✅ Custom field data from ACF Lite or Pro ✅ Visual graphs generated inside Google Sheets ✅ Freeze headers and change row background colours ✅ Compatible with 45+ popular WooCommerce and WordPress plugins ✅ Multisite supportPro sample sheets: Products Sold Bar Graph | Total Orders Line Graph You can check out the user guide to set up the plugin, or watch the videos below. How to Export WooCommerce Orders? https://www.youtube.com/watch?v=jh5ErgluSVU How to Export WooCommerce Products? https://www.youtube.com/watch?v=00cNpysSQz0 How to Export WooCommerce Customers? https://www.youtube.com/watch?v=AZqM9stSKWg How to Export WooCommerce Coupons? https://www.youtube.com/watch?v=VVK-4b0W2zc 📣 Trusted by Over 10,000+ Customers Trusted by online retailers, developers, and marketing teams globally to streamline WooCommerce data management. Subscribe to the WPSyncSheets Newsletter for tips, updates, and exclusive discounts. Other WPSyncSheets Plugins WPSyncSheets also offers Google Sheets integrations for Contact Form 7, Gravity Forms, WPForms, Ninja Forms, Fluent Forms, Formidable Forms, Elementor forms, Document Library Pro and WordPress posts and pages. See the WPSyncSheets website for the full list.
安装:
- Upload the entire
wpsyncsheets-woocommercefolder to the/wp-content/plugins/directory, OR go to Plugins > Add New > Search and search for "WPSyncSheets For WooCommerce". - Activate the plugin through the Plugins screen (Plugins > Installed Plugins).
- Open the WPSyncSheets For WooCommerce menu in your WordPress admin and connect your Google account from the Google API Settings tab, allowing both Google Drive and Google Sheets permissions.
屏幕截图:
常见问题:
My new orders are not showing up in the connected Google Sheet.
This is usually a connection or permission problem. Check that the Google account is still authenticated, that both Google Drive and Google Sheets permissions were allowed during authentication, and that the correct spreadsheet and order statuses are selected in the export settings. Re-authenticating from the Google API Settings tab resolves most cases.
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 export WooCommerce customers and coupons?
Yes, the plugin can export WooCommerce customers and coupons into Google Sheets.
Can I export only orders with a specific status?
Yes. Order export can be filtered by WooCommerce order status, so you can keep processing, completed, or refunded orders in their own view.
Can I import CSV or Excel files into WooCommerce?
Yes. The plugin supports local CSV and Excel (.xlsx) import and export for orders, products, customers, and coupons, with a preview step that shows valid and error row counts before the import runs.
My import keeps failing or times out on large files.
Imports run through chunked background processing specifically to avoid server timeouts (504 errors) on large files. If an import still stalls, split the file into smaller batches and check your host's PHP execution time and memory limits.
Can I choose, rename or reorder the sheet headers?
The free version always includes all default sheet headers for orders, products, customers, and coupons, with their default names and order. Choosing which headers to include, renaming and reordering sheet headers, renaming order status sheets, and adding extra headers from plugins, custom fields or metadata are available in the Pro Version.
Is the plugin compatible with HPOS (High-Performance Order Storage)?
Yes, the plugin is 100% HPOS compatible.
Does the plugin support multisite?
Yes, the plugin supports multisite exports to Google Sheets.
Does the plugin export posts, pages, and custom post types?
No. For that, use WPSyncSheets For Core, which imports and exports WordPress posts and pages via Google Sheets.
Can the plugin import orders or products from Google Sheets into WooCommerce?
Not in the free version, which exports from WooCommerce to Google Sheets and supports local CSV/Excel files. Importing orders, products, customers, coupons, and events from Google Sheets into WooCommerce is available in WPSyncSheets For WooCommerce Pro.
Is my Google account data safe?
Yes. The connection uses Google's own secure authentication, data is written directly to the spreadsheet you select, and no Google account or Drive data is stored by the plugin author.
Do I need coding knowledge to use this plugin?
No. The setup wizard and settings screens are designed for non-developers, and no code is required.
更新日志:
2.2.5 - Saturday, 3rd October 2026
- Improved: Enhanced plugin security and overall stability.
- Fixed: Fatal error caused by an undefined wp_create_nonce() call during plugin loading when custom Google API credentials are saved.
- Improved: Refined header management and Pro feature handling.
- Improved: Optimized plugin code for better stability and maintainability.
- Security: Strengthened AJAX requests, Google authorization, and admin-side validation.
- Improved: Enhanced CSV/Excel import processing for greater reliability and safer data handling.
- Improved: Improved export processing and temporary file management.
- Added: External services and source code sections in the readme; Requires Plugins header for WooCommerce; composer.json for the bundled PHP libraries.
- Fixed: WordPress Plugin Check issues (escaping, sanitisation, translators comments, prefixed globals, debug code, bundled test files).
- Fixed: Undefined wp_generate_password() call during early plugin initialization by adding a cryptographically secure random_int() fallback for installation ID generation.
- Added: Interactive Setup Wizard for guided onboarding and initial setup.
- Added: One-Click direct connection to Google Sheets.
- Added: CSV/Excel Import & Export for Orders, Products, Customers, and Coupons.
- Added: Excel (.xlsx) file format support.
- Added: File preview step before import with valid/error row count.
- Added: Chunked background import processing to prevent server timeouts (504).
- Improved: Code optimizations.
- Changed: Tested with WordPress 7.0.
- Changed: Optimized code.
- Changed: Updated plugin text domain from wpssw to wpsyncsheets-woocommerce to match the plugin slug.
- Changed: Regenerated translation template (.pot) file.
- Tested: WooCommerce 10.3.6.
- Tested: WordPress 6.9.
- Added: "Leave a Review" functionality.
- Changed: Optimized code.
- Tested: WooCommerce 10.1.2.
- Tested: WordPress 6.8.2.
- Added: "Upgrade to Pro" link.
- Added: Dashboard tab.
- Added: Feedback form popup.
- Changed: UI/UX improvements.
- Changed: UI/UX improvements.
- Fixed: Error caused by calling get_refunds() on WC_Order_Refund object.
- Changed: Optimized code.
- Tested: WooCommerce 9.8.5.
- Changed: Customer country names updated to 2-letter country codes.
- Changed: UI/UX improvements.
- Changed: Country names updated to 2-letter country codes.
- Fixed: Issue with refresh token.
- Changed: Added function_exists() check for is_plugin_active() for improved security.
- Changed: Added user capability checks for secure execution.
- Changed: Added nonce verification for improved security.
- Changed: Optimized code.
- Tested: WordPress 6.7.1.
- Changed: Updated and tested with Guzzle library 7.9.2.
- Added: WooCommerce export customer settings.
- Added: WooCommerce export coupon settings.
- Changed: Optimized code.
- Changed: UI/UX improvements.
- Changed: Optimized code.
- Added: New design integration.
- Tested: WordPress 6.6.1.
- Changed: Optimized code.
- Changed: Optimized "Click to Sync" functionality for orders.
- Tested: WordPress 6.6.
- Changed: Optimized code.
- Added: Compatibility with WooCommerce HPOS.
- Changed: Optimized code.
- Changed: Optimized code.
- Added: Clear Spreadsheet button.
- Added: WooCommerce export product settings.
- Changed: Optimized code.
- Changed: Optimized code.
- Changed: Optimized code.
- Fixed: Coding standards improvements and security patch.
- Changed: Optimized code.
- Added: Download Spreadsheet button.
- Added: Library loading.
- Added: Initial version.