Paypal Sessions Viewer + pushorder

[neilw]

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?

[paulm]

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

[neilw]

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.

[schoolboy]

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
/**
 *
 * @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.

[paulm]

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

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.

[razzzor]

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?

[kamoljan]

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?

[paulm]

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?

[paulm]

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.

[paulm]

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.