Exported deals and accounts have "Sales owner" which is the first/last name. But upon import, a required field is called 'Sales owner" which expects email address.
This is misleading and can easily result in a user mapping the "Sales owner" field in exported file to "Sales owner" field in CRM. This results in all the records getting the default sales owner.
1) MOST Importantly - there is NO error or warning about this. It should be considered an error condition when sales owner field is not an email and record should not import when no matching sales owner found. Having a default sales owner should be an optional action (not default) at import.
2) The column names are confusing and lead to this issue.
2a. the exported colum should have been labeled "Sales owner name". And in order to allow import, the email should be included in export. Better yet, just export the sales owner email.
3) the mapping UI should make this all more clear.
As noted, the biggest issue with this is its completely caused by poor labeling of the exported data files in combination with mis-labeled import fields making this all too likely that a user will make this mistake. The UI currently actually forces a user down this path.
Best answer by Aishwarya ParthasarathiView original