Question

Saludos

¿Como puedo hacer un cron jobs en magento y que borre los carritos de compras abandonados?, ¿Alguien que me oriente?, una guia

Gracias.

Answer 1

Solucionado

este es el script

 date_default_timezone_set('America/Bogota');
  ini_set('display_errors', 1); error_reporting(E_ALL);
  $root = realpath($_SERVER["DOCUMENT_ROOT"]);
  require_once("$root/site/app/Mage.php"); //Path to Magento
  umask(0);
  Mage::app();
  // $connection = Mage::getSingleton('core/resource')->getConnection('core_write');
  // $result = $connection->query("SELECT * FROM sales_flat_quote WHERE is_active = 0");
  // print_r($result->fetch());
  cart();

  function cart(){
    //prevent or look into properly joining things in.
    $orders = Mage::getModel('sales/order')->getCollection()->addAttributeToSelect('*');
    $quote_ids  = $orders->getColumnValues('quote_id');
    $quote_ids = array_filter($quote_ids, 'is_numeric');
    $lifetime *= 900;
    $carts = Mage::getModel('sales/quote')->getCollection()->addFieldToFilter('entity_id',array('nin'=>$quote_ids));
    #$carts->addFieldToFilter('updated_at', array('to'=>date("Y-m-d", time()-$lifetime)));

    $i = 0;

    ob_start();
    echo date("d-m-Y H:i:00",time());
    $date_exec = ob_get_contents();
    ob_end_clean();

    foreach($carts as $cart) {
      $i = $i + 1;

      //var_dump('abandoned cart', $cart);
      echo 'PRODUCT '. $i."<br/>";
      echo $cart->getCustomerFirstname();
      echo $cart->getCustomerLastname();
      echo $cart->getCustomerEmail();
      echo $date_exec;
      //$cart->delete();
      echo '<br />';
    }
  }