=== GSheetConnector – WooCommerce Google Sheets Connector, Export Orders & Products to Google Sheets in Real-Time ===
Contributors: westerndeal, abdullah17
Author URI: https://www.gsheetconnector.com/
Tags: woocommerce, google sheets, woocommerce export, order export, integration
Requires at least: 5.3
Tested up to: 7.1
Requires PHP: 7.4
Stable tag: 1.5.0
License: GPLv2 or later
License URI: http://www.gnu.org/licenses/gpl-2.0.html

WooCommerce Google Sheet Connector automatically syncs orders, products, customers, coupons, and variations to Google Sheets.

== Description ==

GSheetConnector for WooCommerce is a powerful and easy-to-use Google Sheets integration plugin that connects your WooCommerce store directly with Google Sheets. Automatically sync WooCommerce orders, products, customers, and more into a Google Spreadsheet to organize, analyze, and manage your store data efficiently.

With real-time data sync, every new WooCommerce order is instantly added as a new row in your selected Google Sheet. You can also create separate tabs based on order status (Processing, Completed, Pending, Cancelled, Refunded) for better tracking and reporting.

This plugin is perfect for store owners, marketing teams, and accounting departments who want a simple and reliable way to maintain WooCommerce order data for reporting, analytics, inventory planning, and team collaboration.

### 🚀 Why Use This Plugin?

➜ Real-time sync of WooCommerce orders to Google Sheets  
➜ Sync Products, Product Variations, Coupons, and Customers  
➜ Automatically create separate sheets tabs based on order status  
➜ Customize and organize column headers in Google Sheets  
➜ Simple and secure Google account authentication  
➜ Debug logs for quick troubleshooting  

- **[Documentation](https://www.gsheetconnector.com/docs/woocommerce-gsheetconnector) | [Support](https://www.gsheetconnector.com/support) | [Demo](https://woogsheets.gsheetconnector.com/) | [WooCommerce Google Sheet Connector PRO](https://www.gsheetconnector.com/woocommerce-google-sheet-connector-pro)**

### 🧪 Check Live Demo

Demo Link: [Open Demo](https://woogsheets.gsheetconnector.com/)

Google Sheet (View Submitted Data): [View Sheet](https://docs.google.com/spreadsheets/d/1BLkcJLk8bQvSSuIRPHXLDnSNBNmrEVGZ2o44x5uZVlI/edit#gid=1091708451)

= How to Use this Plugin =

* **Step: 1 - [In Google Sheets](https://sheets.google.com/)** 
➜ Log into your Google Sheets.  
➜ Create a new sheet and name it. ( You can also select existing sheet while setting the connection as per Step 3).

* **Step: 2 - In WordPress Admin**
➜ Navigate to WooCommerce > Google Sheet > Integration Tab
➜ Authenticate with Google using new "Google Access Code" while clicking on "Get Code"
➜ Make Sure to ALLOW Google Permissions for Google Drive and Google Sheets and then copy the code and paste in Google Access Code field, and Hit Save & Authenticate.
➜ Now fetch the sheet details by clicking "Click here to fetch Sheet details to be set at WooCommerce settings."

* **Step: 3 - Connect with Google Sheet**
➜ Navigate to WooCommerce > Google Sheet > WooCommerce Data Settings.
➜ Select the appropriate Sheet from the "Google Sheet Name" dropdown box.
➜ Select WooCommerce Order Status to create Sheet Tabs and add headers to your selected Google Sheet.
➜ Lastly test by ordering any product and putting it to a different order states ( Processing, Hold etc).

### 🚀 Pro Plugin Features
➜ Sync all WooCommerce orders (default + custom order statuses) to Google Sheets in real time.
➜ Sync all Products, Product Variations, Coupons, and Customers.
➜ Sync existing orders, missed entries, and data based on order status or date range.
➜ Cron-based automatic syncing at user-defined time intervals.
➜ Bi-directional sync for Orders, Products, Variations, Coupons, and Customers (Google Sheet → WooCommerce).
➜ Sync Custom Fields and Meta Fields (including third-party plugin data).
➜ Choose from three different integration methods based on organizational needs.
➜ Create multiple feeds and send data to different Google Sheets as required.
➜ Create Individual feeds with individual sheets for Orders, Products, Products Variations, Users & Coupons
➜ 2-way Sync – Send data from Google Sheets to your WooCommerce store via the connected sheet.
➜ Easy tracking and monitoring through advanced error logs.
➜ Freeze headers, add header color, and apply odd/even row background colors in Google Sheets.
➜ Manage data row structure order-wise or product-wise.
➜ Filter and sync data based on selected product categories.
➜ Add and customize header names as needed.
➜ Compatible with 50+ popular WooCommerce add-on plugins.
<a href="https://www.gsheetconnector.com/wc-gsheetconnector-pro?wp-repo" target="_blank"><strong>🔒 Upgrade to Pro? Get it Now</strong></a>


### 🔗 Other Google Sheets Integrations

<strong>Contact Forms to Google Sheet Integration</strong>
[CF7 GSheetConnector Pro](https://www.gsheetconnector.com/cf7-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description)
[WPForms GSheetConnector Pro](https://www.gsheetconnector.com/wpforms-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description)
[Gravity Forms GSheetConnector Pro](https://www.gsheetconnector.com/gravity-forms-google-sheet-connector?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description)
[Ninja Forms GSheetConnector pro](https://www.gsheetconnector.com/ninja-forms-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description)
[Forminator Forms GSheetConnector Pro](https://www.gsheetconnector.com/forminator-forms-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description)
[Formidable Forms GSheetConnector Pro](https://www.gsheetconnector.com/formidable-forms-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description)
[Fluent Forms GSheetConnector Pro](https://www.gsheetconnector.com/fluent-forms-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description)

<strong>eCommerce to Google Sheet Integration</strong>
[WooCommerce GSheetConnector PRO](https://www.gsheetconnector.com/woocommerce-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description)
[GSheetConnector PRO for Easy Digital Downloads](https://wordpress.org/plugins/gsheetconnector-easy-digital-downloads?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description)

<strong>Page Builders to Google Sheet Integration</strong>
[Elementor Forms Google Sheet Connector](https://www.gsheetconnector.com/elementor-forms-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description)
[Avada Forms Google Sheet Connector](https://www.gsheetconnector.com/avada-forms-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description)
[DIVI Forms Google Sheet Connector](https://www.gsheetconnector.com/divi-forms-db-google-sheet-connector-pro?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description)
[GSheetConnector For Core](https://www.gsheetconnector.com/gsheetconnector-for-core?utm_source=wordpress.org&utm_medium=referral&utm_campaign=WPGSC&utm_content=plugin+repos+description)


== Installation ==

1. Upload "wc-gsheetconnector" to the "/wp-content/plugins/" directory, OR "Site Admin > Plugins > New > Search > GSheetConnector WooCommerce > Install`.  
2. Activate the plugin through the 'Plugins' screen in WordPress.  
3. Use the `Admin Panel > WooCommerce > Google Sheet > Integration` screen to connect to `Google Sheets` by entering the Access Code. You can get the Access Code by clicking the "Get Code" button. 
Enjoy!

== Screenshots ==

1. Google Sheet Integration Shown with Authentication along with Permissions.
2. Fetch Sheets.
3. Google Sheet Tab Creation as per order status and Google Sheet headers with form submitted data.
4. Role Settings.
5. Beta-version.
6. System Status.
7. Feed Settings.
8. 2way Sync.
9. Extensions.
10. 2 way sync settings.

== Frequently Asked Questions ==

= New Submitted Orders are not showing in my Configured Sheet? =

If the new submitted orders never shows in your Sheet then one of these things might be the reason:
1. Wrong access code or did not allowed permission to Google Drive and Google Sheets(Check debug log under Integration Tab)
Please double-check those items and hopefully getting them right will fix the issue.

= View Debug log is empty under Integration Tabs  =

Make sure to <a href="https://www.gsheetconnector.com/how-to-enable-debugging-in-wordpress">enable debug log from wp-config.php</a> if submitted order is not showing in sheet, It will helps to show the conflict issue (if there is any) or shows what is making an issue.

== Changelog ==

= 1.5.0 (28-10-2026) =
* Added: Service Account authentication support and related settings.
* Improved: Google Sheets connection status messages and Service Account email display in WooCommerce Data Settings.
* Fixed: Service Account compatibility with WooCommerce order synchronization.

= 1.4.12 (10-10-2026) =
* Updated: Freemius integration code and related files.
* Improved: Spreadsheet names in the "Choose Google Spreadsheet" dropdown are now displayed in alphabetical (A–Z), case-insensitive order.

= 1.4.11 (23-09-2026) =
* Added: Added Pro-only display blocks for Product Category as Sheet Tabs and Graph Sheets in the WooCommerce Data Settings tab.
* Added: Added Pro-only display support for premium features in the Extensions tab.
* Added: Added a Pro-only display block for Sync Orders (Product Category Tabs) in the Google Sheets Data Sync section.
* Fixed: An issue where variable product names could contain unfiltered HTML/non-breaking space characters around the - separator when exporting Product Name (QTY) (SKU) to Google Sheets.
* Fixed: Improved the display and activation/deactivation handling of Pro integrations in the Extensions tab.
* Fixed: An issue where the Copy Logs, Clear Logs, and Download CSV buttons were not working correctly in the System Status Debug Log section.

= 1.4.10 (06-08-2026) =
* Added: HPOS compatibility support for WooCommerce order data handling.
* Improved: Enhanced error handling across the WooCommerce sync process for better stability.
* Improved: Added additional validation to prevent potential runtime notices during order synchronization.
* Improved: Optimized Google Sheets API interactions by reducing redundant requests.
* Improved: Enhanced caching for Google Sheets header and account data to improve performance.
* Improved: Added capability checks to privileged AJAX actions for improved security.
* Fixed: Improved handling of order trash and restore events for both HPOS and legacy order storage.
* Fixed: Resolved compatibility issues with PHP 8.1 and WordPress 7.x.
* Fixed: Corrected Google Sheet permission badge rendering on the System Status page.
* Fixed: Removed invalid markup from the System Status page.
* Fixed: Corrected the download URL for the Fluent Forms extension.
* Fixed: Removed unused legacy debug log JavaScript code.
* Fixed: Various code quality, compatibility, and stability improvements.

= 1.4.9 (30-07-2026) =
* Added: Connected feeds table to the Dashboard for quick access to Google Sheet connections.
* Refactored: Improved overall code quality by removing unused code, consolidating duplicate logic, and updating inline documentation.
* Removed: Unused initialization methods related to error log management.
* Removed: Duplicate and unused role settings file.
* Improved: Consolidated error log table creation into a single reusable helper.
* Improved: Extracted WordPress Filesystem initialization into a reusable helper function.
* Improved: Removed redundant JSON decoding during the authentication process.
* Improved: Updated and corrected PHPDoc comments for improved code documentation.
* Cleaned: Removed obsolete development comments and legacy code annotations.

= 1.4.8 (18-06-2026) =
* Added: Admin notice slider for plugin announcements, review requests, upgrade prompts, and authentication reminders.
* Added: Dashboard tab for quick access to plugin information, notices, and settings.
* Improved: Optimized bundled library files by including only the required components.
* Fixed: Proper handling and display of error messages when required Google Sheets and Google Drive permissions are not granted in the Integration tab.
* Fixed: Improved handling of invalid OAuth tokens to prevent repeated debug log entries during page refresh.
* Fixed: Issues with Activate, Install, and Deactivate actions in the Extensions tab.
* Fixed: Improved compatibility with PHP 8.x versions.

= 1.4.7 (25-03-2026) =
* Fixed: Addressed all identified issues to improve overall stability and compliance.

= 1.4.6 (14-11-2025) =
* Added: "Next Steps…" section in the Integration tab.
* Updated: Updated the header logo and the dashboard widget logo.
* Fixed: Improved responsive CSS.

= 1.4.5 (19-09-2025) =
* Added: Feed settings for Pro features.
* Updated: Readme file.
* Updated: UI design improvements.

= 1.4.4 (23-07-2025) =
* Added: Extension tab added.
* Added: Debug logs file will be created under wp-upload folder.
* Moved freemius folder under Library folder insider vendor folder.

= 1.4.3 (16-07-2025) =
* Fixed: Solved  Licensing/Trademark issues in main plugin file and readme.
* Removed direct links to 5-star reviews to comply with WordPress plugin guidelines.
* Updated “Tested Up To” value to reflect compatibility with the latest WordPress version.
* Replaced static <script> and <link> tags with wp_enqueue_script and wp_enqueue_style for proper asset loading and dependency management.
* Eliminated all remote file inclusions to improve security and meet WordPress repository requirements.
* Removed plugin folder write operations and any instructions requiring users to manually edit/write files inside the plugin directory.
* Escaped all variables and options before outputting to the frontend or admin interface.
* Replaced generic function/class/constant/option names with properly prefixed versions to avoid naming collisions.
* Corrected text domain to match the plugin slug for consistent internationalization support.
* Blocked direct file access by adding appropriate file-level checks (e.g., defined( 'ABSPATH' ) || exit;).
* Implemented proper nonce verification and security best practices throughout AJAX and form submissions.
* Passed Plugin Check review with all critical issues resolved.

= 1.3.20 (21-04-2025) =
* Fixed: Connected Email display issue.

= 1.3.19 (19-04-2025) =
* Added: Moved saving of credentials to database for Auto API Integration.

= 1.3.18 (27-01-2025) =
* Fixed: Minor UI Changes.
* Added: Require plugins added.

= 1.3.17 (07-01-2025) =
* Added: A Dashboard Widget has been added.
* Added: Showcased the "Manual Method" button on the Integration tab.
* Added: The "Copy Log" button has been added.
* Fixed: Undefined error when clicking the "Copy to Clipboard" button in the System Info tab.
* Fixed: The issue with the Debug Log view and the close button has been fixed.

= 1.3.16 (27-07-2024) =
* Fixed: The issue of the Shipping Method Title Field displaying code in the sheet has been resolved.

= 1.3.15 (07-06-2024) =
* Fixed: Undefined error.

= 1.3.14 (04-04-2024) =
* Fixed: UI changes.
* Added: Added links for support,docs and upgrade to pro.

= 1.3.13 (20-02-2024) =
* Secured code from the Vulnerabilities.

= 1.3.12 (16-02-2024) =
* Fixed: Uninstallation of Plugin.
* Added: Pro features(Custom Order Status,Other Sheet Tabs to Enable,Custom Static Headers,Custom Static Blank Headers, Coupons Header,Subscriptions Header,Sync Coupons,Sync Subscriptions ) display on woocommerce data settings page and also Pro features display(Beta Version, Debug Logs)Tabs.

= 1.3.11 (29-12-2023) =
* Fixed : Fixed validate parent plugin exists or not then show alert message display issue.

= 1.3.10 (02-12-2023) =
* Added : Orders Header - Values ​​are shown in extra header related to order and extra header related to order's product option.

= 1.3.9 (17-10-2023) =
* Fixed : Undefined image path issue resolved.

= 1.3.8 (13-10-2023) =
* Fixed: Resolved the CSS conflict issue in the Google Sheet Settings tab.

= 1.3.8 (09-10-2023) =
* Added: Updated the Google API Client Library to version 2.12.6.
* Added: Unauthorized access alerts in the Authorization Settings.
* Added: Replaced the "Get Code" button with "Sign in with Google" for a simplified authentication process.
* Added: Alerts for missing Google Drive and Google Sheets permissions during authentication.
* Added: Redesigned the System Status and Error Log pages.
* Added: Extended the Pro version feature section with additional capabilities.
* Fixed: Resolved deprecated function issues related to Freemius integration.
* Fixed: Improved Freemius compatibility for Multisite installations.
* Fixed: Several UI improvements and enhancements on the Integration page.

= 1.3.6 (07-08-2023) =
* Fixed : Vulnerabilities issues.

= 1.3.5 (05-07-2023) =
* Updated Freemius SDK version to 2.5.10.

= 1.3.4 (08-06-2023) =
* Fixed : Undefined option issues is resolved.
* Change UI : Pro features display on setting page and Integration Page.

= 1.3.3 (28-04-2023) =
* Fixed : Vulnerabilities issue resolved.

= 1.3.2 (08-04-2023) =
* Removed unused code. 

= 1.3.1 (15-03-2023) =
* Undefined "get_sku()" function issue resolved.

= 1.3.0 (02-08-2022) =
* Freemius issues resolved: (1)Undefined property: stdClass::$plugins 

= 1.2.9 (01-08-2022) =
* Freemius issues -  (1)count(): Parameter must be an array or an object issues are resolved.

= 1.2.8 (30-07-2022) =
* Wrong option name issue is resolved.

= 1.2.7 (29-07-2022) =
* New Google Integration method implemented using web app.
* Code Optimization

= 1.2.6 (18-06-2022) =
* Compatible with WooCommerce GSheetConnector PRO.

= 1.2.5 (30-05-2022) =
* Is Plugin active error resolved in some cases.

= 1.2.4 (28-05-2022) =
* Free and Pro both plugins can be activated at the same time.

= 1.2.3 (21-03-2022) =
* Freemius SDK updated to 2.4.3
* Solved PHP Notice:  "Undefined property: stdClass::$plugin"
* Solved PHP Warning:  "count(): Parameter must be an array or an object that implements Countable"

= 1.2.2 (22-02-2022) =
* Changed UI of Google Sheet Setting Page.

= 1.2.1 (18-09-2021) =
* Resolved Notice Error for WooCommerce as a required plugin.

= 1.2 (12-09-2021) =
* Freemius Integration.

= 1.1 (18-11-2021) =
* Added Validation For Google Settings Form. 
* Fixed : Errors throws while updating orders without changing order status.

= 1.0 Released Initial version =