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)