Missing Order OC-3.0.3.2

justint24 wrote: ↑

Fri Mar 25, 2022 11:18 pm

I have spoken to First Data and can confirm they have the correct transaction notification URL on their system.

First data logs have been switched on today via the extension and so for this is what has been recorded in the log

2022-03-25 9:42:00 - getOrder - 18807
2022-03-25 9:45:19 - getOrder - 18808
2022-03-25 10:10:17 - getOrder - 18808

Have you checked your web access logs to see if first Data actually call your Notification URL?

Sorry not sure which logs i should be looking for. Outside public_html directory i see a directory called access-logs but that's empty. Error log also empty.

justint24 wrote: ↑

Sat Mar 26, 2022 1:15 am

Sorry not sure which logs i should be looking for. Outside public_html directory i see a directory called access-logs but that's empty. Error log also empty.

If using cPanel it's Raw Access under METRICS, otherwise ask your host.

I have it.

So not sure what i'm looking for or if to upload the file here.

But i see 1 instance of first data

193.178.55.182 - - [25/Mar/2022:17:11:52 +0000] "GET /admin/index.php?route=marketplace/modification&user_token=yQRv1pA4brKglfr66ctN6Q1f1GvwU1l7 HTTP/1.1" 200 3909 "OUR-URL/admin/index.php?route=extension/payment/firstdata&user_token=yQRv1pA4brKglfr66ctN6Q1f1GvwU1l7" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:98.0) Gecko/20100101 Firefox/98.0"

You want to look at the URLs in your access log for something like below...
^ basically to see if firstdata is calling back to your website.

The callback would be most likely on the catalog side not the admin.

I have checked all files and this only appears once - route=extension/payment/firstdata/notify

193.178.55.182 - - [23/Mar/2022:07:08:17 +0000] "GET /favicon.ico HTTP/1.1" 404 607899 "OUR-URL/index.php?route=extension/payment/firstdata/notify" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:98.0) Gecko/20100101 Firefox/98.0"

justint24 wrote: ↑

Sat Mar 26, 2022 3:17 pm

I have checked all files and this only appears once - route=extension/payment/firstdata/notify

193.178.55.182 - - [23/Mar/2022:07:08:17 +0000] "GET /favicon.ico HTTP/1.1" 404 607899 "OUR-URL/index.php?route=extension/payment/firstdata/notify" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:98.0) Gecko/20100101 Firefox/98.0"

I would check with your host. That entry means that /favicon.ico was requested with /index.php?route=extension/payment/firstdata/notify being the referrer. Probably because someone enter the URL into a web browser. If you don't see any entries with /index.php?route=extension/payment/firstdata/notify as the first item, then It could be being blocked by some sort of firewall or something in your htaccess.

So since the last post.

I spoke to my host, who looked at the issue and said First Data could be blocked in the server firewall. If you can provide the IP's they'd be connecting from we can check this.

So i went off to speak with First Data who eventually gave me 14 IP's. We added them all to the server firewall to allow them through and nothing has changed.

All First Data orders are still going to missing orders.

ADD Creative wrote: ↑

Thu Mar 24, 2022 7:35 pm

nikythebest wrote: ↑

Thu Mar 24, 2022 6:23 pm

Hello,
Did anyone solve the problem with the missing orders? I have the same problem and is very annoying. I don't think there is a problem with the email or smtp because the problem is that the status order is 0 and is not changing. Can you please help me?

Thank you

You need to provide more information. What version of OpenCart? What version of PHP? What theme? What extensions that modify the checkout or orders? What payment extensions are being used? Any errors in the OpenCart error log? Any errors in the server/PHP error log?

Opencart 3.0.3.8.
Php 7.3
There is nothing worng with the checkout or any extensions. As CIP said in this post, after an order is placed succesfully, the second and the third didn't goes through even if the success page is showing. I think this is a problem with the Opencart because this problem persist with fresh install using default COD payment method and free delivery.

Do you have a solution?
Thank you

nikythebest wrote: ↑

Thu Apr 21, 2022 5:55 pm

Opencart 3.0.3.8.
Php 7.3
There is nothing worng with the checkout or any extensions. As CIP said in this post, after an order is placed succesfully, the second and the third didn't goes through even if the success page is showing. I think this is a problem with the Opencart because this problem persist with fresh install using default COD payment method and free delivery.

Do you have a solution?
Thank you

There is no generic solution. There are many causes of order going to missing orders. If you want a solution it would be best to provide the following information.

What theme?
What extensions that modify the checkout or orders?
What payment extensions are being used?
Any errors in the OpenCart error log?
Any errors in the server/PHP error log?

ADD Creative wrote: ↑

Thu Apr 21, 2022 6:11 pm

nikythebest wrote: ↑

Thu Apr 21, 2022 5:55 pm

Opencart 3.0.3.8.
Php 7.3
There is nothing worng with the checkout or any extensions. As CIP said in this post, after an order is placed succesfully, the second and the third didn't goes through even if the success page is showing. I think this is a problem with the Opencart because this problem persist with fresh install using default COD payment method and free delivery.

Do you have a solution?
Thank you

There is no generic solution. There are many causes of order going to missing orders. If you want a solution it would be best to provide the following information.

What theme?
What extensions that modify the checkout or orders?
What payment extensions are being used?
Any errors in the OpenCart error log?
Any errors in the server/PHP error log?

Default theme.
Clean fresh install, no extensions, no modifications. Default payment method COD. No error in opencart. No error in php log.

nikythebest wrote: ↑

Thu Apr 21, 2022 6:49 pm

Default theme.
Clean fresh install, no extensions, no modifications. Default payment method COD. No error in opencart. No error in php log.

When you test with the COD payment method and the order goes to missing orders, does the customer always receive the order email? Do you always get taken to the success page?

Have you tried disabling your browser's cache in its developer tool and testing?

Have you checked your web access logs that index.php?route=extension/payment/cod/confirm is accessed every time you click on confirm order?

I am still struggling with this one.

I have now installed First data for another client. So i now have 2 websites using first data and all go into missing orders. Worldpay and paypal all work perfectly.

Is there a bug with the first data extension, is there a paid/supported version of the extension i can pursue. Happy to even pay anyone to work it out.

I have first datas 14 IP's whitelisted on the firewall and still go into missing orders.

If you are not seeing the notifiy URL in your access logs then the callback may be blocked or not configured correct. (as mentioned above)
Do you see anything with that in your access logs?

Keep in mind there are sometimes two access logs, one for http requests and another for https requests (depending on the server setup). Check the root of your webspace for a logs folder or contact your host.

Also take note that it appears firstdata uses its own logger method and writes to a separate debug log. If you have debugging enabled, check your storage/logs folder for a firstdata.log and see if anything useful is present there.
https://github.com/opencart/opencart/bl ... ta.php#L64