Paypal Sessions Viewer + pushorder

[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?

[euphoric]

Hi guys, i managed to get this working on my live server (IIS6 + ZC 1.38), but when trying on a local development server ( IIS7 + ZC 1.38) I get the error:

1366 Incorrect decimal value: '' for column 'products_price' at row 1
in:
[INSERT INTO dev_orders_products (orders_id, products_id, products_model, products_name, products_price, final_price, onetime_charges, products_tax, products_quantity, products_priced_by_attribute, product_is_free, products_discount_type, products_discount_type_from, products_prid) VALUES ('22', '183', '', '', '', '0', '0', '0', '1', '', '', '', '', '183:58c0d33b81b1bb9a2143cbe94009071c')]

Any ideas why it doesnt work locally?

[HomicideRocker]

Thank you SO very much. This add-on is exactly what I needed. You are an IPN angel.

[sansan0831]

Thanks a lot... I'm just looking for it. It still works on 1.3.9f.

[dumus]

where can i get this mod?

[wastaboo]

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

where can i get this mod?

[paulm]

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

[neilw]

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.

[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?

[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?