Paypal Sessions Viewer + pushorder

Have an install guide for dummies on this one?

When you guys install something liek this are you using Dreamweaver or just a basic FTp program?

The instructions say copy all contents to the /admin folder

So am I just copying 1 file the PayPal_Sessions_Viewer folder into the /admin and im done?

Or do I need to go into that folder and transfer each one into each /includes, /boxes etc etc??

Sorry im new to all of this. Just trying to learn.

This thread is not really about the basics of ftp and such. It would be much better to start a new separate thread about that.

But there have been some remarks about the installation (and an error in the readme) a couple of posts up in this thread, so maybe reading these posts will help :smile:

I installed this module today and have a question about the sessions stored in the table. Everything seems to be working fine.

I'm on ZC 1.3.8a and I've been live for 9 months accepting Paypal Website Payments Standard for all of that time. During the first week of January I experienced 2 scenarios where the payment completed in Paypal but did not record an order in Zen Cart. After researching I couldn't identify a cause for the failures and wrote it off as a hiccup in the IPN.

Today I had another instance where this happened. I discovered the Paypal Sessions Viewer and had hopes this would at least allow me to bring the order into the system without contacting my customer.

This customer's transaction does not show up. I attempted to query the tables in the database directly as well (not sure if I'm looking in the correct place (paypal_session?) but the data appeared to correlate to the data I see in the online viewer).

The payment completed this afternoon so it shouldn't have expired yet.

My question is this: how can there be no instance of this customer's transaction in the sessions table? By definition doesn't there need to be an entry in the table 'waiting' for the Paypal IPN?

I've now turned my Paypal logging on to see if I can somehow capture more data if this event happens again.

Thanks in advance for any assistance or thoughts on my issue.

Hi pinkchalkstudio,

(on older Zen Cart versions the data would not even be removed after full completion of the order)

Zen Cart 1.3.8 has built in logic that deletes the session data at some point. But I am not sure if it removes the whole record or only deletes the session data (which would be preferred). And I also don't know when it exactly deletes the data. Hopefully it does this after saving the order data and sending the e-mails....

I think expiration is not a possible cause, because I assume a transaction can not expire after it has completed succesfully (which is the case here because you received the payment).

No other ideas atm :-(

Thank you paulm. Mystery solved on my end. Fortunately the order it occurred on was a regular customer and she was willing to communicate back and forth with me about the details of her transaction.

Here's what happened:

She went to checkout and got interrupted before completing the transaction in Paypal. She came back and proceeded with payment which was successful. In the time she delayed this processing I had gone into the system and made some mark downs on two of the items in her cart. (Now what are the chances of that happening, I have over 500 products but it did!)

The Paypal payment went through for $39.40. Her Zen Cart total was actually $36.50 with the markdowns. Thus the IPN couldn't do a match on amount and the order was 'stuck'.

I could see the $36.50 transaction in the viewer but since they were different amounts I assumed she had abandoned her cart earlier and that was just sitting there. I went ahead and pushed that order into the system using this mod (thank you for a wonderful contribution!). I'll now issue her a Paypal refund.

After reviewing the forums last night I've decided to install Paypal Express Checkout and drop the use of Paypal IPN Website Payments Standard. I originally used IPN because I wanted to provide credit cards w/o a Paypal Account. Since then I've acquired my own credit card processing from First Data (via the Zen Cart partners links) and I don't need this feature from Paypal.

Thanks for this mod, it helped me get to the root of an issue that was extremely difficult to debug!

:lamo: Hello Paul
Thank you for the contribution works realy nice, but i notice that all the sales i make they all go thru in paypal but all got a duplicated. Meaning it will pull 2 orders one is done and the oder get's stock but is the same oreder. So maybe in your next update can you add a second button to removed the orders that seen stock but they are not orders. Thank you Paul :clap::bigups:

where can i get this mod?

Here.
:lamo: http://www.zen-cart.com/forum/showthread.php?t=98343 :lamo:
:smartalec:

dumus:

where can i get this mod?

:smile:

In defense of dumus: the link has been added to the top post by a moderator (recently I think, not august 2008).

I recently set up a 1.3.8a cart with Paypal Standard as my only payment. I added this Stuck Order mod as a precaution after reading this thread. As we opened the store, I did a trial small sale using Paypal (non-member) and it worked fine. The order was added, the emails went out, I was returned to my store and our store Paypal account showed the transaction.

Today we got a real order. But I didn't actually get the order. Instead I saw that someone had created account. I also have Supertracker installed, so I saw that the last page the customer was on was the Checkout Confirmation page, which is just before they jump to the Paypal page, and they had added the items to their cart. But no order had been created.

When I checked the Stuck Paypal orders, I saw an item for that customer and that amount. I did not see anything in the regular Paypal IPN listing nor in my Paypal account transactions. So I clicked the Add Order to database and Send Emails. The listing in Stuck orders disappeared. The order appears in the Orders section now. But there is still no transaction showing in my Paypal account.

Being brand new to this, I'm not sure what this means. Did the customer actually pay or did he stop prior to actually completing his paypal credit card info?

I'm waiting to contact the customer until I can get a better handle on what all this means. I did send an email to Paypal support describing this event with the customer name, amount and my order number. Not sure if I'll hear anything from them.

Can anyone guide me on this first transaction gone bad? Thanks.

In playing with this, I see that if I add something to a cart, then go to the Paypal payment page, then check the Stuck Paypal list, it shows the transaction.

Am I right then that what likely happened is that the customer went to the Paypal page but never completed the order, thus leaving this transaction on paypal hanging? Is the way I can tell it is an actual order is if I see the transaction listed in the Paypal account listing itself, then I push the order to the store database? In other words, did I add an order that was actually never completed in the paypal payment page?

Please don't expect too much of this add on.

Use it like this

• You receive a payment from paypal but somehow there is no order for it in your shop.

• Login into your paypal account and look at the payment details, you should find a zen_id there.

• Go to the Paypal Session viewer and look for a record with the same id

(to be honest I rarely check the id, but it depends, a.o. on the amount of course)

• Compare more details and/or contact the customer if in doubt

• Complete the order using the pushorder feature if you are convinced that the payment and session viewer record match

Thanks for the instructions. That is kind of what I found out. The shopper had stopped at the Paypal screen and had not completed the purchase, but Paypal generates a session ID. Fortunately the customer came back and completed a purchase later, so I got a chance to see how it works. The key, if I am right, is to wait until you see a transaction complete in Paypal, but you do not see it complete in Zencart. Then do the push. Thanks.

paulm:

A last comment about the readme: it appears that the folder structure has changed in version 2.x, and the readme appears not to be updated at the time to reflect that change.

Try to leave the IP-address definitions empty in both configuration files. Like this:

define('PAYPAL_PUSHORDER_IP', '');

I installed this, but see that the two configure files are different.

**includes/extra_configures/pushorder.php:-**
```php
<?php
/**
 *
 * @copyright Copyright 2003-2008 Zen Cart Development Team
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: pushorder.php,  v 3.02 2008/05/28 paulm
*/
// add a pushorder password (must match the admin pushorder password)
define('PAYPAL_PUSHORDER_PASS', 'my-password-here');
// replace by your admin ip-address (empty string will skip ip-address check)
define('PAYPAL_PUSHORDER_IP', '');
// (un)checks the "send notification emails" checkbox
define('PAYPAL_PUSHORDER_SEND_EMAIL', 'true'); // true / false

// move to language file if desired 
define('PAYPAL_PUSHORDER_COMMENTS', "\n" . '(pushed paypal order)');
?>

admin/includes/extra_configures/pushorder.php:-

<?php
/**
 *
 * @copyright Copyright 2003-2008 Zen Cart Development Team
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: pushorder.php,  v 3.0 2008/05/20 paulm
*/

// add a pushorder password (must match the catalog pushorder password)
define('PAYPAL_PUSHORDER_PASS', 'my-password-here');

?>

... yet you say that the IP address should be left blank in both configure files... There is no provision for IP in the ADMIN's configure file. :huh:

schoolboy:

... yet you say that the IP address should be left blank in both configure files... There is no provision for IP in the ADMIN's configure file.It looks like I mixed up two things :blush:

Both passwords must match. The admin pushorder password is added to the pushorder form and compared to the catalogue password (the pushorder script is on the catalogue side), if they don't match the order won't be "pushed".

The IP setting is catalogue only.

Set passwords, left IP empty, FTP'd into root directory. It seems to work in admin properly, shows up under the customers menu. But when I click "Move to orders database" it loads the new window with a 404 page not found. The pushorder.php is definitely in the right place. I tried changing permissions on the file, but it still wouldn't work.

Any ideas?

Hello Paul,

Thanks for module.

And I think I found some bug:
When press "Move to Orders database", I had error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '000000 where products_id = '3219'' at line 1
in:
update products set products_ordered = products_ordered + 1,000000 where products_id = '3219

and in file includes/classes/order.php
from this

$db->Execute("update " . TABLE_PRODUCTS . " set products_ordered = products_ordered + " . sprintf('%f', $this->products[$i]['qty']) . " where products_id = '" . zen_get_prid($this->products[$i]['id']) . "'");

Changed to this

$db->Execute("update " . TABLE_PRODUCTS . " set products_ordered = products_ordered + " . sprintf('%d', $order->products[$i]['qty']) . " where products_id = '" . zen_get_prid($order->products[$i]['id']) . "'");

And it worked out.

Please, give Your suggestions about it?

Hello Kamoljan,

I think the conversion to INT helps because it removes the comma.

It seems weird that 1000000 apparently becomes 1,000000 somewhere in the code though, but I have no idea where that comes from. It might even be a Zen Cart bug i.s.o. a Pushorder bug. As far as I know Pushorder does not really do anything with the amounts, but I did not write the code so I am not sure (I only updated some parts the code).

Maybe ordering a quantity of >= 1000000 is not possible with Paypal/Zen Cart, and that's why the order was stuck in the first place?

Something to think about: it's possible to order quantities < 1 in Zen Cart (depending on product settings?). And I assume the suggested fix conflicts with that.

razzzor:

when I click "Move to orders database" it loads the new window with a 404 page not found. The pushorder.php is definitely in the right place. I tried changing permissions on the file, but it still wouldn't work.If the url you see is yoursite.com/pushorder.php, and you get a 404 while the file is on the server I guess it's a server problem.