Bulk upload of multiple contacts linked to a single account Essentials - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Michel Maciej Wisniewski-BalickiMichel Maciej Wisniewski-Balicki 

Bulk upload of multiple contacts linked to a single account Essentials

Hello,
I am struggling with mass upload of Accounts and Contacts to Salesforce Essentials. I need to massively upload a big database of Contacts and Accounts. The database includes a list of contacts working for diverse companies. 
It is important that, whenever several contacts are working for 1 single company, 1 Account record is created in "Account Object" and a relation to all of the Contacts related to this company.

To do this, I use Data Import Wizzard. The problem is that whenever I import my contacts, if it happens that 3 contacts work for Company ABC, 3 ABC records are created, and there should be only one.

I was consuting documentation, and it is stated that you can create such relation with data loader (https://help.salesforce.com/articleView?id=000316718&language=en_US&type=1&mode=1) 
The problem is that Essentials does not allow data loader usage.

Is there a turnaround that would allow me to create massively such relations between contacts and accounts, or it can be done only manually?
Eric PraudEric Praud
Hi Michel,

In "What do you want to do?", choose "Add new and update existing records", then choose how you want to make a match for existing contacts and accounts. I would recommend the Salesforce ID if you can as it's always unique (as opposed to Name & Site). Don't worry about the 3rd option in my screenshot, it's specific to my org
User-added image