Post by jasonc310771 » Wed Mar 08, 2017 3:12 am

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.

Active Member

Posts

Joined
Fri Mar 01, 2013 6:46 pm

Post by cyclops12 » Wed Mar 08, 2017 4:31 am

This post may be of use to you
viewtopic.php?f=191&t=170918

Active Member

Posts

Joined
Sun Sep 27, 2015 1:10 am

Post by jasonc310771 » Wed Mar 08, 2017 4:51 am

Would this work for PayPal Payments Standard ?

Active Member

Posts

Joined
Fri Mar 01, 2013 6:46 pm

Post by Elboy » Thu Mar 09, 2017 1:35 pm

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.

Newbie

Posts

Joined
Wed Nov 21, 2012 2:30 am

Post by jasonc310771 » Thu Mar 09, 2017 4:18 pm

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...

Active Member

Posts

Joined
Fri Mar 01, 2013 6:46 pm

Post by jasonc310771 » Thu Mar 09, 2017 4:41 pm

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 ?

Active Member

Posts

Joined
Fri Mar 01, 2013 6:46 pm

Post by hebiki » Wed Mar 15, 2017 6:06 pm

anyone founda solution to this yet? i am experiencing this on 3 of my sites.

New member

Posts

Joined
Sun Oct 10, 2010 4:00 pm
Who is online

Users browsing this forum: No registered users and 4 guests