How to cancel automatically pending order with in 7 days in Magento 1.8.1? [closed]

Question

How can I auto cancel pending orders if they are not processed within 7 days?

Answer 1

Try to set cron job,

In config.xml,

    <config>
       <global>
          <module_name>
             <class>Namaspace_Modulename_Model</class>
          </module_name>
       </global>
         <crontab>
                <jobs>
                    <order_cancel_orders>
                        <schedule><cron_expr>*/5 * * * *</cron_expr></schedule>
                        <run><model>modulename/observer::cancelPendingOrders</model></run>
                    </order_cancel_orders>
            </crontab>
        </config>

In observer.php

         class Namaspace_Modulename_Model_Observer
    {

                public function cancelPendingOrders(){
                            $date = strtotime("-7 day");
                            $result_date  = date('Y-m-d h:i:s', $date);
                            $orderCollection = Mage::getResourceModel('sales/order_collection');

                            $orderCollection->addFieldToFilter('status', 'pending')
                                    ->addFieldToFilter('created_at', array('lteq' =>  $result_date))
                                    ->getSelect()
                                    ->order('main_table.entity_id');

                            $orders ="";
                            foreach($orderCollection->getItems() as $order)
                            {
                              $orderModel = Mage::getModel('sales/order');
                              $orderModel->load($order['entity_id']);


                              if(!$orderModel->canCancel())
                                continue;

                              $orderModel->cancel();
                              $orderModel->setStatus('canceled_pendings');
                              $orderModel->save();

                            }
            }
  }