=== GSheetConnector for WC ===
Contributors: westerndeal, abdullah17, gsheetconnector
Author URI: https://www.gsheetconnector.com/
Tags:  woocommerce, woocommerce addon, woocommerce google sheets, sync woocommerce with google sheets, woocommerce orders sync to google sheets
Docs: https://www.gsheetconnector.com/docs/woocommerce-gsheetconnector
Tested up to: 6.8
Requires at least: 5.3
Requires PHP: 7.4
Requires Plugins: woocommerce
Stable tag: 1.4.6
License: GPLv2 or later
License URI: http://www.gnu.org/licenses/gpl-2.0.html

Google Sheet Integration for WooCommerce Plugin, Addon plugin of WooCommerce - Helps to send the orders directly to Google Sheets in a real-time.

== Description ==

Google Spreadsheet addon plugin for WooCommerce to connect your store data directly with Google Sheets.

This plugin is a bridge between your [WooCommerce](https://wordpress.org/plugins/woocommerce/) orders and [Google Sheets](https://www.google.com/sheets/about/). Whenever any new order is placed in **WooCommerce** a new row with the order details will be added or moved to the appropriate **Google Sheet Tabs as per the order status.**

[Documentation](https://www.gsheetconnector.com/docs/woocommerce-gsheetconnector/installation-process-free-version) | [Support](https://www.gsheetconnector.com/support) | [Demo](https://woogsheets.gsheetconnector.com/) | [Premium Version](https://www.gsheetconnector.com/woocommerce-google-sheet-connector-pro)

= Still haven't purchased ? <a href="https://www.gsheetconnector.com/wc-gsheetconnector-pro?wp-repo" target="_blank">Get it Now</a> =

= Check Live Demo =
[Demo Link](https://woogsheets.gsheetconnector.com/)

[Google Sheet URL to Check submitted Data](https://docs.google.com/spreadsheets/d/1BLkcJLk8bQvSSuIRPHXLDnSNBNmrEVGZ2o44x5uZVlI/edit#gid=1091708451)
<br>
= 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).

**Compatible with various WooCommerce Addons.**

* **Upgrade to [GSheetConnector for WC PRO Version](https://www.gsheetconnector.com/wc-gsheetconnector-pro?wp-repo)**

➜ Custom Google API Integration Settings
➜ Allowing to Create a New Sheet from Plugin Settings
➜ Custom Ordering Feature / Manage Fields to Display in Sheet using Enable-Disable / Edit the Fields/ Headers Name to display in Google Sheet.
➜ Enabled Various Fields in Headers and also Compatible with various WooCommerce Addons
➜ Manage Existing WooCommerce Products and Users
➜ Syncronize Existing Orders, Products and Users
➜ Freeze Header Settings
➜ Header Color and Row Odd/Even Colors.
Refer to the features and benefits page for more detailed information on the features of the  [GSheetCnnector for WC PRO Plugin](https://www.gsheetconnector.com/wc-gsheetconnector-pro?wp-repo)

**This plugin is not affiliated with or endorsed by WooCommerce or Automattic.**


> <strong>Google Sheet Connector Contact Form Addons</strong>
[CF7 Google Sheet Connector](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 Google Sheet Connector](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 Google Sheet Connector](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 Google Sheet Connector](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)
[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)
[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)
If you are using Easy Digital Downloads for Selling Digital Products then you can use in FREE
[Easy Digital Downloads Google Sheet Connector](https://wordpress.org/plugins/gsheetconnector-easy-digital-downloads/)


== 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.

7. 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.4.6 (14-11-2025) =
- Fixed: Improved responsive CSS.
- Added: "Next Steps…" section in the Integration tab.
- Updated: Updated the header logo and the dashboard widget logo.

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

= 1.4.4 (23-07-2025) =
- Added: Extension tab added.
- Moved freemius folder under Library folder insider vendor folder.
- Added: Debug logs file will be created under wp-upload 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 : Solved Conflict CSS Issue in Google Sheet Tab Settings.

= Version 1.3.8 (09-10-2023) =
= Key Highlights: =
- Client library updated : Google API V-2.12.6 . 
- Authorization Form Settings: Alerts for Unauthorized Access.
- Streamlined Authentication: Replaced "Get Code" button with "Sign in with Google" for ease of use.
- Permissions Alert: Users lacking Google Drive and Sheets permissions now receive a clear alert during authentication.
- Enhanced System Status: Redesigned System Status and Error Log for improved functionality.
- Pro-Version Feature Expansion: Extended a Pro-Version feature tab for added capabilities.
= Bug Fixes and Updates: =
- Deprecation Fixes: Resolved deprecated function errors related to Freemius integration.
- Multi-Site Optimization: Freemius optimized for multi-site compatibility.
- UI Enhancements: Several user interface fixes and additions to 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) =
- Fixed : Errors throws while updating orders without changing order status.
- Added Validation For Google Settings Form. 

= 1.0 Released Initial version =
