# Deleting duplicate third party files

**URL:** <https://www.dolibarr.org/forum/t/deleting-duplicate-third-party-files/17067>\
**Category:** Using my Dolibarr\
**Tags:** Third-Parties, Data, Help, MySQL, Database\
**Created:** [November 2, 2018, 9:09pm UTC](https://www.dolibarr.org/forum/t/deleting-duplicate-third-party-files/17067 "2018-11-02T21:09:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![RonGreen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/r/d9b06d/32.png) [@RonGreen](https://www.dolibarr.org/forum/u/RonGreen)\
**Post date:** [November 2, 2018, 9:09pm UTC](https://www.dolibarr.org/forum/t/deleting-duplicate-third-party-files/17067/1 "2018-11-02T21:09:24Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![aljawaid](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/aljawaid/32/388_2.png) [@aljawaid](https://www.dolibarr.org/forum/u/aljawaid)\
**Post date:** [November 2, 2018, 11:32pm UTC](https://www.dolibarr.org/forum/t/deleting-duplicate-third-party-files/17067/2 "2018-11-02T23:32:34Z")

</div>

PHPMyadmin? or direct through the database

---

<div class="post-metadata">

**Author:** ![fappels](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/f/838e76/32.png) [@fappels](https://www.dolibarr.org/forum/u/fappels)\
**Post date:** [November 3, 2018, 9:36am UTC](https://www.dolibarr.org/forum/t/deleting-duplicate-third-party-files/17067/3 "2018-11-03T09:36:54Z")

</div>

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

 ![](https://www.z-application.com/image/massdeletecompany.png)

---

<div class="post-metadata">

**Author:** ![eldy](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/eldy/32/12_2.png) [@eldy](https://www.dolibarr.org/forum/u/eldy)\
**Post date:** [November 3, 2018, 10:04am UTC](https://www.dolibarr.org/forum/t/deleting-duplicate-third-party-files/17067/4 "2018-11-03T10:04:46Z")

</div>

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.