Magento – How to find missing orders in Magento

magento2.2.3orderssales-order

When I check the orders were placed on our site in the Magento admin panel, some of the order numbers are missing or we can say there's no sequence in order number.

Example: Magento was at number 100034468 and the next order number that came in was 100034470. The number 100034469 is missing.

So I don't know what happened to that missing order number. I have read some of the posts in Magento community, they are all saying that this can happen If there is session error or the transaction was declined to the order. Because of this, the order number will not be used again.

Unfortunately, there's no payment log under the var folder in order to check about the failed transaction. I want to know what happened to the missing order number.

I hope that I will get a satisfied answer from you. Looking forward to your comment. Thanks.

Best Answer

You will simply not get those orders,

because they are not exists

whenever some customer initiate the checkout process a unique order incrementid is assigned to them

but if they fail to put order and in mean time some other customer place the order that order increment id will be skipped

and you will no longer see that order increment id's order.

Related Solutions

Magento – SOAP order inserting: How to stipulate the payment method

To enter the payment as paypal (standard) use:

$paymentMethod = array(
         'method' => 'paypal_standard',
         'last_trans_id' => 'xxxxxxxxxxxx'
     );

Where xxxxxxxxxxxx is your transaction id. You also need to invoice the order after you created it with the API salesOrderInvoiceCreate.

Magento – Orders are missing in Magento but showing as paid in Paypal

The MYSQL error is more a symptom of another issue, than the cause.

In your question you mention that you get a 'long page load' -> this is the real reason for your issues, and then results in the MYSQL has gone away error.

What you need to diagnose is that long delay. What is causing it? It can be a multitude of things.

As an example, on a site I manage, I had exactly the same issues. The end result was that a 3rd party module was syncing orders with an external system using the sales_order_place_after method, which then resulted in a long delay, and the MYSQL error.

You need to debug what that delay is, and solve the root of the issue.

Another example could be when customers sign up for newsletter at checkout (hence why only some are affected) - if you are using an external newsletter signup system, that signup sync could cause delays in the checkout, if not properly implemented.

Your best way to solve this, and identify the lag is to use NewRelic.

ref:

https://github.com/ProxiBlue/OrderSyncQueRunner

http://www.proxiblue.com.au/blog/new-relic/

Best Answer

Related Solutions

Magento – SOAP order inserting: How to stipulate the payment method

Magento – Orders are missing in Magento but showing as paid in Paypal

Related Topic