{"id":1341,"date":"2020-11-07T07:07:03","date_gmt":"2020-11-07T07:07:03","guid":{"rendered":"https:\/\/meetanshi.com\/blog\/2020\/11\/07\/delete-data-from-table-in-magento-2\/"},"modified":"2025-05-22T11:34:01","modified_gmt":"2025-05-22T06:04:01","slug":"delete-data-from-table-in-magento-2","status":"publish","type":"post","link":"https:\/\/meetanshi.com\/blog\/delete-data-from-table-in-magento-2\/","title":{"rendered":"How to Delete Data from Table in Magento 2"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Previously, we learned&nbsp;<a href=\"https:\/\/meetanshi.com\/blog\/add-delete-action-column-in-magento-2\/\" target=\"_blank\" rel=\"noreferrer noopener\">to add delete action column in Magento 2<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you wish to<strong>&nbsp;delete data from the table in Magento 2<\/strong>, this post is helpful for you.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here, we will delete all the data of a user that is ID, name, email, telephone and created at in Magento 2.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The below solution is a part of Magento 2 module development series.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Steps to Delete Data from Table in Magento 2:<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To delete the data from the table in Magento 2, you have to create a file&nbsp;<strong>Delete.php<\/strong>&nbsp;at&nbsp;<strong><em>appcodeMeetanshiExtensionControllerIndex&nbsp;<\/em><\/strong><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;?php\n\nnamespace Meetanshi\\Extension\\Controller\\Index;\n\nuse Magento\\Framework\\App\\Action\\Context;\nuse Magento\\Framework\\View\\Result\\PageFactory;\nuse Meetanshi\\Extension\\Model\\ExtensionFactory;\nuse Magento\\Framework\\Controller\\ResultFactory;\nuse Magento\\Framework\\App\\Action\\Action;\n\nclass Delete extends Action\n{\n    protected $resultPageFactory;\n    protected $extensionFactory;\n\n    public function __construct(\n        Context $context,\n        PageFactory $resultPageFactory,\n        ExtensionFactory $extensionFactory\n    )\n    {\n        $this->resultPageFactory = $resultPageFactory;\n        $this->extensionFactory = $extensionFactory;\n        parent::__construct($context);\n    }\n\n    public function execute()\n    {\n        try {\n            $data = (array)$this->getRequest()->getParams();\n            if ($data) {\n                $model = $this->extensionFactory->create()->load($data['id']);\n                $model->delete();\n                $this->messageManager->addSuccessMessage(__(\"Record Delete Successfully.\"));\n            }\n        } catch (\\Exception $e) {\n            $this->messageManager->addErrorMessage($e, __(\"We can\\'t delete record, Please try again.\"));\n        }\n        $resultRedirect = $this->resultFactory->create(ResultFactory::TYPE_REDIRECT);\n        $resultRedirect->setUrl($this->_redirect->getRefererUrl());\n        return $resultRedirect;\n\n    }\n}<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">After creating the file, when you click&nbsp;<strong>Delete,&nbsp;<\/strong>you will manage to delete the data.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2020\/10\/How-to-Delete-Data-from-Table-in-Magento-2-1024x271.jpg\" alt=\"How to Delete Data from Table in Magento 2\" class=\"wp-image-11235\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Done!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Do share the solution with Magento Community via social media.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Thank you.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/meetanshi.com\/blog\/add-delete-action-column-in-magento-2\/\">How to Add Delete Action Column in Magento 2<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/meetanshi.com\/blog\/update-table-data-in-magento-2\/\">How to Update Table Data in Magento 2<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Previously, we learned&nbsp;to add delete action column in Magento 2. If you wish to&nbsp;delete data from the table in Magento 2, this post is helpful&#8230;<\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[34],"tags":[],"class_list":["post-1341","post","type-post","status-publish","format-standard","hentry","category-magento"],"acf":[],"_links":{"self":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1341","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/comments?post=1341"}],"version-history":[{"count":3,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1341\/revisions"}],"predecessor-version":[{"id":14631,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1341\/revisions\/14631"}],"wp:attachment":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/media?parent=1341"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/categories?post=1341"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/tags?post=1341"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}