🛒Workflow Routing

WooCommerce Sync: Orders to Google Sheets

Six WooCommerce events are written to Google Sheets as they happen: order created, order completed, order refunded, customer created, product created and product updated. Each one can go to its own sheet, and there is no charge per order.

Included in Pro$79/yr or $199 lifetime - also in Agency

Ships in SheetLink Pro, a separate plugin installed next to the free SheetLink Forms plugin. The free plugin contains no locked features.

WooCommerce Sync: Orders to Google Sheets diagram

Key Benefits

Orders as they are placed

A row is written when an order is placed, with the order number, status, total, currency, billing contact and the items ordered. Another row is written when the order is completed.

Refunds, partial and full

Every refund writes a row with the refund amount and reason, the running total refunded and what the order has netted, so a partial refund is not missed.

New customer accounts

When a customer account is created, a row records the customer ID, email, name, username and registration date.

Product changes

A row is written when a product is created and each time one is saved, with its SKU, price, sale price, stock quantity and stock status. It is a log of changes, not a live inventory table.

Change orders and products from the sheet

From SheetLink Pro 1.3.0, with Two-Way Sync, editing the status cell of an order row can move the order to that status, and editing a price or stock cell of a product row can change the product. Each is off until you switch it on, and only the cell you edit is acted on.

How It Works

WooCommerce Sync listens for six WooCommerce events on your own site: order created, order completed, order refunded, customer created, product created and product updated. When one happens, it builds a row from that event's fields and posts it to the Receiver URL on the event's card, which is the web app address of the SheetLink script in your Google Sheet. The send is scheduled and runs straight afterwards, outside the customer's request, so checkout is not held up. Every delivery is listed in the Sync Log. A failed delivery is retried about 5 minutes, 30 minutes and 2 hours later, then kept in the Retry Queue for a one-click re-send. Each event adds a new row: an order that is created, completed and refunded produces three rows, and no other status change writes anything.

Real-World Use Cases

Daily order log

A sheet that grows by one row per order gives revenue by day and orders by billing country, with pivot tables on the columns that are sent. No WooCommerce admin access is needed to read it.

Refund ledger

Send Order completed and Order refunded to their own sheets. Your bookkeeper sees each completed order's total and each refund's amount and reason as they happen. From SheetLink Pro 1.2.0 the order rows can also carry the tax, shipping and discount totals, the coupon codes and the payment method.

Product change log

Send Product updated to a sheet and filter by SKU to see when a price or a stock quantity was changed in the product editor.

Feature Comparison

Manual exportWooCommerce Sync
New ordersIn the file when you next exportA row as each order is placed
Completed ordersIn the file when you next exportA new row when the order is completed
RefundsLook them up in WooCommerceA row per refund, with amount and reason
New customersA separate exportA row per new account
EffortRepeated by handSet up once

Frequently Asked Questions

What WooCommerce data is sent?

Six events. Every order event sends the order number, status, total, net total, amount refunded, currency, the billing email, name, phone, city and country, the items in one cell, and its dates. From SheetLink Pro 1.2.0 it can also send the billing state, the tax, shipping and discount totals, the coupon codes, the payment method, and the shipping address. Order refunded adds the refund amount, refund ID, reason and whether it was partial. Customer created sends the customer ID, email, name, username and registration date. Product created and Product updated send the product ID, name, SKU, type, status, price, regular price, sale price, stock quantity and stock status.

Is tax, shipping, coupon or payment method data included?

Yes, from SheetLink Pro 1.2.0. An order event can send the tax, shipping and discount totals, the coupon codes, the payment method and its title, the billing state, and the shipping address in one cell together with its city, state, postcode and country. On a site that was already sending an order event with a blank field list, these fields stay out until you write yes after them on the event's card, so that an update does not add columns to your sheet by itself. Order notes and custom checkout fields are not sent.

Does a status change update the order's row?

No. Each event adds a new row. An order that is created, completed and then refunded produces three rows. Other status changes, such as processing or on hold, do not write anything.

Does it send orders placed before I set it up?

No. Rows are written from the moment an event is switched on. There is no import of earlier orders.

Can orders, refunds and products go to different sheets?

Yes. Each event has its own Receiver URL, so each can post to a different spreadsheet. Give two events the same URL to keep them together; a column named _sheetlink_wc_event tells the rows apart.

How are line items written?

All of an order's items go into one cell, as product names with quantities, separated by commas. There is no mode that writes one row per line item.

Does it slow down checkout?

No. The send is scheduled and runs straight afterwards, outside the customer's request, so a slow or unreachable sheet does not hold up checkout.

What do I need?

A Pro or Agency licence, the free SheetLink Forms plugin with the SheetLink Pro plugin beside it, and a Google Sheet with the SheetLink script deployed as a web app. WooCommerce Sync is included in Pro ($79/yr or $199 lifetime) and Agency, with no fee per order.

Can the events go to Excel?

Yes, from SheetLink Pro 1.2.0. Each event can also be added as a row to a table in your Excel Online workbook. Excel alongside a Google Sheet is part of WooCommerce Sync; Excel as an event's only destination requires SheetLink Plus. See WooCommerce to Excel Online.

Can I change an order or a product by editing the sheet?

Yes, from SheetLink Pro 1.3.0, if you also use Two-Way Sync with its script in the sheet. Editing the status cell of an order row can change the order's status. Editing the regular_price, sale_price or stock_quantity cell of a product row can change the product. Each of the three is switched on separately on the WooCommerce Sync screen, and you choose which statuses the sheet may set. A status change made this way sends WooCommerce's usual customer emails.

Get WooCommerce orders into Sheets as they happen

Orders, refunds, new customers and product changes, each as a row in your own Google Sheet. Part of Pro.