Paypal Sessions Viewer + pushorder

[paulm]

Sometimes paypal IPN orders are not completed automatically (the customer has payed successfully, but the order does not appear in the admin and no
order emails are sent).

This contribution allows you to "push" these orders into your orders table. It is based on the Paypal Sessions Viewer by Dr. Byte + ShoeTick's update and pushorder addon.

Last minute notes:

- You need to check the payments yourself. The script does not do this for you.

- Repeated IPN's sent by Paypal allow Zen Cart to complete the order, even if the initial IPN failed. So it's usually best to wait a while to see if the order is completed automatically after all.

- The security of the pushorder feature has improved a lot compared to v2.0. But I still recommend to rename (or even remove) pushorder.php, especially when it's not in use.

Version details:

Version 3.01
1- added possibility to add pushorder comments to the order comments (defined in configure file)

2- added notify checkbox (send order emails or not)

3- added a link to the customer details page

4- some other small modifications

Version 3.0
1- fixed PHP5 issue with viewer (I hope)

- Added pagination
Now 20 sessions are listed per page (in older versions all sessions were listed)

2- improved security
added ip address check, and fixed the (was not working in 2.0 !?) pushorder password protection

3- added confirmation form to pushorder.php

4- fixed link to pushorder.php

5- defined pushorder.php filename
Makes it easier to rename the file (to improve security)

6- added two configure files

admin/includes/extra_configures/pushorder.php
pushorder password

and:
includes/extra_configures/pushorder.php
pushorder password (this and the admin pushorder password must match)
ip-address setting (enter the ip address of the admin that is allowed to push the paypal orders)

7- removed the redirection back to the admin
your admin should not reside at www.yourdomain.nl/admin anyway, but at a secret location!

8- added email notification
PAYPAL_PUSHORDER_SEND_EMAIL true/false

Known issues:
- pushorders are not saved to the "PayPal Instant Payment Notifications" table.
- The pushorder do not follow the "normal code flow". So several zen notifiers will probably be skipped by it.

v 2.0

This is a the stuck paypal orders script by DrByte but with some major improvements.

Firstly, Instead of using $_SESSION to store the data I am using a variable name.
This fixes the bug that makes DrByte's version log you out of admin when you use it.

Secondly, You can push the order into your orders database so that you can keep track
of inventory and orders.

Available for download from the addons area: http://www.zen-cart.com/index.php?ma...products_id=84

[paulm]

Version 3.02

Only changed the PAYPAL_PUSHORDER_IP comment and it's default definition to:

// replace by your admin ip-address (empty string will skip ip-address check)
define('PAYPAL_PUSHORDER_IP', 'xxx.xxx.xxx.xxx'); 

(in the pushorder.php config file)

[paulm]

Questions about this mod have been asked in another thread for some reason....

I think this answers some of the questions:

This mod a.o. shows the product id's. It's simple: shoppingcart => contents => and there you see numbers (product id's) with their qty values.

But if you use the pushorder feature you don't need to know the product id's! Just click the button ("Move to Orders database") and, after confirmation, the order will be "pushed" into your database.

If you are unsure if it's the right session you are looking at you can verify it by looking up the zenid in your paypal dashboard (transaction details) and see if it matches the Session_ID of the Paypal session viewer.

[tigerbalm]

Paul - firstly - top one - thanks!!

Just one query ... your msg below refers to a change to the PAYPAL_PUSHORDER_IP. I downloaded the 3.01 link on this thread and there is no definition for PAYPAL_PUSHORDER_IP in the pushorder.php config file - unless I'm supposed to add it from your included code but I don't think so. The only thing I have in that file is PAYPAL_PUSHORDER_PASS define.

I reckon there might be another 3.02 download that I've missed somewhere -

Could you confirm?

many thanks again - you're a star!

Version 3.02

Only changed the PAYPAL_PUSHORDER_IP comment and it's default definition to:

// replace by your admin ip-address (empty string will skip ip-address check)
define('PAYPAL_PUSHORDER_IP', 'xxx.xxx.xxx.xxx'); 

(in the pushorder.php config file)

[tigerbalm]

Sorry - excuse that last post - now sorted - I was looking at the wrong config file!!

[paulm]

Thanks for telling it's sorted

Indeed, the pass needs to be defined on both sides (admin and catalog) and the ip-address only on the catalog side.

[thomasharding]

Fantastic solution here. It works fine too.

I wish there was a way this could be more client friendly though.
I know for a fact that something this technical can never be understood by a regular shop owner (we develop e-commerce for SME's). Never mind, haha, I'll just have to stick around and wait for those arses at PP to sort their crap out.

Such a shame really, thought I was finally emerging from that dark and stinky paypal tunnel.

I wish everything was as reliable as Protx.

Good work!

[paulm]

I wish there was a way this could be more client friendly though.

That, and several other things, indeed could be improved a lot! It would cost (me) way too much time though to make big improvements.

It's even too much to mention what other improvements I am thinking about right now. But I am sure it would be doable in a reasonable amount of time by someone that has more knowledge of the Papal IPN module....

[ksf]

Just installed 3.01 and seems to work fine. I'm on v1.38a

[alan57m]

Thanks so much. We have had a few paypal MIAs too. Works fine on our 1.38a too.