How to mass delete duplicates

Hello Paul,

Sorry to hear the sync process did not work as intended.

You may want to consider using Sugar's import functionality to find duplicates where then you can re-import a lead records and by ensuring to include the "delete=1" column as shown, you can mass delete the duplicates rather efficiently:

http://support.sugarcrm.com/Knowledge_Base/Import_Export/Using_Import_to_Find_Duplicates_Across_Modules/index.html 

Regards,
Rudy Robledo
SugarCRM Support

I would suggest you copy the original import data, then delete all columns except "Name" & "ID". You then add a new column titled "Deleted" and set this to 1 for all rows. After doing so, import the file selecting the "Create new records and update existing records" option during the import. Make sure all 3 columns are mapped to appropriate Sugar field name and the records will be marked as deleted upon import completion. I hope this helps.