kevinhillstrand Posted May 14, 2012 Share Posted May 14, 2012 Hi, We recently acquired a VPS hosting company that was based in the UK, as such all currency for all clients are set to GBP. Does anyone here know how to automatically change every client in a WHMCS database from GBP currency to USD, and to automatically update their outstanding invoices & active services to the equivalent amount in USD? It would need to automatically check the GBP > USD rates and update all existing active service recurring prices to USD. We would like to change everything to USD as we are an American based company. I appreciate any insight into this. Best, Kevin 0 Quote Link to comment Share on other sites More sharing options...
othellotech Posted May 14, 2012 Share Posted May 14, 2012 it can be done with a bit of sql and some calculations ... drop me an email/pm if you want a quote - done it several times over several acquisitions 0 Quote Link to comment Share on other sites More sharing options...
kevinhillstrand Posted May 14, 2012 Author Share Posted May 14, 2012 it can be done with a bit of sql and some calculations ... drop me an email/pm if you want a quote - done it several times over several acquisitions I can't seem to PM you, can you please PM me or email kevin@ftnhosting.net 0 Quote Link to comment Share on other sites More sharing options...
ani_web Posted August 23, 2013 Share Posted August 23, 2013 I want to change the Price rate of all existing active services with Newly changed price by default. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.