Magento

Paulus - 05 September 2011 12:25 PM

Which one exactly? There’s several posted;-)

I’d love to know for 1.5.1.0

And I’m looking for 1.6.0.0

Don’t need to execute next sql to delete products:

TRUNCATE TABLE `catalog_product_link`;
TRUNCATE TABLE `catalog_product_link_attribute`;
TRUNCATE TABLE `cataloginventory_stock`;

So sql query list :

SET FOREIGN_KEY_CHECKS = 0;
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_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_label`;
TRUNCATE TABLE `catalog_product_super_attribute_pricing`;
TRUNCATE TABLE `catalog_product_super_attribute`;
TRUNCATE TABLE `catalog_product_super_link`;
TRUNCATE TABLE `catalog_product_enabled_index`;
TRUNCATE TABLE `catalog_product_website`;
TRUNCATE TABLE `catalog_category_product_index`;
TRUNCATE TABLE `catalog_category_product`;
TRUNCATE TABLE `cataloginventory_stock_item`;
TRUNCATE TABLE `cataloginventory_stock_status`;
TRUNCATE TABLE catalog_product_entity;
SET FOREIGN_KEY_CHECKS = 1;

Also you can use script delete_byid.php from zip archive delete_byid.zip

1. Deploy your file to new folder ‘magoch’ at the same location with ‘app’ folder on your server.
2. Open project url/magoch/delete_byid.php

Additinal: you can see result file (result_deletedById.csv) passed sku in folder /var/import/ in case you have it before start .
Alternatively you can use it from command line.

Hope it will help for somebody.

How to delete all products in magento
http://www.phptechi.com/how-to-delete-all-products-in-magento.html

i ran this query to remove all products from my db

Now when i try to import the products they dont get assigned the the categories. Its like as if i didnt have the category column in the csv?

any way to fix this? I am using the 1.6.1.0 version.

@daniel5455: Try to re-index data after import. Works for me.
Question to all you guys! Is there any way to delete entities using PHP? So I can delete all products using CSV?
Thank You!

I could not find the SQL queries to run for version 1.7. So I had to find it out from a fresh magento install.
I have added the script in my blog. Check it out here

This worked great for me running 1.7.0.2

You can do this from the Admin.

1. Go to Catalog->Manage Products.
2. Click on “Select All”. (this selects ALL products, not just those on the page).
3. From “Actions” dropdown choose “Delete”.
4. Click “Submit”

Voala!

Sam Figueroa - 29 September 2009 06:48 AM

I think while this will be a whole lot slower it is more future-version-proof-ish since it works against the API.
Works for me.

function deleteAllProducts()
  {
    $products = Mage::getResourceModel('catalog/product_collection')->setStoreId(STORE_ID)->getAllIds();
    if(is_array($products))
    {
      foreach ($products as $key => $productId)
      {
        try {
          $product = Mage::getSingleton('catalog/product')->load($productId);
          Mage::dispatchEvent('catalog_controller_product_delete', array('product' => $product));
          $product->delete();          
        } catch (Exception $e) {
          echo "<br/>Can't delete product w/ id: $productId";
        }
      } 
    }
  }

Just bit question what this code do in deletion?

Thanks,

When I needed to clear out all categories in Magento 1.7.0.2 I used the suggestions above but tweaked slightly. TRUNCATE was complaining about foreign key references so I just ran DELETE and then reset the AUTOINCREMENT so it started back at 3.

Did the job for me. Hope it helps others.

Don’t forget the Cache Flat Tables and honestly, leave catalog_product_link_type alone if you don’t need to truncate it… I removed it and added the flat tables ...

SET FOREIGN_KEY_CHECKS = 0;
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_flat_1`;
TRUNCATE TABLE `catalog_product_flat_2`;
TRUNCATE TABLE `catalog_product_flat_3`;
TRUNCATE TABLE `catalog_product_flat_4`;
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_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_label`;
TRUNCATE TABLE `catalog_product_super_attribute_pricing`;
TRUNCATE TABLE `catalog_product_super_attribute`;
TRUNCATE TABLE `catalog_product_super_link`;
TRUNCATE TABLE `catalog_product_enabled_index`;
TRUNCATE TABLE `catalog_product_website`;
TRUNCATE TABLE `catalog_category_product_index`;
TRUNCATE TABLE `catalog_category_product`;
TRUNCATE TABLE `cataloginventory_stock_item`;
TRUNCATE TABLE `cataloginventory_stock_status`;
TRUNCATE TABLE catalog_product_entity;
SET FOREIGN_KEY_CHECKS = 1;

Mike Smullin solution worked fantastic for me.

Just had to add that it was ok for the foreign key to be constrained for the time being.

at the top of his code put the following if you’re having foreign key problems

and at the bottom of his code but the following to turn it back on

Hope I was able to help with those having foreign key problems.