Magento – In which table payment method information of order save

orderspayment-methods

I am checking with admin panel order and suddenly when i view particular order. I get error

Uncaught exception 'Mage_Core_Exception' with message 'The requested Payment Method is not available.' .

It is inserted in database corrected or not i want to check this. How i can remove this error method. I want to know location of database table in which all information holds regarding magento order. And also when i print order by collection and used following line of code then same error is coming for that order.

$orders->getPayment()->getMethodInstance()->getTitle();

Best Answer

To find out which (nonexistent) payment method was used, have a look at the sales_flat_order_payment table which contains the payment information for each order (it has a 1:1 relation to sales_flat_order which is the main table for orders). You are looking for the method column.

To be able to load the orders again, you can change the invalid methods to a standard method like checkmo.

Related Solutions

Magento – Cancel order with Magento’s Free Payment Method

If the payment method has been setup to go directly into the status "processing" then you will not be able to cancel the order as orders that have an invoice cannot be cancelled via the admin section.

You can check your settings via System->Configuration->Sales->Payment Methods

Here under the tab Zero Subtotal Checkout you can assign if the invoice is setup and which status the order will be put into.

enter image description here

Magento – Calling “Payment Method” in Order Details

Use below code

$order = Mage::getModel('sales/order');
$incrementId = Mage::getSingleton('checkout/session')->getLastRealOrderId();
$order->loadByIncrementId($incrementId);

$payment = $order->getPayment()->getMethodInstance()->getTitle();

Best Answer

Related Solutions

Magento – Cancel order with Magento’s Free Payment Method

Magento – Calling “Payment Method” in Order Details

Related Topic