Orders are not visible in dashboard - All orders has to be manually added from tables

Hi,

I am having issue with 2.3.0.2. version, I am using Journal theme. This is my site

Everyone who check out and choose stripe payment option, none of this orders are visible in the dashboard.
I have to go to phpmyadmin and enter manually each order searching through tables.

I can not do this any longer, it is exhausting, and people do not receive any notification that the order was placed, until I manually enter those orders.
HELP

Check both your PHP and OpenCart error logs. Have you contacted the developer of the Stripe payment extension you are using?

Have you checked whether the orders are listed under the 'Missing Orders' filter? These are the ones with order_status=0 because the payment gateway may not have sent back a message to OpenCart about the successful payment.

ADD Creative wrote: ↑

Tue Jul 09, 2024 8:04 pm

Check both your PHP and OpenCart error logs. Have you contacted the developer of the Stripe payment extension you are using?

These are the error logs. The order was made on 6th of July at 9:22 AM. What am I looking at?
Yes there is no response from the developer Digital Bird.
I can not upload php error log because it is too big. :/

JNeuhoff wrote: ↑

Tue Jul 09, 2024 8:15 pm

Have you checked whether the orders are listed under the 'Missing Orders' filter? These are the ones with order_status=0 because the payment gateway may not have sent back a message to OpenCart about the successful payment.

Where can I find this? Under order_history_id there is a missing order_id — 2084 .. I received a stripe notification about order 2084 that was succesfully captured..
But not in dashboard. 2084 is visible under oc_order under 2084 and 2085..
I can see people are placing orders many times, but only one capture is done. This is awful.


EDIT: AHA, I found it.. under 2084 is 0, under 2085 is 11, so what should I do now?

You only need to look in the error logs around the time the order that were paid but not showing in the dashboard were made. You want to look for anything related to orders and payments. Also look for any errors relating to emails, a these can also cause the issue.

OpenCart cart will create an order ever time the customer gets to the last step of the checkout. Only orders what the customer has make payment will have the status changed for 0 to something else.

ideep13 wrote: ↑

Tue Jul 09, 2024 9:11 pm

Where can I find this? Under order_history_id there is a missing order_id — 2084 .. I received a stripe notification about order 2084 that was succesfully captured..

You need to check your missing orders in the admin backend at
Sales > Orders > Filter Missing Orders

JNeuhoff wrote: ↑

Tue Jul 09, 2024 11:22 pm

ideep13 wrote: ↑

Tue Jul 09, 2024 9:11 pm

Where can I find this? Under order_history_id there is a missing order_id — 2084 .. I received a stripe notification about order 2084 that was succesfully captured..

You need to check your missing orders in the admin backend at
Sales > Orders > Filter Missing Orders

Omg. I have never used this. And what I found was a lot of missing orders. So next I should just edit them and process, right?
But why is this happening?
The order was made on 6th of july.. at approx. 9:22

there is nothing in the error logs around that time.. this is what I got

2024-07-06 8:41:12 - PHP Notice: Undefined variable: langIdSwitchTo in /home/staskkac/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php on line 266
2024-07-06 8:41:12 - PHP Notice: Undefined variable: langIdSwitchTo in /home/staskkac/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php on line 268
2024-07-06 11:04:35 - PHP Notice: Undefined variable: langIdSwitchTo in /home/staskkac/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php on line 266
2024-07-06 11:04:35 - PHP Notice: Undefined variable: langIdSwitchTo in /home/staskkac/public_html/vqmod/vqcache/vq2-

If you are sure you actually received payment you can process and just changed the status of the order. It will then appear in the main list.

Orders get stuck in the missing orders even when paid due to your site not receiving notification for your payment processor. There are many reasons, including:
A fault with the payment processor not sending notification.
An error with your site causing the notification to be ignored or not changing the status of an order.
A bug in the payment extension.
The notification being block by a firewall.

ADD Creative wrote: ↑

Wed Jul 10, 2024 12:34 am

If you are sure you actually received payment you can process and just changed the status of the order. It will then appear in the main list.

Orders get stuck in the missing orders even when paid due to your site not receiving notification for your payment processor. There are many reasons, including:
A fault with the payment processor not sending notification.
An error with your site causing the notification to be ignored or not changing the status of an order.
A bug in the payment extension.
The notification being block by a firewall.

Payment is always received. Thank you for your insight. I want to fix this. So what should be the first thing to do? I need a little mentoring here.

If you have checked both the PHP and OpenCart error logs and there is nothing in them around the time of the orders that is related. Then some more thing to check would be.

Try making a test order yourself, something might show up that will help you.
Try disabling extension one by one to see if any cause the issue.
Check your server error log at the time of the orders.
Check your web access log at the time of the orders. You will need to know what to look for such as checking the response codes are not 500, 403, etc.

You would also need to work out how the payment extension works and how it sets the order status.

Could it be this?
https://www.antropy.co.uk/blog/missing-orders/