WooCommerce Sync

Push WooCommerce orders, refunds, customers, and product catalogue changes to Google Sheets in real time.

Maintained by Arden Talbot, founder of SheetLinkWP

What this add-on does

WooCommerce Sync hooks into six WooCommerce events and pushes structured data to the Google Sheet (and Apps Script webhook) of your choice for each event. Each event type can target its own sheet and webhook, so Orders, Refunds, Products, and Customers can each have their own sheet.

From SheetLink Pro 1.2.0 each event can also be added as a row to a table in your Excel Online workbook, alongside the sheet or instead of it.

From SheetLink Pro 1.3.0, with Two-Way Sync, an edit made in the sheet can also change an order's status or a product's price and stock. Each is off until you switch it on.

Requires the Pro tier (or Agency). Activate on the License page first. WooCommerce itself must be installed and active.

Supported events

Six events fire automatically based on WooCommerce hooks:

  • Order created - hook: woocommerce_new_order. Fires when any order is placed, even if unpaid.
  • Order completed - hook: woocommerce_order_status_completed. Fires when an order moves to the Completed status.
  • Order refunded - hook: woocommerce_order_refunded. Fires on full or partial refund and includes the refund amount and reason.
  • Customer created - hook: woocommerce_created_customer. Fires when a new customer registers.
  • Product created - hook: woocommerce_new_product. Fires when a new product is added to the catalogue. Captures ID, name, SKU, type, status, price, regular price, sale price, stock quantity, stock status, and date created.
  • Product updated - hook: woocommerce_update_product. Fires when a product is saved, for example after a price or stock edit in the product editor.

Configuring an event

  1. Open SheetLink -> WooCommerce Sync. Each event has its own card.
  2. Check Sync this event for events you want to enable.
  3. Paste a Google Apps Script web-app URL in the Receiver URL field for each enabled event. (You can reuse the same URL across events if you want everything on one sheet, or use different URLs for separate sheets.)
  4. Edit the Field -> column map to choose which fields are sent. Each line is a WooCommerce field (pre-filled with the event's list). A field with anything after the equals sign is sent; leave the right side blank to skip it. If every line is blank, all fields are sent. The screen suggests a column letter, but the letter does not place the column: the receiver script names a column after each field it receives.
  5. Click Save all events.

Delivery fires asynchronously so WooCommerce checkout is never slowed down. If the Google Apps Script is briefly unavailable, the delivery is retried about 5 minutes, 30 minutes and 2 hours later and then kept in the Retry Queue for a manual re-send. Each event adds a new row; a status change does not update an earlier row.

Writing events to Excel Online tables

Each event card has an Excel Online row. It needs SheetLink Pro 1.2.0 or later and a Microsoft 365 work or school account connected under SheetLink -> Excel Online, with a workbook chosen there.

  1. In the workbook, make a table for the event (Insert -> Table, with headers) and name its columns after the fields you want, for example Order ID, Total, E-mail and Items.
  2. On the event card tick Also add this event as a row in an Excel table and pick the table. Click Refresh the list if a new table is missing.
  3. Click Save all events. A warning appears if none of the table's headings matches a field of the event.
  4. Use Send test to add a sample row.

A column is filled when its heading matches a field name, ignoring capitals, spaces and punctuation. The card lists every field the event sends under "Headings you can use". A column headed event receives the event's name. Columns that match nothing stay empty. Each event adds a new row.

Excel alongside a Receiver URL is part of WooCommerce Sync. Excel as an event's only destination, with the Receiver URL left empty, also requires SheetLink Plus. The Excel write is scheduled, logged and retried on its own, separately from the sheet. Full guide: WooCommerce to Excel Online.

Changing orders and products from the sheet

From SheetLink Pro 1.3.0 the rows WooCommerce Sync writes can be used to change WooCommerce, if Two-Way Sync is also on and its script (version 2) is in the sheet. At the foot of the WooCommerce Sync screen, the card Changes made in the sheet has three switches, all off to begin with:

  • Order status - editing the status cell of an order row moves the order to that status. Tick the statuses the sheet may set; processing, on-hold and completed are ticked to begin with.
  • Product price - editing the regular_price or sale_price cell of a product row sets that price. Write a plain number such as 12.50.
  • Product stock - editing the stock_quantity cell of a product row sets the stock, on a product that tracks stock.

Only the cell you edit is acted on, the row has to keep its _sheetlink_wc_event column and its id column, and the card lists the last 20 edits with what was applied or refused. A status change made this way sends WooCommerce's usual customer emails. The rules and limits are set out in full under Two-Way Sync - Changing WooCommerce from the sheet. It works with Google Sheets, not with Excel tables.

Accounting export: enable Order Completed and Order Refunded, both pointing at one sheet. Your bookkeeper gets a real-time ledger of paid-vs-refunded transactions.

Inventory dashboard: enable Product Updated pointing at a dedicated "Inventory" sheet. Send stock_quantity, stock_status, price, and date_modified. Each save of a product in the editor adds a row, so the sheet is a log of changes.

CRM handoff: enable Customer Created pointing at your lead-capture sheet (same one that receives form submissions). Add a source column set to woocommerce via Apps Script so you can distinguish form leads from order leads.

Order fulfilment workflow: enable Order Created pointing at a dedicated "Open Orders" sheet. As your team ships orders manually they can add a shipped-at timestamp in a free-form column without affecting sync.

Troubleshooting

  • Events configured but nothing arrives in the sheet: confirm WooCommerce is installed and active; the events only fire while it is. Also check the Receiver URL starts with https://script.google.com/ or https://script.googleusercontent.com/.
  • Some fields missing from the sheet: check the field map. When some lines have a value after the equals sign, a line with an empty right side is skipped and its field is not sent.
  • Duplicate rows on the same order ID: multiple events may fire for one order (e.g. Order Created + Order Completed). That is expected. Filter in the sheet by _sheetlink_wc_event column, which is auto-appended so you can distinguish them.

Ready to Get Started?

Install SheetLink Forms and connect your first form in under 10 minutes.