WooCommerce Google Sheet Connector Pro
- Ratings :
WooCommerce Google Sheet Connector is the easiest way to set up a Google Sheets WooCommerce integration on your WordPress store. It's a powerful, flexible connector plugin that acts as a bridge between WooCommerce and Google Sheet. GSheetConnector For the WooCommerce plugin syncs your WooCommerce Orders, Products, Customers, Coupons, and Events to a single Google Spreadsheet.
- WooCoomerce Orders within one single Google Sheet
- Auto Order ID / Edit Orders – Order wise data
- Enable / Disable Sheet Headers, Edit Sheet Headers – Freeze Headers
- Manage all orders in a single sheet with all 7 order status.
- Each status will create separate sheets and automatically orders based on the order ID
- Sync Orders, Background Row Color, Download & Sync Spreadsheet
- Secure and latest google library.
You have to install and activate the WooCommerce plugin before using GSheetConnector For WooCommerce!
If You haven’t installed WooCommerce, please navigate to WooCommerce Installation Documentation.
- 11 Reviews Read Reviews
- Active Installed 11376+
- Latest Version
2.1.14 Change log - 14 Days Refund Policy
- 24×7 Support
- 55K+ Happy Customer
## [2.1.14]
## [2.1.13]
* Improved: Optimized bundled library files by including only the required components.
* Fixed: Improved compatibility with PHP 8.x versions.
## [2.1.12]
## [2.1.11]
## [2.1.10]
## [2.1.9]
## [2.1.8]
## [2.1.5]
## [2.1.3]
## [2.1.2]
- Fixed: Syntax error under Feed Subscription File.
## [2.1.1]
## [2.1.0]
## [2.0.39]
## [2.0.38]
## [2.0.37]
## [2.0.36]
## [2.0.33]
## [2.0.32]
## [2.0.31]
## [2.0.29]
## [2.0.28]
## [2.0.26]
* Resolved: A syntax error that occurred when the Woo Subscriptions plugin was activated.
* Fixed: An issue where order sync failed for sheets containing more than 26 columns (AA, AB, etc.) when using descending sorting.
* Fixed: Duplicate order entries when updating WooCommerce orders containing multiple products.
* Fixed: An issue where updating the WooCommerce order status created duplicate sheet entries for multi-item orders.
* Added dynamic setup recommendations for Automatic and Manual Google account connection methods based on the connected email domain, helping users choose the most suitable syncing option.
* Added separate sheet fetch timestamp tracking for Automatic, Manual, and Service Account connection methods.
* Added a database-based debug logging system for improved issue tracking and troubleshooting.
* Added onboarding guidance for authentication configuration.
* Added 2-way sync functionality in the WooCommerce Data Settings tab.
* Added a new Dashboard tab for improved plugin navigation and management.
* Added a new Extensions tab.
* Added a slider-based admin notification system with interactive notice handling.
* Added compatibility with the Payment Gateway Based Fees and Discounts for WooCommerce plugin.
* Added compatibility for 2-way sync (Google Sheets to WooCommerce) with the ATUM Inventory Management for WooCommerce plugin.
* Improved License tab functionality with proper license activation/deactivation handling, expiration management, and enhanced status and error message displays.
* Improved the Last Fetched Date display to follow WordPress date and time settings.
* Redesigned the plugin UI for a cleaner and more user-friendly experience.
* Enhanced authentication error handling with clearer guidance for users.
* Improved admin notifications for better clarity and usability.
* Performed overall code optimization and performance improvements.
* Fixed an issue where the Order Paid Date was using server time instead of the WordPress store timezone. * Fixed the exported value now correctly reflects the store’s local time in Google Sheets.
* Fixed a blank screen issue that occurred in the Settings page on multisite installations.
* Fixed an issue where orders with custom order statuses were not being synced to Google Sheets.
- Added: Compatible with ATUM Inventory Management for WooCommerce plugin.
- Fixed: Optimized cron execution for improved performance and faster data synchronization.
- Added: Support for language-based tab name translations in WooCommerce data settings.
- Fixed: Issue where feed creation did not work correctly for translated locations.
- Fixed: Sorting issue in the order feed.
- Fixed: Sync issue between the Order feed and Product feed.
- Fixed: Issue where coupon discounts were applied after the product price, causing incorrect display of the price.
- Added: Compatibility with the Meta Box AIO plugin (https://metabox.io/).
- Added: Compatibility with the PDF Invoices & Packing Slips for WooCommerce plugin (https://wpovernight.com/downloads/woocommerce-pdf-invoices-packing-slips-bundle/).
- Fixed: The Order Created Date value in the sheet to use the local timezone.
- Fixed: Revert the code changes related to language-based sheet tab translations.
## [2.1.7]
- Fixed: Issue with language-based sheet tab translations for existing users.
## [2.1.6]
- Added: Scheduled cron functionality to handle background tasks asynchronously and avoid frontend execution.
- Added: New “Extra Header Related to Order Product Variations” dropdown option in the Orders Header tab.
- Fixed: Issue with Product Variation Stock Quantity during two-way product synchronization.
- Fixed: Problem where language-based sheet tabs and headers were not created correctly in Google Sheets.
- Fixed: Incorrect formatting of phone numbers (e.g. +234 906 468 7777) in Google Sheets.
- Fixed: New order not getting placed and orders not getting updated when user setup orderwise data saving settings.
## [2.1.4]
- Added: Plugin Name and Integration Method have been added under the System Status tab.
- Added: Compatible with Extra Product Options Builder for WooCommerce Pro plugin.
- Fixed: Display Last Fetch Date in WordPress General Settings using the site’s timezone format.
- Fixed: UI design updates.
- Fixed: License text message updates.
- Fixed: Moved logs to the uploads folder for better file organization.
- Fixed: Issue where the \'Create New\' sheet option is hidden when using the Existing or Manual method of integration.
- Fixed: Syntax error under Feed Subscription File.
- Fixed: Issue where the Authorized Domain and Authorized Redirect URIs copied are not working in the manual integration method.
- Added: 2-way sync functionality for Products Variation and Customers, Coupons under the Feed Settings.
- Added: Service Account as a new Integration method.
- Fixed: Product Sync under Woocommerce Data Settings and Feed Settings.
- Fixed: \"product type\" update for 2-way sync under Feed Settings and Sync Tab.
- Fixed: Incorrect product variation values saved under the Orders sheet.
- Fixed: Not inserting data after 1000 rows limit reached in the Google Sheet.
- Fixed: Custom blank header not saving blank values if added in middle of the header columns.
- Added: an option to preserve HTML fields (no sanitization) for the product description and short description.
- Added: \"Product Name (Qty) (SKU)\" as a default option in the \"Extra Header Related To Order\'s Product\" dropdown.
- Added: 2-way sync functionality for Orders and Products in the feed settings.
- Added: UI changes.
- Removed: the DRIVE_METADATA_READONLY permission and add the DRIVE_FILE permission in the manual integration method.
- Fixed: synchronization issues in the order, product, customer, coupon, and product variation feeds.
- Fixed: the incorrect values showing in the Google Sheet for Customer Total Orders, Customer Total Revenue, and Customer Average Order Value fields.
- Added: The \"author\" column to the Feed Settings.
- Added: Saving of credentials to database for Auto API Integration.
- Added: When a Product is trashed, restored, or deleted in WooCommerce, the same action should be reflected in the Google Sheet.
- Fixed: Not inserting data after 1000 rows limit reached in the Google Sheet.
- Fixed: Displaying the License Expiration Date on License Page.
- Fixed: Sortable functionality for product headers, product variation headers, customer headers, coupon headers, and subscription headers.
- Fixed: Errors while creating the Feeds.
- Fixed: Custom Fields toggle on/off and delete issue.
- Fixed: Issue with the Custom Product Addon plugin\'s data not displayed when row management is set to Order Wise.
- Fixed: Entries not syncing to the sheet due to slashes apperaing in the field list for \"Extra Header Related To Order\'s Product\" under Orders Header settings.
- Added: Feed Settings tab for connecting with multisheet and also aggregated sheet for orders, products, variations, coupons and customers.
- Added: Settings to reset and delete all data from the database upon uninstallation.
- Added: Redirect URI and Debug Log options for improved debugging and authentication.
- Added: Enhanced 2-way sync for inserting products with third-party WooCommerce plugins.
- Fixed: Issue with the \"Product Height\" and \"Product Weight\" fields in the \"All Products\" Sheet.
## [2.0.35]
- Added: Product URL field in order settings.
- Fixed: Custom Fields toggle on/off and delete issue.
- Fixed: Error while syncing the products.
## [2.0.34]
- Added: Compatibility with plugin CURCY - WooCommerce Multi Currency Premium.
- Added: Dispatched Date and Order Complete Date for plugin WooCommerce Shipping Tracking.
- Fixed: Error while syncing the orders.
- Fixed: Order data not getting saved to the sheet correctly on Bulk Action status change from the Orders page.
- Fixed: Undefined error while clicking the \"Copy to Clipboard\" button on the System Info page.
- Added: Additional Headers for the Products Header Tab.
- Fixed: The issue with creating a new spreadsheet.
- Added: Compatibility with Stock Manager for WooCommerce plugin.
- Fixed: The synchronization issue with the All Orders tab.
- Fixed: Issue with the extra header related to the Order Image URL in the Google Sheet.
- Fixed: Issue with updating Product SKU.
- Fixed: Issue with product variation synchronization.
- Fixed: Issue with coupon synchronization.
- Fixed: Update not showing up since version 2.0.19.
- Fixed: Customer Total Orders, Customer Total Revenue, and Customer Average Order values are showing incorrectly in the Order Sheet.
## [2.0.30]
- Added: Fields for Customer Total Orders, Customer Total Revenue, and Customer Average Order Value in the Orders Header.
- Added: Products Category Filter Wise Order Sync Functionality.
- Added: Insert the Order and details from a Google Sheet to WooCommerce from the \"All Orders\" sheet.
- Fixed: Custom Fields toggle on/off and delete issue.
- Added: Update the Order Status and details from a Google Sheet to WooCommerce from the \"All Orders\" sheet.
- Added: Insert debugging constants into the configuration file while enabling from System Status.
- Fixed: Updating image paths in the 2-way product synchronization process.
- Added: Create or Update Products from Google Sheet to WooCommerce with default WooCommerce fields.
- Added: Compatibility with YITH WooCommerce Multi Vendor Premium plugin.
- Added: Compatibility with Fooevents Custom Attendee Fields plugin.
- Added: Enabled or Disabled the Wordpress Debug Log if already defined in the config file.
- Added: Product Tax field in order settings.
- Added: Product Sale Price field in product settings.
- Added: Displayed the \"Product Category Filter\" When the user selects the \"All Products\" tab.
- Added: UI Changes.
- Fixed: Custom Fields toggle on/off and delete issue.
- Fixed: The save button only appears after saving the license key.
- Fixed: Product Variation Stock value 0 saved in google sheet.
- Fixed: Product Variation field showing incorrect values in the order sheet.
### Added
- Added a new Toggle to enable the WooCommerce Subscriptions Sheet to enable the extra fields in individual sheets, along with the Sync feature, which will be shown if using the Subscription official addon.
### Fixed
- Fixed Remove products on \"On Hold\" Status from the backend and updated to sheet accordingly.
- Fixed multiple add order item save issues in the sheet.
- Fixed display issue for Custom Static Blank Headers field after save.
- Fixed uninstallation of plugin.
## [2.0.25]
### Added
- Added Extra Header Related To Orders for Additional fields for single entry and sync for both product wise and order wise settings.
### Fixed
- Solved Product sync issues for more than 100 products.
### Added
- Compatibility with JetEngine WooCommerce addon plugin for date format from \"integer value to date\".
- Compatibility with Checkout Field Editor (Checkout Manager) for the WooCommerce addon plugin.
### Fixed
- Formatted text from HTML to normal text for Product description and Product Short Description while saving on Google Sheet.
- Solved minor errors when users reset password.
### Added
- Added Debug Logs tab.
### Fixed
- Changed the Layout of the Woocommerce Data Settings tab.
## [2.0.22]
### Added
- Custom order status to Google Sheet.
- Coupons module.
- Coupons Sync functionality.
- Custom static headers and blank headers.
### Fixed
- Undefined offset issues.
- Order Sync error.
- When the product is updated, the All products variation sheet is also updated.
### UI Changed
- Changed Layout of Google Sheet Settings page.
## [2.0.21]
### Fixed
- Plugin clashing while adding new user data.
### Fixed
- Plugin clashing while adding new user data.
### Fixed
- The page hangs while adding product variation attributes.
- Error while creating product variations and saving them.
- Twice entry getting saved in sheet when orderwise setting gets updated.
### Added
- Add Product Category Filter Wise Sync Functionality.
- Redesigned plugin Debug log, System Status and WordPress debug log view for improved functionality and user experience.
- For users without Google Drive and Google Sheets, permissions Authentication displayed an alert with a message.
- Changed the Layout of the Role Settings Tab.
- Updated Library Version to 2.12.6.
- When the user clicks the \"All Products, All Products Variation, All Customers\" tab then
displayed \"Products Header, Products Variation Header, Customers Header\" respectively for Google Sheet headers(column name).
- The \"Beta Version\" tab enables users to preview upcoming updates and features to get updates for pre-release.
### Fixed
- Resolved clear button not working correctly in the system status tab.
- Resolved debugging view, open and close links systematically.
- Vulnerabilities issues.
- Multiple order placing saving multiple entries to Google Sheet.
- Error with table not exist.
- Error while syncing the Orders.
- Save button not displaying for activating plugin License.
- Made compatible with WooCommerce Subscriptions plugin ( https://woocommerce.com/products/woocommerce-subscriptions/ )
- Removed Duplicate Code For Checkout Fields Manager for WooCommerce - By QuadLayers.
- Solved additional fields delete icon, and colouring along with the fields key.
- Filter to Sync orders by order status.
- Fetched meta values of the plugin \"Web Expert WooCommerce Skroutz & BestPrice XML Feed\" to extra headers.
- Authorization control by hiding the button when the user is not authenticated.
- System Status to know essential information for debugging.
- Solved Conflict CSS Issue in heading names.
- Updated products while adding and updating the orders.
- Sync functionality added for variation product.
- Added new field \"Order Total (Excl. Shipp. Charges and Other Fees)\" in order headers
- Fixed Product stock issue.
- Fixed product header update and edit issue.
- Resolved a few compatibility issues.
## [2.0.15]
- Added new functionality to remove extra headers from the setting panel.
- Fixed vulnerabilities issue.
- Fixed Converting an array with random format into a string for dynamic headers.
- Fixed Product stock and Product SKU not getting saved on the Google Sheet.
## [2.0.14] - 16-05-2023
- Added a new feature for adding order header dynamically for any 3rd party woocommerce plugins.
- Removed the duplicate \"Regular Product price\" field from the product header.
- Fixed undefined offset issues.
## [2.0.13] - 06-04-2023
- Added check to make compatibility code only work on the setting panel.
- Solved compatible issues with \"Checkout Fields Manager for WooCommerce\" - By QuadLayers
- Solved compatibility issue with custom hooks.
- Solved undefined array offset error.
- Solved undefined error while adding customer headers
- Compatible plugins with - WooCommerce Conditional Product Fields at Checkout - By Lagudi Domenico (https://www.gplgood.com/downloads/woocommerce-conditional-product-fields-at-checkout/).
- Added Setting for orders to fill entries in ascending and descending order.
- Added two Custom hooks for adding a new column of Order Header \"get_external_headers\" and Product Header \"get_ext_product_order_headers\".
