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

[Basara]

Hello.
Products may also be missing from Admin if cache is outdated, or if the product is not assigned to the store view you are checking.

Those names are stored in the product description table. To check them in the database, use your own AbanteCart table prefix from system/config.php (DB_PREFIX) and run

Code Select Expand

SELECT name
FROM prefix_product_descriptions
WHERE name LIKE '%( Copy )%';
but it is unsafe to delete only from product_descriptions, because products are linked across several tables.

[G. O.]

Hello.
Products may also be missing from Admin if cache is outdated, or if the product is not assigned to the store view you are checking.

Those names are stored in the product description table. To check them in the database, use your own AbanteCart table prefix from system/config.php (DB_PREFIX) and run

Code Select Expand

SELECT name
FROM prefix_product_descriptions
WHERE name LIKE '%( Copy )%';
but it is unsafe to delete only from product_descriptions, because products are linked across several tables.

thank you for support, actually they were very old products data and we already deleted them from website dashboard but on database still saved and i don't know why they stayed there if already deleted them from the panel. any way I did solved my issue but there is still a small issue. when the AI BOT retrieving the data about products from the database table we have n the product description section an html info and the AI BOT printing them in the answer section and still trying to find a solution for this too.