Default Fields & Sync Direction Summary

Summary

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 is supported, and is handled on a case by case basis over support ticket. Additional WooCommerce plugins that add extra functionality/fields would not conflict with our sync, but may need custom mapping if their fields need to be used by our sync.

WooCommerce -> QuickBooks Desktop

Customer (new only)

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

Order (new only)

  • Can be synced as Invoice, Sales Receipt, Sales Order, or Estimate
  • Associated Customer
  • Billing Address
  • Shipping Address
  • Order Date
  • Due Date (If invoice)
  • Product/Service line items
  • SKU
  • Description
  • Quantity
  • Amount
  • Class
  • Inventory Site (with Advanced Inventory addon)
  • Shipping
  • Discount
  • Tax
  • Memo
  • Custom Fields (custom mapping handled on a case by case basis)

Product (new only)

  • Item Name/Number (uses WooCommerce SKU if exists, otherwise WooCommerce name)
  • Description (optional)
  • Inventory Level (if inventory product)
  • Price

Variation (new only)

  • Item Name/Number (uses WooCommerce SKU if exists, otherwise WooCommerce name)
  • 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

QuickBooks Desktop -> WooCommerce

Inventory Level (any updates)

  • Inventory Level
  • Quantity on Hand, or,
  • Available Quantity (Quantity on Hand - Quantity on Sales Order)

Pricing (any updates)

  • Base Product Price
  • Syncs any changes to the base product price in QuickBooks to the base product price in WooCommerce.

Was this article helpful?
0 out of 0 found this helpful

Navigation