Overview
This article comes from a user question about editing addresses.
The Question:
I found that an address in the system used by several records is incorrect (zip of 55411 instead of correct zip of 55114). It's also in the system correctly on some records. Anyway I'm trying to change the "master" address (Little red wrench button) but when I get to the next screen it won't allow me to make any changes and the menus are greyed out. You can find the incorrect address on [named person here] and several other [business name here] people. I figure since it's really easy to grab the wrong one in this case, it's best to correct the master one vs. just doing each record individually.
Thanks - MJ
Hi MJ,
Addresses can be a little tricky sometimes. In this case the easier method for handling this would be from the Addresses list.
I next searched for the address of 2610 Univ (this was the address associated with the named person in the question).
As I review the list I see a few things:
1. Some of the addresses are not in use (Use Count) and can be purged.
2. Street 2 has suite numbers so indeed they are not all the same address.
3. And of course as you mentioned, one has a bad zip.
4. Some have a nation and some do not. This can create a duplicate address situation.
Let’s purge the non- used addresses.
Oddly, that deleted only 2 instead of 3. No matter. We’ll merge this into another record effectively deleting it.
I will merge address 2211 into 2273 using the drag n’ drop method. (If you are not familiar with drag n’ drop merging, at the 4:10 mark in this video we show you how to drag n’ drop merge voter/donor records).
I am left with two Suite 100 records and two suite 450 records.
Because of the bad zip code on record 2273, I will need to manually merge again using drag n’ drop. 2273 will be merged with 2466.
That now leaves us with this:
Just to ensure the list has the best data, I’m going to click Search to refresh the results. The record count and the Use Count are both updated:
Now it’s time to run an automated merge to combine the Suite 450’s:
You can check all three if you like, but in this case it’s the lack of nation that is causing duplication.
The list now looks like this:
The addresses are now unique and uniform. We could do a little further clean up by adding the nation to the ones that are blank.
Your list now looks like this:
Resources
YouTube Channel – How To Manage Duplicates
Knowledge Base – Automatically Conform Addresses
Knowledge Base – Address Management