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.

Custom Object

UltraCart Object	UltraCart Field	Salesforce.com ObjectSalesforce.com Field
Order	Payment Type	<Custom>	<Custom>
Order	Order ID	<Custom>	<Custom>
Order	Company Name		<Custom>
Order	Custom Field 1		<Custom>
Order	Custom Field 2	<Custom>	<Custom>
Order	Custom Field 3		<Custom>
Order	Custom Field 4		<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>
Order	Credit Card Exp Year	<Custom>	<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	Signle Sign On ID	<Custom>

Account Object

AccountAccountAccountAccountAccount

UltraCart Object	UltraCart Field	Salesforce Field
Order	First Name + Last Name	Account	Name
Order	Billing Address 1	Account	BillingStreet
Order	Billing City	Account	BillingCity
Order	Billing State	Account	BillingState
Order	Billing Zip		BillingPostalCode
Order	Billing Country		BillingCountry
Order	Shipping Address 1	Account	ShippingStreet
Order	Shipping City		ShippingCity
Order	Shipping State		ShippingState
Order	Shipping Zip	Account	ShippingPostalCode
Order	Shipping Country		ShippingCountry
Order	Day Phone	Account	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	Account (Person)	BillingStreet
Order	Billing City	Account (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 CityAccount (Person)	PersonMailingCity
Order	Shipping State	Account (Person)	PersonMailingState
Order	Shipping Zip	Account (Person)	PersonMailingPostalCode
Order	Shipping Country	Account (Person)	PersonMailingCountry
Order	Shipping Address 1Account (Person)	ShippingStreet
Order	Shipping City	Account (Person)	ShippingCity
Order	Shipping State	Account (Person)	ShippingState
Order	Shipping ZipAccount (Person)	ShippingPostalCode
Order	Shipping CountryAccount (Person)	ShippingCountry
Order	Billing Title	Account (Person)	PersonTitle
Order	Email	Account (Person)	PersonEmail	PersonEmail

Opportunity Object

OpportunityOpportunityOpportunityOpportunityOpportunityOpportunityOpportunityOpportunityOpportunityOpportunityOpportunityOpportunityOpportunity

UltraCart Object	UltraCart Field	Salesforce Field
Order	Order ID	Opportunity	Name
	"Closed Won"	Opportunity	StageName
Order	Total	Opportunity	Amount
	"100"		Probability
Order	Creation Date		CloseDate
Order	Payment Type	Opportunity	<Custom>
Order	Order ID		<Custom>
Order	Custom Field 1		<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		<Custom>
Order	Shipping & Handling Total		<Custom>
Order	Shipping Method	Opportunity	<Custom>
Order	Tax County		<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		<Custom>
Order	Current Stage		<Custom>
Order	Mailing List	Opportunity	<Custom>
Order	Advertising Source		<Custom>
Order	Merchant ID		<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		<Custom>
Order	Single Sign on CCID		<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	<Custom>
Order.Affiliate	Affiliate ID
Order.Affiliate	Affiliate Name
Order.Affiliate	Affiliate E-Mail
Order.Affiliate	Affiliate Commission Amt
Order.AutoOrder	Auto Order Code
Order.AutoOrder	Cancelled By User
Order.AutoOrder	Cancellation Date
Order.AutoOrder	Failure Reason
Order.AutoOrder	Next Charge Attempt
Order.AutoOrder	Rotating Gateway Code

Order.CustomerProfile	Allow 3rd Party Billing	<Custom>	<Custom>
Order.CustomerProfile	Allow COD	<Custom>	<Custom>
Order.CustomerProfile	Allow PO
Order.CustomerProfile	Auto Approve COD
Order.CustomerProfile	Auto Approve PO
Order.CustomerProfile	Minimum Item Count
Order.CustomerProfile	No Free Shipping
Order.CustomerProfile	Tax Exempt
Order.CustomerProfile	Tax ID
Order.CustomerProfile	Customer Profile ID
Order.CustomerProfile	Signle Sign On ID
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

Contact Object

ContactContactContactContactContactContactContactContactContactContactContactProduct

UltraCart Object	UltraCart Field	Salesforce Field
Order	Billing First Name	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		MailingPostalCode
Order	Shipping Country		MailingCountry
Order	Shipping Phone	Contact	Phone
Order	Billing Title		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		<Custom>
Order	Billing Country		<Custom>
Order	Merchant ID	Contact	<Custom>
Order.CustomerProfile	Billing First NameContact	FirstName
Order.CustomerProfile	Billing Last NameContact	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 CityContact	<Custom>
Order.CustomerProfile	Billing State	Contact	<Custom>
Order.CustomerProfile	Billing Postal Code	Contact	<Custom>
Order.CustomerProfile	Billing CountryContact	<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		<Custom>
Order.CustomerProfile	Minimum Item Count		<Custom>
Order.CustomerProfile	No Free Shipping	Contact	<Custom>
Order.CustomerProfile	Tax Exempt		<Custom>
Order.CustomerProfile	Tax ID		<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		<Custom>
Order.CustomerProfile	Billing Postal Code		<Custom>
Order.CustomerProfile	Billing Country	Contact	<Custom>
Order.CustomerProfile	Merchant ID	Contact	<Custom>
Item	Description	Product	Name
Item	Item ID		<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	Product	Description
	"true"	Product	IsActive

Versions Compared

Old Version 1

New Version 2

Key

Salesforce.com Field Mapping

Custom Object

Account Object

Account (Person) Object

Opportunity Object

Contact Object

Opportunity Line Item Object

Product Object

Page Comparison

Versions Compared

Old Version 1

New Version 2

Key

Salesforce.com Field Mapping

Custom Object

Account Object

Account (Person) Object

Opportunity Object

Contact Object

Opportunity Line Item Object

Product Object