A customer is facing locking issued when importing large data volumes of order records that are children in a master-detail relationship with the…

Importing Account records first followed by order records after sorting orders by AccountID is the

recommended way to avoid locking issues during import. This can reduce the number of lock

contention errors by minimizing the number of parent records that are concurrently processed by

multiple batches. Sorting orders by AccountID can also group the child records by their parent

records and avoid updating the same parent record in different batches3. Importing Account records

first followed by order records after sorting order by OrderID will not help with avoiding locking

issues because it does not group the child records by their parent records. Changing the relationship

to Lookup and updating the relationship to master-detail after import will not work because

changing a relationship from Lookup to master-detail requires that all child records have a parent

record, which may not be the case after import. Importing Order records and Account records

separately and populating AccountID in orders using batch Apex will not help with avoiding locking

issues because it still requires updating the parent records in batches.