PayPal/Nochex Payment Problems

[ccn1]

Hi All

I have been visiting this problem on and off for a month now and still cannot seem to crack the problem.

The problem I am having is when a customer pays via PayPal or Nochex, the payment is deposited into the relevant account, but no order transaction is posted to Zen Cart. Admin or customer order history etc.

I noticed, Paying by "Money Order" or "Cash on Delivery" works fine so Im thinking it must be something to do with the payment gateways, authority maybe.

Site details as follows:

Zen Cart 1.3.8a
DB Patch Level 1.3.8
- Fresh Installation Method

CURL Support - Enabled

I have visited PayPal links and double checked settings.

I have double checked the NOCHEX settings (which is only a "Sellers" account at the moment)

After running the tools in the extra's folder I get mixed results:

Curl appears ok, but the paypal and nochex IPN_RETURN files dont appear to provide any information at all.

Any help would be much appreciated as it would be nice to get a friends website up intime for Christmas.

URL of site in question: www.mytimepiece.co.uk



Many thanks in advance.

Chris

[DrByte]

The problem I am having is when a customer pays via PayPal or Nochex, the payment is deposited into the relevant account, but no order transaction is posted to Zen Cart. Admin or customer order history etc.

I noticed, Paying by "Money Order" or "Cash on Delivery" works fine so Im thinking it must be something to do with the payment gateways, authority maybe.

Those are classic symptoms of the PayPal (or other gateway) server being unable to talk to your store to report a completed payment and activate the order.

PayPal troubleshooting: http://www.zen-cart.com/wiki/index.php/PayPal

[ccn1]

Hi DrByte and thankyou for your reply,

Yes Ive read that section a few times now, and then again just now.

I also noticed that when I return to the shop after payment has been made, it brings up the last order (which I made using pay via money order) and not the the correct one.

If your not too tired I haved pasted the log files from the transaction if it makes any sense.....

File 1)

Dec 09 2008 11:36 -- Keys for submission: Array
(
[charset] => iso-8859-1
[lc] => GB
[page_style] => Primary
[custom] => zenid=6e6e4e20c868d81f07136a9eaabfbadf
[business] => sales@*****.co.uk
[return] => http://www.****.co.uk/index.php?main...referer=paypal
[cancel_return] => http://www.****.co.uk/index.php?main...eckout_payment
[shopping_url] => http://www.****.co.uk/index.php?main_page=shopping_cart
[notify_url] => http://www.****.co.uk/ipn_main_handler.php
[redirect_cmd] => _xclick
[rm] => 2
[bn] => zencart
[mrb] => R-6C7952342H795591R
[pal] => 9E82WJBKKGPLQ
[first_name] => ****
[last_name] => ****
[address1] => *****House
[city] => *****
[state] => 0
[zip] => rm16 *****
[country] => GB
[email] => chris.*****.com
[address2] => 3 ********* Dock
[H_PhoneNumber] => *****
[night_phone_b] => ******
[day_phone_b] => ********
[no_shipping] => 1
[upload] => 1
[currency_code] => GBP
[cmd] => _ext-enter
[item_name] => My *******Purchase
[item_number] => Store Receipt
[amount] => 1.70
[shipping] => 0.00
[tax] => 0.00
[tax_cart] => 0.00
)




File 2)


Dec 09 2008 11:39 -- IPN PROCESSING INITIATED.
*** Originating IP: 66.211.170.66 notify.paypal.com

Dec 09 2008 11:39 -- IPN INFO - POST VARS received (sorted):
Array
(
[business] => sales@*****.co.uk
[charset] => windows-1252
[custom] => zenid=6e6e4e20c868d81f07136a9eaabfbadf
[first_name] ********
[handling_amount] => 0.00
[item_name] => My ******* Purchase
[item_number] => Store Receipt
[last_name] => ********
[mc_currency] => GBP
[mc_fee] => 0.26
[mc_gross] => 1.70
[notify_version] => 2.6
[payer_email] => chris.**********.com
[payer_id] => MWQSE7GFQHWZN
[payer_status] => unverified
[payment_date] => 03:39:11 Dec 09, 2008 PST
[payment_fee] =>
[payment_gross] =>
[payment_status] => Completed
[payment_type] => instant
[protection_eligibility] => Ineligible
[quantity] => 1
[receipt_id] => 4121-7421-2597-0460
[receiver_email] => sales@********.co.uk
[receiver_id] => MXGKJDF4BPBRY
[residence_country] => GB
[shipping] => 0.00
[tax] => 0.00
[transaction_subject] => zenid=6e6e4e20c868d81f07136a9eaabfbadf
[txn_id] => 8YK283397F687561D
[txn_type] => web_accept
[verify_sign] => AiPC9BjkCyDFQXbSkoZcgqH3hpacAcRF.dvVotuzfMeeaWcf0S5nYRF6
)


Dec 09 2008 11:39 -- IPN INFO - POST VARS to be sent back for validation:
To: www.paypal.com:80
POST /cgi-bin/webscr HTTP/1.1
Host: www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 870
Connection: close

Array
(
[mc_gross] => 1.70
[protection_eligibility] => Ineligible
[payer_id] => MWQSE7GFQHWZN
[tax] => 0.00
[payment_date] => 03:39:11 Dec 09, 2008 PST
[payment_status] => Completed
[charset] => windows-1252
[first_name] => ********
[mc_fee] => 0.26
[notify_version] => 2.6
[custom] => zenid=6e6e4e20c868d81f07136a9eaabfbadf
[payer_status] => unverified
[business] => sales@*******.co.uk
[quantity] => 1
[verify_sign] => AiPC9BjkCyDFQXbSkoZcgqH3hpacAcRF.dvVotuzfMeeaWcf0S5nYRF6
[payer_email] => chris.**********.com
[txn_id] => 8YK283397F687561D
[payment_type] => instant
[last_name] => *********
[receiver_email] => sales@**********.co.uk
[payment_fee] =>
[receiver_id] => MXGKJDF4BPBRY
[txn_type] => web_accept
[item_name] => My ********Purchase
[mc_currency] => GBP
[item_number] => Store Receipt
[residence_country] => GB
[receipt_id] => 4121-7421-2597-0460
[handling_amount] => 0.00
[transaction_subject] => zenid=6e6e4e20c868d81f07136a9eaabfbadf
[payment_gross] =>
[shipping] => 0.00
[cmd] => _notify-validate
)


Dec 09 2008 11:39 -- IPN INFO - Confirmation/Validation response
SUCCESS

Dec 09 2008 11:39 -- Breakpoint: 1 - Collected data from PayPal notification

Dec 09 2008 11:39 -- IPN INFO :: Transaction email details.
From IPN = sales@******.co.uk | sales@******.co.uk
From CONFIG = sales@******.co.uk

Dec 09 2008 11:39 -- Breakpoint: 2 - Validated transaction components

Dec 09 2008 11:39 -- Breakpoint: 3 - Communication method verified

Dec 09 2008 11:39 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

Dec 09 2008 11:39 -- Breakpoint: 4 - Details: txn_type=unique ordersID = 0 IPN_id=0

Relevant data from POST:
txn_type = unique
parent_txn_id = None
txn_id = 8YK283397F687561D

Dec 09 2008 11:39 -- Breakpoint: 5 - Transaction type (txn_type) = unique

Dec 09 2008 11:39 -- IPN WARNING :: Currency/Amount Mismatch. Details:
PayPal email address = sales@****.co.uk
| mc_currency = GBP
| submitted_currency = GBP
| order_currency = GBP
| mc_gross = 1.70
| converted_amount = 1.00
| order_amount = 1



The same kind of problem happens with NOCHEX which makes me think its something else ?

Never had this problem before and using the same hosting company as my other sites - strange.

Anyway, if you have any more suggestions I will welcome them with open arms..

Many thanks in advance.

Chris

[CandleMan]

When you log into Nochex account, check the last transaction and see if there is a callback made or not.
That may indicate the problem there perhaps.
There should be a tick next to the transaction.

[DrByte]

The log files are always helpful:

Dec 09 2008 11:39 -- IPN WARNING :: Currency/Amount Mismatch. Details:
PayPal email address = sales@****.co.uk
| mc_currency = GBP
| submitted_currency = GBP
| order_currency = GBP
| mc_gross = 1.70
| converted_amount = 1.00
| order_amount = 1

It seems your store has a 1.00 value for the order amount, but PayPal is treating it as 1.70, presumably because your PayPal account is adding shipping and/or taxes to the order after Zen Cart sends the transaction to them?

[ccn1]

When you log into Nochex account, check the last transaction and see if there is a callback made or not.
That may indicate the problem there perhaps.
There should be a tick next to the transaction.

Thanks CandleMan

There is a cross in the "Callback Status" box and the roll over text states "Callback Failed", that shows somethings wrong !!

Any ideas what could be causing it ?

Regards

Chris

[ccn1]

The log files are always helpful:It seems your store has a 1.00 value for the order amount, but PayPal is treating it as 1.70, presumably because your PayPal account is adding shipping and/or taxes to the order after Zen Cart sends the transaction to them?

Thanks Again for your reply DrByte,

From your reply I noticed something that the customer had put in. The "site wide, category & product mark up" module, which was and you gusessed it marking up all products by 70%. A £1 sale = £1.70.....

If it wasnt for you pointing out the details in the paypal log file I would have looked for ages, or forever ha ha.

I will have a scout around to see if anyone else is having the same problem with that module.

Many thanks for your help.

Chris

[CandleMan]

There is an issue with paypal adding the tax twice (i have the same issue) causing a mismatch in the ordered amounts and therefore rejecting the payment but I think it is only in Paypal Express I think.
I don't have the same problem with nochex mind??

[DrByte]

There is an issue with paypal adding the tax twice (i have the same issue) causing a mismatch in the ordered amounts and therefore rejecting the payment but I think it is only in Paypal Express I think.

Transactions via PayPal Website Payments Standard/IPN will have any tax/shipping added as configured in your PayPal account, thus causing mismatches.
Express Checkout transactions are treated exactly as submitted.

[ccn1]

Hi DrByte

I have looked in the shipping/tax etc and cant find anything our of the ordinary.

Is there any reason you have seen why the markup module will not work ? I can seem to find any related issues to my problem so it suggests other people are using it without problems.

When i put the markup down to 0% the order goes through as normal. When I use the markup, it does not work....

Sorry to be a pain

Chris