Paypal Sessions Viewer + pushorder

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 https://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?main_page=product_contrib_info&products_id=84

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)

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.

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!

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)

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

Thanks for telling it's sorted :smile:

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

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!

:D

thomasharding:

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

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

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

Love this module - saved a lot of time and trouble with stuck PayPal orders - which seems to have gotten a little better but not 100%.

My question is, can you have more than 1 admin IP address so multiple users can push orders?

cutterscreek:

Love this module - saved a lot of time and trouble with stuck PayPal orders - which seems to have gotten a little better but not 100%.

My question is, can you have more than 1 admin IP address so multiple users can push orders?

If you're on about multiple administrators on one ZC installation, you'll find admin profiles useful:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=86

Hope that helped :smartalec:

Thank you for the recommendation however I am actually wanting to allow multiple admins to push orders but it only allows one admin IP address in the pushorder module. I want to add multiple IP addresses to the php file so other admins can also push the orders.

Oh well, not to sound like a broken record, dripping tap, or annoying barking dog, but with Admin Profiles you can specify what sections of the admin you can restrict for different users.

So for instance, you can only select it for the admin in question, not anyone else.

Despite that, I'm crap with IP related gubbins.

I am afraid admin profiles wont help much here. The actual pushorder script is at the catalog side and it's not limited by the admin. That is why the ip-address protection has been added to improve security.

The script does not support multiple ip-addresses currently. But I think that if you rename the pushorder script to a secret name, and the admins that use it can be trusted, you can disable the ip-address check (by leaving the definition empty).

Also the pushorders will have a pushorder comment and will be recognized easyly (making abuse possibilities even more unlikely).

Ah, ok. Told you I was crap with it :P

I cannot even begin to tell you how awesome you are. You saved me once again! This was the first time I had a stuck PayPal order and I was frantic. I was dreading having to contact my customer about their missing order. "Yeah, hi. I have your money... now what exactly did you order?" Not good!

You rock! :clap:

Thanks :D

Credits should mainly go to Shoetick and DrByte though!

I just uploaded version 3.02 to the downloads area: http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=84 (and I assume it will become available there soon).

paulm:

I am afraid admin profiles wont help much here. The actual pushorder script is at the catalog side and it's not limited by the admin. That is why the ip-address protection has been added to improve security.

The script does not support multiple ip-addresses currently. But I think that if you rename the pushorder script to a secret name, and the admins that use it can be trusted, you can disable the ip-address check (by leaving the definition empty).

Also the pushorders will have a pushorder comment and will be recognized easyly (making abuse possibilities even more unlikely).

I tried leaving the definition blank and it worked on my computer but not the other persons computer who needs to be able to push the orders. Unfortunately her IP address renews itself so giving it a defined IP address does not work in her case. Can you clarify for me how to leave the definition blank in case I missed something? TIA

Nevermind, just downloaded the update and it worked perfectly. Thanks again for a GREAT module!