Default Fields & Sync Direction Summary - Shopify & QuickBooks Online Sync

A summarized list of the default fields and the direction they can sync between Shopify and QuickBooks Online

Written by the MyWorks Team

Updated at August 19th, 2024

Summary

MyWorks Sync has many different options when it comes to syncing data between Shopify and QuickBooks Online, and this article helps share what direction data syncs, whether new or updated data syncs, and what fields are synced by default.

Below is a list of the default fields and types of data we sync between Shopify & QuickBooks Online - including custom fields we can map as we sync orders. 

Shopify -> QuickBooks Online

Customer (new)

  • First Name
  • Last Name
  • Company Name
    • Supports Shopify Plus Company names and Location names
  • Email
  • Address Line 1
  • Address Line 2
  • City
  • State
  • Postcode
  • Country

Order (new and updated)

  • Can be synced as an Invoice or Sales Receipt
  • Order Number (can be Shopify order number, custom order number, or adding a prefix before.)
  • Associated Customer
  • Billing Address
  • Shipping Address
  • Shipping From field
  • Order Date
  • Due Date & Terms (If invoice) 
  • Class / Department / Location
  • Product/Service line items
  • SKU
  • Description
  • Quantity
  • Amount
  • Shipping Amount
  • Discount
  • Tax
  • Memo
  • Custom Fields 1-3 (if mapped in our custom field mapping)

Product (new and updated)

  • Name
  • Image (if not present in QuickBooks product)
  • Description
  • SKU
  • Inventory Level (if inventory product)
  • Price
  • Taxable Status
  • Cost

Variation (new and updated)

  • Name
  • Description
  • SKU
  • Inventory Level (if inventory product)
  • Price
  • Taxable Status
  • Cost

Payment (new)(if invoice)

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

Inventory (updated)

  • Inventory Level

Pricing (updated)

  • Product Price

QuickBooks Online -> Shopify

Inventory (updated)

  • Inventory Level

Pricing (updated)

  • Product Price

Payment (new)

  • Shopify Order Status can be updated to “Paid” when a payment is added to the related invoice in QuickBooks.