1

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? – Mohamed23gharbi Feb 4 at 11:59
  • Payment gateway online. – zus Feb 4 at 12:29
  • Can you share the whode order status history? – Mohamed23gharbi Feb 4 at 22:34
  • Status History = snipboard.io/ZHEbjh.jpg – zus Feb 5 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 ? – Mohamed23gharbi Feb 5 at 10:27
2
+50

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 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 at 11:44
  • fyi - Full amount received, we called them they did nothing. – zus Feb 4 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 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 at 6:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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