Table of Contents

Salesforce.com Field Mapping

The following table displays all the fields within UltraCart and how they will automatically map to the corresponding fields on Salesforce.com objects.For each Salesforce.com Object type there is a table showing what can be mapped into the field from the UltraCart side.

Account Object

.com ObjectSalesforce.com OrderAccountAccountAccountAccountShipping Address 1AccountShipping CityAccountShippingCityOrderShipping State

UltraCart Object	UltraCart Field	Salesforce	Field
Order	Payment Type	<Custom>	<Custom>
Order	Order ID	<Custom>	<Custom>
Order	Company Name	<Custom>	<Custom>
Order	Custom Field 1	<Custom>	<Custom>
Order	Custom Field 2	<Custom>	<Custom>
Order	Custom Field 3	<Custom>	<Custom>
Order	Custom Field 4	<Custom>	<Custom>
Order	Custom Field 5	<Custom>	<Custom>
Order	Shipping & Handling Total	<Custom>	<Custom>
Order	Shipping Method	<Custom>	<Custom>
Order	Review Link	<Custom>	<Custom>
Order	Credit Card Type	<Custom>	<Custom>
Order	Credit Card Exp Month	<Custom>	<Custom>
Order	Credit Card Exp Year	<Custom>	<Custom>
Order	Credit Card Num Last 4	<Custom>	<Custom>
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	Account	BillingState
Order.CustomerProfile	Billing Zip		BillingPostalCode
Order.CustomerProfile	Billing Country	Account	BillingCountry
Order.CustomerProfile	Phone	Phone	ShippingStreet
Order.CustomerProfile	Business Notes	Description

Account

...

(Person) Object

UltraCart Object	UltraCart Field	Salesforce Field
Order	First Name + Last NameAccount (Person)	Name
Order	Billing Address 1Account (Person)	BillingStreet
Order	Billing CityAccount (Person)	BillingCity
Order	Billing StateAccount (Person)	BillingState
Order	Billing ZipAccount (Person)	BillingPostalCode
Order	Billing Country	Account (Person)	BillingCountry
Order	Shipping Address 1Account (Person)	PersonMailingAddress
Order	Shipping City	Account (Person)	PersonMailingCity
Order	Shipping StateAccount (Person)	PersonMailingState
Order	Shipping Zip	Account (Person)	PersonMailingPostalCode
Order	Shipping CountryAccount (Person)	PersonMailingCountry
Order	Shipping Address 1Account (Person)	ShippingStreet
Order	Shipping CityAccount (Person)	ShippingCity
Order	Shipping StateAccount (Person)	ShippingState
Order	Shipping ZipAccount (Person)	ShippingPostalCode
Order	Shipping Country	Account (Person)	ShippingCountry
Order	Billing Title	Account (Person)	PersonTitle
Order	Email	Account (Person)	PersonEmail
Order	Order ID	Opportunity	Name
	"Closed Won"	Opportunity	StageName
Order	Total	Opportunity	Amount
	"100"	Opportunity	Probability
Order	Creation Date	Opportunity	CloseDate
Order	Payment Type	Opportunity	<Custom>
Order	Order ID	Opportunity	<Custom>
Order	Custom Field 1	Opportunity	<Custom>
Order	Custom Field 2	Opportunity	<Custom>
Order	Custom Field 3	Opportunity	<Custom>
Order	Custom Field 4	Opportunity	<Custom>
Order	Custom Field 5	Opportunity	<Custom>
Order	Custom Field 6	Opportunity	<Custom>
Order	Custom Field 7	Opportunity	<Custom>
Order	Shipping & Handling Total	Opportunity	<Custom>
Order	Shipping Method	Opportunity	<Custom>
Order	Tax County	Opportunity	<Custom>
Order	Order Comments	Opportunity	<Custom>
Order	Order Notes	Opportunity	<Custom>
Order	Order Merchant Notes	Opportunity	<Custom>
Order	Payment Status	Opportunity	<Custom>
Order	Shipped Date	Opportunity	<Custom>
Order	Payment Method	Opportunity	<Custom>
Order	Current Stage	Opportunity	<Custom>
Order	Mailing List	Opportunity	<Custom>
Order	Advertising Source	Opportunity	<Custom>
Order	Merchant ID	Opportunity	<Custom>
Order	Coupon Code	Opportunity	<Custom>
Order	Review Link	Opportunity	<Custom>
Order	Credit Card Type	Opportunity	<Custom>
Order	Credit Card Exp Month	Opportunity	<Custom>
Order	Credit Card Exp Year	Opportunity	<Custom>
Order	Credit Card Num Last 4	Opportunity	<Custom>
Order	Single Sign on CCID	Opportunity	<Custom>
Order.Item	Quantity	Opportunity Line Item	Quantity
Order.Item	Unit Price After Discount	Opportunity Line Item	Unit Price
Order.Item	Description	Opportunity Line Item	Description
Order	Creation Date	Opportunity Line Item	ServiceDate
Order.Item.Option#	Name	Opportunity Line Item	<Custom>
Order.Item.Option#	Value	Opportunity Line Item	<Custom>
Order.Item	Parent Kit Item ID	Opportunity Line Item		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

Product

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>	<Custom>
Order.CustomerProfile	Allow COD	<Custom>	<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	Signle Single Sign On ID	<Custom>
Order.CustomerProfile	First Name + Last Name	Account	Name
Order.CustomerProfile	Billing Address 1	Account	BillingStreet
Order.CustomerProfile	Billing City	Account	BillingCity
Order.CustomerProfile	Billing State	Account	BillingState
Order.CustomerProfile	Billing Zip	Account	BillingPostalCode
Order.CustomerProfile	Billing Country	Account	BillingCountry
Order.CustomerProfile	Phone	Account	Phone
Order.CustomerProfile	Business Notes	Account	Description
Order	Billing First Name	Contact	FirstName
Order	Billing Last Name	Contact	LastName
Order	Shipping Address1	Contact	MailingStreet
Order	Shipping City	Contact	MailingCity
Order	Shipping State	Contact	MailingState
Order	Shipping Zip	Contact	MailingPostalCode
Order	Shipping Country	Contact	MailingCountry
Order	Shipping Phone	Contact	Phone
Order	Billing Title	Contact	Title
Order	Email	Contact	Email
Order	Billing Address 1	Contact	<Custom>
Order	Billing Address 2	Contact	<Custom>
Order	Billing City	Contact	<Custom>
Order	Billing State	Contact	<Custom>
Order	Billing Postal Code	Contact	<Custom>
Order	Billing Country	Contact	<Custom>
Order	Merchant ID	Contact	<Custom>
Order.CustomerProfile	Billing First Name	Contact	FirstName
Order.CustomerProfile	Billing Last Name	Contact	LastName
Order.CustomerProfile	Day Phone	Contact	Phone
Order.CustomerProfile	Billing Title	Contact	Title
Order.CustomerProfile	Email	Contact	Email
Order.CustomerProfile	Billing Address 1	Contact	<Custom>
Order.CustomerProfile	Billing Address 2	Contact	<Custom>
Order.CustomerProfile	Billing City	Contact	<Custom>
Order.CustomerProfile	Billing State	Contact	<Custom>
Order.CustomerProfile	Billing Postal Code	Contact	<Custom>
Order.CustomerProfile	Billing Country	Contact	<Custom>
Order.CustomerProfile	Merchant ID	Contact	<Custom>
Order.CustomerProfile	Allow 3rd Party Billing	Contact	<Custom>
Order.CustomerProfile	Allow COD	Contact	<Custom>
Order.CustomerProfile	Allow PO	Contact	<Custom>
Order.CustomerProfile	Auto Approve COD	Contact	<Custom>
Order.CustomerProfile	Auto Approve PO	Contact	<Custom>
Order.CustomerProfile	Minimum Item Count	Contact	<Custom>
Order.CustomerProfile	No Free Shipping	Contact	<Custom>
Order.CustomerProfile	Tax Exempt	Contact	<Custom>
Order.CustomerProfile	Tax ID	Contact	<Custom>
Order.CustomerProfile	Customer Profile ID	Contact	<Custom>
Order.CustomerProfile	Single Sign On ID	Contact	<Custom>
Order.CustomerProfile	Billing Address 1	Contact	<Custom>
Order.CustomerProfile	Billing Address 2	Contact	<Custom>
Order.CustomerProfile	Billing City	Contact	<Custom>
Order.CustomerProfile	Billing State	Contact	<Custom>
Order.CustomerProfile	Billing Postal Code	Contact	<Custom>
Order.CustomerProfile	Billing Country	Contact	<Custom>
Order.CustomerProfile	Merchant ID	Contact	<Custom>
Item	Description	Product	Name
Item	Item ID	Product	ProductCode
Item	Description

Note
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

Product

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

Versions Compared

Old Version 1

New Version Current

Key

Salesforce.com Field Mapping

Account Object

Account

(Person) Object

Contact Object

Custom Object

Opportunity Object

Opportunity Line Item Object

Product Object

Page Comparison

Versions Compared

Old Version 1

New Version Current

Key

Salesforce.com Field Mapping

Account Object

Account

(Person) Object

Contact Object

Custom Object

Opportunity Object

Opportunity Line Item Object

Product Object