Docs

Log in to read the version of docs relevant to your site, or use the dropdown versions

Field-Mapping

Important This page pertains to v1.37 of the Salesforce integration. If you last installed the Salesforce integration before 6th Jan 2020, it is likely that you are using a deprecated version of the integration (package v1.31 and below) that performs a contact-based mapping. To migrate to the current version, contact support.

Object-Level Mapping

Chargebee objects are mapped to standard as well as custom objects in Salesforce. The latter are created by Chargebee. The table below shows the relationship between objects in either systems in terms of data flow.

Chargebee Object/DataSalesforce Object (* indicates custom object)
CustomerAccount
Contact
Plan/AddonProduct
CB Pricing Tier* 
Price Book Entry
QuoteCB Quote*
CB Quote Line Item*
CB Quote Product*
CB Quote Coupon*
SubscriptionOpportunity
Opportunity Product
CB Opportunity Product*
CB Opportunity Coupon*
CB Subscription*
Subscription Addon*
Coupon Line Items*
InvoiceCB Invoice*
CB Invoice Line Item*
CouponCB Coupon*
Credit NoteCB Credit Note*
CB Credit Note Allocation*
Chargebee site domain nameCB Site*

Field-Level Mapping for Standard Objects

Here we look at how fields in standard Salesforce objects are mapped to data in Chargebee. The notation used to represent Chargebee data is as seen in the [link_api]Chargebee backend API[].

Account

Accounts in Salesforce are mapped to customers in Chargebee. Given below is the default field-mapping.

Salesforce Field (* indicates custom field)** Chargebee Field / Data **
Account Name Customer.company
Phone Customer.phone
Auto Collection* Customer.auto_collection
Billing Street Customer.billing_address.line1  +  line2  +  line3   (the  field values are concatenated, separated by commas)
Billing City Customer.billing_address.city
Billing Zip/Postal Code Customer.billing_address. zip
Billing State/Province Customer.billing_address. state
Billing Country Customer.billing_address. country
Chargebee Email* Customer.email
Chargebee First Name* Customer.first_name
Chargebee Id*Customer.id
Chargebee Last Name* Customer.last_name
Chargebee Site*Lookup to CB Site object which in turn stores the domain name of the Chargebee site this account belongs to
Is Synced*Indicates that the record has been mapped to Chargebee.
Locale* Customer.locale
Net Term Days* Customer.net_term_days
Payment Method Status* Customer.payment_method.status
Payment Method Type* Customer.payment_method.type
Sync with Chargebee*Checkbox that automates data sync from the account to Chargebee whenever a change is made to the account.
Taxability* Customer.taxability
VAT Number* Customer.vat_number

Contact

The Contact object is mapped to fields in the Customer object in Chargebee. The default mapping is given below.

Salesforce Field (* indicates custom field)Chargebee Field / Data
Email Customer.email
Name (composite field)Customer.first_nameCustomer.last_name
Phone Customer.phone
Preferred currency*(Deprecated)
Payment Method Status*(Deprecated)
Payment Method Type*(Deprecated)
Net Term Days*(Deprecated)
Chargebee_Modified_Time*(Deprecated)
Auto collection*(Deprecated)
Sync with Chargebee*Checkbox that marks the contact – while it is attached to an account – as the one to consider for syncing with Chargebee.

Price Book

A Price Book record is created for each Chargebee site that is connected to the Salesforce org. The fields used by the integration are as follows:

Salesforce Field (* indicates custom field)Chargebee Field / Data
CB Site*Lookup to CB Site object which in turn stores the domain name of the Chargebee site this price book belongs to.
Price Book NameCB Price Book prefixed with the Chargebee site domain name.

Price Book Entry

A price book entry record is created for each Chargebee plan and addon.

Salesforce Field (* indicates custom field)Chargebee Field / DataComments
Product CodePlan.id or Addon.id
List PricePlan.price or Addon.priceThe value is set to 0 when the Recurring charge model is volume, tiered or stairstep.
ActivePlan.status or Addon.statusIf Plan.status or Addon.status is active then true else false.
Use Standard PriceAlways set to false.
Currency ( chargebeeapps__Currency__c )Plan. currency_code or  Addon.currency_code
Currency ( CurrencyIsoCode )(Not used)
Setup Cost* Plan.setup_cost
Trial Period Unit*Plan.trial_periodOnly applicable for plans.
Trial Period Unit*Plan. trial_period_unitOnly applicable for plans.
Bill Every*Plan.period  or Addon.period
Bill Every Unit*Plan.period_unit or Addon.period_unit
Billing Cycles*Plan.billing_cycles or Addon.billing_cycles
Free Quantity* Plan.free_quantity Only applicable for plans.
Recurring charge model*Addon.charge_typeOnly applicable for addons.
Pricing Model* Plan.pricing_model or addon.pricing_model
Invoice Name*Plan.invoice_name or Addon.invoice_name
Chargebee Modified Time*Time when changes to the plan/addon record were last synced to Salesforce.
Addon Applicability* Plan.addon_applicability Only applicable for plans and not for addons.

Product

Each plan and addon is synced into Salesforce as a Product record.

Salesforce Field (* indicates custom field)Chargebee Field / Data
External ID(Not used)
Active(Not used)
Product NamePlan.name or Addon.name
Product CodePlan.id or Addon.id
Product CurrencyPlan. currency_code or  Addon.currency_code
Trial Period*(Deprecated)
Trial Period Unit*(Deprecated)
Bill Every*(Deprecated)
Bill Every Unit*(Deprecated)
Billing Cycles*(Deprecated)
Free Quantity*(Deprecated)
Recurring charge model*(Deprecated)
Price*(Deprecated)
Set Up Fee*(Deprecated)
Status*(Deprecated)
Product Type*The value is PLAN for plans and  ADDON for addons.
Invoice Name*(Deprecated)
Currency*(Deprecated)
ChargeBee Modified Time*(Deprecated)
Addon Type*(Deprecated)
Addon Applicability*(Deprecated)

Opportunity

Opportunity records are only created or modified by the integration when some form of opportunity handling has been configured. The following opportunity fields are updated by the integration:

Salesforce Field (* indicates custom field)Chargebee Field/Data
AmountSum of Totals of the Opportunity Products.
Close Date Subscription.activated_at
Opportunity Currency Subscription.currency_code
Opportunity NameThis field is set to the company name of the customer record.
Price bookThe Id of the price book for the Chargebee site.
StageThe stage of the opportunity may be set via the integration if configured accordingly.
CB Opportunity Type*Indicates the opportunity type in relation to Chargebee. This field is set by Chargebee and can have one of the following values: New subscription - indicates that the opportunity is for creating a new subscription. Renewal - indicates that the opportunity has been created via setting 4.1 for subscriptions with finite billing cycles, for the renewal of their terms. Upgrade/Downgrade - indicates that the opportunity has been updated using the Manage CB Products action to update an existing subscription.
Subscription Id*The id of the subscription in Chargebee that the opportunity is linked to.
Update Chargebee*Checkbox which determines whether a subscription should be created or updated in Chargebee when the opportunity is won.
Coupon*Deprecated field. The attached coupons can now be found in the CB Coupon related list for the opportunity.

Opportunity Product

Opportunity Product records are only created or modified by the integration when some form of opportunity handling has been configured. The following opportunity product fields are updated by the integration:

Salesforce Field (* indicates custom field)Chargebee Field/Data
SubtotalSales Price x Quantity
Total(Sales Price - Sales Price x Discount) x Quantity
Quantity Subscription.plan_quantity or Subscription.addons.quantity
Price Book EntryLookup(Price Book Entry)
List priceList Price from Price Book Entry
Sales Price Subscription.plan_unit_price or Subscription.addons.unit_price
DiscountFor Chargebee plans: the discount percentage is calculated based on the plan free quantity and the coupon discount. For Chargebee addons: the discount percentage is calculated based on the coupon discount. By default, the integration considers all types of Chargebee coupons in the Discount calculation. However, for a given Chargebee site, if you want to exclude limited period or one-time coupons while calculating Discount, contact  support@chargebee.com .
Service Period (days)* Subscription.event_based_addons. service_period_in_days
Billing Cycles* Subscription.remaining_billing_cycles or Subscription.addons.remaining_billing_cycles
Apply Charges*Subscription.event_based_addons. charge_once
Addon Event* Subscription. event_based_addons.on_event

Was this article helpful?