Handle import errors and validation issues
After import, Upper validates every address and flags issues you can review by status. Filter, check, and fix Needs Review, Not Found, and Duplicate stops.
When you import stops, Upper Route Planner checks every address and assigns it a validation status. Stops that need a closer look are surfaced by a single red address-validation icon, so you can review and fix them before you optimize the route.
A clean import sets up everything downstream — optimization, ETAs, customer notifications, and proof of delivery. A stop with a bad address can't be sequenced and the driver can't reach it, so resolving validation issues first is the cheapest minute you can spend on any route.
This guide uses the default driver and delivery labels. If your workspace is configured for service work, you may see Technician and Service wording instead — the steps are the same.
What happens after an import
After your stops are imported, Upper assigns each one a validation status and shows a single red address-validation icon on screen. The stop list's Review column shows each row's status, and clicking the red icon surfaces all the flagged stops grouped by status so you can work through them in one place.
The four validation statuses
| Status | What it means | What to do |
|---|---|---|
| Verified | Address found and confirmed | None — ready to optimize |
| Needs Review | Address is incomplete or ambiguous | Review and confirm the right address |
| Not Found | Address could not be located | Edit the address to fix it |
| Duplicate | The same address appears more than once | Remove the extra stop, or keep both if intentional |
Review and fix flagged stops
Open the flagged stops
Click the red address-validation icon to see all flagged stops grouped by status.
Open a stop that needs attention
Select a flagged stop to review its address. You can edit it from the stop's Action (…) menu using Edit Stop, or place it on the map with Edit Stop On Map.
Fix the address based on its status
- Needs Review — Confirm the correct address for the stop.
- Not Found — Correct the typo or missing detail. If a street address won't resolve, you can use GPS coordinates instead (see Related below).
- Duplicate — Remove the extra stop with Delete Stop, or keep both if two deliveries genuinely go to the same place.
Save your changes
Save the stop with the blue Done button.
Resolve flagged stops before you optimize. A stop with an address Upper can't place can't be sequenced into the route, so it's worth clearing the icon first.
Common scenarios
- Abbreviated street names from a spreadsheet — Many stops come back Needs Review. Confirm the correct address and move on.
- Mixed-quality data from another system — A handful of Not Found stops. Filter to them, fix the addresses, and save. Usually faster than re-importing.
- Same building, multiple deliveries — Stops flag as Duplicate. Keep both if the duplication is intentional.
Troubleshooting
Related
Fix addresses that weren't found
Spot and fix Not Found stops in Upper after an import. Open the stop, correct the address, and let Upper re-check it so the stop is ready to route.
Import CSV and Excel files
Import stops into Upper from a CSV or Excel file. Use Import with Preview to map columns and check data, or Import File to drag and drop a spreadsheet.