Default Fields and Sync Direction Summary

A helpful overview of the fields and record types synced between Xero and WooCommerce with MyWorks

Written by the MyWorks Team

Updated at June 27th, 2023

MyWorks Sync has a lot of different options when it comes to syncing data, and this article helps share what direction data syncs, whether new or updated data syncs, and what fields are synced by default.

Below are a list of the default fields synced/mapped already in our sync. Custom field mapping for order fields is supported, and is handled on a case by case basis over support ticket. Additional WooCommerce extensions that add extra functionality/ fields would not conflict with our sync, but may need custom mapping if their fields need to be used by MyWorks.

WooCommerce -> Xero

Customer (new and updated)

  • First Name
  • Last Name
  • Company Name
  • Email
  • Address Line 1
  • Address Line 2
  • City
  • State
  • Postcode
  • Country

Order (new and updated)

  • Can be synced as Invoice or Quote
  • Order Number (can be WooCommerce order ID, custom order number, or next Xero number)
  • Reference Number
  • Associated Customer
  • Billing Address
  • Shipping Address
  • Issue Date
  • Due Date (If invoice)
  • Tracking Category (up to two)
  • Product/Service line items
    • SKU
    • Description
    • Quantity
    • Amount
    • Account
    • Discount
    • Tax
    • Tracking Category (up to two)
  • Shipping
  • Discount / Coupons
  • Taxes
  • Memo / Note

Product & Variation (new and updated)

  • Item Code
  • Name
  • Type (Inventory or Non-Inventory)
  • Description (optional)
  • Inventory Level (if inventory product)
  • Price

Payment (new)(if invoice)

  • Related invoice
  • Payment Date
  • Payment Method
  • Reference No. (Transaction ID or WooCommerce order number)
  • Amount Received

Refund (new)

  • Related order
  • Refund Date
  • Payment Method
  • Reference No. (Transaction ID or WooCommerce order number)
  • Items Refunded
  • Amount Refunded

Xero -> WooCommerce

Product (new and updated)

  • Item Code
  • Name
  • Type (Inventory or Non-Inventory)
  • Description (optional)
  • Inventory Level (if inventory product)
  • Price

Inventory (updated)

  • Inventory Level

Pricing (updated)

  • Sale Price

Payment (new)

  • Updates WooCommerce order status when Xero invoice is paid.