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 and updated)
First Name
Last Name
Company Name
Email
Phone Number
Address Line 1
Address Line 2
City
State
Postcode
Country
Order (new and updated)
Can be synced as Invoice, Sales Receipt, Sales Order, or Estimate
Order Number (can be WooCommerce order ID, custom order number, or next QuickBooks number)
Associated Customer
Billing Address
Shipping Address
Order Date
Due Date (If invoice)
Class
Product/Service line items
SKU
Description
Quantity
Amount
Class
Inventory Site (with Advanced Inventory)
Shipping Amount
Discount
Tax
Memo
Custom Fields (custom mapping handled on a case by case basis)
Product (new)
Item Name/Number (uses WooCommerce SKU if exists, otherwise WooCommerce name)
Description (optional)
Inventory Level (if inventory product)
Price
Variation (new)
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
Refund (new)
Syncs as Credit Memo with optional CreditCardRefund record
Refund Date
Payment Method
Class
Reference No. (Transaction ID or WooCommerce order number)
Amount Refunded
Items Refunded
QuickBooks Desktop -> WooCommerce
Product (new)
QuickBooks Item Name/Number
Sales Description
Purchase Description
Inventory Level
Price
Created as a simple product in WooCommerce, with choice of status as Published, Draft or Pending Review
Inventory Level (any updates)
Inventory Level
Quantity on Hand, or,
Available Quantity (Quantity on Hand - Quantity on Sales Order)
Pricing (any updates)
Regular Product Price
Syncs any changes from the QuickBooks Price field to the "Regular Price" field in WooCommerce.
Sale Product Price
Syncs any changes from the QuickBooks Price field to the "Sale Price" field in WooCommerce - which represents the price a product is "on sale" for.
Custom support available for syncing Pricing Levels, if supported in WooCommerce
The QuickBooks product price fields our sync reads can be set in MyWorks Sync > Settings > Pull - and can be the following fields:
Regular Sales Price field in the QuickBooks Item
A custom field in the QuickBooks Item named "SalesPrice"
A custom field in the QuickBooks Item named "Retail Price"
A per-item "Price Level" present in QuickBooks