WIS hosting Posted July 10, 2009 Share Posted July 10, 2009 Hello, I am using 3.8.1 this version still runs ok and I'd rather not change WHMCS right now. But here my problem: recently I changed the domain prices. But clients who ordered last year receive an invoice for the next year. But they all have the old prices. do I have to change them all manually? And why doesn't the system look at the prices giving in the system? thanks 0 Quote Link to comment Share on other sites More sharing options...
scurrell Posted July 10, 2009 Share Posted July 10, 2009 But they all have the old prices.do I have to change them all manually? And why doesn't the system look at the prices giving in the system? thanks You may have special pricing for some clients, so the system doesn't automatically change the pricing to reflect your new prices. You have to change them manually for existing clients. Or run a query to update them en-masse in the database. 0 Quote Link to comment Share on other sites More sharing options...
WIS hosting Posted July 10, 2009 Author Share Posted July 10, 2009 I don't use special prices. I am not experienced with Mysql. And to change 500 accounts manually is not done. Isn't there a way to change it in WHMCS? 0 Quote Link to comment Share on other sites More sharing options...
scurrell Posted July 10, 2009 Share Posted July 10, 2009 Isn't there a way to change it in WHMCS? Yes. One by one. If you search the forum, you'll probably find the necessary script to run against your database to update the prices. 0 Quote Link to comment Share on other sites More sharing options...
WIS hosting Posted July 10, 2009 Author Share Posted July 10, 2009 I think this is a big shortcoming in the WHMCS software. Prices do get updated as inflation occurs. Maybe something for Matt to consider revising? 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted July 11, 2009 WHMCS Support Manager Share Posted July 11, 2009 Run this command in phpmyadmin (backup first) UPDATE tbldomains SET recurringamount=450 WHERE recurringamount=400 0 Quote Link to comment Share on other sites More sharing options...
WIS hosting Posted July 11, 2009 Author Share Posted July 11, 2009 Ok Thanks! I think i have to change 450 and 400 into the prices I want to use? 0 Quote Link to comment Share on other sites More sharing options...
scurrell Posted July 11, 2009 Share Posted July 11, 2009 Ok Thanks! I think i have to change 450 and 400 into the prices I want to use? Yes, "450" being the equivalent to your new price, and "400" your existing price. 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.