We are getting problems with Authorize.net 'timing out' but then creating the order in Magento and then creating the transaction on Authorize.net.

To resolve, I have to go to Authorize.net and capture funds there. However, this leaves the invoice in Magento as unpaid.

Is there a place in the DB where I can change this status or is there some code to make the Authorize.net/Magento 2.2 connection more reliable? It doesn't happen often, but it happens enough to be annoying.

1 Answer 1


In DB you can change 'state' Column value to 2 in 'sales_invoice' table.

Gel all invoice state : vendor/magento/module-sales/Model/Order/Invoice.php

const STATE_OPEN = 1;

const STATE_PAID = 2;


For changing the state by coding, looks this model : vendor/magento/module-sales/Model/InvoiceOrder.php

        try {
            $order = $this->paymentAdapter->pay($order, $invoice, $capture);
                $this->orderStateResolver->getStateForOrder($order, [OrderStateResolverInterface::IN_PROGRESS])
        } catch (\Exception $e) {
            throw new \Magento\Sales\Exception\CouldNotInvoiceException(
                __('Could not save an invoice, see error log for details')
  • I edited the DB via phpMyAdmin, and reindexed, but the orders I changed are still 'Pending' in Sales > Invoices I'll keep digging, but this gets me closer for sure!
    – dawhoo
    Commented Dec 12, 2017 at 17:42
  • 1
    You have to update state column in 'sales_invoice_grid' table also.
    – D Singh
    Commented Dec 13, 2017 at 5:22
  • That was it! "sales_invoice_table" and "sales_invoice_grid" - all invoices are correctly marked - thank you thank you!
    – dawhoo
    Commented Dec 13, 2017 at 17:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.