[Support Thread] Nochex APC

[CJPinder]

Problem solved! I read through all the previous posts again (got a nice headache now) and found the entry below. Tried the same thing and it worked. Thanks for taking the time to help, very much appreciated.

Glad it is now working for you. Good luck with the business.

Regards,
Christian.

[scotchgitt]

Error: 1146 Table user_zc1.zen_nochex_sessions' doesn't exist
in:
[delete from zen_nochex_sessions where session_id = '...........']

Has this error been corrected or a fix identified.

I am running 1.3.7 of zen cart and 1.2 of the nochex module (I have also tried 1.1).

I have not installed and uninstalled it 3 times and still get the error.

Any advice or questions thanks.

[mali]

Hi,

I have a problem with nochex notification email. I use zencart 1.3.7, Shared SSL and have Nochex merchant account.

I downloaded Nochex_APC_v1.21.zip, the version that has been modified by christian (CJPinder). I have removed/uninstalled the old version (1.2) and replace it by this new version. Christian mentioned in the install.txt that this version will now pass product description to Nochex. But in Nochex confirmation email, it still shows [NO MESSAGE ATTACHED] :

Sent To: [email protected]
Amount: £25.83
Date: 19/11/2007 20:43:53
Funded From Card Ending: 333
Description: [NO MESSAGE ATTACHED]


Can someone please suggested what could be wrong?

Regards
Mali

[CJPinder]

I downloaded Nochex_APC_v1.21.zip, the version that has been modified by christian (CJPinder). I have removed/uninstalled the old version (1.2) and replace it by this new version. Christian mentioned in the install.txt that this version will now pass product description to Nochex. But in Nochex confirmation email, it still shows [NO MESSAGE ATTACHED] :

Erm...that looks like a bug I hadn't spotted. The description is not being passed through if you have a Merchant account. Bear with me and I will sort out a fix.

Regards,
Christian.

[CJPinder]

NoChex APC v1.3 attached. If you are already using v1.2.1 then no database changes will be required, just upload the files. This version should fix the description not being passed through on Merchant accounts.

Let me know how you get on.

Regards,
Christian.

[feelgood2k]

Works for me, however:

Both this and the previous version do something odd at nochex when I use a gift certificate that covers more than the Amount but less than the Amount + Postage.

Looking at the html for the form that submits to Nochex, the Amount is negative.

You are then shown a Nochex "Send Payment" screen with the negative amount filled in, rather than the normal Payment form you would expect.

Perhaps some logic to stop the amount ever being negative is needed, so that gift certificate redemptions reduce the amount first, then the postage.

This would have to be done early enough so as not to cause problems with the reports.

[CJPinder]

Both this and the previous version do something odd at nochex when I use a gift certificate that covers more than the Amount but less than the Amount + Postage. Looking at the html for the form that submits to Nochex, the Amount is negative.

Hmmmm... It sends an Amount and a Postage through to NoChex. The Amount is calculated as Amount = OrderTotal - Postage. Using a Gift Certificate deducts the appropriate amount of money from OrderTotal before it gets to the payment module. So in some circumstances OrderTotal can be less than the Postage.

I'll amend the module so that if the OrderTotal is less than the Postage then it just sends the OrderTotal through and no postage. That should fix it. The postage won't be shown individually in that particular case but at least you will be able to accept payment.

Regards,
Christian.

[mali]

NoChex APC v1.3 attached. If you are already using v1.2.1 then no database changes will be required, just upload the files. This version should fix the description not being passed through on Merchant accounts.

Let me know how you get on.

Regards,
Christian.

Hi Christian,

Thank you for your help. It doesn't show product description but at least it show 'Description: R-Spec Performance Products Ltd Purchase'. This looks like paypal IPN.

Regards,
Mali

[feelgood2k]

Hmmmm... It sends an Amount and a Postage through to NoChex. The Amount is calculated as Amount = OrderTotal - Postage. Using a Gift Certificate deducts the appropriate amount of money from OrderTotal before it gets to the payment module. So in some circumstances OrderTotal can be less than the Postage.

I'll amend the module so that if the OrderTotal is less than the Postage then it just sends the OrderTotal through and no postage. That should fix it. The postage won't be shown individually in that particular case but at least you will be able to accept payment.

Regards,
Christian.

Good work Christian. Let me know when you're done and I'll give it a whirl.

I wonder if other modules have the same issue. Ill have to check.

Also, is the Order ID meant to be blank in the email from nochex?

Im assuming this isnt known until the callback itself, which is perhaps after nochex send the email?

[CJPinder]

Good work Christian. Let me know when you're done and I'll give it a whirl.

V1.3.1 is attached which should fix the negative amount bug when using Gift Certs.

Also, is the Order ID meant to be blank in the email from nochex?

Im assuming this isnt known until the callback itself, which is perhaps after nochex send the email?

Exactly, the order ID doesn't get created until the order is placed which is after the payment is made. As the order ID isn't known ahead of time it can't be passed over to NoChex.

Some payment modules have a guess at the order ID and assume it will be the current ID + 1. That can get confusing if someone places an order while someone else is making a payment though. I believe the other option is to use the external order number generator. Not tried it though.

Regards,
Christian.