Forums / Built-in Shipping and Payment Modules / PayPal CreditCard Orders Don't Show Up In My Zen Cart

PayPal CreditCard Orders Don't Show Up In My Zen Cart

Locked

Views: 5,639

Results 1 to 20 of 21
This thread is locked. New replies are disabled.
11 Jun 2007, 2:23 AM
#1
rwclark avatar

rwclark

New Zenner

Join Date:
Mar 2007
Posts:
18
Plugin Contributions:
0

PayPal CreditCard Orders Don't Show Up In My Zen Cart

OK. I've scoured the forums for about an hour or two before posting this. I thought I understood what was going on, but apparently not.

I set up Zen Cart with PayPal IPN for a client and some of the PayPal orders weren't getting back to ZenCart so there'd be a PayPal receipt and no record of what the customer ordered.

So I found the May PayPal patch, installed that, and turned on PDT. Thought everything would work now.

But in fact, here's what happens. Auto Return only works if you pay using PayPal. And that seems to be OK. But if you pay using a credit card, there's just a tiny link that says "return to merchant." As I understand things, the PayPal data should go back to Zen Cart whether or not the auto return works. Is this wrong? What can I do to fix this?

I also ran the PayPal IPN test php script and it showed everything was fine (http://www.jameskelleher.com/ipncheck.php).

11 Jun 2007, 2:27 AM
#2
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: PayPal CreditCard Orders Don't Show Up In My Zen Cart

pay with Credit card ( no account ) at paypal means that the user HAS to hit th ereturn link,

there are 2 links there return to merchant or create account,

they HAVE to choose one

Zen cart PCI compliant Hosting

11 Jun 2007, 3:48 AM
#3
rwclark avatar

rwclark

New Zenner

Join Date:
Mar 2007
Posts:
18
Plugin Contributions:
0

Re: PayPal CreditCard Orders Don't Show Up In My Zen Cart

It seems impossible to ensure that every customer will click that link. Is there a way around this? Or is this just a limitation of PayPal IPN? Would another payment module work better?

Ryan

Merlinpa1969:

pay with Credit card ( no account ) at paypal means that the user HAS to hit th ereturn link,

there are 2 links there return to merchant or create account,

they HAVE to choose one

11 Jun 2007, 4:22 AM
#4
rwclark avatar

rwclark

New Zenner

Join Date:
Mar 2007
Posts:
18
Plugin Contributions:
0

Re: PayPal CreditCard Orders Don't Show Up In My Zen Cart

The final PayPal page looks like this...

"Thank You for your payment

Secure Transaction
You have sent a secure payment of $XXX USD to . This payment will appear on your card statement as "PAYPAL *". You will receive an email receipt for this shortly.
View Printable Receipt"

On the bottom left there's a link that says "Return to Merchant" and on the bottom right there's a link that says "Sign Up."

It looks a lot like a final confirmation and a customer could easily just assume everything was done and close the window at this point. That's all I'm saying.

Is there a way to make this process less ambiguous?

rwclark:

It seems impossible to ensure that every customer will click that link. Is there a way around this? Or is this just a limitation of PayPal IPN? Would another payment module work better?

Ryan

11 Jun 2007, 4:32 AM
#5
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: PayPal CreditCard Orders Don't Show Up In My Zen Cart

not on zen carts end, that is all paypal,

Zen cart PCI compliant Hosting

11 Jun 2007, 5:29 AM
#6
rwclark avatar

rwclark

New Zenner

Join Date:
Mar 2007
Posts:
18
Plugin Contributions:
0

Re: PayPal CreditCard Orders Don't Show Up In My Zen Cart

So the PayPal IPN module is functioning correctly, then?

On the Wiki it says that between making the payment and the customer clicking there's some communication between PayPal's server and Zen Cart's. It seems that clicking the "return to merchant" link is the final step?

Thanks so much,
Ryan

Merlinpa1969:

not on zen carts end, that is all paypal,

11 Jun 2007, 7:01 AM
#7
drbyte avatar

drbyte

Sensei

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

Re: PayPal CreditCard Orders Don't Show Up In My Zen Cart

If the customer doesn't click the Return To Merchant link, then you must rely on the IPN notification (instead of PDT) to release your order.

PDT is triggered if the customer comes back to your store directly from PayPal.

IPN is triggered when PayPal authorizes the payment. This is background communications, and doesn't rely on the customer. However, it does rely on your server configuration to talk to paypal's server.
The wiki article talks about potential communication issues:
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.

12 Jun 2007, 12:53 AM
#8
rwclark avatar

rwclark

New Zenner

Join Date:
Mar 2007
Posts:
18
Plugin Contributions:
0

Re: PayPal CreditCard Orders Don't Show Up In My Zen Cart

Thanks. So what this indicates is that PDT is probably working, but IPN is not, correct?

DrByte:

If the customer doesn't click the Return To Merchant link, then you must rely on the IPN notification (instead of PDT) to release your order.

PDT is triggered if the customer comes back to your store directly from PayPal.

IPN is triggered when PayPal authorizes the payment. This is background communications, and doesn't rely on the customer. However, it does rely on your server configuration to talk to paypal's server.
The wiki article talks about potential communication issues:
http://www.zen-cart.com/wiki/index.php/PayPal

13 Jun 2007, 5:41 AM
#9
drbyte avatar

drbyte

Sensei

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

Re: PayPal CreditCard Orders Don't Show Up In My Zen Cart

rwclark:

Thanks. So what this indicates is that PDT is probably working, but IPN is not, correct?

If your customers are paying by CC and not creating or using their PP account, and they're not clicking on the Return To Merchant link at the end of the process, AND you're not getting those orders in your Zen Cart site, then yes, your IPN communications are not working properly.

Troubleshooting IPN issues:
http://www.zen-cart.com/wiki/index.php/PayPal

Enabling Debug Logging for analysis:
http://www.zen-cart.com/forum/showthread.php?t=61199

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

6 Jul 2007, 11:05 PM
#10
rwclark avatar

rwclark

New Zenner

Join Date:
Mar 2007
Posts:
18
Plugin Contributions:
0

Re: PayPal CreditCard Orders Don't Show Up In My Zen Cart

I spoke with the hosting company about the problem I've been having, after pointing them to this info from the Wiki:

  • Check with your host that port 80 and 443 are open for bidirectional communication.
  • Check there is no IP block or firewall to prevent PayPal's™ servers from talking to your server (your host should check this, and you should check any blocking you may have done via your control panel.
  • Check .htaccess for any deny from statements and be sure none of them are addresses related to PayPal™.
    PayPal IP Address List (these should be in your host's firewall whitelist)
    notify.paypal.com (as of June 2006):
    216.113.188.202
    216.113.188.203
    216.113.188.204
    66.211.170.66

They think that the site may need to be on a static IP instead of a shared IP in order for PayPal to properly communicate with Zen Cart, but they're not sure.

Does this sound plausible? Anyone know?

Ryan

DrByte:

If your customers are paying by CC and not creating or using their PP account, and they're not clicking on the Return To Merchant link at the end of the process, AND you're not getting those orders in your Zen Cart site, then yes, your IPN communications are not working properly.

Troubleshooting IPN issues:
http://www.zen-cart.com/wiki/index.php/PayPal

Enabling Debug Logging for analysis:
http://www.zen-cart.com/forum/showthread.php?t=61199

7 Jul 2007, 12:18 AM
#11
rwclark avatar

rwclark

New Zenner

Join Date:
Mar 2007
Posts:
18
Plugin Contributions:
0

Re: PayPal CreditCard Orders Don't Show Up In My Zen Cart

I also turned on debugging. Here is an example log file of an order that went through to PayPal, but didn't get recorded in Zen Cart.


Jun 22 2007 6:45 -- IPN PROCESSING INITIATED.
*** Originating IP: 66.211.170.66 notify.paypal.com

Jun 22 2007 6:45 -- IPN NOTICE :: ipn_application_top -> language files okay

Jun 22 2007 6:45 -- IPN INFO - POST VARS received (sorted):
Array
(
[address_city] => [City]
[address_country] => [Country]
[address_country_code] => IS
[address_name] => [Customer Name]
[address_state] => 0
[address_status] => unconfirmed
[address_street] => [Street Address]
[address_zip] => 0710
[business] => [[email protected]]
[charset] => windows-1252
[custom] => zenid=d1cd0bec404a7f0370e6c64d045a2e4e
[first_name] => [Customer First Name]
[item_name] => [Item Name]
[item_number] => 1
[last_name] => [Customer Last Name]
[mc_currency] => USD
[mc_fee] => 3.75
[mc_gross] => 88.50
[notify_version] => 2.1
[payer_email] => [[email protected]]
[payer_id] => 8EHJTF8J6WX66
[payer_status] => unverified
[payment_date] => 03:27:24 Jun 22, 2007 PDT
[payment_fee] => 3.75
[payment_gross] => 88.50
[payment_status] => Completed
[payment_type] => instant
[quantity] => 1
[receipt_id] => 3340-9942-1742-5526
[receiver_email] => [[email protected]]
[receiver_id] => HPXBBS37S57RQ
[residence_country] => [Country Code]
[shipping] => 0.00
[tax] => 0.00
[txn_id] => 18B86136L1428591T
[txn_type] => web_accept
[verify_sign] => AW4tREiER6Pnf60LxfFW4ljgTTpqAzZvlMbr04H4qaxrig9MJEq72o5T
)

Jun 22 2007 6:45 -- IPN INFO - POST VARS to be sent back for validation:
To: www.paypal.com:80
POST /cgi-bin/webscr HTTP/1.1

Host: https://www.paypal.com

Content-type: application/x-www-form-urlencoded

Content-length: 960

Connection: close

Array
(
[mc_gross] => 88.50
[address_status] => unconfirmed
[payer_id] => 8EHJTF8J6WX66
[tax] => 0.00
[address_street] => [Street Address]
[payment_date] => 03:27:24 Jun 22, 2007 PDT
[payment_status] => Completed
[charset] => windows-1252
[address_zip] => 0710
[first_name] => [Customer First Name]
[mc_fee] => 3.75
[address_country_code] => [Country Code]
[address_name] => [Customer Name]
[notify_version] => 2.1
[custom] => zenid=d1cd0bec404a7f0370e6c64d045a2e4e
[payer_status] => unverified
[business] => [[email protected]]
[address_country] => [Country]
[address_city] => [City]
[quantity] => 1
[verify_sign] => AW4tREiER6Pnf60LxfFW4ljgTTpqAzZvlMbr04H4qaxrig9MJEq72o5T
[payer_email] => [[email protected]]
[txn_id] => 18B86136L1428591T
[payment_type] => instant
[last_name] => [Customer Last Name]
[address_state] => 0
[receiver_email] => [[email protected]]
[payment_fee] => 3.75
[receiver_id] => HPXBBS37S57RQ
[txn_type] => web_accept
[item_name] => [Item Name]
[mc_currency] => USD
[item_number] => 1
[residence_country] => [Country Code]
[receipt_id] => 3340-9942-1742-5526
[payment_gross] => 88.50
[shipping] => 0.00
[cmd] => _notify-validate
)

Jun 22 2007 6:45 -- IPN INFO - Confirmation/Validation response
SUCCESS

Jun 22 2007 6:45 -- Breakpoint: 1

Jun 22 2007 6:45 -- IPN INFO :: Transaction email details.
From IPN = [[email protected]] | [[email protected]]
From CONFIG = [[email protected]]

Jun 22 2007 6:45 -- Breakpoint: 2

Jun 22 2007 6:45 -- Breakpoint: 3

Jun 22 2007 6:45 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

Jun 22 2007 6:45 -- Breakpoint: 4 txn_type=unique ordersID = 0 IPN_id=0

Jun 22 2007 6:45 -- IPN DEBUG::uniqueness-test. Relevant data from POST:
txn_type = unique
parent_txn_id =
txn_id = 18B86136L1428591T

Jun 22 2007 6:45 -- IPN NOTICE::Set transaction type = unique
POST data:
mc_gross=88.50
&address_status=unconfirmed
&payer_id=8EHJTF8J6WX66
&tax=0.00
&address_street=[Street Address]
&payment_date=03:27:24 Jun 22, 2007 PDT
&payment_status=Completed
&charset=windows-1252
&address_zip=0710
&first_name=[Customer First Name]
&mc_fee=3.75
&address_country_code=[Country Code]
&address_name=[Customer Name]
&notify_version=2.1
&custom=zenid=d1cd0bec404a7f0370e6c64d045a2e4e
&payer_status=unverified
&business=[[email protected]]
&address_country=[Country]
&address_city=[City]
&quantity=1
&verify_sign=AW4tREiER6Pnf60LxfFW4ljgTTpqAzZvlMbr04H4qaxrig9MJEq72o5T
&payer_email=[[email protected]]
&txn_id=18B86136L1428591T
&payment_type=instant
&last_name=[Customer Last Name]
&address_state=0
&receiver_email=[[email protected]]
&payment_fee=3.75
&receiver_id=HPXBBS37S57RQ
&txn_type=web_accept
&item_name=[Item Name]
&mc_currency=USD
&item_number=1
&residence_country=[Country Code]
&receipt_id=3340-9942-1742-5526
&payment_gross=88.50
&shipping=0.00
&

Jun 22 2007 6:45 -- Breakpoint: 5 txn_type=unique

Jun 22 2007 6:45 -- IPN WARNING :: Currency/Amount Mismatch. Details:
PayPal email address = [[email protected]]
| mc_currency = USD
| submitted_currency = USD
| order_currency = 88.5
| mc_gross = 88.50
| converted_amount = 8.00
| order_amount = 8

VERIFIED

0

11 Jul 2007, 3:43 AM
#12
rwclark avatar

rwclark

New Zenner

Join Date:
Mar 2007
Posts:
18
Plugin Contributions:
0

Re: PayPal CreditCard Orders Don't Show Up In My Zen Cart

Does anyone know?

Can anyone direct me to an experienced Zen developer who I could hire to fix this?

11 Jul 2007, 4:58 AM
#13
drbyte avatar

drbyte

Sensei

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

Re: PayPal CreditCard Orders Don't Show Up In My Zen Cart

Your problem is here:> rwclark:

Jun 22 2007 6:45 -- IPN WARNING :: Currency/Amount Mismatch. Details:
PayPal email address = [[email protected]]
| mc_currency = USD
| submitted_currency = USD
| order_currency = 88.5
| mc_gross = 88.50
| converted_amount = 8.00
| order_amount = 8

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

11 Jul 2007, 4:59 AM
#14
drbyte avatar

drbyte

Sensei

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

Re: PayPal CreditCard Orders Don't Show Up In My Zen Cart

rwclark:

They think that the site may need to be on a static IP instead of a shared IP in order for PayPal to properly communicate with Zen Cart, but they're not sure.No, the PayPal system does not require the use of a static IP.

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

11 Jul 2007, 5:01 AM
#15
drbyte avatar

drbyte

Sensei

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

Re: PayPal CreditCard Orders Don't Show Up In My Zen Cart

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

14 Jul 2007, 9:17 PM
#16
rwclark avatar

rwclark

New Zenner

Join Date:
Mar 2007
Posts:
18
Plugin Contributions:
0

Re: PayPal CreditCard Orders Don't Show Up In My Zen Cart

Thanks, but it's still not clear to me exactly what the problem is. Something about a currency mismatch?? What would be causing this, especially since some of these are coming from US orders. There should be no currency conversion going on.

Here's another log from a customer in the US..

Jul 13 2007 14:57 -- IPN PROCESSING INITIATED.
*** Originating IP: 66.211.170.66 notify.paypal.com

Jul 13 2007 14:57 -- IPN NOTICE :: ipn_application_top -> language files okay

Jul 13 2007 14:57 -- IPN INFO - POST VARS received (sorted):
Array
(
[address_city] => Sacramento
[address_country] => United States
[address_country_code] => US
[address_name] => [Customer Name]
[address_state] => CA
[address_status] => confirmed
[address_street] => [Customer Address]
[address_zip] => 95825
[business] => [[email protected]]
[charset] => windows-1252
[custom] => zenid=bf031aea5d7a55978bfc2eaff2b6a622
[first_name] => [Name]
[item_name] => [Item]
[item_number] => 1
[last_name] => [LastName]
[mc_currency] => USD
[mc_fee] => 0.91
[mc_gross] => 21.14
[notify_version] => 2.4
[payer_email] => [[email protected]]
[payer_id] => XHM2UZEKDWCT4
[payer_status] => unverified
[payment_date] => 11:42:21 Jul 13, 2007 PDT
[payment_fee] => 0.91
[payment_gross] => 21.14
[payment_status] => Completed
[payment_type] => instant
[quantity] => 1
[receipt_id] => 3075-7464-7166-7479
[receiver_email] => [[email protected]]
[receiver_id] => HPXBBS37S57RQ
[residence_country] => US
[shipping] => 0.00
[tax] => 0.00
[txn_id] => 85B94401H3889551W
[txn_type] => web_accept
[verify_sign] => An5ns1Kso7MWUdW4ErQKJJJ4qi4-A46ajse3lXOVIPpxGwrrOfWx2gH4
)

Jul 13 2007 14:57 -- IPN INFO - POST VARS to be sent back for validation:
To: www.paypal.com:80
POST /cgi-bin/webscr HTTP/1.1
Host: https://www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 973
Connection: close

Array
(
[mc_gross] => 21.14
[address_status] => confirmed
[payer_id] => XHM2UZEKDWCT4
[tax] => 0.00
[address_street] => [Customer Address]
[payment_date] => 11:42:21 Jul 13, 2007 PDT
[payment_status] => Completed
[charset] => windows-1252
[address_zip] => 95825
[first_name] => [Name]
[mc_fee] => 0.91
[address_country_code] => US
[address_name] => [Customer Name]
[notify_version] => 2.4
[custom] => zenid=bf031aea5d7a55978bfc2eaff2b6a622
[payer_status] => unverified
[business] => [[email protected]]
[address_country] => United States
[address_city] => Sacramento
[quantity] => 1
[verify_sign] => An5ns1Kso7MWUdW4ErQKJJJ4qi4-A46ajse3lXOVIPpxGwrrOfWx2gH4
[payer_email] => [[email protected]]
[txn_id] => 85B94401H3889551W
[payment_type] => instant
[last_name] => [LastName]
[address_state] => CA
[receiver_email] => [[email protected]]
[payment_fee] => 0.91
[receiver_id] => HPXBBS37S57RQ
[txn_type] => web_accept
[item_name] => [Item]
[mc_currency] => USD
[item_number] => 1
[residence_country] => US
[receipt_id] => 3075-7464-7166-7479
[payment_gross] => 21.14
[shipping] => 0.00
[cmd] => _notify-validate
)

Jul 13 2007 14:57 -- IPN INFO - Confirmation/Validation response
SUCCESS

Jul 13 2007 14:57 -- Breakpoint: 1

Jul 13 2007 14:57 -- IPN INFO :: Transaction email details.
From IPN = [[email protected]] | [[email protected]]
From CONFIG = [[email protected]]

Jul 13 2007 14:57 -- Breakpoint: 2

Jul 13 2007 14:57 -- Breakpoint: 3

Jul 13 2007 14:57 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

Jul 13 2007 14:57 -- Breakpoint: 4 txn_type=unique ordersID = 0 IPN_id=0

Jul 13 2007 14:57 -- IPN DEBUG::uniqueness-test. Relevant data from POST:
txn_type = unique
parent_txn_id =
txn_id = 85B94401H3889551W

Jul 13 2007 14:57 -- IPN NOTICE::Set transaction type = unique
POST data:
mc_gross=21.14
&address_status=confirmed
&payer_id=XHM2UZEKDWCT4
&tax=0.00
&address_street=[Customer Address]
&payment_date=11:42:21 Jul 13, 2007 PDT
&payment_status=Completed
&charset=windows-1252
&address_zip=95825
&first_name=[Name]
&mc_fee=0.91
&address_country_code=US
&address_name=[Customer Name]
&notify_version=2.4
&custom=zenid=bf031aea5d7a55978bfc2eaff2b6a622
&payer_status=unverified
&business=[[email protected]]
&address_country=United States
&address_city=Sacramento
&quantity=1
&verify_sign=An5ns1Kso7MWUdW4ErQKJJJ4qi4-A46ajse3lXOVIPpxGwrrOfWx2gH4
&payer_email=[[email protected]]
&txn_id=85B94401H3889551W
&payment_type=instant
&last_name=[LastName]
&address_state=CA
&receiver_email=[[email protected]]
&payment_fee=0.91
&receiver_id=HPXBBS37S57RQ
&txn_type=web_accept
&item_name=[Item]
&mc_currency=USD
&item_number=1
&residence_country=US
&receipt_id=3075-7464-7166-7479
&payment_gross=21.14
&shipping=0.00
&

Jul 13 2007 14:57 -- Breakpoint: 5 txn_type=unique

Jul 13 2007 14:57 -- IPN WARNING :: Currency/Amount Mismatch. Details:
PayPal email address = [[email protected]]
| mc_currency = USD
| submitted_currency = USD
| order_currency = 21.14
| mc_gross = 21.14
| converted_amount = 8.00
| order_amount = 8
VERIFIED
0

14 Jul 2007, 9:23 PM
#17
rwclark avatar

rwclark

New Zenner

Join Date:
Mar 2007
Posts:
18
Plugin Contributions:
0

Re: PayPal CreditCard Orders Don't Show Up In My Zen Cart

Here's another one...I'd really appreciate it if someone could give me some pointers.

This one seems a little different with the "could not find stored session in DB, cannot re-create session as PayPal IPN transaction" message.

========

Jul 11 2007 20:40 -- IPN PROCESSING INITIATED.
*** Originating IP: 66.211.170.66 notify.paypal.com

Jul 11 2007 20:40 -- IPN FATAL ERROR :: Could not find stored session in DB, cannot re-create session as PayPal IPN transaction.

Jul 11 2007 20:40 -- IPN FATAL ERROR :: No saved session data available to build order from IPN. Cannot process this as an IPN-only transaction.

Jul 11 2007 20:40 -- IPN NOTICE :: ipn_application_top -> language files okay

Jul 11 2007 20:40 -- IPN INFO - POST VARS received (sorted):
Array
(
[address_city] => Salt Lake City
[address_country] => United States
[address_country_code] => US
[address_name] => [Customer Name]
[address_state] => UT
[address_status] => unconfirmed
[address_street] => [Address]
[address_zip] => 84101
[business] => [[email protected]]
[charset] => windows-1252
[custom] =>
[first_name] => [Name]
[item_name1] => [Item]
[item_number1] =>
[last_name] => [Name]
[mc_currency] => USD
[mc_fee] => 2.50
[mc_gross] => 76.00
[mc_gross_1] => 76.00
[mc_handling] => 0.00
[mc_handling1] => 0.00
[mc_shipping] => 0.00
[mc_shipping1] => 0.00
[notify_version] => 2.4
[num_cart_items] => 1
[payer_email] => [[email protected]]
[payer_id] => AAJNDG2NA84SJ
[payer_status] => verified
[payment_date] => 17:25:33 Jul 11, 2007 PDT
[payment_fee] => 2.50
[payment_gross] => 76.00
[payment_status] => Completed
[payment_type] => instant
[quantity1] => 1
[receiver_email] => [[email protected]]
[receiver_id] => HPXBBS37S57RQ
[residence_country] => US
[tax] => 0.00
[txn_id] => 6XN66183CW906684A
[txn_type] => cart
[verify_sign] => A0asK6oiIZmtBFrRCq-Iiqf8lrk.Azox3aVvUOjwQO1Xt1acxI8f0won
)

Jul 11 2007 20:40 -- IPN INFO - POST VARS to be sent back for validation:
To: www.paypal.com:80
POST /cgi-bin/webscr HTTP/1.1
Host: https://www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 975
Connection: close

Array
(
[mc_gross] => 76.00
[address_status] => unconfirmed
[item_number1] =>
[payer_id] => AAJNDG2NA84SJ
[tax] => 0.00
[address_street] => [Address]
[payment_date] => 17:25:33 Jul 11, 2007 PDT
[payment_status] => Completed
[charset] => windows-1252
[address_zip] => 84101
[mc_shipping] => 0.00
[mc_handling] => 0.00
[first_name] => [Name]
[mc_fee] => 2.50
[address_country_code] => US
[address_name] => [Customer Name]
[notify_version] => 2.4
[custom] =>
[payer_status] => verified
[business] => [[email protected]]
[address_country] => United States
[num_cart_items] => 1
[mc_handling1] => 0.00
[address_city] => Salt Lake City
[verify_sign] => A0asK6oiIZmtBFrRCq-Iiqf8lrk.Azox3aVvUOjwQO1Xt1acxI8f0won
[payer_email] => [[email protected]]
[mc_shipping1] => 0.00
[txn_id] => 6XN66183CW906684A
[payment_type] => instant
[last_name] => [Name]
[address_state] => UT
[item_name1] => [Item]
[receiver_email] => [[email protected]]
[payment_fee] => 2.50
[quantity1] => 1
[receiver_id] => HPXBBS37S57RQ
[txn_type] => cart
[mc_gross_1] => 76.00
[mc_currency] => USD
[residence_country] => US
[payment_gross] => 76.00
[cmd] => _notify-validate
)

Jul 11 2007 20:40 -- IPN INFO - Confirmation/Validation response
SUCCESS

Jul 11 2007 20:40 -- Breakpoint: 1

Jul 11 2007 20:40 -- IPN INFO :: Transaction email details.
From IPN = [[email protected]] | [[email protected]]
From CONFIG = [[email protected]]

Jul 11 2007 20:40 -- Breakpoint: 2

Jul 11 2007 20:40 -- Breakpoint: 3

Jul 11 2007 20:40 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

Jul 11 2007 20:40 -- Breakpoint: 4 txn_type=unique ordersID = 0 IPN_id=0

Jul 11 2007 20:40 -- IPN DEBUG::uniqueness-test. Relevant data from POST:
txn_type = unique
parent_txn_id =
txn_id = 6XN66183CW906684A

Jul 11 2007 20:40 -- IPN NOTICE::Set transaction type = cart
POST data:
mc_gross=76.00
&address_status=unconfirmed
&item_number1=
&payer_id=AAJNDG2NA84SJ
&tax=0.00
&address_street=[Address]
&payment_date=17:25:33 Jul 11, 2007 PDT
&payment_status=Completed
&charset=windows-1252
&address_zip=84101
&mc_shipping=0.00
&mc_handling=0.00
&first_name=[Name]
&mc_fee=2.50
&address_country_code=US
&address_name=[Customer Name]
&notify_version=2.4
&custom=
&payer_status=verified
&business=[[email protected]]
&address_country=United States
&num_cart_items=1
&mc_handling1=0.00
&address_city=Salt Lake City
&verify_sign=A0asK6oiIZmtBFrRCq-Iiqf8lrk.Azox3aVvUOjwQO1Xt1acxI8f0won
&payer_email=[[email protected]]
&mc_shipping1=0.00
&txn_id=6XN66183CW906684A
&payment_type=instant
&last_name=[Name]
&address_state=UT
&item_name1=[Item]
&receiver_email=[[email protected]]
&payment_fee=2.50
&quantity1=1
&receiver_id=HPXBBS37S57RQ
&txn_type=cart
&mc_gross_1=76.00
&mc_currency=USD
&residence_country=US
&payment_gross=76.00
&

Jul 11 2007 20:40 -- Breakpoint: 5 txn_type=cart

Jul 11 2007 20:40 -- IPN NOTICE::Express Checkout payment notice on completed order -- IPN Ignored

15 Jul 2007, 12:37 AM
#18
drbyte avatar

drbyte

Sensei

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

Re: PayPal CreditCard Orders Don't Show Up In My Zen Cart

rwclark:

Thanks, but it's still not clear to me exactly what the problem is. Something about a currency mismatch?? What would be causing this, especially since some of these are coming from US orders.

...
Jul 13 2007 14:57 -- IPN WARNING :: Currency/Amount Mismatch. Details:
PayPal email address = [[email protected]]
| mc_currency = USD
| submitted_currency = USD
| order_currency = 21.14
| mc_gross = 21.14
| converted_amount = 8.00
| order_amount = 8
VERIFIED
0

You're right ... there should be no conversion happening.
But, the validation process is discovering that the parameters it's receiving from the IPN notification received from PayPal, compared vs the stored order in Zen Cart ... don't match properly.

More specifically it looks like you might have mismatched versions of code on your site. Did you install a PayPal patch but miss a file?

This particular log appears to have come from a PayPal IPN module transaction.

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

15 Jul 2007, 12:41 AM
#19
drbyte avatar

drbyte

Sensei

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

Re: PayPal CreditCard Orders Don't Show Up In My Zen Cart

rwclark:

Here's another one...I'd really appreciate it if someone could give me some pointers.

This one seems a little different with the "could not find stored session in DB, cannot re-create session as PayPal IPN transaction" message.

========

Jul 11 2007 20:40 -- IPN PROCESSING INITIATED.
*** Originating IP: 66.211.170.66 notify.paypal.com

Jul 11 2007 20:40 -- IPN FATAL ERROR :: Could not find stored session in DB, cannot re-create session as PayPal IPN transaction.

Jul 11 2007 20:40 -- IPN FATAL ERROR :: No saved session data available to build order from IPN. Cannot process this as an IPN-only transaction.

...

Jul 11 2007 20:40 -- IPN NOTICE::Express Checkout payment notice on completed order -- IPN Ignored

That's an Express Checkout notification. Since Express Checkout already inserts orders directly into the database, the IPN notification from PayPal is ignored.

The "could not find stored session" and "no saved session data" alerts indicate that the IPN-processing module cannot find any PayPal IPN payment-module data for this order (because that module wasn't used to create this notification). It's a status message. Perhaps it shouldn't be called a "fatal error" anymore. Don't get hung up on those alerts. The fact that the log is from and Express Checkout transaction is enough to nullify those messages.

You do not seem to have any problem with Express Checkout transactions. Only IPN transactions.

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

15 Jul 2007, 4:19 AM
#20
rwclark avatar

rwclark

New Zenner

Join Date:
Mar 2007
Posts:
18
Plugin Contributions:
0

Re: PayPal CreditCard Orders Don't Show Up In My Zen Cart

The weird thing is the Express module isn't even enabled (the site only uses IPN). But I went in and installed the latest patch and I think things might be working correctly now. I had installed the patch from May, but this most recent one might have done the trick. Thank you.