Error “Could not locate linked container” when importing CSV with ZIP Codes to Maps Territory Planning

Step 1: Prepare Your CSV File

Prepare your CSV to upload, and this file should have the Container and a valid Assignment value.

Note: If you are using United States POSTAL CODE which is a five-digit value, you may need to add back in leading zeroes as the ZIP codes in the CSV should exactly match the POSTAL CODE.

Step 2: Remove Unlinked Containers from the Original CSV

• Use the Download Log option to extract the errors in the file to generate a CSV. This would be your Original file to be re-uploaded to Territory Planning.
• Run the below SOQL in your org and export the results into another CSV:

Select id, maps__AlignmentId__c, maps__ContainerId__c from maps__TPUnitAssignment__c where maps__DataSourceId__c ='Container' and maps__AlignmentId__c <<Alignment ID>> and export the results into a CSV file.

• Compare the postal codes from the above CSV with the postal codes in the original file. Remove all the data from the original file whose ZIP Codes do not match with the Postal Code from the file generated in the above step.

Step 3: Re-Upload the File

Save the Original File and re-run the Upload from CSV feature.