So here's the problem, I've already done a clean install and didn't help. I hope somebody here would be able to help out.
No orders show up in admin or user panel after doing a successful purchase! No history of any orders whatsoever!
The odd thing is that they do appear in my databases and I can see them with phpmyadmin.
I did a lot googling and searching but found nothing that could help me, some people had similar issues and the suggestions was to check if I have "Order statuses" Which I do have (like pending, completed... blah blah).
I tried using other purchase methods, tried different usernames different products...
I even changed hosts to see if it'll help (Both linux and my current host was recommended for Opencart), nothing works.
So I'm basically stumped, dunno what to do.
EDIT: Okay so I found my orders when I filtered Orders list by "Missing Orders" ! Why are they Missing orders and not pending? is this also why there are no order history in user's panel too?
Yes, the order is completed and I get the confirmation screen and the email. I'm pretty sure the order is completed because I can see it when I filter "Missing Orders" in admin panel and it shows up. then I click on view the order and go to the Order History tab and click on Add History, and then the order shows up in both admin and user panel (under Pending status)rph wrote:Should be fine if you're just using default payment methods. Are you sure you're actually completing the order? You get a confirmation screen and email and your shopping cart empties out?
I uploaded two screen shots.
Capture.JPG (24.61 KiB) Viewed 14368 times
Capture2.JPG (61.08 KiB) Viewed 14368 times
Actually I don't get a confirmation email up until I add the Order History and tick the Notify Customer checkbox. after I get the email the order numbers do match, they were both 30.rph wrote:And the order numbers match from the confirmation email?
Edit: I'm using version 18.104.22.168
Yep, I just tried that too, the cart is empty and I thought maybe the problem was with the users so I tried making a purchase as a guest and the same thing...rph wrote:It sounds like the orders aren't being completed. Did you try logging in with the account and seeing if the items are still in the cart?
And then I thought maybe there's something wrong with the custom template that I'm using so I switched to the default template and didn't make any difference.
This is starting to get annoying, dead ends...!
I checked the store settings, New orders are being assigned as Pending.rph wrote:Check what status new orders are being assigned in your store settings. Also check your database for what order_status_id is being assigned on a new order.
and I checked the database, there isn't any table called Order_status_id ! That's weird... But I found a column named "Order_status_id" in a table called "order" (is this what you meant?) I had two orders there, one of them is 15 the other one is 0.
Capture3.JPG (24.59 KiB) Viewed 14320 times
Capture4.JPG (16.69 KiB) Viewed 14320 times
You're right, the problem is definitely from the function not being called back. I checked the error logs, they were empty except for some old errors that has nothing to do with this problem. I disabled the modules and VQmods but it didn't make any difference!rph wrote:The idea was to check that your order_status table was lining up correctly. It is so this is likely an issue with the confirmation function not being called. Check your error log, check your VQMod error log, disable any third-party extensions, and try placing an order with a different payment method like COD.
What I did notice was that, this time I chose the products, entered names, addresses etc... but I didn't click on Confirm Order and closed the page. The unfinished order appeared as missing order. Which means that there's definitely something wrong with the call back function!
No, that's the proper default behavior. If you don't finalize the order then it's not an order. That's why I asked you if you completed the order. It's entirely possible customers are going into the checkout to get info like shipping cost then choosing to abandon the order.WhiteRenard wrote:The unfinished order appeared as missing order. Which means that there's definitely something wrong with the call back function!
Okay... then what should we do?rph wrote:No, that's the proper default behavior. If you don't finalize the order then it's not an order. That's why I asked you if you completed the order. It's entirely possible customers are going into the checkout to get info like shipping cost then choosing to abandon the order.WhiteRenard wrote:The unfinished order appeared as missing order. Which means that there's definitely something wrong with the call back function!
Users browsing this forum: No registered users and 40 guests