I am creating a Shopify à Salesforce import package that we would like to schedule on a regular basis.
We are mapping Orders à Donations, and Customers à Accounts (in our setup they become Person Accounts).
Donations are created after the Accounts and is only uploaded if there is an associated Customer/Account with the same email.
The unique identifier for Orders is an External ID from Salesforce called Shopify Order ID
The unique identifier for Accounts is Shopify Email Copy, which also is an External ID that by the help of a process builder is filled out by copying the email field.
However, we do not always want to match on a Person Accounts. If there is a Contact part of a regular Account with the same email, we would prefer it to not create a Person Account on top of this, as it would create unnecessary clutter.
So we would like this setup:
- New individual donor -> Person account
- Recurring individual donor -> match to his/her Person account
- Except if: There is an existing CRM contact under an account in Salesforce.
How do we solve that last part in a smart way?