Salesforce.com Field Mapping

For each Salesforce.com Object type there is a table showing what can be mapped into the field from the UltraCart side.

Account Object

UltraCart Object	UltraCart Field	Salesforce Field
Order	First Name + Last Name	Name
Order	Billing Address 1	BillingStreet
Order	Billing City	BillingCity
Order	Billing State	BillingState
Order	Billing Zip	BillingPostalCode
Order	Billing Country	BillingCountry
Order	Shipping Address 1	ShippingStreet
Order	Shipping City	ShippingCity
Order	Shipping State	ShippingState
Order	Shipping Zip	ShippingPostalCode
Order	Shipping Country	ShippingCountry
Order	Day Phone	Phone
Order.CustomerProfile	First Name + Last Name	Name
Order.CustomerProfile	Billing Address 1	BillingStreet
Order.CustomerProfile	Billing City	BillingCity
Order.CustomerProfile	Billing State	BillingState
Order.CustomerProfile	Billing Zip	BillingPostalCode
Order.CustomerProfile	Billing Country	BillingCountry
Order.CustomerProfile	Phone	Phone
Order.CustomerProfile	Business Notes	Description

Account (Person) Object

UltraCart Object	UltraCart Field	Salesforce Field
Order	First Name + Last Name	Name
Order	Billing Address 1	BillingStreet
Order	Billing City	BillingCity
Order	Billing State	BillingState
Order	Billing Zip	BillingPostalCode
Order	Billing Country	BillingCountry
Order	Shipping Address 1	PersonMailingAddress
Order	Shipping City	PersonMailingCity
Order	Shipping State	PersonMailingState
Order	Shipping Zip	PersonMailingPostalCode
Order	Shipping Country	PersonMailingCountry
Order	Shipping Address 1	ShippingStreet
Order	Shipping City	ShippingCity
Order	Shipping State	ShippingState
Order	Shipping Zip	ShippingPostalCode
Order	Shipping Country	ShippingCountry
Order	Billing Title	PersonTitle
Order	Email	PersonEmail

Contact Object

UltraCart Object	UltraCart Field	Salesforce Field
Order	Billing First Name	FirstName
Order	Billing Last Name	LastName
Order	Shipping Address1	MailingStreet
Order	Shipping City	MailingCity
Order	Shipping State	MailingState
Order	Shipping Zip	MailingPostalCode
Order	Shipping Country	MailingCountry
Order	Shipping Phone	Phone
Order	Billing Title	Title
Order	Email	Email
Order	Billing Address 1	<Custom>
Order	Billing Address 2	<Custom>
Order	Billing City	<Custom>
Order	Billing State	<Custom>
Order	Billing Postal Code	<Custom>
Order	Billing Country	<Custom>
Order	Merchant ID	<Custom>
Order.CustomerProfile	Billing First Name	FirstName
Order.CustomerProfile	Billing Last Name	LastName
Order.CustomerProfile	Day Phone	Phone
Order.CustomerProfile	Billing Title	Title
Order.CustomerProfile	Email	Email
Order.CustomerProfile	Billing Address 1	<Custom>
Order.CustomerProfile	Billing Address 2	<Custom>
Order.CustomerProfile	Billing City	<Custom>
Order.CustomerProfile	Billing State	<Custom>
Order.CustomerProfile	Billing Postal Code	<Custom>
Order.CustomerProfile	Billing Country	<Custom>
Order.CustomerProfile	Merchant ID	<Custom>
Order.CustomerProfile	Allow 3rd Party Billing	<Custom>
Order.CustomerProfile	Allow COD	<Custom>
Order.CustomerProfile	Allow PO	<Custom>
Order.CustomerProfile	Auto Approve COD	<Custom>
Order.CustomerProfile	Auto Approve PO	<Custom>
Order.CustomerProfile	Minimum Item Count	<Custom>
Order.CustomerProfile	No Free Shipping	<Custom>
Order.CustomerProfile	Tax Exempt	<Custom>
Order.CustomerProfile	Tax ID	<Custom>
Order.CustomerProfile	Customer Profile ID	<Custom>
Order.CustomerProfile	Single Sign On ID	<Custom>
Order.CustomerProfile	Billing Address 1	<Custom>
Order.CustomerProfile	Billing Address 2	<Custom>
Order.CustomerProfile	Billing City	<Custom>
Order.CustomerProfile	Billing State	<Custom>
Order.CustomerProfile	Billing Postal Code	<Custom>
Order.CustomerProfile	Billing Country	<Custom>
Order.CustomerProfile	Merchant ID	<Custom>

Custom Object

UltraCart Object	UltraCart Field	Salesforce.com Field
Order	Payment Type	<Custom>
Order	Order ID	<Custom>
Order	Company Name	<Custom>
Order	Custom Field 1	<Custom>
Order	Custom Field 2	<Custom>
Order	Custom Field 3	<Custom>
Order	Custom Field 4	<Custom>
Order	Custom Field 5	<Custom>
Order	Shipping & Handling Total	<Custom>
Order	Shipping Method	<Custom>
Order	Review Link	<Custom>
Order	Credit Card Type	<Custom>
Order	Credit Card Exp Month	<Custom>
Order	Credit Card Exp Year	<Custom>
Order	Credit Card Num Last 4	<Custom>
Order.Affiliate	Affiliate ID	<Custom>
Order.Affiliate	Affiliate Name	<Custom>
Order.Affiliate	Affiliate E-Mail	<Custom>
Order.Affiliate	Affiliate Commission Amt	<Custom>
Order.AutoOrder	Auto Order Code	<Custom>
Order.AutoOrder	Cancelled By User	<Custom>
Order.AutoOrder	Cancellation Date	<Custom>
Order.AutoOrder	Failure Reason	<Custom>
Order.AutoOrder	Next Charge Attempt	<Custom>
Order.AutoOrder	Rotating Gateway Code	<Custom>
Order.CustomerProfile	Allow 3rd Party Billing	<Custom>
Order.CustomerProfile	Allow COD	<Custom>
Order.CustomerProfile	Allow PO	<Custom>
Order.CustomerProfile	Auto Approve COD	<Custom>
Order.CustomerProfile	Auto Approve PO	<Custom>
Order.CustomerProfile	Minimum Item Count	<Custom>
Order.CustomerProfile	No Free Shipping	<Custom>
Order.CustomerProfile	Tax Exempt	<Custom>
Order.CustomerProfile	Tax ID	<Custom>
Order.CustomerProfile	Customer Profile ID	<Custom>
Order.CustomerProfile	Single Sign On ID	<Custom>

If you are mapping fields to a custom object in Salesforce then the object must have a relationship to the Opportunity table so that the column Opportunity__c exists on the custom object.

Opportunity Object

UltraCart Object	UltraCart Field	Salesforce Field
Order	Order ID	Name
	"Closed Won"	StageName
Order	Total	Amount
	"100"	Probability
Order	Creation Date	CloseDate
Order	Payment Type	<Custom>
Order	Order ID	<Custom>
Order	Custom Field 1	<Custom>
Order	Custom Field 2	<Custom>
Order	Custom Field 3	<Custom>
Order	Custom Field 4	<Custom>
Order	Custom Field 5	<Custom>
Order	Custom Field 6	<Custom>
Order	Custom Field 7	<Custom>
Order	Shipping & Handling Total	<Custom>
Order	Shipping Method	<Custom>
Order	Tax County	<Custom>
Order	Order Comments	<Custom>
Order	Order Notes	<Custom>
Order	Order Merchant Notes	<Custom>
Order	Payment Status	<Custom>
Order	Shipped Date	<Custom>
Order	Payment Method	<Custom>
Order	Current Stage	<Custom>
Order	Mailing List	<Custom>
Order	Advertising Source	<Custom>
Order	Merchant ID	<Custom>
Order	Coupon Code	<Custom>
Order	Review Link	<Custom>
Order	Credit Card Type	<Custom>
Order	Credit Card Exp Month	<Custom>
Order	Credit Card Exp Year	<Custom>
Order	Credit Card Num Last 4	<Custom>
Order	Single Sign on CCID	<Custom>

Opportunity Line Item Object

UltraCart Object	UltraCart Field	Salesforce Field
Order.Item	Quantity	Quantity
Order.Item	Unit Price After Discount	Unit Price
Order.Item	Description	Description
Order	Creation Date	ServiceDate
Order.Item.Option#	Name	<Custom>
Order.Item.Option#	Value	<Custom>
Order.Item	Parent Kit Item ID	<Custom>

Product Object

UltraCart Object	UltraCart Field	Salesforce Field
Item	Description	Name
Item	Item ID	ProductCode
Item	Description	Description
	"true"	IsActive