Critical Multi-Currency Gateway Bug

[robertb]

Hello All,

 

There is a critical bug in WHMCS related to multiple currency gateways.

 

I've had a ticket open with WHMCS for months now... but their usually good support has disappeared and is no longer replying to my request for any updates. It seems odd that they would acknowledge a bug and then just ignore it... but anyway...

 

I'm hoping that maybe someone here has a creative solution or hack to get this working.

 

I have two gateways, US$ and CAD$.

 

Both gateways use a token system for security.

 

The US$ gateway is first in the list, so I guess it's my default.

 

 

I have an account that paid their first invoice using the US$ gateway.

When they paid that invoice, I can see in the log "Credit Card US$ Remote Storage", which is good.

 

Then the customer requested they be changed in Canadian dollars.

Everything in their account, including the general "Profile" and specific "Product/Service" is now setup for CAD$ gateway.

 

On the "summary" page I click "Credit Card Information" and CLEAR all the details. (Just in case these details were married to the US$ gateway.)

 

I then input a new credit card.

 

Upon their next renewal, the transaction is declined.

 

In the Gateway Log, I can see it's using the "Credit Card US$ Remote Storage".

It should have used "Credit Card CAD$ Remote Storage", but it did not.

 

So, the big bug and big question is why is it still using the US$ gateway?

Everything on this account is setup for the CAD$ gateway.

 

This does not make any sense... and banging my head against the keyword has not produced the solution, hehe.

 

It's like WHMCS is just calling the wrong gateway for some reason.

 

I would assume that when WHMCS sees that everything on the user's profile is setup for the CAD$ gateway, it should know to use CAD$ Remote Storage.

 

Any ideas?

[brian!]

i'm not sure if this is going to help with your issue, but you should not have changed the currency in the client's profile.

 

http://forum.whmcs.com/showthread.php?33858-Client-currency&p=169032#post169032

 

Once a client has placed the first order that's the currency used for all subsequent orders.

You can change their currency via the admin area but I'd strongly recommend against it as it just changes the symbol and doesn't convert the amounts.

in the absence of support fixing the bug, the quick solution might be to just create a new account for this client, using Canadian $ and see if that will charge in the correct currency.

[robertb]

Hi Brian,

 

Thanks for the reply.

 

I totally understand that changing the currency only changes the symbol in the interface on all the invoice.

I know that and I'm not too worried about it at all.

 

The issue is that a customer was paying in US$ and now wants to pay in CAD$.

 

Within WHMCS, I should be able to change the payment gateway to the CAD$ gateway and have it work correctly.

 

But, due to this nasty bug, it simply does not work...... very frustrating.

 

I can create a brand new WHMCS account.... surely that is a work-around... it's just a pretty annoying work-around... especially for WHMCS which boasts that it supports multiple currencies.

 

They really should say "we support multiple currencies but if a customer needs to change currencies at any point in time, then you're screwed!" hehe

[brian!]

Hi Robert,

 

I totally understand that changing the currency only changes the symbol in the interface on all the invoice. I know that and I'm not too worried about it at all.

just for anyone else reading the thread in the future...

 

http://docs.whmcs.com/Clients:Profile_Tab#Client_Currency

 

A client's currency is fixed when they place their first order, all subsequent orders will use that same currency. As a result, clients will not see the currency selector on their order form.

 

Once a client has placed an order - and therefore generated invoices, services and transactions - we recommend against changing their currency in the admin area. The currency dropdown on the client's Profile tab will change the currency symbol, it will not automatically convert any prices, invoices or transactions into the appropriate amount in the new currency.

 

I couldn't find that quote when I first replied, but I knew i'd seen it in the docs somewhere.

 

The issue is that a customer was paying in US$ and now wants to pay in CAD$.

Within WHMCS, I should be able to change the payment gateway to the CAD$ gateway and have it work correctly.

i'm not sure if this is an option for your payment gateway(s), but perhaps you could have kept them using the US$ gateway, change their profile to use CAD$ and used "Convert To For Processing" - yes I know, that's another workaround!

 

http://docs.whmcs.com/Payment_Gateways

 

btw - have you looked in the database table, tblclients, to see if there is any gateway info stored for this client that wasn't visible from the admin area? perhaps if there is and you can delete it (backup the db first though!), it might allow the change of gateway you desire.

 

also, if these are third-party payment gateways (i.e not ones supplied by default from WHMCS), it might be worth contacting them to see if they know of any tweaks to reset the gateway choice.

 

But, due to this nasty bug, it simply does not work...... very frustrating.

generally speaking, WHMCS will consider a bug to be the software not working as (they) intended it to - so considering they don't recommend client's currencies being changed, it's possible they might not see it as a bug.

 

that said, I can understand your frustration of wanting to make a simple tweak to the client's payment method - however, as you are changing both currency and gateway, it's difficult to know which (or both) is causing the issue.

 

I can create a brand new WHMCS account.... surely that is a work-around... it's just a pretty annoying work-around... especially for WHMCS which boasts that it supports multiple currencies.

but never with the same client!

 

i'm afraid that using work-arounds with WHMCS is pretty much a necessity.

 

it might also be worth posting your open support ticket ID too - I don't work for WHMCS, so I can't help you directly with that, but if one of the support guys comes across the thread, then they'll be able to read your ticket thread.

[robertb]

So, I've been trying to figure out what entry in the database is causing WHMCS to call the wrong gateway remote storage function...

 

And, for the life of me, I cannot figure it out.

 

I just don't see anything that would make WHMCS think it should use the US$ gateway when the CAD$ gateway has been selected.

 

I've searched and searched.

 

Does someone smarter than me have any ideas of where I should look?

 

As Brian suggested (and... thanks again for your fantastic comments/insights!), my Ticket # with WHMCS, which they seem to be ignoring even though they said they were working on it... is: OMM-513486

 

Thanks in advance to anyone who can give me a push in the right direction.

[WHMCS Jesse]

So, I've been trying to figure out what entry in the database is causing WHMCS to call the wrong gateway remote storage function...

 

And, for the life of me, I cannot figure it out.

 

I just don't see anything that would make WHMCS think it should use the US$ gateway when the CAD$ gateway has been selected.

 

I've searched and searched.

 

Does someone smarter than me have any ideas of where I should look?

 

As Brian suggested (and... thanks again for your fantastic comments/insights!), my Ticket # with WHMCS, which they seem to be ignoring even though they said they were working on it... is: OMM-513486

 

Thanks in advance to anyone who can give me a push in the right direction.

 

Robert,

 

I apologize for any inconvenience you've had so far, we're presently reviewing over this ticket and will have a response out to you today. It's been proven hard to determine the cause, so it's needing deeper investigation by our senior staff.

 

Thanks for your patience.

[robertb]

Hi Jesse,

 

Thank you very much for the reply. I'm glad someone is looking into it.

 

My previous ticket entries of "Any update"...." have all been ignored.

 

So, I'm glad happy to hear that a senior person is investigating.

 

In the ticket I also provide access to my DEV environment so we can even safely do some testing, which I know is helpful.