Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

...

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 ObjectUltraCart FieldSalesforce.com Field
OrderPayment Type<Custom>
OrderOrder ID<Custom>
OrderCompany Name<Custom>
OrderCustom Field 1<Custom>
OrderCustom Field 2<Custom>
OrderCustom Field 3<Custom>
OrderCustom Field 4<Custom>
OrderCustom Field 5<Custom>
OrderShipping & Handling Total<Custom>
OrderShipping Method<Custom>
OrderReview Link<Custom>
OrderCredit Card Type<Custom>
OrderCredit Card Exp Month<Custom>
OrderCredit Card Exp Year<Custom>
OrderCredit Card Num Last 4<Custom>
Order.AffiliateAffiliate ID<Custom>
Order.AffiliateAffiliate Name<Custom>
Order.AffiliateAffiliate E-Mail<Custom>
Order.AffiliateAffiliate Commission Amt<Custom>
Order.AutoOrderAuto Order Code<Custom>
Order.AutoOrderCancelled By User<Custom>
Order.AutoOrderCancellation Date<Custom>
Order.AutoOrderFailure Reason<Custom>
Order.AutoOrderNext Charge Attempt<Custom>
Order.AutoOrderRotating Gateway Code<Custom>
Order.CustomerProfileAllow 3rd Party Billing<Custom>
Order.CustomerProfileAllow COD<Custom>
Order.CustomerProfileAllow PO<Custom>
Order.CustomerProfileAuto Approve COD<Custom>
Order.CustomerProfileAuto Approve PO<Custom>
Order.CustomerProfileMinimum Item Count<Custom>
Order.CustomerProfileNo Free Shipping<Custom>
Order.CustomerProfileTax Exempt<Custom>
Order.CustomerProfileTax ID<Custom>
Order.CustomerProfileCustomer Profile ID<Custom>
Order.CustomerProfileSignle Sign On ID<Custom>

Account Object

UltraCart ObjectUltraCart FieldSalesforce Field
OrderFirst Name + Last NameName
OrderBilling Address 1BillingStreet
OrderBilling CityBillingCity
OrderBilling StateBillingState
OrderBilling ZipBillingPostalCode
OrderBilling CountryBillingCountry
OrderShipping Address 1ShippingStreet
OrderShipping CityShippingCity
OrderShipping StateShippingState
OrderShipping ZipShippingPostalCode
OrderShipping CountryShippingCountry
OrderDay PhonePhone
Order.CustomerProfileFirst Name + Last NameName
Order.CustomerProfileBilling Address 1BillingStreet
Order.CustomerProfileBilling CityBillingCity
Order.CustomerProfileBilling StateBillingState
Order.CustomerProfileBilling ZipBillingPostalCode
Order.CustomerProfileBilling CountryBillingCountry
Order.CustomerProfilePhonePhone
Order.CustomerProfileBusiness NotesDescription
   

...

UltraCart ObjectUltraCart FieldSalesforce Field
OrderFirst Name + Last NameName
OrderBilling Address 1BillingStreet
OrderBilling CityBillingCity
OrderBilling StateBillingState
OrderBilling ZipBillingPostalCode
OrderBilling CountryBillingCountry
OrderShipping Address 1PersonMailingAddress
OrderShipping CityPersonMailingCity
OrderShipping StatePersonMailingState
OrderShipping ZipPersonMailingPostalCode
OrderShipping CountryPersonMailingCountry
OrderShipping Address 1ShippingStreet
OrderShipping CityShippingCity
OrderShipping StateShippingState
OrderShipping ZipShippingPostalCode
OrderShipping CountryShippingCountry
OrderBilling TitlePersonTitle
OrderEmailPersonEmail

...

Contact Object

UltraCart ObjectUltraCart FieldSalesforce Field
OrderBilling First NameFirstName
Order IDBilling Last Name "Closed Won"StageNameLastName
OrderShipping Address1MailingStreet
OrderShipping CityMailingCity
OrderTotalShipping StateAmountMailingState
 "100"ProbabilityOrderShipping ZipMailingPostalCode
OrderCreation DateShipping CountryCloseDateMailingCountry
OrderPayment TypeShipping Phone<Custom>Phone
OrderOrder ID<Custom>Billing TitleTitle
OrderEmailEmail
OrderCustom Field Billing Address 1<Custom>
OrderCustom Field Billing Address 2<Custom>
OrderCustom Field 3Billing City<Custom>
OrderCustom Field 4Billing State<Custom>
OrderCustom Field 5Billing Postal Code<Custom>
OrderCustom Field 6Billing Country<Custom>
OrderCustom Field 7Merchant ID<Custom>
OrderShipping & Handling Total<Custom>
OrderShipping Method<Custom>
OrderTax County<Custom>
OrderOrder Comments<Custom>
OrderOrder Notes<Custom>
OrderOrder Merchant Notes<Custom>
OrderPayment Status<Custom>
OrderShipped Date<Custom>
OrderPayment Method<Custom>
OrderCurrent Stage<Custom>
OrderMailing List<Custom>
OrderAdvertising Source<Custom>
OrderMerchant ID<Custom>
OrderCoupon Code<Custom>
OrderReview Link<Custom>
OrderCredit Card Type<Custom>
OrderCredit Card Exp Month<Custom>
OrderCredit Card Exp Year<Custom>
OrderCredit Card Num Last 4<Custom>
OrderSingle Sign on CCID<Custom>

Contact Object

UltraCart ObjectUltraCart FieldSalesforce Field
OrderBilling First NameFirstName
OrderBilling Last NameLastName
OrderShipping Address1MailingStreet
OrderShipping CityMailingCity
OrderShipping StateMailingState
OrderShipping ZipMailingPostalCode
OrderShipping CountryMailingCountry
OrderShipping PhonePhone
OrderBilling TitleTitle
OrderEmailEmail
OrderBilling Address 1<Custom>
OrderBilling Address 2<Custom>
OrderBilling City<Custom>
OrderBilling State<Custom>
OrderBilling Postal Code<Custom>
OrderBilling Country<Custom>
OrderMerchant ID<Custom>
Order.CustomerProfileBilling First NameFirstName
Order.CustomerProfileBilling Last NameLastName
Order.CustomerProfileDay PhonePhone
Order.CustomerProfileBilling TitleTitle
Order.CustomerProfileEmailEmail
Order.CustomerProfileBilling Address 1<Custom>
Order.CustomerProfileBilling Address 2<Custom>
Order.CustomerProfileBilling City<Custom>
Order.CustomerProfileBilling State<Custom>
Order.CustomerProfileBilling Postal Code<Custom>
Order.CustomerProfileBilling Country<Custom>
Order.CustomerProfileMerchant ID.CustomerProfileBilling First NameFirstName
Order.CustomerProfileBilling Last NameLastName
Order.CustomerProfileDay PhonePhone
Order.CustomerProfileBilling TitleTitle
Order.CustomerProfileEmailEmail
Order.CustomerProfileBilling Address 1<Custom>
Order.CustomerProfileBilling Address 2<Custom>
Order.CustomerProfileBilling City<Custom>
Order.CustomerProfileBilling State<Custom>
Order.CustomerProfileBilling Postal Code<Custom>
Order.CustomerProfileBilling Country<Custom>
Order.CustomerProfileMerchant ID<Custom>
Order.CustomerProfileAllow 3rd Party Billing<Custom>
Order.CustomerProfileAllow COD<Custom>
Order.CustomerProfileAllow PO<Custom>
Order.CustomerProfileAuto Approve COD<Custom>
Order.CustomerProfileAuto Approve PO<Custom>
Order.CustomerProfileMinimum Item Count<Custom>
Order.CustomerProfileNo Free Shipping<Custom>
Order.CustomerProfileTax Exempt<Custom>
Order.CustomerProfileTax ID<Custom>
Order.CustomerProfileCustomer Profile ID<Custom>
Order.CustomerProfileSingle Sign On ID<Custom>
Order.CustomerProfileBilling Address 1<Custom>
Order.CustomerProfileBilling Address 2<Custom>
Order.CustomerProfileBilling City<Custom>
Order.CustomerProfileBilling State<Custom>
Order.CustomerProfileBilling Postal Code<Custom>
Order.CustomerProfileBilling Country<Custom>
Order.CustomerProfileMerchant ID<Custom>

 

Custom Object

Billing Address
UltraCart ObjectUltraCart FieldSalesforce.com Field
OrderPayment Type<Custom>
OrderOrder ID<Custom>
OrderCompany Name<Custom>
OrderCustom Field 1<Custom>
OrderCustom Field 2<Custom>
OrderCustom Field 3<Custom>
OrderCustom Field 4<Custom>
OrderCustom Field 5<Custom>
OrderShipping & Handling Total<Custom>
OrderShipping Method<Custom>
OrderReview Link<Custom>
OrderCredit Card Type<Custom>
OrderCredit Card Exp Month<Custom>
OrderCredit Card Exp Year<Custom>
OrderCredit Card Num Last 4<Custom>
Order.AffiliateAffiliate ID<Custom>
Order.AffiliateAffiliate Name<Custom>
Order.AffiliateAffiliate E-Mail<Custom>
Order.AffiliateAffiliate Commission Amt<Custom>
Order.AutoOrderAuto Order Code<Custom>
Order.AutoOrderCancelled By User<Custom>
Order.AutoOrderCancellation Date<Custom>
Order.AutoOrderFailure Reason<Custom>
Order.AutoOrderNext Charge Attempt<Custom>
Order.AutoOrderRotating Gateway Code<Custom>
Order.CustomerProfileAllow 3rd Party Billing<Custom>
Order.CustomerProfileAllow COD<Custom>
Order.CustomerProfileAllow PO<Custom>
Order.CustomerProfileAuto Approve COD<Custom>
Order.CustomerProfileAuto Approve PO<Custom>
Order.CustomerProfileMinimum Item Count<Custom>
Order.CustomerProfileNo Free Shipping<Custom>
Order.CustomerProfileTax Exempt<Custom>
Order.CustomerProfileTax ID<Custom>
Order.CustomerProfileCustomer Profile ID<Custom>
Order.CustomerProfileSingle Sign On ID<Custom>Order.CustomerProfile
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 ObjectUltraCart FieldSalesforce Field
OrderOrder IDName
 "Closed Won"StageName
OrderTotalAmount
 "100"Probability
OrderCreation DateCloseDate
OrderPayment Type<Custom>
OrderOrder ID<Custom>
OrderCustom Field 1<Custom>
Order.CustomerProfileBilling Address Custom Field 2<Custom>
Order.CustomerProfileBilling CityCustom Field 3<Custom>
OrderCustom Field 4<Custom>
OrderCustom Field 5<Custom>
OrderCustom Field 6<Custom>
OrderCustom Field 7<Custom>
OrderShipping & Handling Total<Custom>
OrderShipping Method<Custom>
OrderTax County<Custom>
OrderOrder Comments<Custom>
OrderOrder Notes<Custom>
OrderOrder Merchant Notes<Custom>
OrderPayment Status<Custom>
OrderShipped Date<Custom>
OrderPayment Method<Custom>
Order.CustomerProfileBilling StateCurrent Stage<Custom>
Order.CustomerProfileBilling Postal CodeMailing List<Custom>
Order.CustomerProfileBilling CountryAdvertising Source<Custom>
Order.CustomerProfileMerchant ID<Custom>
OrderCoupon Code<Custom>
OrderReview Link<Custom>
OrderCredit Card Type<Custom>
OrderCredit Card Exp Month<Custom>
OrderCredit Card Exp Year<Custom>
OrderCredit Card Num Last 4<Custom>
OrderSingle Sign on CCID<Custom>

Opportunity Line Item Object

UltraCart ObjectUltraCart FieldSalesforce Field
Order.ItemQuantityQuantity
Order.ItemUnit Price After DiscountUnit Price
Order.ItemDescriptionDescription
OrderCreation DateServiceDate
Order.Item.Option#Name<Custom>
Order.Item.Option#Value<Custom>
Order.ItemParent Kit Item ID<Custom>  

 

Product Object

UltraCart ObjectUltraCart FieldSalesforce Field
ItemDescriptionName
ItemItem IDProductCode
ItemDescriptionDescription
 "true"IsActive