I have received order, if i try to take invoice its not possible to do that because of qty canceled as well as Canceled updated in Comment History,

I am using CCAvenue Payment Gateway.

enter image description here

How to solve the issue?

  • Is this an online method (using gateway) or an offline one? Is the a decision manager or a fraud system that can cancel the order? Or Just the cancel action was clicked inententionnally? Feb 4, 2020 at 11:59
  • Payment gateway online.
    – zus
    Feb 4, 2020 at 12:29
  • Can you share the whode order status history? Feb 4, 2020 at 22:34
  • Status History = snipboard.io/ZHEbjh.jpg
    – zus
    Feb 5, 2020 at 4:22
  • seems to be very specific case related to your website. do you have an automatic shipping process ? which checks quantities in warehouse for example and have the ability to cancel the order automatically ? are you the only user on admin ? you confirm no one did cancel order from admin panel ? Feb 5, 2020 at 10:27

1 Answer 1


I cannot tell you the reason why the order was canceled. There could be a lot of reasons

  • payment processor sent a message back for canceling the order
  • someone actually canceled it from admin
  • ,,,

But I can tell you how to make it invoice-able again.
Take the order id. The entity_id field in the sales_order table, not the increment id.
Let's say it's 110.

Now run these queries:

update sales_flat_order set state = 'processing' where entity_id = 110;
update sales_flat_order_item set qty_canceled = 0.0000 where order_id = 110;

Now you should see the invoice button and you should be able to invoice the order.
Please backup your db before doing this in case I'm wrong.

  • May i know why payment processor sent a message back for canceling the order?
    – zus
    Feb 4, 2020 at 11:23
  • I didn't say that happened. I said it could happen. Maybe for insufficient funds, or maybe the customer asked the company to revert the payment, or fraud suspicion, or anything else.
    – Marius
    Feb 4, 2020 at 11:44
  • fyi - Full amount received, we called them they did nothing.
    – zus
    Feb 4, 2020 at 11:49
  • for the last time...I'm not saying this is exactly what happened. It could have been one of the ways the order got canceled. But not necessarily. Probably something else did it.
    – Marius
    Feb 4, 2020 at 13:00
  • Upcoming days so many order canceled by automatically. May i know the all reasons about canceled order automatically. Can i get any documentation? thanks
    – zus
    Feb 5, 2020 at 6:34

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.