Recommended Salesforce Object Load Order for Large Data Loads and Data Migrations

Standard Salesforce Object Load Order

Load objects in the following sequence to respect parent-child relationships:

1. Accounts — Top-level parent object; most other records relate to Accounts.
2. Contacts — Related to Accounts (lookup relationship to Account).
3. Opportunities — Related to Accounts and Contacts.
4. Products — Independent; no parent dependency on records above.
5. Opportunity Line Items — Related to Opportunities and Products (requires both to exist).
6. Cases — Related to Contacts (and optionally Accounts).
7. Leads — Typically independent; no parent dependency.
8. Campaigns — Independent; no parent dependency.
9. Campaign Members — Related to Campaigns, Contacts, and Leads (all three must exist first).
10. Contracts — Related to Accounts and Contacts.
11. Assets — Related to Accounts, Contacts, Cases, and Products (all must exist first).

Notes on Custom Objects and Activities

• Custom Objects: The load order for custom objects depends on your specific Salesforce implementation and the lookup/master-detail relationships you have configured. Map your custom object relationships and load parent objects before child objects.
• Activities (Tasks and Events): Activities are the last objects to load. They can be related to most standard and custom objects. Load all related parent objects before loading Activities to ensure relationship lookups succeed.