How to Delete All Products in Magento

Prem Tiwari - - Magento Tutorial

Are you running a Magento based online store OR are you a Magneto developer? This tutorial helps both either you are a Magento Developer Or Magento website owner. If you want to reset your Magento online store like you want to delete all product completely from your site, then keep your eyes in this post as I am going to share how to delete all products in Magento in a single click.

magento tutorial

How to Delete All Products in Magento

Magento holds the products information in more than 30+ database tables like catalog_product_bundle_option, catalog_product_bundle_option_value, catalog_product_bundle_selection, catalog_product_entity_datetime, catalog_product_entity_decimal, and etc. In this tutorial, I will explain how to delete all products completely from your Magento store. Follow the below steps:

Step 1) Login to your website cPanel and search the PHPMyAdmin.

Step 2) Now open the PHPMyAdmin and select your database.

Step 3) Open the SQL tab in PHPMyAdmin and copy paste below SQL queries.

Step 4) Now execute the below SQL queries. It will be deleted all products with all products attributes from your online store.

Hope this tutorial helps you delete all products from your Magento store. If you like this tutorial, do like and share this tutorial with your friends, and don’t forget to follow us on Facebook and Twitter to learn cool Magento tips and tricks.

Prem Tiwari

Prem Tiwari is the founder of and also a professional developer and a blogger by hobby.

Tags: , , , , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.