Magento orders paid via paypal, eway or any other payment gateway, sometimes mark the orders as Suspected Fraud. The Suspected Fraud status is assigned to state "Payment Review". This means the order doesnot have invoice issued and the confirmation email is also not sent. We cannot create the invoice for it either.
The Suspected Fraud status is assigned to order because of exchange rates or tax rounding. For example, the amount of money which Paypal charges the customer is out by 1p compared to the amount of money that Magento thinks should have been charged. When Paypal tells Magento that the order has been paid and how much money has been paid, Magento sees this difference and marks it as Suspected Fraud.
The solution is to update the state of the Suspected Fraud status to "processing" instead of "payment review".
For this, go to magento admin panel and to System -> Order Statuses section. There you can see the list of Order Statuses and the Suspected Fraud status assigned to the Payment Review state.
Now, we need to unassign the status of Suspected Fraud by clicking the Unassign link. After unassigning it, click on "Assign status to state" button. We need to assign it to the "Processing" state as shown in fig below.
Select the Order status "Suspected Fraud" from first dropdown and Order State to "Processing" from the next select. Then save status assignment.
This solution solves the problem of updating the status of "Suspected Fraud" orders. We can now update the status to processing and create invoice for it too. However, this applies to orders created after we have done above.
For the orders that are already created before, the above solution won't work. We need to run a script for this.
Sample script:
require_once('app/Mage.php');
Mage::app();
//Get orders having status of "fraud".
$orders = Mage::getModel('sales/order')->getCollection()
->addFieldToFilter('status', 'fraud');
//update the order state to processing
foreach ($orders as $order) {
$orderId = $order->getId();
$fullOrder = Mage::getModel('sales/order')->load($orderId);
$fullOrder->setState(Mage_Sales_Model_Order::STATE_PROCESSING, true);
$fullOrder->setStatus('processing', false);
$fullOrder->save();
//create invoice and send order confirmation email
try {
if(!$fullOrder->canInvoice()) {
Mage::throwException(Mage::helper('core')->__('Cannot create an invoice.'));
}
$invoice = Mage::getModel('sales/service_order', $fullOrder)->prepareInvoice();
if (!$invoice->getTotalQty()) {
Mage::throwException(Mage::helper('core')->__('Cannot create an invoice without products.'));
}
$invoice->setRequestedCaptureCase(Mage_Sales_Model_Order_Invoice::CAPTURE_OFFLINE);
$invoice->register();
$transactionSave = Mage::getModel('core/resource_transaction')->addObject($invoice)->addObject($invoice->getOrder());
$transactionSave->save();
} catch (Mage_Core_Exception $e) {
}
}
}
This script can be saved on a separate file and can be runned manually.
Comments
Post a Comment