Skip to content

Instantly share code, notes, and snippets.

@vishy93
Last active February 26, 2019 14:31
Show Gist options
  • Save vishy93/02084d4df9fcd1fa004ade6755982cfe to your computer and use it in GitHub Desktop.
Save vishy93/02084d4df9fcd1fa004ade6755982cfe to your computer and use it in GitHub Desktop.
Script to mark processing state orders between certain date as completed
<?php
$mageFilename = '../app/Mage.php';
require_once $mageFilename;
Mage::setIsDeveloperMode(true);
ini_set('display_errors', 1);
umask(0);
Mage::app('admin');
Mage::register('isSecureArea', 1);
Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);
set_time_limit(0);
ini_set('memory_limit','1024M');
/*
const STATE_NEW = 'new';
const STATE_PENDING_PAYMENT = 'pending_payment';
const STATE_PROCESSING = 'processing';
const STATE_COMPLETE = 'complete';
const STATE_CLOSED = 'closed';
const STATE_CANCELED = 'canceled';
const STATE_HOLDED = 'holded';
const STATE_PAYMENT_REVIEW = 'payment_review';
*/
/*
$orderId = array('100035306','100035307');
// Start Magento
$app = Mage::app();
foreach ($orderId as $order) {
$order = Mage::getModel('sales/order')->loadByIncrementID($order);
$old_state = $order->getState();
$order->addStatusToHistory(Mage_Sales_Model_Order::STATE_COMPLETE);
$order->setStatus('complete');
$history = $order->addStatusHistoryComment('Order was invoiced via profit master.', false);
$history->setIsCustomerNotified(false);
$order->save();
$new_state = $order->getState();
echo "Modified order $order->getId(): Old state: $old_state. New state: $new_state\n";
}
*/
/*
$dateStart = date('Y-m-d', "01/01/2007");
$dateEnd = date('Y-m-d', "30/09/2016");
*/
/*
$originalDate = "2010-03-21";
$newDate = date("d-m-Y", strtotime($originalDate));
*/
$collection = Mage::getModel('sales/order')->getCollection()
->addAttributeToFilter('created_at', array('from'=>"2007/01/01", 'to'=>"2016/09/30"))
->addAttributeToFilter('status', array('eq' => Mage_Sales_Model_Order::STATE_PROCESSING))
->setOrder('created_at', 'ASC')
->load();
foreach ($collection as $order) {
/*
echo("working");
$order = Mage::getModel('sales/order')->loadByIncrementID($order->getIncrementId());
*/
$old_state = $order->getState();
$order->addStatusToHistory(Mage_Sales_Model_Order::STATE_COMPLETE);
$order->setStatus('complete');
$history = $order->addStatusHistoryComment('Order was invoiced via profit master.', false);
$history->setIsCustomerNotified(false);
$order->save();
$new_state = $order->getState();
echo "Modified order $order->getId(): Old state: $old_state. New state: $new_state\n";
}
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment