Deleting duplicate third party files

In setting up imports of third parties I inadvertently made three copies of over 6,000 entries. So I now have duplicates (three exact copies) of the same entry. I know how to delete files one by one, but that is horribly slow. How can I delete all duplicates in a batch deletion?

PHPMyadmin? or direct through the database

From Dolibarr 7+ you can mass delete customers that are not linked to any business object (invoice, order …).

When you made an import, each record as the same value of importkey for same import. You can use this value to make a mass delete with a sql request if you have knowledge for. If not you can select by date of creation from the user interface to delete them by lot of 1000.

1 Like