Magento Suspected Fraud

If an order comes through Magento as Suspected Fraud and you’ve addressed the issue via your Payment Gateway, many times Magento will not recognize the change. Here’s how to manually update the order status:

1. From the backend of magento, open the order in question.
2. Take Note of the Order # and the number after the last slash of the URL
   1. https://abc.com/index.php/manage/sales_order/view/order_id/47436/
3. Open up the sales_flat_order table, and find the row with the matching entity_id (number you pulled from the URL in Step 2) column.
   1. Change ‘state’ column value to ‘processing’
   2. Change ‘status’ column value to ‘processing’
   3. Close Table
4. Open up the sales_flat_order_grid table, and find the row with the matching entity_id (number you pulled from the URL in Step 2) column.
   1. Change ‘status’ column value to ‘processing’
5. Open up the sales_flat_order_status_history table, and find the row with the matching parent_id (number you pulled from the URL in Step 2) column. There might be multiple rows, but we are looking for a row that has a value containing the word ‘fraud’ in the ‘status’ column
   1. Change ‘status’ column value to ‘processing’