Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Delete ALL products
 
pumba
Jr. Member
 
Total Posts:  28
Joined:  2008-05-14
 

I need to clean up my database and re-import products so I need to delete all products I already have in there.

Is there any way to do it?
Using SQL statements to clean tables directly is perfectly fine.

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
Discovery
Enthusiast
 
Total Posts:  767
Joined:  2007-12-29
 

Go in to phpmyadmin and DELETE FROM `catalog_product_entity` WHERE attribute_set_id =NNN if you only want to delete your products with your custom attribute set (in which case you will have to look up NNN from your catalog_product_entity table. In that way you can keep ‘demo’ products that have their own attribute sets.
Alternatively, truncate the table, as per the instructions in the wiki.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top