Magento – Change invoice status to paid programmatically

invoicemagento-1.7

How can we programmatically change the status of an invoice to Paid for an order with an offline payment method (eg bank transfer or cash)?

I have tried using the following capture method but this still leaves the invoice as Pending:

$order->load($_POST['order']);
$order->getPayment()->capture();
$order->save();

So how can we update an invoice with an offline payment method to Paid?

Best Answer

Have you tried this?

$invoice = Mage::getModel('sales/order_invoice')->load(...id_of_invoice...);
$invoice->pay()->save();

Related Solutions

Magento2 – How to Get Paid Invoice Collection Filtered by Payment Method

Try this:

$collection = Mage::getResourceModel('sales/order_invoice_collection');
$collection->addFieldToFilter('state', Mage_Sales_Model_Order_Invoice::STATE_PAID);
$collection->getSelect()->join(array('P' => $collection->getResource()->getTable('sales/order_payment')),"P.parent_id = main_table.order_id",array('method'=>'P.method'));
$collection->addFieldToFilter('method', 'checkmo');
echo '<pre>';
foreach($collection as $invoice) {
    print_r($invoice);
}

Magento 2 – How to Perform Invoice Capture Programmatically

It's pretty similar to M1 in Magento 2, you need to inject the Magento\Sales\Model\Service\InvoiceService in your class:

protected $_invoiceService;

public function __construct(
    ...
    \Magento\Sales\Model\Service\InvoiceService $invoiceService
    ...
) {
    ...
    $this->_invoiceService = $invoiceService;
    ...
}

Then, assuming you have the order you can do:

$invoice = $this->_invoiceService->prepareInvoice($order);
$invoice->setRequestedCaptureCase(\Magento\Sales\Model\Order\Invoice::CAPTURE_ONLINE);
$invoice->register();

To set a transaction ID on an invoice you can simply call setTransactionId() method on the invoice object.

Best Answer

Related Solutions

Magento2 – How to Get Paid Invoice Collection Filtered by Payment Method

Magento 2 – How to Perform Invoice Capture Programmatically

Related Topic