I am using Version 2.3.0.2, and orders that I have done via paypal are not showing up in admin. I thought I register an account and try again and still the second order that the payment went through ok this also did not show up in admin. Have I forgotten to do something ?
They show in phpmyadmin, I am using OC out of the box.
I think Paypal has changed something as all my sites were working fine the other day with paypal payments standard and now they all have this problem. All orders go into missing.
If I use another payment method like cash on delivery the order completes fine and appears in the order list.
If I use another payment method like cash on delivery the order completes fine and appears in the order list.
Ok I have been digging around the code this morning and adding in breaklines and echoing out the sql queries.
Seems that admin>model>sale>order.php getOrders() function is not getting all the orders correctly. Or I have not set up the admin area correctly to filter the order statuses on that page ?
Original default query to get orders seems to filter out paypal orders from the list. Returned manually added orders via admin and cash on delivery fine.
SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT os.name FROM oc_order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '1') AS order_status, o.shipping_code, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `oc_order` o WHERE o.order_status_id > '0' ORDER BY o.order_id DESC LIMIT 0,20
Take out the Where and order by clauses and all orders are returned. So it may be an issue with the code just under the create sql query process.
Will keep looking...
Seems that admin>model>sale>order.php getOrders() function is not getting all the orders correctly. Or I have not set up the admin area correctly to filter the order statuses on that page ?
Original default query to get orders seems to filter out paypal orders from the list. Returned manually added orders via admin and cash on delivery fine.
SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT os.name FROM oc_order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '1') AS order_status, o.shipping_code, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `oc_order` o WHERE o.order_status_id > '0' ORDER BY o.order_id DESC LIMIT 0,20
Take out the Where and order by clauses and all orders are returned. So it may be an issue with the code just under the create sql query process.
Will keep looking...
I see that all my orders done via paypal have a order_status_id of 0 (zero)
It could be that paypal is sending something other than what OC is expecting which is causing the 0 to be stored and not a 1 for pending.
Has anyone else spotted this ?
It could be that paypal is sending something other than what OC is expecting which is causing the 0 to be stored and not a 1 for pending.
Has anyone else spotted this ?
Who is online
Users browsing this forum: No registered users and 5 guests
