I would like to import several contacts into Salesforce and avoid duplicates. I would like to do this via upsert (not the the import wizard). For the upsert I plan on using dataloader.io.
I have performed an export of the Account and Contact objects in two separate CSV files. For the export of the Contact object, I have the (record) Id and Account Id.
I am not sure how to update the working CSV that contains new Account and Contact information with the information from the exported sheets.
What are the steps to preparing the working CSV to upsert into Salesforce?
Best Answer
When performing an upsert you can avoid duplicates by matching on either the Salesforce ID or custom External ID type field. If your performing an upsert, or update using dataloader.io, you must map a column to the Salesforce ID or an external ID.
Using dataloader.io, the ~ steps: Import your parent Account records.
Import your child Contact records, ensure the Account field contain the name of your Accounts.
Note, because you are upserting from an export ensure your upsert files do not contain any system fields.
Good Luck.