Prospects and Contacts Import Errors
This section describes errors that you may see on a prospects and contacts import. For more information, see That Record Does Not Exist.
That Record Does Not Exist
The error occurs when phone numbers are not mapped correctly.
To correct the error:
-
Go to Lists > Search > Saved Searches > New.
-
Click Customer.
-
On the Criteria > Standard subtab, add the Stage is Prospect filter in addition to any other required fields.
-
In the Results > Columns subtab, add the following fields:
-
Name
-
Phone Number
-
Contact Fields: Name
-
Contact Fields: Internal ID
-
Other required fields
-
-
Click Preview.
-
Click Export -CSV.
-
Save the CSV file.
-
Open the CSV file and edit as required (for example, update the phone number field).
-
Save the CSV file.
When importing the CSV file, map the fields as follows:
Your Fields |
NetSuite Fields |
---|---|
Internal ID |
Internal ID (Internal ID of Prospect) |
Company |
Company Name (Prospect Folder) |
Phone |
Phone (Prospect Folder) |
Contact |
Contact (Contact Folder) |
Contact Phone Number |
Main Phone (Contact Folder) |
Internal ID of Contacts |
Internal ID (Contact Folder) |