Page 1 of 1

All new orders are going to missing orders

Posted: Tue Jun 05, 2018 10:03 am
by calpang1026
I am using opencart 2.3.x due to a recent upgrade, all the new incoming orders are ending up in cancelled orders and can be found in the "missing orders" only and nothing is showing in the admin error log.
This applies to all my payment methods I have (bank transfer, paypal standard, cash on delivery), and all the order_status_id = 0 in the database.

Desperatly need some help with this.

Thanks

Re: All new orders are going to missing orders

Posted: Tue Jun 05, 2018 10:31 pm
by OSWorX
You did not write which version you have used before.
But that behaviour seems to be a missing setting in the store configuration.

Re: All new orders are going to missing orders

Posted: Fri Jun 08, 2018 9:46 am
by calpang1026
Hi v2.1 was the previous version. The default status for new order is set as "Processing" in the store configuration, and all the statuses in the payment gateways seem to be in the right place...

Re: All new orders are going to missing orders

Posted: Fri Jun 08, 2018 3:27 pm
by OSWorX
calpang1026 wrote:
Fri Jun 08, 2018 9:46 am
The default status for new order is set as "Processing" in the store configuration, and all the statuses in the payment gateways seem to be in the right place...
If all of that settings are correct, looks like your customers did not finished their purchases.

Because the moment they reach the final page in the checkout, the order is created with the status = 0.
The status will then be changed only after confirmation.

Re: All new orders are going to missing orders

Posted: Thu Apr 18, 2019 1:30 am
by ivan2121
I have the same issue. Using Version 2.0.3.1

Default status in the store settings is set to Pending
Using PayPal Pro fro card payments and the status is set to processing

Recently we received an email from PayPal and the transaction ID receipt made BUT the order from that customer is in the Missing Orders.
How is that possible?

I will appreciate any help greatly!!

Re: All new orders are going to missing orders

Posted: Fri Apr 19, 2019 5:12 am
by johnp
I had this problem on a couple of 1.5.6.5 sites. Check that the primary email address you have in your Paypal account is the same one as you use for your main store email. On Paypal standard payments I was getting mismatch errors in the Error logs file due to mismatching email addresses. Paypal saw this as possible fraud.

Re: All new orders are going to missing orders

Posted: Sun Apr 21, 2019 6:37 pm
by ivan2121
johnp wrote:
Fri Apr 19, 2019 5:12 am
I had this problem on a couple of 1.5.6.5 sites. Check that the primary email address you have in your Paypal account is the same one as you use for your main store email. On Paypal standard payments I was getting mismatch errors in the Error logs file due to mismatching email addresses. Paypal saw this as possible fraud.
Thanks for the reply. I had this issue with only one order that went to missing orders and the Paypal payment was received at the same time.

I enabled IPN in my PayPal account settings and provided the correct IPN URL and tried again with a couple of new PayPal Standart orders and few Card payments via PayPal Pro and it all worked good. However, I think the Paypal account email is different than the Store email so maybe I should change that too.

I also have another issue with another OC 2.3.0.2 store. I use PayPal Hosted module for card payments. What started happening recently is that for each new card payment the status 'Processing' duplicates for several times in the Order History tab. Each time that send emails to the customer which is very very disturbing and we got several customer complaints already!!! I cannot find info anywhere about how to fix this. The developer does not respond also.

Re: All new orders are going to missing orders

Posted: Mon Apr 22, 2019 4:02 am
by johnp
I've seen that before with third party templates and checkouts. See if it happens with the default setup.

Re: All new orders are going to missing orders

Posted: Mon Apr 22, 2019 4:04 am
by johnp
ivan2121 wrote:
Sun Apr 21, 2019 6:37 pm
johnp wrote:
Fri Apr 19, 2019 5:12 am
I had this problem on a couple of 1.5.6.5 sites. Check that the primary email address you have in your Paypal account is the same one as you use for your main store email. On Paypal standard payments I was getting mismatch errors in the Error logs file due to mismatching email addresses. Paypal saw this as possible fraud.
Thanks for the reply. I had this issue with only one order that went to missing orders and the Paypal payment was received at the same time.

I enabled IPN in my PayPal account settings and provided the correct IPN URL and tried again with a couple of new PayPal Standart orders and few Card payments via PayPal Pro and it all worked good. However, I think the Paypal account email is different than the Store email so maybe I should change that too.

I also have another issue with another OC 2.3.0.2 store. I use PayPal Hosted module for card payments. What started happening recently is that for each new card payment the status 'Processing' duplicates for several times in the Order History tab. Each time that send emails to the customer which is very very disturbing and we got several customer complaints already!!! I cannot find info anywhere about how to fix this. The developer does not respond also.
I never use Paypal IPN. I have it disabled in Paypal. I let Opencart use its own built in callback.