Summary

MyWorks Sync has many different options for 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 is 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 with our support team. 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 MyWorks 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
• Weight
• Category (mapped to Department in QuickBooks POS)
• Attribute (map up to two attributes to QuickBooks "Attribute" and "Size" fields)

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
• Weight
• Category (mapped to Department in QuickBooks POS)
• Attribute (map up to two attributes to QuickBooks "Attribute" and "Size" fields)

QuickBooks POS -> WooCommerce

Inventory Level (any updates)

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

Pricing (any updates)

• Regular Product Price
  • Syncs any changes from the QuickBooks POS Price field to the "Regular Price" field in WooCommerce.
• Sale Product Price
  • Syncs any changes from the QuickBooks POS Price field to the "Sale Price" field in WooCommerce - which represents the price a product is "on sale" for. 

The QuickBooks product price fields our sync reads can be set in MyWorks Sync > Settings > Pull - and can be one of the following fields:

• Regular Sales Price field (Price1) in the QuickBooks Item
• The Price2 - Price5 fields in the QuickBooks Item
• The "WebPrice" field in the QuickBooks Item
• A custom field in the QuickBooks Item named "Online Price"
• A custom field in the QuickBooks Item named "Sale Price"
• A custom field in the QuickBooks Item named "Custom Field 1, 2, 3, 4, or 5"

Product (new and updated)

• Note: QuickBooks products always sync into WooCommerce as simple products.
• Image
• Name
• SKU (Can use Item Number, UPC, or ALU field in QuickBooks)
• Description
• Inventory Level (if inventory product)
• Price
• Weight
• Category (mapped to Department in QuickBooks POS)
• Attribute (map QuickBooks "Attribute" and "Size" fields to WooCommerce attributes)