Intuit QuickBooks Web Store Integration

The below outlines field mappings which allow your web store to fully integrate with QuickBooks accounting software. QuickBooks Webstore - PDFDownload StoreFront/QuickBooks Mapping

Customer Data

From StoreFront To QuickBooks
Customer E-mail E-mail
First Name First Name
Last Name Last Name
Billing Company Company Name
Billing Phone Phone
Fax Fax
Billing Address Addr1 Billing Address Addr1
Billing Address Addr2 Billing Address Addr2
Billing Address State Billing Address State
Billing Address City Billing Address City
Billing Address PostalCode Billing Address PostalCode
Billing Address Country Billing Address Country

Sales Order

From StoreFront To QuickBooks
Order ID and Prefix (If Applicable) Reference Number
Customer UID Customer Reference
Billing Address Addr1 Billing Address Addr1
Billing Address Addr2 Billing Address Addr2
Billing Address State Billing Address State
Billing Address City Billing Address City
Billing Address PostalCode Billing Address PostalCode
Billing Address Country Billing Address Country
Shipping Address 1 Shipping Address 1
Shipping Address 2 Shipping Address 2
Shipping Address – City Billing Address – City
Shipping Address – State Shipping Address – State
Shipping Address – Postal Code Shipping Address – Postal Code
Shipping Address – Country Shipping Address – Country
Payment Method Payment Method
Ship Method Ship Method
Order Date Transaction Date
PID Item Reference
Quantity Quantity
Price Rate
Is Taxable Sales Tax Code

Inventory Updates

From QuickBooks To StoreFront
Item Name/Number Product Code/SKU
Sales Price Price
Cost Cost
Quantity On Hand – Qauntity On Sales Orders Inventory Quantity

Sales Invoice

From StoreFront To QuickBooks
Order ID and Prefix (If Applicable) Ref Number
Customer UID Customer Reference
Billing Address Addr1 Billing Address Addr1
Billing Address Addr2 Billing Address Addr2
Billing Address State Billing Address State
Billing Address City Billing Address City
Billing Address PostalCode Billing Address PostalCode
Billing Address Country Billing Address Country
PO Number PO Number
Ship Carrier Ship Method
Order Date Transaction Date
PID Item Reference
Quantity Quantity
Price Rate
Is Taxable Sales Tax Code
Accounts Receivable Account

Sales Receipt

From StoreFront To QuickBooks
Order ID and Prefix (If Applicable) Ref Number
Customer UID Customer Reference
Billing Address Addr1 Billing Address Addr1
Billing Address Addr2 Billing Address Addr2
Billing Address State Billing Address State
Billing Address City Billing Address City
Billing Address PostalCode Billing Address PostalCode
Billing Address Country Billing Address Country
Shipping Address 1 Shipping Address – Address 1
Shipping Address 1.2 Shipping Address – Address 2
Shipping Address – City Shipping Address – City
Shipping Address – State Shipping Address – State
Shipping Address – Postal Code Shipping Address – Postal Code
Shipping Address – Country Shipping Address – Country
Payment Method Payment Method
Ship Carrier Ship Method
Order Date Transaction Date
PID Item Reference
Quantity Quantity
Price Rate
Is Taxable Sales Tax Code
Sales Account