database issue

[G. O.]

Hello,

i need you help to know the best way to remove these duplication on database as you see in the bottom extracted text: how to remove these duplications from database? all of this came from cloning the products for fast edits of products details 📊 Found 356 duplicate/copy products

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
DUPLICATE PRODUCTS LIST:
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📦 ORIGINAL/CATEGORY: 01-171 ( Copy )
  └─ Duplicate: 01-171 ( Copy ) (ID: 2103)
  └─ Duplicate: 01-171 ( Copy ) (ID: 2103)
  └─ Duplicate: 01-171 ( Copy ) (ID: 2143)
  └─ Duplicate: 01-171 ( Copy ) (ID: 2143)
  Total copies: 4


📦 ORIGINAL/CATEGORY: 01-171 ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy )
  └─ Duplicate: 01-171 ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) (ID: 2110)
  └─ Duplicate: 01-171 ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) (ID: 2110)
  └─ Duplicate: 01-171 ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) (ID: 2149)
  └─ Duplicate: 01-171 ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) (ID: 2149)
  Total copies: 4



they are 📊 Found 356 duplicate/copy products and this is just a sample of what i have in the database

[Basara]

Hello.
In AbanteCart admin, search for "( Copy )", select all, and remove. Direct database edits are strongly discouraged.

[G. O.]

Hello.
In AbanteCart admin, search for "( Copy )", select all, and remove. Direct database edits are strongly discouraged.

the problem is not on admin side, there is nothing in products side panel, it is in the database. I'm getting this information when we are exporting products information from database information to website AI Assistant bot, bot retrieving these information from product id table