Intuit QuickBooks Web Store Integration

The below outlines field mappings which allow your web store to fully integrate with QuickBooks accounting software. Download 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