Docs

Support

Getting Started

Implementing Chargebee

Product Catalog

Subscriptions

Customers

Entitlements

Invoices, Credit Notes, and Quotes

Taxes

Payments

Hosted Capabilities

Site Configuration

Multi Business Entity

Multi Business Entity Overview
- Limitations and Feature or Integration Support in Multi-Business Entity
- Multi Business Entity Invoices
- Multi Business Entity Taxes
- Multi Business Entity Notifications
- Multi Business Entity for Oracle NetSuite
- Multi Business Entity for Xero
- Multi Business Entity for Sage Intacct
- Multi Business Entity for QuickBooks
- Multi Business Entity Reports and Analytics
- Multiple Business Entity Offline Payments
- Multi Business Entity Smart Routing
- Multi Business Entity Transfer Configuration
- Best Practice to Use API Keys for Multi Business Entity
- Frequently Asked Questions
Customer Transfer Overview
- About Resources and Managing Associated Workflow Processes
- Data Management Actions
- Getting Started with Customer Transfer
- Data Management Navigation
- Integration and System Impacts
- Customer Transfer FAQs

Mobile Subscriptions

Reports and Analytics

Integrations

Data Privacy & Security

Data Operations

Salesforce Field-Mapping

This document describes the relationship between the various Chargebee and Salesforce fields. Field mapping is one of the most important steps as it creates a bidirectional linkage between the two systems and thereby gives greater control on the implications of the native salesforce settings.

Warning

Migration
If you are migrating your Chargebee site from Product Catalog 1.0 to 2.0, the Salesforce integration package cannot be readily migrated. Contact support to perform the migration.

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/Data	Salesforce Object (* indicates custom object)
Customer	Account
Customer	Contact
Item (Plan/Addon/Charge)	Product
Item Price	CB Item Price*
	CB Pricing Tier*
	Price Book Entry
Quote	CB Quote*
	CB Quote Line Item*
	CB Quote Product*
	CB Quote Coupon*
Subscription	Opportunity
	Opportunity Product
	CB Opportunity Product*
	CB Opportunity Coupon*
	CB Subscription*
	Subscription Addon*
	Coupon Line Items*
Invoice	CB Invoice*
Invoice	CB Invoice Line Item*
Coupon	CB Coupon*
Credit Note	CB Credit Note*
Credit Note	CB Credit Note Allocation*
Chargebee site domain name	CB 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 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 Billing Contact*	Lookup to a contact that is used to populate billing contact details in sales driven automations.
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 whether 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`
Business Entity*	`Lookup(CB Business Entity)`

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_name`, `Customer.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 single Price Book record is created for all the Chargebee sites that are connected to the Salesforce org.

Note

Regardless of the number of connected sites and number of currency/frequency combinations configured in your Chargebee site for a particular plan, there can be only one Price Book created for all the connected Chargebee sites where only one billing frequency and currency combination for a particular plan is recorded. For example, an ‘Advanced' plan supports three currencies - USD, EUR, and AUD and 2 billing frequencies - annual and monthly). Out of the two billing frequencies, only one can be stored in a single standard or custom pricebook. The integration however relies primarily on the Item Price (custom object) for a specific price point associated with a product.

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 Name

CB 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 / Data	Comments
Salesforce Field (* indicates custom field)	Chargebee Field / Data	Comments
Product Code	Plan.id or Addon.id or Charge.id
List Price	`item_price.price`	The value is set to `0` when the Recurring charge model is `volume`, `tiered` or `stairstep`.
Use Standard Price	(Deprecated)	Not in use for v1.38 and later versions
Currency (`chargebeeapps__Currency__c`)	(Deprecated)	(Deprecated)
Currency (`CurrencyIsoCode`)	`Plan.currency_code`, `Addon.currency_code`, or `Charge.currency_code`
Setup Cost*	(Deprecated)	(Deprecated)
Trial Period Unit*	(Deprecated)	(Deprecated)
Trial Period Unit*	(Deprecated)	(Deprecated)
Bill Every*	(Deprecated)	(Deprecated)
Bill Every Unit*	(Deprecated)	(Deprecated)
Billing Cycles*	(Deprecated)	(Deprecated)
Free Quantity*	(Deprecated)	(Deprecated)
Recurring charge model*	(Deprecated)	(Deprecated)
Pricing Model*	(Deprecated)	(Deprecated)
Invoice Name*	(Deprecated)	(Deprecated)
Chargebee Modified Time*	(Deprecated)	(Deprecated)
Addon Applicability*	(Deprecated)	(Deprecated)
Resource Version*	(Deprecated)	(Deprecated)
Site*	(Deprecated)	(Deprecated)

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)
CB Item Family*	`item.item_family_id`
Active	(Not used)
Product Name	`Plan.name, Addon.name, or Charge.name`
Product Description	`item.description`
Product Code	`Plan.id`, `Addon.id`, or `Charge.id`
Product Currency	`Plan.currency_code`, `Addon.currency_code` or `Charge.currency_code`
Metered*	`item.metered`
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 and `CHARGE` for charges.
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
CB Subscription Id*	(Deprecated)
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.
CB Opportunity Type*	Indicates the opportunity type in relation to Chargebee. This field is set by Chargebee and can have the following value: New subscription: indicates that the opportunity is for creating a new subscription.
Close Date	`subscription.activated_at`
Contract term Id*	`subscription.contract_term.id`
Opportunity Currency	`subscription.currency_code`
Amount	Sum of Totals of the Opportunity Products.
Price book	The Id of the price book for the Chargebee site.
Subscription Id*	The id of the subscription in Chargebee that the opportunity is linked to.
Stage	The stage of the opportunity may be set via the integration if configured accordingly.
Opportunity Name	This field is set to the company name of the customer record.
Business Entity*	Lookup(CB Business Entity)

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
Subtotal	Sales Price x Quantity
CB Item Price*	`item_price.id`
Total	(Sales Price - Sales Price x Discount) x Quantity
Quantity	`Subscription.plan_quantity` or `Subscription.addons.quantity`
Price Book Entry	Lookup(Price Book Entry)
List price	List Price from Price Book Entry
Sales Price	`Subscription.plan_unit_price` or `Subscription.addons.unit_price`
Discount	For Chargebee plans: the discount percentage is calculated based on the plan free quantity and the coupon discount. For Chargebee addons and charges: 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`

Field-Level Mapping for Custom Objects

In this section, custom objects created by Chargebee in Salesforce are listed. The tables provide a field-level mapping between those objects and Chargebee entities. The Chargebee fields mentioned in the tables are attributes of resources available in Chargebee APIv2 .

CB Item Price

CB Item Price in Salesforce is mapped to the Item Price resource in Chargebee.

Salesforce Field (* indicates custom field)	Chargebee Field/Data
Trial Period Unit	`tial_period_unit`.
Trial Period	`trial_period`
Status	`status`
Resource version	`resource_version`
Product	`name`
Pricing Model	`pricing_model`
Price Book	Lookup to a Price Book record corresponding to the Chargebee site that the Item Price belongs to.
Price	`price`
Period Unit	`period_unit`
Period	`period`
Free Quantity	`free_quantity`
External Id	`id`
Currency	`currency_code`
CB Item Price Name	`name`
Billing Cycles	`billing_cycles`

CB Subscription

CB Subscription in Salesforce is mapped to the Subscription resource in Chargebee.

Salesforce Field (* indicates custom field)	Chargebee Field/Data
Account	Master-Detail(Account)
Action at term end	`subscription.contract_term.action_at_term_end`
Address Line 1	`subscription.shipping_address.line1`
Address Line 2	`subscription.shipping_address.line2`
Address Line 3	`subscription.shipping_address.line3`
Business Entity	Lookup(CB Business Entity)
CB Customer Id	`subscription.customer_id`
CB Id	`"<domain name of the Chargebee site>"+"subscription.id"`
CB Plan Id	`subscription.subscription_items[].item_price_id` of the plan.
CB Site	Lookup(CB Site)
CB Subscription Id	`subscription.id`
CB Subscription Name	`subscription.id`
Chargebee Modified Time	`subscription.updated_at`
City	`subscription.shipping_address.city`
Company	`subscription.shipping_address.company`
Contact	Lookup(Contact)
Country	`subscription.shipping_address.country`
Created By	User who triggers the sync or turns on auto sync.
Currency	`subscription.currency_code`
Current Term End	`subscription.current_term_end`
Current Term Start	`subscription.current_term_start`
Due Invoices Count	`subscription.due_invoices_count`
Due Since	`subscription.due_since`
Email	`subscription.shipping_address.email`
First Name	`subscription.shipping_address.first_name`
Last Modified By	User who triggers the sync or turns on auto sync.
Last Name	`subscription.shipping_address.last_name`
MRR	`subscription.mrr`
Next billing Amount	`invoice_estimate.total`
Next billing at	`subscription.next_billing_at`
Opportunity	Lookup(Opportunity)
Phone	`subscription.shipping_address.phone`
Plan Amount	`subscription.subscription_items[].amount or subscription.subscription_items[].amount_in_decimal` of the plan.
Plan Quantity	`subscription.subscription_items[].quantity or subscription.subscription_items[].quantity_in_decimal` of the plan.
Plan Unit Price	`subscription.subscription_items[].unit_price or subscription.subscription_items[].unit_price_in_decimal` of the plan.
.PO Number	`subscription.po_number`
Product	Lookup(Product)
Reason for cancellation	`subscription.cancel_reason`
Cancellation Reason Code	`subscription.cancel_reason_code`
Remaining Billing Cycles	`subscription.remaining_billing_cycles`
Resource Version	`subscription.resource_version`
Site	(Deprecated)
State/ County/ Province	`subscription.shipping_address.state`
Subscription Activated At	`subscription.activated_at`
Subscription Cancelled At	`subscription.cancelled_at`
Subscription Created At	`subscription.created_at`
Subscription Id	`"<domain name of the Chargebee site>"+"subscription.id"`
Subscription Started At	`subscription.started_at`
Subscription status	`subscription.status`
Total Dues	`subscription.total_dues`
Trial End	`subscription.trial_end`
Trial Start	`subscription.trial_start`
Zip/ Postal Code	`subscription.shipping_address.zip`

CB Invoice

The CB Invoice in Salesforce is mapped to the Invoices resource in Chargebee.

Salesforce Fields	Chargebee Fields
Account	Lookup(Account)
Amount	`invoice.total`
Business Entity	`Lookup(CB Business Entity)`
CB Customer CB Id	`invoice.customer_id`
CB Id	"<domain name of the Chargebee site>"_"`invoice.id`"
CB Invoice Id	`invoice.id`
CB Invoice Name	`invoice.id`
CB Site	Lookup(CB Site)
CB Subscription	Lookup(CB Subscription)
CB Subscription CB Id	`invoice.subscription_id`
Chargebee Modified Time	`invoice.updated_at`
Created By	Lookup(User)
Due Amount	`invoice.amount_due`
Due Date	`invoice.due_date`
Invoice Date	`invoice.date`
Invoice ID	`invoice.id`
Last Modified By	Lookup(User)
Next Retry	`invoice.next_retry_at`
Owner	`invoice.payment_owner`
Paid On	`invoice.paid_at`
PO Number	`invoice.po_number`
Price Type	`invoice.price_type`
Recurring	`invoice.recurring`
Resource Version	`invoice.resource_version`
Status	`invoice.status`
SubTotal	`invoice.sub_total`
Tax	`invoice.tax`
Vat Number	`invoice.vat_number`

CB Invoice Line Item

The CB Invoice Line Item in Salesforce is mapped to the Invoices resource in Chargebee.

Salesforce Fields	Chargebee Fields
Amount	`invoice.line_items.amount`
CB Invoice	Master-Detail(CB Invoice)
CB Invoice CB Id	`invoice.id`
CB Invoice Line Item CB Id	`invoice.line_items.id`
CB Item Price	Lookup(CB Item Price)
Created By	Lookup(User)
Discount Amount	`invoice.line_items.discount_amount`
End Date	`invoice.line_items.date_to`
Invoice Line Items Name	`invoice.line_items.name`
Last Modified By	Lookup(User)
Price	invoice.line_items.unit_amount
Product	Lookup(Product)
Quantity	`invoice.line_items.quantity`
Reason for tax exemption	`invoice.line_items.tax_exempt_reason`
Start Date	`invoice.line_items.date_from`
Tax Amount	`invoice.line_items.tax_amount`
Total amount	`invoice.line_items.amount`

CB Credit Note

The CB Credit Note in Salesforce is mapped to the Credit notes resource in Chargebee.

Salesforce Fields	Chargebee Fields
Account	Lookup(Account)
Allocated Amount	`credit_notes.amount_allocated`
Available Amount	`credit_notes.amount_available`
Business Entity	`Lookup(CB Business Entity)`
CB Credit Note Name	`credit_notes.id`
CB Invoice	Master-Detail(CB Invoice)
CB Invoice Id	`credit_notes.reference_invoice_id`
CB Site	Lookup(CB Site)
Contact	Lookup(Contact)
Created By	Lookup(User)
CreditNote CB Id	`credit_notes.id`
Customer CB Id	`credit_notes.customer_id`
Issued Date	`credit_notes.date`
Last Modified By	Lookup(User)
Price Type	`credit_notes.price_type`
Reason	`credit_notes.reason_code`
Refunded Amount	`credit_notes.amount_refunded`
Refunded At	`credit_notes.refunded_at`
Resource Version	`credit_notes.resource_version`
Round-Off Amount	`credit_notes.round_off_amount`
Status	`credit_notes.status`
Sub Total	`credit_notes.sub_total`
Total	`credit_notes.total`
Type	`credit_notes.type`
Voided At	`credit_notes.voided_at`

CB Coupon

The CB coupon in Salesforce is mapped to the Coupons resource in Chargebee.

Salesforce Fields	Chargebee Fields
Addon Id	`coupon.item_type.addon`
Apply On	`coupon.apply_on`
CB Coupon Id	`coupon.id`
CB Id	"<domain name of the Chargebee site>"_"`coupon.id`"
CB Site	Lookup(CB Site)
Charge Constraint	`coupon.item_constraints.item_type`
Charge Id	`coupon.item_type.charge`
Chargebee Modified Time	`coupon.updated_at`
Coupon Created At	`coupon.created_at`
Coupon Id	`coupon.id`
Coupon Name	`coupon.name`
Created By	Lookup(User)
Discount Amount	`coupon.discount_amount`
Discount Percentage	`coupon.discount_percentage`
Discount Type	`coupon.discount_type`
Duration Month	`coupon.duration_month`
Duration Type	`coupon.duration_type`
Invoice Name	`coupon.invoice_name`
Last Modified By	Lookup(User)
Max Redemptions	`coupon.max_redemptions`
Owner	Lookup(User,Group)
Plan Constraint	`coupon.item_constraints.item_type`
Plan Id	`coupon.plan_id`
Redemptions	`coupon.redemptions`
Resource Version	`coupon.resource_version`
Status	`coupon.status`
Valid Till	`coupon.valid_till`

Was this article helpful?