How can i delete products from specified category by using database or control panel of the magento.

  • you want to delete permantly or unassig this products from this category ? Commented May 3, 2016 at 9:20
  • i need permanently delete from category
    – Gem
    Commented May 3, 2016 at 9:29
  • 2
    "permanently delete from category" is still not clear. If you want to actually delete the products, refer to the linked duplicate. If not, please update the question and be more specific. Commented May 3, 2016 at 10:53

1 Answer 1


At magento,Product and category relation has been saved at table catalog_category_product_index.catalog_category_product are the main tables.

Basically, catalog_category_product is main table.

you need to run a delete mysql query by which you can remove that category products.


Delete from catalog_category_product where category_id='YOUR_Cat_ID'
  • How can i add more than one id's
    – zus
    Commented Jan 23, 2018 at 4:49

Not the answer you're looking for? Browse other questions tagged or ask your own question.