I want to do a mass duplicate merge using just the email field and then updating from the last updated record from the dupes. This functionality is currently done on a single one by one action via the UI. The Mass Dupe feature also wont work as this compares more than just the email. (Unless I can disable the name also comparison and run the mass dupe)
I am happy to do this in MySQL on the DB but I am not sure what happens in the background of a dupe check and if i can do this in-mass in the database directly.
Has anyone tried this successfully?
I have thousand of potential dupes based on email comparison.