Salesforce Integration: How the Sync Works

The Salesforce integration syncs data one way, from Salesforce to Rev.io. Every run processes records in the same order: accounts first, then contacts, then opportunities.

When the integration is first set up with Enable Initial Sync checked, it runs a one-time sync of your existing Salesforce data and matches records as described below.

RecordHow it is matched
AccountsMatched to existing Rev.io customers by company name, with at least a 93% name match. Small differences such as Inc and LLC are ignored. Accounts with no match are created as new customers.
ContactsMatched by exact email address first, then by name with at least a 93% name match. Contacts with no match are created under their customer.
OpportunitiesNot matched. They are created in Rev.io, or updated if the opportunity is already linked.

After a record is matched or created, the integration writes the Rev.io ID into the custom field in Salesforce, such as Rev_io_ID__c. This links the two records permanently, so a linked record is never created again.

After the initial sync, the scheduled sync runs automatically on the Sync Schedule, daily at 3:00 AM by default. It only processes records that changed since the last run.

The following rules apply to every sync.

  • Salesforce values always win. Linked Rev.io records are updated with the latest Salesforce values.
  • Changes made in Rev.io are not sent back to Salesforce.
  • Deleting a record in Salesforce does not delete it in Rev.io.

Salesforce account fields sync to Rev.io customer fields as shown below. New customers are created with the Business identity, Customer type, and Open status.

Salesforce FieldRev.io Field
NameCompany Name.
BillingStreetAddress Line 1. A placeholder is used if the field is blank.
BillingCityCity. A placeholder is used if the field is blank.
BillingStateState/Province Code. State names are converted to codes, such as California to CA.
BillingPostalCodePostal Code.
BillingCountryCountry Code. Country names are converted to codes, such as United States to USA.
WebsiteWebsite.

Salesforce contact fields sync to Rev.io contact fields as shown below. Contacts are created under the customer linked to their Salesforce account.

Salesforce FieldRev.io Field
FirstName and LastNameName. The first and last names are combined.
EmailEmail Address. The email address is also used to match contacts.
PhonePhone Number.

Salesforce opportunity fields sync to Rev.io opportunity fields as shown below. Opportunities only sync when Opportunity Trigger Stages is set.

Salesforce FieldRev.io Field
NameName.
AmountExpected Amount.
CloseDateClose Date.
StageNameStage, using the Stage Map, and Status, using the Status Map.

The Stage Map and Status Map settings translate your Salesforce pipeline stages into Rev.io values. For example, the following maps could be used.

Salesforce StageExample Rev.io Values
ProspectingStage Discovery, status Open.
ProposalStage Proposal.
NegotiationStage Negotiation.
Closed WonStage Won, status Won.
Closed LostStage Lost, status Lost.

If a Salesforce stage isn't mapped, the integration uses the PSA Default Stage and PSA Default Status. When a Closed Lost opportunity syncs, the Closed Lost Reason text is entered in the lost reason field. The opportunity owner is matched to a Rev.io user by email, and the PSA Default Owner User ID is used when no user matches. See the Salesforce Integration: Configuration article for more information about these settings.

For more information about the Salesforce integration, see the following articles.

Salesforce Integration: Overview
Salesforce Integration: Frequently Asked Questions