Order Sync with Google Sheets for WooCommerce – Bulk Edit WooCommerce Orders, Sync Order Details & More

Description

Sync WooCommerce orders with Google Sheets. Perform WooCommerce order sync, order management, and bulk editing with Google Sheets. 🔥

Welcome to the next generation of WooCommerce order management. Automatically sync WooCommerce orders with Google Sheets. Our WordPress Google Sheets integration ensures you are always one step ahead with faster and more efficient sales order management.

Integrate once and enjoy unlimited bidirectional order sync between WooCommerce and Google Sheets. With this plugin, you can bulk edit WooCommerce orders from the connected spreadsheet instead of updating them one by one. It saves time, and you can focus more on other aspects of your business.

🚀 QUICK & EASY ORDER MANAGEMENT SYSTEM FOR WOOCOMMERCE

  • Performs e-commerce order management, sales order management, and WooCommerce order sync from a connected spreadsheet.
  • Saves time by bulk editing order status from Google Sheets. The status changes instantly on the connected WooCommerce store.
  • Managing the plugin requires zero coding or technical knowledge. Super easy to use with quick setup steps.

👁️ View Demo | 🚀 Get The ULTIMATE Version

🔝 ORDER SYNC WITH GOOGLE SHEETS FOR WOOCOMMERCE FEATURES

  • 2-way order sync between WooCommerce and Google Sheets: sync WooCommerce orders with Google Sheets. Once you connect your store with a spreadsheet, the order status will change bidirectionally and automatically. You can sync as many orders as you wish. WooCommerce order sync is now easier than ever.

  • Bulk editing WooCommerce orders: You can bulk edit WooCommerce orders from Google Sheets, without having to update each order manually. For instance, if you want to change the status of a whole batch of orders from “Pending” to “Processing”, you can now do this in bulk from the connected spreadsheet. The changes will be applied instantly to the orders in WooCommerce.

  • Unlimited automatic order details export from WooCommerce: once you activate the plugin, your WooCommerce order details (order date, order ID, shipping details, product name, order status, order quantity, total price, payment method, order URL, discount, and customer notes) get exported automatically to the connected spreadsheet with our expertly crafted formatting.

  • 1-click manual order sync on Google Sheets: using the “Fetch from WooCommerce” option on Google Sheets, you can manually import WooCommerce order details with a single click.

  • Manual order sync on WooCommerce from Google Sheets: you can use the “Sync on WooCommerce” option from Google Sheets to manually sync order status with WooCommerce.

  • Order details (name, ID, quantity, price) sync: sync order details (product name, ID, quantity, price, payment method) from WooCommerce to Google Sheets.

  • Imported order sync: whether you use any third-party plugin to import or export your order details or the default WordPress import/export tool, our order sync plugin will make sure none of your data gets lost. Once you import your data on WooCommerce and click on “Sync orders on Google Sheets”, your orders will be synced immediately.

  • Empty order sync: Empty orders can be a hassle if not maintained properly. When you import bulk orders with third-party plugins/default WordPress tools, you often lose a few product details. In those instances, your empty orders will be synced as “No Products” in Google Sheets. It gives you the flexibility to either remove or edit the empty orders.

  • Easy setup wizard: our easy setup wizard will help you on every step to get started with your WooCommerce order sync journey.

👁️ View Demo | 🚀 Get The ULTIMATE Version

🔝 ORDER SYNC WITH GOOGLE SHEETS FOR WOOCOMMERCE ULTIMATE FEATURES

  • All free features

  • Payment method sync: sync customer’s payment method information with Google Sheets.

  • Order date sync with date-wise order sorting: sync order date from WooCommerce and sort orders in ascending order according to the date.

  • Discount sync: sync discount information between WooCommerce and Google Sheets.

  • Shipping details sync: track customers’ shipping details from Google Sheets.

  • Order URL sync: sync the order URL and get an insight into where the transaction took place from the connected spreadsheet.

  • Customer notes sync: sync customer notes with Google Sheets.

  • Order quantity sync: Sync the quantity for each ordered product on Google Sheets.

  • WooCommerce Custom Fields Sync: WooCommerce custom fields or metadata lets you display additional product data (Special Instructions, Gift Messages, Delivery Date, etc.). With WooCommerce custom fields sync, you can sync the custom fields data that comes with orders on Google Sheets.

  • Billing details sync: Get a total overview of billing details with the customer’s name, address, phone, and email on the connected Google spreadsheet.

  • Customer name sync: The ‘order placed by’ column ensures you have the details of the customer who placed the order.

  • Order coupon sync (upcoming): learn about applied coupons from Google Sheets.

👁️ View Demo | 🚀 Get The ULTIMATE Version

Privacy Policy

Order Sync with Google Sheet for WooCommerce uses Appsero SDK to collect some telemetry data upon user’s confirmation. This helps us to troubleshoot problems faster & make order improvements.

Appsero SDK does not gather any data by default. The SDK only starts gathering basic telemetry data when a user allows it via the admin notice. We collect the data to ensure a great user experience for all our users.

Integrating Appsero SDK DOES NOT IMMEDIATELY start gathering data, without confirmation from users in any case.

Learn more about how Appsero collects and uses this data.

Screenshots

  • Bi-directional sync between WooCommerce and Google Sheet
  • Manage and update WooCommerce order status from Google Sheet
  • Get additional syncing option on your Google Sheet
  • Edit and update WooCommerce order status from Google Sheet
  • One click instant orders sync on Google sheet from WooCommerce dashboard
  • Start syncing your orders with easy and fast setup

Installation

  1. Navigate to WordPress Dashboard>Plugins>Add New and search ‘Order Sync with Google Sheets” and Activate the plugin.
  2. Upload your credentials.json file from the Google Cloud Platform and connect your spreadsheet.
  3. Provide editor access to your service account and configure Apps Script.
  4. That’s it. Enjoy super-fast order sync between WooCommerce and Google Sheets.

You can also follow our step-by-step tutorial.

FAQ

How can I link my site with Google Sheets?

It’s pretty simple and easy. You’ll have to insert a link to the spreadsheet and provide editor access to your service account.

How do I sync orders in WooCommerce?

Install Order Sync with Google Sheets for WooCommerce and link with your Google Sheets spreadsheet. Now you can sync and manage your WooCommerce orders from a connected spreadsheet.

How many order status can I change from Google Sheets?

Unlimited! There is absolutely no limit when it comes to syncing order status between WooCommerce and Google Sheets.

Which product description can I sync with Google Sheets?

On the free version, you can sync the following order details – product name, ID, quantity, and price. On the paid version you can also sync payment method, discount amount, shipping details, order URL, and customer notes.

Can I remove any WooCommerce order from the Google Sheets?

No. You won’t be able to remove any order from Google Sheets.

Do I need to know any programming language for using this plugin?

No. No coding knowledge is required for using this plugin.

Reviews

Read all 3 reviews

Contributors & Developers

“Order Sync with Google Sheets for WooCommerce – Bulk Edit WooCommerce Orders, Sync Order Details & More” is open source software. The following people have contributed to this plugin.

Contributors

“Order Sync with Google Sheets for WooCommerce – Bulk Edit WooCommerce Orders, Sync Order Details & More” has been translated into 1 locale. Thank you to the translators for their contributions.

Translate “Order Sync with Google Sheets for WooCommerce – Bulk Edit WooCommerce Orders, Sync Order Details & More” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

1.7.0 – 25 Mar 2024

  • New: Orders can now be bulk edited from Google Sheets, without having to update each order manually
  • Fix: Fixed an issue that prevented syncing of the first order to the connected Google Sheets
  • Fix: Fixed the long delay when placing a new order on the website
  • Improvement: Improved the overall syncing performance

1.6.2 – 27 Jan 2024

  • Fix: Fixed an issue that prevented users from copying the AppScript code during the plugin setup process

1.6.1 – 22 Jan 2024

  • Improvement: This update includes routine maintenance focused on keeping the plugin up-to-date

1.6.0 – 13 Dec 2023

  • New: Custom fields of WooCommerce orders can now be synced to the Google Sheets

1.5.0 – 28 NOV 2023

  • New: Full compatibility with WooCommerce High-Performance Order Storage
  • Fix: Fixed an issue that sometimes caused an error during the onboarding process while trying to setup the plugin

1.4.3 – 14 Nov 2023

  • New: Added user friendly notices with new design
  • Improvement: Enhanced top bar notice design

1.4.2 – 9 Nov 2023

  • Improvement: Enhanced compatibility to support WordPress 6.4

1.4.1 – 2 Nov 2023

  • Fix: Fixed an issue that caused a fatal error when calling the set_campaign method on null due to a conflict between the SDK and some plugin

1.4.0 – 26 OCT 2023

  • New: Showing the quantity of each ordered items beside their names in the Product Names column
  • New: Customer’s billing address is now shown in the Billing Address column on Google Sheets. This includes phone number and email address of the customer along with other billing data
  • New: Introduced a new column “Order Placed by” to show the details of the person who placed the order
  • New: Added the controls of Total Items and Total Price columns in the settings page to show/hide the columns in Google Sheet
  • New: Added top bar notice to notify the old user to update to the App Script
  • Improvement: The columns on the Google Sheet can now be expanded by dragging with mouse as much as needed
  • Improvement: Updated popup design
  • Improvement: Updated the Apps Script to fix some loading issues within Google Sheet
  • Fix: Removed the irrelevant order syncing status

1.3.6 – 21 SEP 2023

  • Improvement: Enhanced performance and fixed minor issues

1.3.5 – 14 AUG 2023

  • Improvement: Enhanced compatibility to support WordPress 6.3

1.3.4 – 5 JUL 2023

  • Fix: Orders syncing issue on websites using a higher version of SQL
  • Fix: Showing notice when there are no orders to sync
  • Fix: App Script issue with empty sheet tab on Google Sheets while configuring the plugin

1.3.3

  • Improvement: Enhanced performance and fixed minor issues

1.3.2

  • Improvement: Enhanced performance and fixed minor issues

1.3.1

  • Fix: Fixed review/rating collection popup not closing

1.3.0

  • New: Implemented popup for taking reviews/rating
  • Improvement: Enhanced PRO installation notification when free is not installed/activated.

1.2.0

  • New: Imported order syncing support
  • New: Syncing empty orders
  • Improvement: Enhanced performance and fixed minor issues

1.1.3

  • Improvement: Enhanced performance and fixed minor issues

1.1.2

  • Fix: lead collection issue from SDK.
  • Improvement: Checked compatibility with WordPress 6.2

1.1.1

  • [Fixed]: After enabling this WooCommerce in Multisite, it mentions that the WooCommerce plugin must be enabled.
  • [Improved]: readme file
  • [Improved]: AppsScript file
  • [Improved]: Plugin folder name
  • [Improved]: Plugin text domain name

1.1.0

  • [New]: Added Order date, Total discount, Payment method, Shipping details, Order URl, Customer note column
  • [New] Added Setting page

1.0.1

  • Fixed: Security issues and patches
  • Improved: Improved code quality and standard
  • Fixed: Removed Sweetalert and added our own toast library.
  • Added: Appsero sdk for Security
  • Added: Headwayapp
  • Added: Setup video tutorials

1.0.0

  • Initial release