How to delete all products in magento

Yes, We can delete all the products and its information by executing few set of commands. After execution it will clear all the information related to product, however its not wise action for production environment (take back up of database first in case of production, so that restore). Its ok if you are doing this action in development environment. This blog also guides you on How to truncate all magento categories.

In this blog we have mentioned all sql statements which you have to and execute them on mysql command prompt that’s all.

Example 1: How to delete all products in magento

Step 1: Truncate all product tables.

TRUNCATE TABLE `catalog_product_bundle_option`;
TRUNCATE TABLE `catalog_product_bundle_option_value`;
TRUNCATE TABLE `catalog_product_bundle_selection`;
TRUNCATE TABLE `catalog_product_entity_datetime`;
TRUNCATE TABLE `catalog_product_entity_decimal`;
TRUNCATE TABLE `catalog_product_entity_gallery`;
TRUNCATE TABLE `catalog_product_entity_int`;
TRUNCATE TABLE `catalog_product_entity_media_gallery`;
TRUNCATE TABLE `catalog_product_entity_media_gallery_value`;
TRUNCATE TABLE `catalog_product_entity_text`;
TRUNCATE TABLE `catalog_product_entity_tier_price`;
TRUNCATE TABLE `catalog_product_entity_varchar`;
TRUNCATE TABLE `catalog_product_link`;
TRUNCATE TABLE `catalog_product_link_attribute`;
TRUNCATE TABLE `catalog_product_link_attribute_decimal`;
TRUNCATE TABLE `catalog_product_link_attribute_int`;
TRUNCATE TABLE `catalog_product_link_attribute_varchar`;
TRUNCATE TABLE `catalog_product_link_type`;
TRUNCATE TABLE `catalog_product_option`;
TRUNCATE TABLE `catalog_product_option_price`;
TRUNCATE TABLE `catalog_product_option_title`;
TRUNCATE TABLE `catalog_product_option_type_price`;
TRUNCATE TABLE `catalog_product_option_type_title`;
TRUNCATE TABLE `catalog_product_option_type_value`;
TRUNCATE TABLE `catalog_product_super_attribute`;
TRUNCATE TABLE `catalog_product_super_attribute_label`;
TRUNCATE TABLE `catalog_product_super_attribute_pricing`;
TRUNCATE TABLE `catalog_product_super_link`;
TRUNCATE TABLE `catalog_product_enabled_index`;
TRUNCATE TABLE `catalog_product_website`;
TRUNCATE TABLE `catalog_product_entity`;
TRUNCATE TABLE `cataloginventory_stock`;
TRUNCATE TABLE `cataloginventory_stock_item`;
TRUNCATE TABLE `cataloginventory_stock_status`;

Step 2: Insert product related attributes like upsell, cross sel, super, bundle, etc

insert  into `catalog_product_link_type`(`link_type_id`,`code`) values (1,'relation'),(2,'bundle'),(3,'super'),(4,'up_sell'),(5,'cross_sell');
insert  into `catalog_product_link_attribute`(`product_link_attribute_id`,`link_type_id`,`product_link_attribute_code`,`data_type`) values (1,2,'qty','decimal'),(2,1,'position','int'),(3,4,'position','int'),(4,5,'position','int'),(6,1,'qty','decimal'),(7,3,'position','int'),(8,3,'qty','decimal');
insert  into `cataloginventory_stock`(`stock_id`,`stock_name`) values (1,'Default');

Now we are done with delete all products in magento.

Example 3: Out of the box php code to delete product.

Mage::register(’isSecureArea’, true);
try {
   Mage::getModel(’catalog/product’)->load($pid)->delete();
} catch (Exception $e) {}
Mage::unregister(’isSecureArea’);

Example 3: How to truncate all magento categories.
Its advisable to clean magento products first and then execute magento category clean up statements.
This will remove all the categories and then it will create default category which is root category available by default in magento.

TRUNCATE TABLE `catalog_category_entity`;
TRUNCATE TABLE `catalog_category_entity_datetime`;
TRUNCATE TABLE `catalog_category_entity_decimal`;
TRUNCATE TABLE `catalog_category_entity_int`;
TRUNCATE TABLE `catalog_category_entity_text`;
TRUNCATE TABLE `catalog_category_entity_varchar`;
TRUNCATE TABLE `catalog_category_product`;
TRUNCATE TABLE `catalog_category_product_index`;
insert  into `catalog_category_entity`(`entity_id`,`entity_type_id`,`attribute_set_id`,`parent_id`,`created_at`,`updated_at`,`path`,`position`,`level`,`children_count`) values (1,3,0,0,'0000-00-00 00:00:00','2009-02-20 00:25:34','1',1,0,1),(2,3,3,0,'2009-02-20 00:25:34','2009-02-20 00:25:34','1/2',1,1,0);
insert  into `catalog_category_entity_int`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) values (1,3,32,0,2,1),(2,3,32,1,2,1);
insert  into `catalog_category_entity_varchar`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) values (1,3,31,0,1,'Root Catalog'),(2,3,33,0,1,'root-catalog'),(3,3,31,0,2,'Default Category'),(4,3,39,0,2,'PRODUCTS'),(5,3,33,0,2,'default-category');
Share this nice post:

30 thoughts on “How to delete all products in magento

  1. Pingback: Meine Lesezeichen
  2. I am not sure whether this post is written by him as no one else know such detailed about my problem. You are incredible! Thanks

  3. I got what you designate, thanks for swing up. Woh I am happy to conclude this website finished google. Thanks For Share

  4. An riveting discourse is designer remark. I reckon that you should create statesman on this message, it power not be a inhibition master but generally fill are not enough to utter on such topics. To the succeeding. Cheers !!

  5. I am getting the below error:

    SQL query:

    TRUNCATE TABLE `catalog_product_bundle_option` ;

    MySQL said: Documentation
    #1701 – Cannot truncate a table referenced in a foreign key constraint (`magento`.`catalog_product_bundle_option_value`, CONSTRAINT `FK_CAT_PRD_BNDL_OPT_VAL_OPT_ID_CAT_PRD_BNDL_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `magento`.`catalog_product_bundle_opti)

  6. An riveting word is designer statement. I believe that you should write writer on this subject, it power not be a bias subject but mostly people are not enough to communicate on much topics. To the next. Cheers like your How to delete all products and its information.

  7. Pingback: Sifisdndsk
  8. I got what you wish, thanks for putting up. Woh I am willing to ascertain this website finished google. Thanks For Share !.

  9. A person necessarily lend a hand to make severely articles I would state. This is the first time I frequented your web page and thus far? I amazed with the research you made to make this actual publish incredible. Wonderful task!

  10. I have not checked in here for a while since I thought it was getting boring, but the last several posts are great quality so I guess I’ll add you back to my everyday bloglist. You deserve it my friend :)

  11. Pingback: Jenna Levene

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>