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 ? – Pradeep Sanku May 3 '16 at 9:20
  • i need permanently delete from category – Gem May 3 '16 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. – Fabian Schmengler May 3 '16 at 10:53

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 Jan 23 '18 at 4:49

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