Adds an interactive setup wizard and one-click Google Sheets connection for faster onboarding.<\/p>"},"ratings":{"1":0,"2":0,"3":0,"4":0,"5":27},"assets_icons":{"icon-128x128.gif":{"filename":"icon-128x128.gif","revision":3316755,"resolution":"128x128","location":"assets","locale":"","width":128,"height":128},"icon-256x256.gif":{"filename":"icon-256x256.gif","revision":3316756,"resolution":"256x256","location":"assets","locale":"","width":256,"height":256}},"assets_banners":{"banner-1544x500.gif":{"filename":"banner-1544x500.gif","revision":3314981,"resolution":"1544x500","location":"assets","locale":"","width":1544,"height":500},"banner-772x250.gif":{"filename":"banner-772x250.gif","revision":3314980,"resolution":"772x250","location":"assets","locale":"","width":772,"height":250},"banner-772x250.png":{"filename":"banner-772x250.png","revision":3313877,"resolution":"772x250","location":"assets","locale":"","width":772,"height":250}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0","1.1","1.2","1.3","1.4","1.5","1.6","1.6.1","1.7","1.7.1","1.8","1.8.1","1.8.2","1.9","1.9.1","1.9.2","1.9.3","1.9.4","1.9.5","1.9.6","1.9.7","1.9.8","1.9.9","2.0.0","2.0.1","2.0.10","2.0.2","2.0.3","2.0.4","2.0.5","2.0.6","2.0.7","2.0.8","2.0.9","2.1.0","2.2.0","2.2.1","2.2.2"],"block_files":[],"assets_screenshots":{"screenshot-1-old.png":{"filename":"screenshot-1-old.png","revision":3127925,"resolution":"1","location":"assets","locale":"old","width":1171,"height":655},"screenshot-1.png":{"filename":"screenshot-1.png","revision":3698023,"resolution":"1","location":"assets","locale":"","width":2560,"height":1534},"screenshot-10.png":{"filename":"screenshot-10.png","revision":3311365,"resolution":"10","location":"assets","locale":"","width":854,"height":1135},"screenshot-11.png":{"filename":"screenshot-11.png","revision":3311366,"resolution":"11","location":"assets","locale":"","width":859,"height":752},"screenshot-12.png":{"filename":"screenshot-12.png","revision":3311367,"resolution":"12","location":"assets","locale":"","width":859,"height":958},"screenshot-13.png":{"filename":"screenshot-13.png","revision":3311368,"resolution":"13","location":"assets","locale":"","width":861,"height":734},"screenshot-14.png":{"filename":"screenshot-14.png","revision":3311496,"resolution":"14","location":"assets","locale":"","width":1201,"height":1461},"screenshot-15.png":{"filename":"screenshot-15.png","revision":3311370,"resolution":"15","location":"assets","locale":"","width":1366,"height":657},"screenshot-2-old.png":{"filename":"screenshot-2-old.png","revision":3127926,"resolution":"2","location":"assets","locale":"old","width":1189,"height":1337},"screenshot-2.png":{"filename":"screenshot-2.png","revision":3311353,"resolution":"2","location":"assets","locale":"","width":1202,"height":3965},"screenshot-3.png":{"filename":"screenshot-3.png","revision":3311489,"resolution":"3","location":"assets","locale":"","width":1202,"height":3131},"screenshot-4.png":{"filename":"screenshot-4.png","revision":3311492,"resolution":"4","location":"assets","locale":"","width":1205,"height":2399},"screenshot-5.png":{"filename":"screenshot-5.png","revision":3311494,"resolution":"5","location":"assets","locale":"","width":1202,"height":2001},"screenshot-6.png":{"filename":"screenshot-6.png","revision":3311360,"resolution":"6","location":"assets","locale":"","width":1202,"height":550},"screenshot-7.png":{"filename":"screenshot-7.png","revision":3311362,"resolution":"7","location":"assets","locale":"","width":1217,"height":471},"screenshot-8.png":{"filename":"screenshot-8.png","revision":3311363,"resolution":"8","location":"assets","locale":"","width":1218,"height":487},"screenshot-9.png":{"filename":"screenshot-9.png","revision":3311364,"resolution":"9","location":"assets","locale":"","width":1216,"height":488}},"screenshots":{"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"}},"plugin_section":[],"plugin_tags":[227543,25296,154364,286,51651],"plugin_category":[45,59],"plugin_contributors":[190650,190649],"plugin_business_model":[216238],"class_list":["post-131199","plugin","type-plugin","status-closed","hentry","plugin_tags-export-woocommerce-products","plugin_tags-google-sheets","plugin_tags-order-export","plugin_tags-woocommerce","plugin_tags-woocommerce-export","plugin_category-ecommerce","plugin_category-utilities-and-tools","plugin_contributors-arpitgshah","plugin_contributors-creativewerkdesigns","plugin_business_model-commercial","plugin_committers-creativewerkdesigns"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/wpsyncsheets-woocommerce_81a0ec.svg","icon_2x":false,"generated":true},"screenshots":[{"src":"https:\/\/ps.w.org\/wpsyncsheets-woocommerce\/assets\/screenshot-1.png?rev=3698023","caption":"Google API Integration Settings"},{"src":"https:\/\/ps.w.org\/wpsyncsheets-woocommerce\/assets\/screenshot-2.png?rev=3311353","caption":"WooCommerce Order Export Settings"},{"src":"https:\/\/ps.w.org\/wpsyncsheets-woocommerce\/assets\/screenshot-3.png?rev=3311489","caption":"WooCommerce Product Export Settings"},{"src":"https:\/\/ps.w.org\/wpsyncsheets-woocommerce\/assets\/screenshot-4.png?rev=3311492","caption":"WooCommerce Customer Export Settings"},{"src":"https:\/\/ps.w.org\/wpsyncsheets-woocommerce\/assets\/screenshot-5.png?rev=3311494","caption":"WooCommerce Coupon Export Settings"},{"src":"https:\/\/ps.w.org\/wpsyncsheets-woocommerce\/assets\/screenshot-6.png?rev=3311360","caption":"WooCommerce Order Enable Settings"},{"src":"https:\/\/ps.w.org\/wpsyncsheets-woocommerce\/assets\/screenshot-7.png?rev=3311362","caption":"WooCommerce Product Enable Settings"},{"src":"https:\/\/ps.w.org\/wpsyncsheets-woocommerce\/assets\/screenshot-8.png?rev=3311363","caption":"WooCommerce Customer Enable Settings"},{"src":"https:\/\/ps.w.org\/wpsyncsheets-woocommerce\/assets\/screenshot-9.png?rev=3311364","caption":"WooCommerce Coupon Enable Settings"},{"src":"https:\/\/ps.w.org\/wpsyncsheets-woocommerce\/assets\/screenshot-10.png?rev=3311365","caption":"WooCommerce Order Default Sheet Headers"},{"src":"https:\/\/ps.w.org\/wpsyncsheets-woocommerce\/assets\/screenshot-11.png?rev=3311366","caption":"WooCommerce Product Default Sheet Headers"},{"src":"https:\/\/ps.w.org\/wpsyncsheets-woocommerce\/assets\/screenshot-12.png?rev=3311367","caption":"WooCommerce Customer Default Sheet Headers"},{"src":"https:\/\/ps.w.org\/wpsyncsheets-woocommerce\/assets\/screenshot-13.png?rev=3311368","caption":"WooCommerce Coupon Default Sheet Headers"},{"src":"https:\/\/ps.w.org\/wpsyncsheets-woocommerce\/assets\/screenshot-14.png?rev=3311496","caption":"General Settings"},{"src":"https:\/\/ps.w.org\/wpsyncsheets-woocommerce\/assets\/screenshot-15.png?rev=3311370","caption":"Google Spreadsheet Orders"}],"raw_content":"\n
WPSyncSheets For WooCommerce<\/a><\/strong> automatically exports and syncs your WooCommerce orders, products, customers, and coupons to Google Sheets<\/strong> 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.<\/p>\n\n If you are looking for a WooCommerce Google Sheets Connector<\/a><\/strong> 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.<\/p>\n\n Demo<\/a> | Sample Sheets<\/a> | Docs<\/a> | Support<\/a> | Pro<\/a><\/p>\n\n \u279c Real-time<\/strong> import & export of WooCommerce orders to Google Sheets\n\u279c Separate, automatically created sheet tabs<\/strong> for each data type\n\u279c Share without giving admin access<\/strong> \u2014 send a sheet link to your accountant, VA, or supplier\n\u279c Local CSV & Excel (.xlsx)<\/strong> import and export\n\u279c Bulk-friendly<\/strong> \u2014 read and filter thousands of rows in Sheets instead of paging through wp-admin\n\u279c Interactive setup wizard and one-click Google Sheets connection<\/strong>\n\u279c 100% HPOS compatible<\/strong>, multisite ready<\/p>\n\n WooCommerce to Google Sheets Integration<\/a><\/strong>\nConnect WooCommerce with Google Sheets<\/strong> and export store data in real time. Create a new spreadsheet or select an existing one, let the plugin add a dedicated tab for orders, products, customers, and coupons, and choose exactly which columns are written. Data is synced using secure Google authentication, and no Google account or Drive data is stored by the plugin author.<\/p><\/li>\n Import & Export WooCommerce Orders by Status<\/strong>\nExport 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\"<\/strong> action pushes all of your existing orders into the connected sheet in one go, and every new order after that is appended automatically.<\/p><\/li>\n Import & Export Product Types, Customers & Coupons<\/strong>\nExport simple, variable, grouped, and external products<\/strong>, 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.<\/p><\/li>\n CSV & Excel Import Export with Validation Preview<\/strong>\nImport and export WooCommerce orders, products, customers, and coupons as local CSV or Excel (.xlsx)<\/strong> files. A smart validation preview shows valid versus error row counts before anything is written to your store, and chunked background processing<\/strong> keeps large files from triggering server timeouts (504 errors).<\/p><\/li>\n Modern Dashboard & Guided Setup<\/strong>\nAn 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. Headers can be enabled, disabled, or renamed per data type from the settings screens.<\/p><\/li>\n<\/ul>\n\n Demo Link: Open Demo<\/a><\/p>\n\n Sample Google Sheets (view exported data):\nExported Orders<\/a>\nExported Products<\/a>\nExported Customers<\/a>\nExported Coupons<\/a><\/p>\n\n To test the demo store: add any product to the cart, proceed to checkout, place the order with real or test billing details, then click \"View Your Orders in Spreadsheet\"<\/strong> to see the data land in Google Sheets.<\/p>\n\n Step 1 \u2013 Install & Activate<\/strong>\nInstall and activate the plugin. You will find the WPSyncSheets For WooCommerce<\/strong> menu in your WordPress admin.<\/p><\/li>\n Step 2 \u2013 Connect Google<\/strong>\nOpen the API Integration<\/strong> 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.<\/p><\/li>\n Step 3 \u2013 Configure Export Settings<\/strong>\nCreate new or select existing spreadsheet to use, then enable the data types you want (orders, products, customers, coupons) and adjust the sheet headers for each.<\/p><\/li>\n Step 4 \u2013 Click to Sync<\/strong>\nUse \"Click to Sync\"<\/strong> 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.<\/p><\/li>\n<\/ul>\n\n Written walkthroughs for the most common WooCommerce and Google Sheets workflows:<\/p>\n\n How to Export WooCommerce Orders to Google Sheets Automatically<\/a><\/p><\/li>\n How to Import WooCommerce Orders to Google Sheets<\/a><\/p><\/li>\n Real-Time Sync of WooCommerce Order Status to Google Sheets<\/a><\/p><\/li>\n Bulk Product and Order Management in WooCommerce<\/a><\/p><\/li>\n How to Bulk Edit WooCommerce Product Prices for a Sale<\/a><\/p><\/li>\n How to Use Google Sheets as Your WooCommerce Inventory Control Center<\/a><\/p><\/li>\n Google Sheets vs the WooCommerce Default Dashboard: Which Is Better for Store Management?<\/a><\/p><\/li>\n How to Automatically Sync WordPress Data to Google Sheets<\/a><\/p><\/li>\n How to Build a Marketing Dashboard from WordPress Data Using Google Sheets<\/a><\/p><\/li>\n How to Turn Your WordPress Data into AI-Powered Insights with Google Sheets<\/a><\/p><\/li>\n<\/ul>\n\n Browse every tutorial on the WPSyncSheets Blog<\/a>.<\/p>\n\n Unlock two-way syncing with WPSyncSheets For WooCommerce Pro<\/a><\/strong>:<\/p>\n\n \u2705 All free features<\/strong> \u2013 data export, bulk export, CSV\/Excel import export\n \u2705 Import orders, products, customers, coupons & events<\/strong> from Google Sheets to WooCommerce\n \u2705 Bulk import<\/strong> of orders, products, coupons, customers, and events\n \u2705 Auto field mapping<\/strong> between WooCommerce and Google Sheets\n \u2705 Custom sheet headers<\/strong> \u2013 enable, disable, or create your own\n \u2705 Add, modify, and delete<\/strong> store data directly inside Google Sheets\n \u2705 Scheduled imports and exports<\/strong> at your own intervals\n \u2705 Advanced filters<\/strong> to selectively import or export data\n \u2705 Date range export<\/strong> from WooCommerce to Google Sheets\n \u2705 Category-wise<\/strong> product import export and product attributes<\/strong> support\n \u2705 Custom field data<\/strong> from ACF Lite or Pro\n \u2705 Visual graphs<\/strong> generated inside Google Sheets\n \u2705 Freeze headers<\/strong> and change row background colours\n \u2705 Compatible with 45+<\/strong> popular WooCommerce and WordPress plugins\n \u2705 Multisite support<\/strong><\/p>\n<\/blockquote>\n\n Pro sample sheets: Products Sold Bar Graph<\/a> | Total Orders Line Graph<\/a><\/p>\n\n You can check out the user guide<\/a><\/strong> to set up the plugin, or watch the videos below.<\/p>\n\n https:\/\/www.youtube.com\/watch?v=jh5ErgluSVU<\/p>\n\n https:\/\/www.youtube.com\/watch?v=00cNpysSQz0<\/p>\n\n https:\/\/www.youtube.com\/watch?v=AZqM9stSKWg<\/p>\n\n https:\/\/www.youtube.com\/watch?v=VVK-4b0W2zc<\/p>\n\n Trusted by online retailers, developers, and marketing teams globally to streamline WooCommerce data management. Subscribe to the WPSyncSheets Newsletter<\/a> for tips, updates, and exclusive discounts.<\/p>\n\n 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<\/a> for the full list.<\/p>\n\n This plugin connects to the following external services. No data is sent to any of them until you take the action described.<\/p>\n\n Used to create spreadsheets and sheet tabs, write and update rows, and list the spreadsheets you have shared with the plugin. WooCommerce order, product, customer and coupon data that you enable for export is sent to the spreadsheet you select, each time a record is created or updated and when you run a manual or test sync. The plugin requests only the Used only when you choose the one-click \"Connect with Google\" option. It registers your site so Google can return you to it after authorization, exchanges the authorization code for tokens, refreshes access tokens when they expire, and revokes the connection when you disconnect. It sends your site URL, home URL, the plugin version, a random installation ID generated by the plugin, and the OAuth code or refresh token issued by Google. It is not used when you connect with your own Google client ID and secret.\nProvider: Creative Werk Designs (WPSyncSheets). Terms and Conditions<\/a>, Privacy Policy<\/a>.<\/p>\n\n Used only if you choose to submit the optional feedback form shown when deactivating the plugin, and only after you tick the consent box. It sends the reason you selected, your message, the plugin name and version, the site administrator email address and the site URL.\nProvider: Creative Werk Designs (WPSyncSheets). Terms and Conditions<\/a>, Privacy Policy<\/a>.<\/p>\n\n All JavaScript and CSS shipped with this plugin is unminified, human-readable source; there is no build step. The bundled For basic usage, have a look at the plugin's Documentation<\/a>.<\/p>\n\n\n This is usually a connection or permission problem. Check that the Google account is still authenticated, that both Google Drive<\/strong> and Google Sheets<\/strong> 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.<\/p><\/dd>\n Yes, the plugin can export WooCommerce products with images from your WooCommerce store to Google Sheets.<\/p><\/dd>\n Yes, the plugin supports the export of variation products from your WooCommerce store into Google Sheets.<\/p><\/dd>\n Yes, the plugin can export WooCommerce customers and coupons into Google Sheets.<\/p><\/dd>\n Yes. Order export can be filtered by WooCommerce order status, so you can keep processing, completed, or refunded orders in their own view.<\/p><\/dd>\n 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.<\/p><\/dd>\n 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.<\/p><\/dd>\n Headers can be enabled or disabled for each data type in the free version. Renaming, custom headers, freezing headers, and row colours are available in the Pro Version<\/a>.<\/p><\/dd>\n Yes, the plugin is 100% HPOS compatible.<\/p><\/dd>\n Yes, the plugin supports multisite exports to Google Sheets.<\/p><\/dd>\n\ud83d\ude80 Why Use This Plugin?<\/h4>\n\n
WPSyncSheets For WooCommerce Features<\/h4>\n\n
\n
\ud83e\uddea Check Live Demo<\/h4>\n\n
\ud83d\udccc How to Use this Plugin<\/h4>\n\n
\n
\ud83d\udcd6 Step-by-Step Guides<\/h4>\n\n
\n
\ud83d\udd12 Upgrade to Pro<\/h4>\n\n
\n
How to Export WooCommerce Orders?<\/h4>\n\n
How to Export WooCommerce Products?<\/h4>\n\n
How to Export WooCommerce Customers?<\/h4>\n\n
How to Export WooCommerce Coupons?<\/h4>\n\n
\ud83d\udce3 Trusted by Over 10,000+ Customers<\/h4>\n\n
Other WPSyncSheets Plugins<\/h4>\n\n
External services<\/h3>\n\n
Google Sheets API and Google Drive API<\/h4>\n\n
drive.file<\/code> scope, so it can access spreadsheets it created or that you explicitly picked. The Google Picker script (apis.google.com) is loaded on the plugin settings and setup wizard screens so you can choose a spreadsheet.\nProvider: Google LLC. Google Terms of Service<\/a>, Google APIs Terms of Service<\/a>, Google Privacy Policy<\/a>.<\/p>\n\nWPSyncSheets OAuth relay (api.wpsyncsheets.com)<\/h4>\n\n
WPSyncSheets feedback service (feedback.wpsyncsheets.com)<\/h4>\n\n
Source code<\/h3>\n\n
assets\/js\/wpsslw-ui.js<\/code> is an unmodified custom build of jQuery UI 1.12.1<\/a> (its source is at github.com\/jquery\/jquery-ui<\/a>). PHP libraries under lib\/vendor<\/code> are installed with Composer from lib\/composer.json<\/code>; run composer install --no-dev<\/code> inside lib\/<\/code> to rebuild them.<\/p>\n\n\n\n
wpsyncsheets-woocommerce<\/code> folder to the \/wp-content\/plugins\/<\/code> directory, OR go to Plugins > Add New > Search<\/strong> and search for \"WPSyncSheets For WooCommerce\".<\/li>\n\n
My new orders are not showing up in the connected Google Sheet.<\/h3><\/dt>\n
Can the plugin export WooCommerce products with images?<\/h3><\/dt>\n
Does the plugin support the export of variation products?<\/h3><\/dt>\n
Does the plugin export WooCommerce customers and coupons?<\/h3><\/dt>\n
Can I export only orders with a specific status?<\/h3><\/dt>\n
Can I import CSV or Excel files into WooCommerce?<\/h3><\/dt>\n
My import keeps failing or times out on large files.<\/h3><\/dt>\n
Can I rename or reorder the sheet headers?<\/h3><\/dt>\n
Is the plugin compatible with HPOS (High-Performance Order Storage)?<\/h3><\/dt>\n
Does the plugin support multisite?<\/h3><\/dt>\n
Does the plugin export posts, pages, and custom post types?<\/h3><\/dt>\n