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

July 17, 2024

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

Manage WooCommerce orders from Google Sheets. WooCommerce order sync, e-commerce order management, and sales order management with Google Sheets.

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: 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: Automatically export 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/WooCommerce checkout notes) 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: 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: Get started with your WooCommerce order sync journey with our guided tour.

👁️ 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 that are provided during purchase with Google Sheets.

  • Order notes sync: WooCommerce custom order notes are the messages that admins can add to customer orders. With order notes sync, you can now get private and public order notes in a separate column in the spreadsheet.

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

  • WooCommerce Custom order status sync: Sync any custom order status created manually or using a third-party plugin with your Google Sheets. Simplify your workflow and get greater flexibility and precision in managing your orders.

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

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.

Screenshots

  1. Bi-directional sync between WooCommerce and Google Sheet

    Bi-directional sync between WooCommerce and Google Sheet

  2. Manage and update WooCommerce order status from Google Sheet

    Manage and update WooCommerce order status from Google Sheet

  3. Get additional syncing option on your Google Sheet

    Get additional syncing option on your Google Sheet

  4. Edit and update WooCommerce order status from Google Sheet

    Edit and update WooCommerce order status from Google Sheet

  5. One click instant orders sync on Google sheet from WooCommerce dashboard

    One click instant orders sync on Google sheet from WooCommerce dashboard

  6. Start syncing your orders with easy and fast setup

    Start syncing your orders with easy and fast setup

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.

Changelog

1.9.1 – 17 Jul 2024

  • Fix: Fixed the issues in the setup process that prevented users from configuring the plugin

1.9.0 – 15 Jul 2024

  • New (Sync order notes): Users can now sync the order notes. Both private and public notes will be synced from WooCommerce to Google Sheets

1.8.0 – 3 Jun 2024

  • New (Custom order status sync): Users can now sync custom order statuses. Any update of the custom order status will be synced bidirectionally to WooCommerce and Google Sheets
  • Improvement: Enhanced the custom field sync feature functionality. All types of custom fields related to order can now be synced to the Google Sheet
  • Improvement: Users can now control the display sequence of the custom field columns on the Google Sheets
  • Improvement: Optimized the overall codebase for better performance & maintainability
  • Fix: Fixed the Google Sheets tab creation issue. Users can now use any tab of the Google Sheet to sync the orders. If the entered sheet tab doesn’t exist on Google sheets, a new sheet tab will be automatically created
  • Fix: Fixed the breaking of the Google Sheets when more than ten custom fields are synced

1.7.1 – 04 Apr 2024

  • Improvement: Enhanced compatibility to support WordPress 6.5

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

Details

  • Version: 1.9.1
  • Active installations: 300
  • WordPress Version: 5.4
  • Tested up to: 6.5.5
  • PHP Version: 5.6

Ratings


5 Stars
4 Stars
3 Stars
2 Stars
1 Stars