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 for QuickBooks POS. 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 POS

Customer (new only)

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

Order (new only)

  • Can be synced as Sales Receipt or Sales Order
  • Associated Customer
  • Billing Address
  • Shipping Address
  • Order Date
  • Product/Service line items
    • Item Name
    • Description
    • Quantity
    • Amount
  • Shipping
  • Discount
  • Tax

Product (new only)

  • Image
  • Name
  • SKU (Can use Item Number, UPC or ALU field in QuickBooks)
  • Description
  • Inventory Level (if inventory product)
  • Price
  • Category (mapped to Department in QuickBooks POS)

Variation (new only)

  • Note: Variations will sync as standard products into QuickBooks POS
  • Image
  • Name
  • SKU (Can use Item Number, UPC or ALU field in QuickBooks)
  • Description
  • Inventory Level (if inventory product)
  • Price
  • Category (mapped to Department in QuickBooks POS)

QuickBooks POS -> WooCommerce

Inventory Level (any updates)

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

Pricing (any updates)

  • Base Product Price
    • Syncs any changes to the base product price in QuickBooks to the base product price in WooCommerce.
  • Base Product Sale Price (optional)
    • Syncs any changes from Price Fields 1-5 in QuickBooks to the base product sale price in WooCommerce.

Product (new and updated)

  • Image
  • Name
  • SKU (Can use Item Number, UPC or ALU field in QuickBooks)
  • Description
  • Inventory Level (if inventory product)
  • Price
  • Category (mapped to Department in QuickBooks POS)
Updated on June 30, 2020

Was this article helpful?