Manage Duplicates

the manage duplicate feature scans your database and returns a list of any duplicated records you can then elect to combine the accounts or set them as ignored so they don't appear again when you run the function again check for duplicate records in your database select database from the patrons section on the top navigation bar, then click manage duplicates click on run check to start the process a list of any duplicated patrons will appear you can then click review next to a result to see what information matches upon clicking review , you can see that in this case, the phone number and address are the same in this case, these are two employees of the same company who used the office phone number and address on their purchases since these should not be merged, click cancel to get back to the list, and then click ignore to mark that these have been reviewed and that they are ok the record below is one that can be merged this record has matched the phone number since we know this is the same person, we will go ahead and merge it i note that the arrow shows how the data will be merged you can click on the record you wish to maintain, and the arrow will switch directions if desired, you can also keep the email from the 2nd record as a secondary email address continue to work through your list of possible matches until it is completed note you do not have to handle all merges in one session you can return at any time and the list will still be present how often you check for duplicates is up to you, but doing so often can help keep your database healthy!