Forums / General Questions / Odd Problems with one Order Missing and One totaling incorrect.

Odd Problems with one Order Missing and One totaling incorrect.

Views: 863

Results 1 to 11 of 11
12 Mar 2014, 12:57 AM
#1
g2ktcf avatar

g2ktcf

Totally Zenned

Join Date:
Feb 2011
Location:
Lumberton, TX
Posts:
636
Plugin Contributions:
0

Odd Problems with one Order Missing and One totaling incorrect.

Server Information
Server Host: server.radiant-holidays.com (162.144.60.198)       	Database Host: localhost (127.0.0.1)
Server OS: Linux 2.6.32-431.3.1.el6.x86_64    	Database: MySQL 5.5.36-cll
Server Date: 03/11/2014 18:51:40   	Database Date: 03/12/2014 00:51:40
Server Up Time: 00:51:40 up 44 days, 2:29, 0 users, load average: 0.00, 0.15, 0.14 	HTTP Server: Apache
PHP Version: 5.3.26 (Zend: 2.3.0)   PHP Memory Limit: 128M 	PHP Safe Mode: Off
PHP File Uploads: On    Max Size: 50M 	POST Max Size: 10M
Database Data Size: 10,410 kB 	Database Index Size: 2,196 kB

Well, I have a missing order. PP went through fine but I cannot locate the order or the transaction ID in any of the database files (checked back office first and did not find anything) via SQL. I have only an amount, PP transaction ID and the zenID from PP. There are NO order numbers skipped period. How do I go about looking further than looking for the last name in the order tables and the PP Transaction number in the PP tables??

As for the Subtotal and Totals, the amounts listed in the Admin do not match. If you add up the extended amounts, the total is off by over $13? How would I go about looking for this problem??

I did check my PP info in the Payment Module to make sure that has not been hacked.

12 Mar 2014, 7:30 PM
#2
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,110
Plugin Contributions:
56

Re: Odd Problems with one Order Missing and One totaling incorrect.

Which PalPal version?

12 Mar 2014, 8:04 PM
#3
g2ktcf avatar

g2ktcf

Totally Zenned

Join Date:
Feb 2011
Location:
Lumberton, TX
Posts:
636
Plugin Contributions:
0

Re: Odd Problems with one Order Missing and One totaling incorrect.

PP Standard and I do have debug mode active.

The weird issue is that BOTH of these problems are the SAME customer and under two different orders.

12 Mar 2014, 9:28 PM
#4
g2ktcf avatar

g2ktcf

Totally Zenned

Join Date:
Feb 2011
Location:
Lumberton, TX
Posts:
636
Plugin Contributions:
0

Re: Odd Problems with one Order Missing and One totaling incorrect.

ah I have FEC installed here as well.

13 Mar 2014, 11:53 AM
#5
g2ktcf avatar

g2ktcf

Totally Zenned

Join Date:
Feb 2011
Location:
Lumberton, TX
Posts:
636
Plugin Contributions:
0

Re: Odd Problems with one Order Missing and One totaling incorrect.

I was hoping that I could look back through the IPN numbers at PP but I can only go back 28 days :(

I am really worried that I have other problems like this that I am not aware of.

13 Mar 2014, 1:25 PM
#6
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: Odd Problems with one Order Missing and One totaling incorrect.

The usual recommendation for problems like this is to switch to the much-more-reliable Paypal Express.

13 Mar 2014, 1:28 PM
#7
g2ktcf avatar

g2ktcf

Totally Zenned

Join Date:
Feb 2011
Location:
Lumberton, TX
Posts:
636
Plugin Contributions:
0

Re: Odd Problems with one Order Missing and One totaling incorrect.

Thanks for the input...BUT how do I go about finding out what went wrong?

13 Mar 2014, 1:42 PM
#8
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: Odd Problems with one Order Missing and One totaling incorrect.

You probably can't. As I understand it, this error results from a failure in communication between Paypal's server and yours. Express uses a different communication method.

13 Mar 2014, 1:56 PM
#9
g2ktcf avatar

g2ktcf

Totally Zenned

Join Date:
Feb 2011
Location:
Lumberton, TX
Posts:
636
Plugin Contributions:
0

Re: Odd Problems with one Order Missing and One totaling incorrect.

That leaves me with two bad choices...leave it as it is and deal with the possibilites. OR use the new system that my customers complain about since they cannot ship to anywhere but a verified PP address....

Ugh...

13 Mar 2014, 2:03 PM
#10
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: Odd Problems with one Order Missing and One totaling incorrect.

I'm not sure if this is what you're referring to, but there's this in the Paypal Express configuration in admin:

Express Checkout: Require Confirmed Address
Do you want to require that your (not-logged-in) customers use a confirmed address when choosing their shipping address in PayPal?
(this is ignored for logged-in customers)

Yes
No

13 Mar 2014, 2:18 PM
#11
g2ktcf avatar

g2ktcf

Totally Zenned

Join Date:
Feb 2011
Location:
Lumberton, TX
Posts:
636
Plugin Contributions:
0

Re: Odd Problems with one Order Missing and One totaling incorrect.

stevesh:

I'm not sure if this is what you're referring to, but there's this in the Paypal Express configuration in admin:

Express Checkout: Require Confirmed Address
Do you want to require that your (not-logged-in) customers use a confirmed address when choosing their shipping address in PayPal?
(this is ignored for logged-in customers)

Yes
No

Thanks! This is the very first I have heard of this setting!