Forums / General Questions / PayPal received but no order in system

PayPal received but no order in system

Locked

Views: 10,719

Results 1 to 20 of 64
This thread is locked. New replies are disabled.
26 Feb 2007, 4:47 PM
#1
martinr avatar

martinr

New Zenner

Join Date:
Jul 2006
Posts:
18
Plugin Contributions:
0

PayPal received but no order in system

I have upgraded to 1.37; uninstalled and re-installed PayPal modules; installed the patch; disabled PayPal express until I am sure that it will work, so thi sis an IPN question.

I occasionally receive payments without a corresponding order. I believe that this happens whe a customer fails to close out the paypal screen. The "abandoned cart" tool finds nothing.

Any way to find the order, or recover it? Is it in a cookie in my customer's computer?

26 Feb 2007, 9:08 PM
#2
paperthreads avatar

paperthreads

Zen Follower

Join Date:
Sep 2006
Posts:
142
Plugin Contributions:
0

Re: PayPal received but no order in system

I am having the same problem, but this is only happening when people are paying via payal using the ECheck feature. The order just disappears, there isn't even an order number assigned, becuase the next order that comes through will have the next available order number....

This has only been happening since I upgraded to the newest version 2 weeks ago.

Problem is, i am having to email each customer, and ask them what they paid for, and for a shipping address, so that I can mail their product to them! It also messes up my reports, becuase those orders are MISSING from the reports!

26 Feb 2007, 9:37 PM
#3
martinr avatar

martinr

New Zenner

Join Date:
Jul 2006
Posts:
18
Plugin Contributions:
0

Re: PayPal received but no order in system

I believe that mine are also related to e-checks. And that it is also related to the upgrade. I poked through the SQL databases and have nothing at all about the orders.

I could turn Express back on again, but my last attemopt to use that was somewhat problematic.

26 Feb 2007, 9:52 PM
#4
paperthreads avatar

paperthreads

Zen Follower

Join Date:
Sep 2006
Posts:
142
Plugin Contributions:
0

Re: PayPal received but no order in system

Well, in my opinion, it is related to the upgrade, as I never had a problem before this, and I process an average of 150 orders a month.

I haven't set up Paypal express yet (though I'm off to do that now, in hopes to make it easier for customers!)

BUT, what I just did today, to see if it resolves the issue is I went into my paypal account and I set it up so that it AUTO-matically redirects the customer back to the store out of paypal screens. Lets hope that is where the problem is being incurred, and it will now be resolved!
(Crossing fingers!)

1 Mar 2007, 2:22 AM
#5
webmiss avatar

webmiss

Zen Follower

Join Date:
Feb 2006
Posts:
147
Plugin Contributions:
0

Re: PayPal received but no order in system

Hi,

I'm having a similar problem. We had 8 orders today which processed with no problem. Now several people have ordered and it is not showing up in the database, no confirmation emails are going out, nothing is showing up in individual account order histories. I just tried to go through the same ordering process the customers go through and my order too is not showing up. How do I fix this? I have to get this fixed asap. I'm using Zen Cart 1.3.0.2

webmiss

1 Mar 2007, 6:01 AM
#7
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: PayPal received but no order in system

There is a known problem with echecks in v1.3.7. We're working on it. No ETA.

For sites running older than v1.3.7, check to be sure nothing's blocking the IPN notifications from reaching your site:
http://www.zen-cart.com/wiki/index.php/PayPal

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

1 Mar 2007, 2:04 PM
#8
martinr avatar

martinr

New Zenner

Join Date:
Jul 2006
Posts:
18
Plugin Contributions:
0

Re: PayPal received but no order in system

Thanks, so we aren't going nuts here.

I downloaded and installed the PayPal sessions viewer, it works with 1.3.7 and has the cart information in it. It is a bit of work to extract the order details, but it at least means that I can ship.

3 Mar 2007, 8:16 PM
#9
s_mack avatar

s_mack

Totally Zenned

Join Date:
Jun 2005
Location:
Kelowna, BC Canada
Posts:
1,033
Plugin Contributions:
4

Re: PayPal received but no order in system

I don't think its necessarily an eCheck problem, and I'm pretty certain its not a "I upgraded to 1.3.7 and..." problem. Its a PayPal issue.

How do I know? well, I don't... but like many of you, I'm starting to have this problem sporatically in the last week or so. Unlike some of you (I presume) I upgraded to 1.3.7 the day it came out... and never had an issue until very recently.

Twice it was eChecks... so I thought that was the problem... but just this morning it happened again but with a normal PayPal payment.

A tip for Paperthreads and others worried about accounting/reports. Its simpler to fix than you think. Yes, you have to ask the customer what they ordered... but you don't need to ask them how much they paid or what taxes/shipping charges were there. Just find out what they ordered, then log in to your own store using their account (see Encrypted Master Password contrib) and place the order yourself. The taxes/shipping should be exactly what they saw. Instead of choosing PayPal, of course, choose some manual method (cheque/money order). Then go into the admin and change the order form Pending to Processing since you do have the payment.

Ok, its not ideal... but at least you don't have to ask them a million questions and, more importantly, the order is still on the books.

Hope that helps.

  • Steven
3 Mar 2007, 8:31 PM
#10
martinr avatar

martinr

New Zenner

Join Date:
Jul 2006
Posts:
18
Plugin Contributions:
0

Re: PayPal received but no order in system

Unfortunately, it had to happen with about 30 items in the basket. The payPal sessions viewer did show me what the order was.

I upgraded to 1.37 and PayPal Express just in time to catch the PayPal blank/null bug, then dropped back to IPN to get caught with this.

I switched back to Express, seems to be OK right now.

4 Mar 2007, 6:46 AM
#11
tj1 avatar

tj1

Totally Zenned

Join Date:
Mar 2005
Location:
California
Posts:
628
Plugin Contributions:
0

Re: PayPal received but no order in system

Hi, I've been using ZC and the IPN module for over a year without a single problem. Just got my first paypal payment with no order today.

I found this thread http://www.zen-cart.com/forum/showthread.php?t=32302 in the archived section that has a mod for recovering such orders.

Has anyone tried it, do you know if works with ZC 1.3.7?
It seems like it hasn't been updated in a long time.

4 Mar 2007, 9:44 AM
#12
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: PayPal received but no order in system

IPN vs echeck in v1.3.7 is addressed in today's patch:
http://www.zen-cart.com/forum/showthread.php?p=338031#post338031

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

4 Mar 2007, 12:42 PM
#13
zb21hay avatar

zb21hay

New Zenner

Join Date:
Jan 2006
Posts:
21
Plugin Contributions:
0

Re: PayPal received but no order in system

I've been foollowing this problem for some time, as I had the same issue. I have my site working 90% with paypal, the only remaining issue is with payments that are waiting to be accepted. Occasionally paypal holds up a payment with an unconfirmed address or new account and waits for you to accept or deny. These are the only orders that are getting hung up on our system.
Z

8 Mar 2007, 11:16 PM
#14
tj1 avatar

tj1

Totally Zenned

Join Date:
Mar 2005
Location:
California
Posts:
628
Plugin Contributions:
0

Re: PayPal received but no order in system

Just received my second paypal payment with no corresponding order.

I've been using ZC since version 1.2.3 and never had this issue until upgrading from 1.3.0.2 to 1.3.7 a few days ago.

Not sure if this is a problem with ZC. If I go to Customers>PayPal IPN, the payments show up there, so PayPal is sending back the notifications, but for some reason ZC is not completing and assigning an order.

These payments under Customers>PayPal IPN have an Order # of 0

Anyone knows why this could be happening?

Thanks for any input on this.

8 Mar 2007, 11:23 PM
#15
paperthreads avatar

paperthreads

Zen Follower

Join Date:
Sep 2006
Posts:
142
Plugin Contributions:
0

Re: PayPal received but no order in system

There is a patch to this, read up 2 or 3 messages in this thread, and you will find a link for it.

I installed the patch about 3 days ago, and so far so good :)

8 Mar 2007, 11:47 PM
#16
tj1 avatar

tj1

Totally Zenned

Join Date:
Mar 2005
Location:
California
Posts:
628
Plugin Contributions:
0

Re: PayPal received but no order in system

I also applied that patch as soon as it was released, but just now I received this paypal payment with no order showing up in the orders area.

9 Mar 2007, 4:37 PM
#17
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: PayPal received but no order in system

tj1:

I also applied that patch as soon as it was released, but just now I received this paypal payment with no order showing up in the orders area.

  1. Which date of the patch did you apply?
  2. Do you have Debug Logging turned on in the module? If not turn it on and try a test transaction.
    You need to be sure that the /includes/modules/payment/paypal/logs folder is writable (chmod 777)
    If you do have it already on, please go to that folder and grab the log files, zip them, and post them here for review.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

9 Mar 2007, 5:59 PM
#18
tj1 avatar

tj1

Totally Zenned

Join Date:
Mar 2005
Location:
California
Posts:
628
Plugin Contributions:
0

Re: PayPal received but no order in system

The date of the patch is March 3rd.
I don't have debug logging turned on, I will turn it on now and do a test transaction now.

9 Mar 2007, 11:00 PM
#19
tj1 avatar

tj1

Totally Zenned

Join Date:
Mar 2005
Location:
California
Posts:
628
Plugin Contributions:
0

Re: PayPal received but no order in system

OK, I turned on Debug Logging and have made some test orders.

After placing several test orders I can confirm this only happens when using an existing paypal account and not returning to the cart after making the payment on paypal. I can also confirm this never happened on the previous version of ZC I used 1.3.0.2, this has only happened since I upgraded to 1.3.7.

I hate to admit it, but this time it is not paypal's fault.

BTW, if the payment is made not using a paypal account, choosing the 'Don't have a paypal account option' this problem doesn't occur. ZC shows the order under Customers>Orders as soon as the payment is made regardless of whether or not the customer returns to ZC.

This is what should be addressed in ZC. ZC should record and show the order as soon as the payment is made regardless of whether the customer returns to the cart or not, this is the way it worked in 1.3.0.2 and never had this issue.

I have the logs available for all this orders, do you want me to post them?

9 Mar 2007, 11:11 PM
#20
tj1 avatar

tj1

Totally Zenned

Join Date:
Mar 2005
Location:
California
Posts:
628
Plugin Contributions:
0

Re: PayPal received but no order in system

OK, something else I forgot to mention and seems like a serious issue. Anyone that gets an stuck order should get the PayPal_Session_Viewer_v2.0 and push the stuck order to the orders database ASAP.

http://shoetick.com/PayPal_Session_Viewer_v2.0.zip

If the stuck order is not moved, any future orders by that customer will have the same content as the original stuck order, regardless of what the customer orders. You need to move all stuck orders to avoid getting future corrupted orders with the different contents and total of what the customer ordered.