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 and types of data we sync between Shopify & QuickBooks Desktop.
Shopify -> QuickBooks Desktop
Customer (new)
First Name
Last Name
Company Name
Supports Shopify Plus Company names and Location names
Email
Address Line 1
Address Line 2
City
State
Postcode
Country
Order (new)
Can be synced as an Invoice, Sales Receipt, Sales Order, or Invoice + Sales Order
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
Purchase Order (Stocky) (new)
Can be synced as a Purchase Order, a Bill, or both
Purchase Order Number (can be Stocky PO number, custom order number, adding a prefix before, or using the next available QuickBooks order number.)
Associated Vendor (matching Stocky Vendor Name)
Billing Address
Shipping Address
Order Date
Due Date
Product/Service line items
SKU
Description
Cost
Quantity
Amount
Shipping
Stocky Invoice Number
Product (new)
Shopify Product Name (QuickBooks Description)
Shopify Product SKU (Item Name/Number)
Barcode (if enabled in QuickBooks)
Description
Inventory Level (if inventory product)
Price
Cost
Variation (new)
Shopify Variation Name (QuickBooks Description)
Shopify Variation SKU (Item Name/Number)
Barcode (if enabled in QuickBooks)
Description
Inventory Level (if inventory product)
Price
Cost
Payment (new)(if invoice)
Related invoice
Payment Date
Payment Method
Reference No. (Transaction ID or Shopify order number)
Amount Received
QuickBooks Desktop -> Shopify
Inventory Level (updated)
Inventory Level
Price (updated)
Product Price
Cost (updated)
Product Cost
Product (new) (coming soon)
Name
SKU
Description
Price
Cost
Payment (new) (coming soon)
Shopify Order Status can be updated to “Paid” when a payment is added to the related invoice in QuickBooks.