Sync Salesforce State and Country picklists with HubSpot State/Region and Country properties
Last updated: December 8, 2020
In Salesforce, you can enable State and Country picklists. By default, the State/Region and Country contact properties in HubSpot are single-line text field types. If you want to sync Salesforce State and Country picklists with these default properties, conflicts will frequently occur because non-standardized values can be entered in HubSpot, which will not be accepted by Salesforce.
To properly sync Salesforce State and Country picklists with HubSpot State/Region and Country contact properties, the HubSpot properties must be edited to have a dropdown select field type, then have their default values converted to pass validation for Salesforce State and Country picklists.
- In your HubSpot account, click the settings icon settings in the main navigation bar.
- In the left sidebar menu, navigate to Properties.
- In the Contact properties tab, click the State/Region or Country property.
- Click the Field type dropdown menu and select Dropdown select.
- In the Dropdown options section, click listView Load options....
- In the dialog box, click the Load options dropdown menu and search for and select State/Region or Country, then click Load options.
Please note:
- Salesforce requires that if a record has a state value, a corresponding country must be specified. If a country is not specified, Salesforce will return an error message and the record will not sync between HubSpot and Salesforce. Non-matching state/country values and mismatched state/country pairs will also result in errors and prevent syncing. As such, these steps must be taken for both the State/Region property and the Country property.
- To change the State/Region or Country property field type to dropdown select, you need to export the data, clear the property for all contacts, change the property to a dropdown field type, clean up incorrectly formatted data, and re-import it.
- In your HubSpot account, click the Marketplace icon marketplace in the main navigation bar. Under Manage, select Connected apps.
- Click Salesforce.
- In the CRM Objects section, next to Contacts, click Manage mappings externalLink.
- The contact field mappings will open in a new browser tab. On the right of the State/Region field mapping, click the settings settingsdownCarat dropdown menu and select Edit.
- In the dialog box, under When should HubSpot data update the corresponding Salesforce field?, select Use most recent value, then click Save Mapping. Learn more about field mapping update rules.
- Repeat the previous two steps for the Country field mapping.
- In your HubSpot account, click the Marketplace icon marketplace in the main navigation bar. Under Manage, select Connected apps.
- Click Salesforce.
- In the Salesforce State and Country list section, select Yes. Learn more about the Salesforce State and Country list setting.
Related content
-
Install the HubSpot tracking code
The HubSpot tracking code is unique to each HubSpot account and allows HubSpot to monitor your website...
Knowledge Base -
Manage your properties
Properties are used to store data on certain objects in HubSpot, such as contacts, companies, deals, tickets,...
Knowledge Base -
Log in to HubSpot
There are multiple ways to log in to HubSpot; enter an email...
Knowledge Base