Summary
MyWorks Sync has many different options when it comes to syncing data between Shopify and QuickBooks Desktop, 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. Custom field mapping is also supported when syncing orders from Shopify to QuickBooks.
Shopify -> QuickBooks Desktop
Customer (new)
- First Name
- Last Name
- Company Name
- Address Line 1
- Address Line 2
- City
- State
- Postcode
- Country
Order (new and updated)
- Can be synced as an Invoice, Sales Receipt, Sales Order, or Estimate
- Order Number (can be Shopify order number, custom order number, adding a prefix before, or using the next available QuickBooks order number.)
- Associated Customer
- Billing Address
- Shipping Address
- Order Date
- Due Date & Terms (If invoice)
- Class
- Product/Service line items
- SKU
- Description
- Quantity
- Amount
- Shipping Amount
- Discount
- Tax
- Memo
- Custom Fields
Product (new)
- Name (Item Name/Number)
- Description
- Inventory Level (if inventory product)
- Price
Variation (new)
- Name (Item Name/Number)
- Description
- Inventory Level (if inventory product)
- Price
Payment (new)(if invoice)
- Related invoice
- Payment Date
- Payment Method
- Reference No. (Transaction ID or Shopify order number)
- Amount Received
QuickBooks Desktop -> Shopify
Inventory (updated)
- Inventory Level
Pricing (updated)
- Product Price