Paypal Sessions Viewer + pushorder

[Dizzydog]

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.

[paulm]

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

[pinkchalkstudio]

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.

[paulm]

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 :-(

[pinkchalkstudio]

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!

[wastaboo]

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

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