{"id":200076,"date":"2024-12-02T13:46:58","date_gmt":"2024-12-02T13:46:58","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/all-in-one-gsheetsync-for-woocommerce\/"},"modified":"2024-12-27T09:20:49","modified_gmt":"2024-12-27T09:20:49","slug":"all-in-one-gsheetsync-for-woocommerce","status":"publish","type":"plugin","link":"https:\/\/pl.wordpress.org\/plugins\/all-in-one-gsheetsync-for-woocommerce\/","author":16807267,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"1.0.2","stable_tag":"1.0.2","tested":"6.7.5","requires":"5.3","requires_php":"","requires_plugins":null,"header_name":"All-in-One GSheetSync for WooCommerce","header_author":"Techiesaround","header_description":"Sync WooCommerce orders, product inventory, and customer data effortlessly to Google Sheets, simplifying your data management tasks.","assets_banners_color":"316c6d","last_updated":"2024-12-27 09:20:49","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"https:\/\/techiesaround.com\/all-in-one-gsheetsync-for-woocommerce\/","header_author_uri":"https:\/\/www.techiesaround.com\/","rating":0,"author_block_rating":0,"active_installs":0,"downloads":919,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":{"1.0":{"tag":"1.0","author":"techiesaround","date":"2024-12-02 13:53:15"},"1.0.1":{"tag":"1.0.1","author":"techiesaround","date":"2024-12-09 12:01:48"},"1.0.2":{"tag":"1.0.2","author":"techiesaround","date":"2024-12-27 09:20:49"}},"upgrade_notice":{"1.0.2":"<p>This update introduces support for renamed sheets, multi-sheet selection within a spreadsheet, and the ability to add product name, quantity, and price in the order module.<\/p>","1.0.1":"<p>This update includes three new screenshots for better understanding of the plugin&#039;s functionality and additional product-related links like video tutorials, sample sheets, and Calendly scheduling.<\/p>","1.0":"<p>This is the first release of the All-in-One GSheetSync for WooCommerce plugin.<\/p>"},"ratings":[],"assets_icons":{"icon-128x128.png":{"filename":"icon-128x128.png","revision":3200952,"resolution":"128x128","location":"assets","locale":""}},"assets_banners":{"banner-772x250.png":{"filename":"banner-772x250.png","revision":3204824,"resolution":"772x250","location":"assets","locale":""}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0","1.0.1","1.0.2"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":3200952,"resolution":"1","location":"assets","locale":""},"screenshot-2.png":{"filename":"screenshot-2.png","revision":3200952,"resolution":"2","location":"assets","locale":""},"screenshot-3.png":{"filename":"screenshot-3.png","revision":3204824,"resolution":"3","location":"assets","locale":""},"screenshot-4.png":{"filename":"screenshot-4.png","revision":3204824,"resolution":"4","location":"assets","locale":""},"screenshot-5.png":{"filename":"screenshot-5.png","revision":3204824,"resolution":"5","location":"assets","locale":""},"screenshot-6.png":{"filename":"screenshot-6.png","revision":3204824,"resolution":"6","location":"assets","locale":""},"screenshot-7.png":{"filename":"screenshot-7.png","revision":3204824,"resolution":"7","location":"assets","locale":""},"screenshot-8.png":{"filename":"screenshot-8.png","revision":3204824,"resolution":"8","location":"assets","locale":""},"screenshot-9.png":{"filename":"screenshot-9.png","revision":3204824,"resolution":"9","location":"assets","locale":""}},"screenshots":{"1":"Configure Google API credentials.","2":"Select the Google Sheet and map SKU and stock quantity fields.","3":"Sync product inventory from Google Spreadsheet to WooCommerce by SKU.","4":"Select the Google Sheet and map the required fields to sync orders.","5":"Automatically export WooCommerce orders to Google Spreadsheet in real time.","6":"Select the Google Sheet and map the required fields to sync customer data.","7":"Sync customer details from WooCommerce to Google Spreadsheet.","8":"Enable and view the log section for monitoring synchronization activities.","9":"Detailed view of the log section for tracking data transfers."},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[21483,65950,286,235313,65936],"plugin_category":[],"plugin_contributors":[235314],"plugin_business_model":[],"class_list":["post-200076","plugin","type-plugin","status-publish","hentry","plugin_tags-inventory-management","plugin_tags-order-sync","plugin_tags-woocommerce","plugin_tags-woocommerce-google-sheet","plugin_tags-woocommerce-stock","plugin_contributors-techiesaround","plugin_committers-techiesaround"],"banners":{"banner":"https:\/\/ps.w.org\/all-in-one-gsheetsync-for-woocommerce\/assets\/banner-772x250.png?rev=3204824","banner_2x":false,"banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/all-in-one-gsheetsync-for-woocommerce\/assets\/icon-128x128.png?rev=3200952","icon_2x":false,"generated":false},"screenshots":[{"src":"https:\/\/ps.w.org\/all-in-one-gsheetsync-for-woocommerce\/assets\/screenshot-1.png?rev=3200952","caption":"Configure Google API credentials."},{"src":"https:\/\/ps.w.org\/all-in-one-gsheetsync-for-woocommerce\/assets\/screenshot-2.png?rev=3200952","caption":"Select the Google Sheet and map SKU and stock quantity fields."},{"src":"https:\/\/ps.w.org\/all-in-one-gsheetsync-for-woocommerce\/assets\/screenshot-3.png?rev=3204824","caption":"Sync product inventory from Google Spreadsheet to WooCommerce by SKU."},{"src":"https:\/\/ps.w.org\/all-in-one-gsheetsync-for-woocommerce\/assets\/screenshot-4.png?rev=3204824","caption":"Select the Google Sheet and map the required fields to sync orders."},{"src":"https:\/\/ps.w.org\/all-in-one-gsheetsync-for-woocommerce\/assets\/screenshot-5.png?rev=3204824","caption":"Automatically export WooCommerce orders to Google Spreadsheet in real time."},{"src":"https:\/\/ps.w.org\/all-in-one-gsheetsync-for-woocommerce\/assets\/screenshot-6.png?rev=3204824","caption":"Select the Google Sheet and map the required fields to sync customer data."},{"src":"https:\/\/ps.w.org\/all-in-one-gsheetsync-for-woocommerce\/assets\/screenshot-7.png?rev=3204824","caption":"Sync customer details from WooCommerce to Google Spreadsheet."},{"src":"https:\/\/ps.w.org\/all-in-one-gsheetsync-for-woocommerce\/assets\/screenshot-8.png?rev=3204824","caption":"Enable and view the log section for monitoring synchronization activities."},{"src":"https:\/\/ps.w.org\/all-in-one-gsheetsync-for-woocommerce\/assets\/screenshot-9.png?rev=3204824","caption":"Detailed view of the log section for tracking data transfers."}],"raw_content":"<!--section=description-->\n<p>Take your WooCommerce store to the next level with  <strong>All-in-One GSheetSync for WooCommerce Plugin<\/strong> \u2013 your ultimate solution for seamless integration with Google Sheets! Effortlessly synchronize key elements like <strong>Orders<\/strong>, <strong>Product Inventory Details<\/strong>, and <strong>Customers<\/strong> into a centralized Google Spreadsheet.<\/p>\n\n<p>Say goodbye to manual updates and streamline your data management with <strong>real-time synchronization<\/strong>!<\/p>\n\n<h3><strong>Google API Integration<\/strong><\/h3>\n\n<p>This plugin leverages <strong>Google APIs<\/strong> to deliver powerful features:\n- Read and write data to Google Sheets\n- Handle OAuth authentication for secure access to Google services<\/p>\n\n\n\n<h3><strong>Features List for All-in-One GSheetSync for WooCommerce Plugin<\/strong><\/h3>\n\n<h3><strong>1. Google Credentials Configuration<\/strong><\/h3>\n\n<ul>\n<li>Quickly configure your Google account credentials for smooth integration.<\/li>\n<\/ul>\n\n<h3><strong>2. Stock Updates from Google Spreadsheet<\/strong><\/h3>\n\n<ul>\n<li>Update WooCommerce product stock levels directly from a connected Google Spreadsheet.<\/li>\n<\/ul>\n\n<h3><strong>3. Order Synchronization<\/strong><\/h3>\n\n<ul>\n<li>Automatically sync WooCommerce sales orders to a Google Spreadsheet.<\/li>\n<li>Supports syncing based on these order statuses:\n\n<ul>\n<li>New Order Placement<\/li>\n<li>After Payment Completion<\/li>\n<li>Processing Order<\/li>\n<li>Order Completion<\/li>\n<\/ul><\/li>\n<\/ul>\n\n<h3><strong>4. Customer Data Synchronization<\/strong><\/h3>\n\n<ul>\n<li>Export customer details from WooCommerce to a designated Google Spreadsheet.<\/li>\n<\/ul>\n\n<h3><strong>5. Debug and Log Data Transfers<\/strong><\/h3>\n\n<ul>\n<li>Enable debug mode to log data transfer activities for troubleshooting and monitoring.<\/li>\n<\/ul>\n\n\n\n<h3><strong>Links for Additional Resources<\/strong><\/h3>\n\n<p>Enhance your experience with All-in-One GSheetSync for WooCommerce using the following resources:<\/p>\n\n<ul>\n<li><p><strong>Calendly Support Link<\/strong>: <a href=\"https:\/\/calendly.com\/demo-techiesaround\/customer-support-management\">Schedule a Call<\/a><br \/>\nNeed help? Book a one-on-one session to get support or resolve queries.<\/p><\/li>\n<li><p><strong>Sample Sheets<\/strong>: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1auQVOvEU71X_7c6KLqsgSPWZIOUaIRbMHWyJUEdLJZk\/edit?usp=sharing\">View Sample Sheets<\/a><br \/>\nCheck out our sample sheets to understand how data syncing works.<\/p><\/li>\n<li><p><strong>Product Page<\/strong>: <a href=\"https:\/\/techiesaround.com\/all-in-one-gsheetsync-for-woocommerce\/\">Visit Product Page<\/a><br \/>\nLearn more about the plugin, its features, and updates.<\/p><\/li>\n<li><p><strong>Configuration Guide<\/strong>: <a href=\"https:\/\/techiesaround.com\/create-service-account-in-google-api-console\/\">Configuration Details<\/a><br \/>\nStep-by-step instructions to configure and set up the plugin.<\/p><\/li>\n<li><p><strong>Video Tutorial<\/strong>: <a href=\"https:\/\/youtu.be\/cDdXpq9gbew\">Watch Video Guide<\/a><br \/>\nA comprehensive video tutorial to help you get started quickly.<\/p><\/li>\n<\/ul>\n\n\n\n<h3><strong>Why Choose All-in-One GSheetSync for WooCommerce?<\/strong><\/h3>\n\n<p>This plugin bridges WooCommerce with Google Spreadsheets, enabling <strong>real-time data synchronization<\/strong> for better inventory and order management. \n<strong>Integration is done with Google's most up-to-date and secure libraries<\/strong>, ensuring maximum reliability and safety for your data. Perfect for store owners who value efficiency and accuracy!<\/p>\n\n\n\n<h3><strong>Ready to Simplify Your Workflow?<\/strong><\/h3>\n\n<p>Download the <strong>All-in-One GSheetSync for WooCommerce Plugin<\/strong> today and experience effortless data management!<\/p>\n\n<h3>Third-Party Services Used<\/h3>\n\n<p>This plugin communicates with the following external Google services:<\/p>\n\n<ol>\n<li><p><strong>Google Sheets API<\/strong>: Used to retrieve and append data to Google Sheets. Data such as spreadsheet IDs and content is sent to Google Sheets via API requests.<\/p>\n\n<ul>\n<li>Service Documentation: https:\/\/developers.google.com\/sheets\/api<\/li>\n<li>Terms of Use: https:\/\/developers.google.com\/terms<\/li>\n<li>Privacy Policy: https:\/\/policies.google.com\/privacy<\/li>\n<\/ul><\/li>\n<li><p><strong>Google Drive API<\/strong>: Used to upload and retrieve files from Google Drive.<\/p>\n\n<ul>\n<li>Service Documentation: https:\/\/developers.google.com\/drive\/api<\/li>\n<li>Terms of Use: https:\/\/developers.google.com\/terms<\/li>\n<li>Privacy Policy: https:\/\/policies.google.com\/privacy<\/li>\n<\/ul><\/li>\n<li><p><strong>Google OAuth 2.0<\/strong>: Used for user authentication and authorization of Google services.<\/p>\n\n<ul>\n<li>Service Documentation: https:\/\/developers.google.com\/identity\/protocols\/oauth2<\/li>\n<li>Terms of Use: https:\/\/developers.google.com\/terms<\/li>\n<li>Privacy Policy: https:\/\/policies.google.com\/privacy<\/li>\n<\/ul><\/li>\n<\/ol>\n\n<p>By using this plugin, users are subject to the terms and privacy policies of these external services.<\/p>\n\n<h3>Legal<\/h3>\n\n<p>Please ensure that using these services is compliant with local data protection laws and regulations, as data may be transmitted to Google servers when using this plugin.<\/p>\n\n<!--section=installation-->\n<ol>\n<li>Download and install the plugin via WordPress Plugin Directory or manually upload it to your site.<\/li>\n<li>Activate the plugin through the \"Plugins\" menu in WordPress.<\/li>\n<li>Navigate to the plugin settings and configure your Google API credentials.<\/li>\n<li>Follow the instructions in the settings to connect your WooCommerce store with Google Sheets.<\/li>\n<\/ol>\n\n<!--section=faq-->\n<dl>\n<dt id='what%20is%20all-in-one%20gsheetsync%20for%20woocommerce%3F'><h3>What is All-in-One GSheetSync for WooCommerce?<\/h3><\/dt>\n<dd><p>All-in-One GSheetSync for WooCommerce is a plugin that integrates your WooCommerce store with Google Spreadsheets, allowing real-time synchronization of orders, product inventory, and customer data.<\/p><\/dd>\n<dt id='can%20i%20update%20woocommerce%20stock%20levels%20using%20a%20google%20spreadsheet%3F'><h3>Can I update WooCommerce stock levels using a Google Spreadsheet?<\/h3><\/dt>\n<dd><p>Yes, the plugin allows you to update WooCommerce product stock levels directly from a connected Google Spreadsheet.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>1.0.2<\/h4>\n\n<ul>\n<li>Added support for renamed sheets in Google Spreadsheets:\n\n<ul>\n<li>Previously supported only \"Sheet1\"; now supports renamed sheets.<\/li>\n<\/ul><\/li>\n<li>Multi-sheet support:\n\n<ul>\n<li>Users can now select multiple sheets within a single spreadsheet for synchronization.<\/li>\n<\/ul><\/li>\n<li>Enhanced order module functionality:\n\n<ul>\n<li>Product name, quantity, and price can now be added to orders.<\/li>\n<\/ul><\/li>\n<\/ul>\n\n<h4>1.0.1<\/h4>\n\n<ul>\n<li>Added three new screenshots:\n\n<ul>\n<li>Import product inventory data.<\/li>\n<li>Order synchronization with Google Spreadsheet.<\/li>\n<li>Customer data export to Google Spreadsheet.<\/li>\n<\/ul><\/li>\n<li>Included product-related links for better user experience:\n\n<ul>\n<li>Added video tutorial link for quick setup guidance.<\/li>\n<li>Provided links to sample sheets for configuration references.<\/li>\n<li>Added configuration page link for seamless setup.<\/li>\n<li>Integrated Calendly link for scheduling support.<\/li>\n<li>Included a product page link.<\/li>\n<\/ul><\/li>\n<\/ul>\n\n<h4>1.0<\/h4>\n\n<ul>\n<li>Initial release.<\/li>\n<li>Support for Google Sheets integration.<\/li>\n<li>Sync WooCommerce orders, inventory, and customer details.<\/li>\n<\/ul>","raw_excerpt":"Use All-in-One GSheetSync for WooCommerce to connect your Google Spreadsheet with your WooCommerce system effortlessly.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/200076","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=200076"}],"author":[{"embeddable":true,"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/techiesaround"}],"wp:attachment":[{"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=200076"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=200076"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=200076"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=200076"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=200076"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=200076"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}