Paypal Express on 1.3.09h - partial refund and other issues

[peterdd]

I am using Paypal EC and have copied though the files contained in the 1.3.9h download. Site is 1.3.9h updated - and db upgraded. Many other mods - mostly shipping and alternative SagePay payments from CEON.

Cannot get Paypal partial refunds to work through Zen Cart admin. Full refunds are fine and update. Partials done on the Paypal site DO update the transaction on ZC.

Debug log response array for the ZC partial is:


Response:
Array
(
[TIMESTAMP] => 2010-12-07T10:43:45Z
[CORRELATIONID] => c849699dcd358
[ACK] => Failure
[VERSION] => 60.0
[BUILD] => 1613293
[L_ERRORCODE0] => 10001
[L_SHORTMESSAGE0] => Transaction failed due to internal error
[L_LONGMESSAGE0] => Internal Error
[L_SEVERITYCODE0] => Error
[CURL_ERRORS] =>
)

The request headers and parameters are fine - and match those for the successful full refund with the exception of [REFUNDTYPE => Partial and [AMT] being shown - which I believe is correct.

Any ideas? Is this a bug?

Also, we show goods including local tax (VAT) but when the user uses the express checkout button the amount they are asked to approve in Paypal is shown net of tax. They then return to our site where they choose the shipping and on the next page are shown the now correct tax inclusive price. Is this normal behavior?

If it is normal is there a way to get Paypal to show the tax inclusive amount? I notice from the logs that the tax amount is not being submitted to Paypal e.g for a £17.50 item:

paypalwpp
BEFORE line-item calcs: Array
(
[AMT] => 14.89
[ITEMAMT] => 14.89
[TAXAMT] => 0
[SHIPPINGAMT] => 0
[SHIPDISCAMT] => 0
[HANDLINGAMT] => 0
[INSURANCEAMT] => 0
)
- AFTER doing line-item calcs: Array
(
[AMT] => 14.89
[ITEMAMT] => 14.89
[TAXAMT] => 0
[SHIPPINGAMT] => 0
[SHIPDISCAMT] => 0
[HANDLINGAMT] => 0
[INSURANCEAMT] => 0
[L_NUMBER0] => Q280032
[L_NAME0] => Adults Dunlop Acifort Heavyduty Welly - Green
[L_DESC0] => Footwear Sizes: UK 10
[L_AMT0] => 14.89
[L_QTY0] => 1
[DESC] => Tax included in prices: 0 (0)


Many thanks for reading all this!

[DrByte]

[L_ERRORCODE0] => 10001
[L_SHORTMESSAGE0] => Transaction failed due to internal error
[L_LONGMESSAGE0] => Internal Error
[L_SEVERITYCODE0] => Error

You'll need to contact PayPal for help in troubleshooting the unnamed "internal error" reported by their server: www.paypal.com/mts

[peterdd]

Many thanks DrByte for you very quick response. I'll try with Paypal as you suggest and will report back if any progress.

In the meantime can you or anyone reading this help me with the second part of the question - the issue of the tax not being shown in the Paypal pages. It seems odd to have tax inclusive prices in the store, then tax exclusive prices in Paypal and then back to tax inclusive prices at checkout in the store. Is there a way to harmonize the total the customer sees?


Thanks

[DrByte]

Your prices include tax. That's exactly how it's being submitted to PayPal.
If you want PayPal to show the tax amount on each item, then switch your store to NOT show tax included in prices ... then it will calculate tax separately, and submit it separately.

[peterdd]

Thanks for your reply - but I am confused now.

The item is shown in the cart at 17.50. The logs as shown in original post (and below) show the amount advised by ZC to Paypal is 14.89 (therefore net of tax). There isn't anything in the tax line probably for the reason you suggest. As you point out the log item [DESC] states 'tax included in prices' which is the store setting, but as I am pointing out 14.89 does not include tax! It is just wrong.

I don't want Paypal to show tax for each item - merely the total inclusive of tax - the amount customers think they are paying.

Taking the example given can I get the amount advised to Paypal to be the correct 17.50 (i.e. 14.89 + 17.5%VAT)?

Logs:
paypalwpp
BEFORE line-item calcs: Array
(
[AMT] => 14.89
[ITEMAMT] => 14.89
[TAXAMT] => 0
[SHIPPINGAMT] => 0
[SHIPDISCAMT] => 0
[HANDLINGAMT] => 0
[INSURANCEAMT] => 0
)
- AFTER doing line-item calcs: Array
(
[AMT] => 14.89
[ITEMAMT] => 14.89
[TAXAMT] => 0
[SHIPPINGAMT] => 0
[SHIPDISCAMT] => 0
[HANDLINGAMT] => 0
[INSURANCEAMT] => 0
[L_NUMBER0] => Q280032
[L_NAME0] => Adults Dunlop Acifort Heavyduty Welly - Green
[L_DESC0] => Footwear Sizes: UK 10
[L_AMT0] => 14.89
[L_QTY0] => 1
[DESC] => Tax included in prices: 0 (0)


Many thanks for taking an interest is this issue.

Is this a bug in Paypalwpp or have I a store wide issue?

[peterdd]

DrByte I have now received a response from Paypal about the unspecified 'internal error 10001' received when doing a partial refund from within Zen Cart.

Paypal said: "After reviewing the logs I was able to confirm the "currencycode" variable was missing from the request which is required within partial refunds. Once provided you should no longer have any errors. Below is the documentation for partial refunds along with other API calls, please use this for your reference.

Starting on page 161 for partial refunds: https://cms.paypal.com/cms_content/US/en_US/files/developer/PP_NVPAPI_DeveloperGuide.pdf"


So my question is how do I get the currency code to be submitted? Is there something I should have done to do this?

The only currency is £ sterling with a code of GBP - in admin currencies.

[DrByte]

Tell them that they've got a bug in their system. The CURRENCYCODE requirement was added to their documentation for Specification Version 63.0, but Zen Cart is presently using their 60.0 specification, which does not require CURRENCYCODE. They can check their 60.0 version of their documentation for confirmation. There's no reason for it to be rejected since the API call is written according to their published specifications.

[peterdd]

DrByte - once again many thanks for helping here. I will see what Paypal say and report back.

In the meantime could you have a look at my comments in #5 above re the question about tax and prices. Any guidance would be appreciated.

regards

[DVDTitan]

DrByte - once again many thanks for helping here. I will see what Paypal say and report back.

In the meantime could you have a look at my comments in #5 above re the question about tax and prices. Any guidance would be appreciated.

regards

I'm having exactly the same issue, would be interested to hear what they say.

[peterdd]

I can now report an update from Paypal. I asked when the currency code become compulsory and advised to them DrByte's explanation re version 60.0 and 63.0 etc (see above).

They said:

I can advise that PayPal allows at least one year before most introduced variables become required. At this time the variable "currencycode" is a required variable for Partial Refunds only and we are unable to change the requirements back to older versions. I wanted to again advise that this issue is related only to when attempting to issue partial refunds within ZenCart. You are still able to login to the PayPal account to issue partial refunds as well. I've provided the published documentation in the prior response and unfortunately developers may have to make updates to their shopping carts to ensure they are current with our specifications for all features.

So there you have it. If you're wondering why partial refunds don't work, that's your answer!

PS anybody got an answer to my question as in #5 above?