advanced code snippet search

Posted By

TheJasonParker on 01/12/11


Tagged

magento


Versions (?)

Mass delete products for Magento 1.4+

 / Published in: PHP
 

URL: http://www.sonassi.com/knowledge-base/magento-knowledge-base/mass-delete-products-in-magento/

The easiest way to pull this off is by means of a quick script. The key to this script is that the indexing functionality is disabled entirely for the process, then enabled again at the end – requiring a manual update at the end.

In our case, we filtered the type of products by its “Data Set” – an attribute assigned to that batch of products, but you can change this to suit any means of filtering.

Expand | Embed | Plain Text 
  1. <?php
  2.  
  3. ob_end_flush();
  4. echo "Started ".date("d/m/y h:i:s")."
  5. ";
  6. define('MAGENTO', "/domains/example.com/http");
  7.  
  8. require_once MAGENTO . '/app/Mage.php';
  9. umask(0);
  10. Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID); 
  11.  
  12. $products = Mage::getModel('catalog/product')
  13. ->getCollection()
  14. ->addFieldToFilter('data_set', 1544);
  15.  
  16. $sql = ""; $undoSql = "";
  17. for ($i=0; $i<=8; $i++) {
  18. $sql .= "UPDATE index_process SET mode = 'manual' WHERE index_process.process_id =$i LIMIT 1;";
  19. $undoSql .= "UPDATE index_process SET mode = 'real_time' WHERE index_process.process_id =$i LIMIT 1;";
  20. }
  21.  
  22. $mysqli = Mage::getSingleton('core/resource')->getConnection('core_write');
  23. $mysqli->query($sql);
  24.  
  25. $total_products = count($products);
  26. $count = 0;
  27. foreach($products as $product){
  28. $product->delete();
  29.  
  30. if($count++%100 == 0) {
  31. $cur = strtotime(date("d/m/y h:i:s")) - $time;
  32. $time = strtotime(date("d/m/y h:i:s"));
  33. echo round((($count/$total_products)*100),2)."% deleted ($count/$total_products) ".round(100/$cur)." p/s ".date("h:i:s")."
  34. ";
  35. flush();
  36. }
  37. }
  38.  
  39. echo "Ended ".date("d/m/y h:i:s")."
  40. ";
  41. $mysqli->query($undoSql);
  42. exit();
  43.  
  44. ?>

Report this snippet  

You need to login to post a comment.