Since this is a typical issue when changing from improvement to organizing lastly to creation environments it is convenient to have a shell script that deals with erasing orders in Magento by essentially indicating a rundown of requests to erase, either by request id or request increment id.
In a late post We’ve demonstrated the strides required to erase orders in Magento utilizing several SQL inquiries. Since this is a typical issue when changing from improvement to organizing lastly to creation environments it is convenient to have a shell script that deals with erasing orders in Magento by essentially indicating a rundown of requests to erase, either by request id or request increase id.
This is why We’ve decided to write up a simply PHP shell script containing the required commands to delete orders in Magento. Although it’s pretty self-explanatory I’m planning to release an extension on Magento Connect. Meanwhile feel free to use the code provided below.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
<?php
require ‘../app/Mage.php’;
Mage::app(‘admin’)->setUseSessionInUrl(false);
/**
* whether $removeOrderIds are specified as order increment ids (e.g. 100000025)
* or order ids (e.g. 25).
*/
$useOrderIncrementId = true;
/**
* specify order ids to remove
*/
$removeOrderIds = array(
);
/**
* Deletes order either by $orderIncrementId or $orderId.
* @param int $orderId
* @param boolean $isOrderIncrementId is order increment id
* @return boolean
*/
function deleteOrder($orderId, $isOrderIncrementId = false) {
try {
$order = null;
// load order either based on order increment id or order id
if ($isOrderIncrementId) {
$order = Mage::getModel(‘sales/order’)->load($orderId, ‘increment_id’);
} else {
$order = Mage::getModel(‘sales/order’)->load($orderId);
}
if (!$order->getId()) {
echo ‘Order #’ . $orderId . ‘ does not exist (anymore)’ . PHP_EOL;
return;
}
// 1. call delete to trigger delete-CASCADE
$order->delete();
// 2. manual clean-up for deleted order
// credits go to DeleteOrders extensions
$resource = Mage::getSingleton(‘core/resource’);
$delete = $resource->getConnection(‘core_read’);
$orderTable = $resource->getTableName(‘sales_flat_order_grid’);
$invoiceTable = $resource->getTableName(‘sales_flat_invoice_grid’);
$shipmentTable = $resource->getTableName(‘sales_flat_shipment_grid’);
$creditMemoTable = $resource->getTableName(‘sales_flat_creditmemo_grid’);
$sql = “DELETE FROM “ . $orderTable . ” WHERE entity_id = “ . $orderId . “;”;
$delete->query($sql);
$sql = “DELETE FROM “ . $invoiceTable . ” WHERE order_id = “ . $orderId .“;”;
$delete->query($sql);
$sql = “DELETE FROM “ . $shipmentTable . ” WHERE order_id = “ . $orderId. “;”;
$delete->query($sql);
$sql = “DELETE FROM “ . $creditMemoTable . ” WHERE order_id = “ .$orderId . “;”;
$delete->query($sql);
// 3. we are done!
echo ‘Removed order #’ . $orderId . PHP_EOL;
return true;
} catch (Exception $e) {
echo “Failed to remove order #” . $orderId . “: “
. $e->getMessage() . PHP_EOL;
}
return false;
}
/**
* iterate over $removeOrderIds
*/
foreach ($removeOrderIds as $orderId) {
deleteOrder($orderId, $useOrderIncrementId);
}
echo “DONE!” . PHP_EOL;
?>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
|
<?php
require ‘../app/Mage.php’;
Mage::app(‘admin’)->setUseSessionInUrl(false);
/**
* whether $removeOrderIds are specified as order increment ids (e.g. 100000025)
* or order ids (e.g. 25).
*/
$useOrderIncrementId = true;
/**
* specify order ids to remove
*/
$removeOrderIds = array(
);
/**
* Deletes order either by $orderIncrementId or $orderId.
* @param int $orderId
* @param boolean $isOrderIncrementId is order increment id
* @return boolean
*/
function deleteOrder($orderId, $isOrderIncrementId = false) {
try {
$order = null;
// load order either based on order increment id or order id
if ($isOrderIncrementId) {
$order = Mage::getModel(‘sales/order’)->load($orderId, ‘increment_id’);
} else {
$order = Mage::getModel(‘sales/order’)->load($orderId);
}
if (!$order->getId()) {
echo ‘Order #’ . $orderId . ‘ does not exist (anymore)’ . PHP_EOL;
return;
}
// 1. call delete to trigger delete-CASCADE
$order->delete();
// 2. manual clean-up for deleted order
// credits go to DeleteOrders extensions
$resource = Mage::getSingleton(‘core/resource’);
$delete = $resource->getConnection(‘core_read’);
$orderTable = $resource->getTableName(‘sales_flat_order_grid’);
$invoiceTable = $resource->getTableName(‘sales_flat_invoice_grid’);
$shipmentTable = $resource->getTableName(‘sales_flat_shipment_grid’);
$creditMemoTable = $resource->getTableName(‘sales_flat_creditmemo_grid’);
$sql = “DELETE FROM “ . $orderTable . ” WHERE entity_id = “ . $orderId . “;”;
$delete->query($sql);
$sql = “DELETE FROM “ . $invoiceTable . ” WHERE order_id = “ . $orderId .“;”;
$delete->query($sql);
$sql = “DELETE FROM “ . $shipmentTable . ” WHERE order_id = “ . $orderId. “;”;
$delete->query($sql);
$sql = “DELETE FROM “ . $creditMemoTable . ” WHERE order_id = “ .$orderId . “;”;
$delete->query($sql);
// 3. we are done!
echo ‘Removed order #’ . $orderId . PHP_EOL;
return true;
} catch (Exception $e) {
echo “Failed to remove order #” . $orderId . “: “
. $e->getMessage() . PHP_EOL;
}
return false;
}
/**
* iterate over $removeOrderIds
*/
foreach ($removeOrderIds as $orderId) {
deleteOrder($orderId, $useOrderIncrementId);
}
echo “DONE!” . PHP_EOL;
?>
|
No comments:
Post a Comment