Black Friday: 40% off every Pro planGet 40% off

Sync WooCommerce Orders to Google Sheets

Available in: Pro · Requires: WooCommerce

The WooCommerce Orders data type exports orders to Google Sheets. It appears when WooCommerce is active, and works with both of WooCommerce’s order storage options: High-Performance Order Storage (HPOS) and posts.

Fields

  • Order: Order ID, Order Number, Status, Order Date, Payment Method, Transaction ID, Currency
  • Totals: Subtotal, Discount Total, Shipping Total, Tax Total, Order Total
  • Billing: first name, last name, email, phone, company, address lines 1 and 2, city, state, postcode, country
  • Shipping: first name, last name, address line 1, city, country, shipping method
  • Items: Line Items, Item Count, Coupon Codes
  • Customer Note

Filters

  • Order status
  • Date range: from and to

Real-time sync

Real-time jobs can send a row when an order is created, updated, changes status or is deleted.

Import: update orders

Import jobs update existing orders; they never create new ones. You can map Order ID, Order Number, Status, Customer Note, Tracking Number, Tracking Provider, Tracking URL and a Private Order Note.

  • Unique key: Order ID or order number.
  • Setting: add an order note when an import changes the status.

Ideas

  • Send each new order to a fulfilment sheet.
  • Build a sales report that refreshes every hour.
  • Update order statuses and tracking numbers in bulk from a sheet.

For coupons, refunds, reviews and product categories, see WooCommerce coupons, refunds, reviews and categories.

Was this page helpful? If something is unclear or missing, tell the developer.