Converting Data Between Quick Shopping Cart and Intuit QuickBooks

This list illustrates the field mappings from Quick Shopping Cart Orders to Intuit® QuickBooks® Sales Receipts.

Quick Shopping Cart = maps to = QuickBooks

QuickBooks Integration Setup Customer default = Quick Shopping Cart Customer) = maps to = Customer Full Name

Order Create Date = maps to = Transaction Date

Order Invoice ID = maps to = Reference Number

Billing Full Name = maps to = Billing Address: Address 1

Billing Address 1 = maps to = Billing Address: Address 2

Billing Address 2 = maps to = Billing Address: Address 3

Billing City = maps to = Billing Address: City

Billing State = maps to = Billing Address: State

Billing Postal Code = maps to = Billing Address: Postal Code

Billing Country Code = maps to = Billing Address: Country

Shipping Full Name = maps to = Shipping Address: Address 1

Shipping Address 1 = maps to = Shipping Address: Address 2

Shipping Address 2 = maps to = Shipping Address: Address 3

Shipping City = maps to = Shipping Address: City

Shipping State = maps to = Shipping Address: State

Shipping Postal Code = maps to = Shipping Address: Postal Code

Shipping Country Code = maps to = Shipping Address: Country

Ship Date = maps to = Ship Date

Shipping Method = maps to = Shipping Method

Credit Card Number = maps to = Credit Card Number

Credit Card Expiration Month = maps to = Credit Card Expiration Month

Credit Card Expiration Year = maps to = Credit Card Expiration Year

Name on Credit Card = maps to = Name on Credit Card

Credit Card Billing Address = maps to = Credit Card Billing Address

Credit Card Postal Code = maps to = Credit Card Postal Code

QuickBooks Integration Setup Item(default Quick Shopping Cart Item) - or - QuickBooks Integration Setup Shipping Charge selection - or - QuickBooks Integration Setup Sales Tax selection = maps to = Item Full Name

ASC Product Name - or - Shipping Charge - or - Sales Tax = maps to = Item Description

Quantity = maps to = Quantity

Product Price - or - Shipping Charge - or - Sales Tax = maps to = Amount

Product Price = maps to = Memo

For more information about using QuickBooks, refer to the QuickBooks Quick Start Guide.