Francisco Posted October 2, 2008 Share Posted October 2, 2008 I changed the settings for domain fees for all new orders. I was expecting that WHMCS automatically based all new renewals using the new pricing scheme. However, it does not. It uses the fixed setting per package instead. Any way to bulk modify pricing from clients? Thanks 0 Quote Link to comment Share on other sites More sharing options...
othellotech Posted October 2, 2008 Share Posted October 2, 2008 changing the price of an item at config does not change any existing prices for clients its a simple sql query if you do want to do that update tbldomains set .... where ... 0 Quote Link to comment Share on other sites More sharing options...
chickendippers Posted October 2, 2008 Share Posted October 2, 2008 This is handy if you adjust your prices for new customers, but if your customers are in contract you may wish to keep their price constant. To mass-edit the value you'll need to edit the database; phpmyadmin etc. 0 Quote Link to comment Share on other sites More sharing options...
delator Posted October 2, 2008 Share Posted October 2, 2008 feature request - after a domain price has been changed, have a page with all the domain names in a list, client name, current renew price and the updated renew price, and a select box to choose which to update DOMAIN NAME | CLIENT NAME | CUR RENEW $ | UPDATE RENEW $ | UPDATE? jojo.com | john smith | $39.95 | 35.95 | [ ] etc etc 0 Quote Link to comment Share on other sites More sharing options...
Francisco Posted October 2, 2008 Author Share Posted October 2, 2008 can you guys give me a sample SQL query? Switching from $9.99 to $14.99 Thanks 0 Quote Link to comment Share on other sites More sharing options...
R-n-R Posted February 11, 2009 Share Posted February 11, 2009 feature request - after a domain price has been changed, have a page with all the domain names in a list, client name, current renew price and the updated renew price, and a select box to choose which to update DOMAIN NAME | CLIENT NAME | CUR RENEW $ | UPDATE RENEW $ | UPDATE? jojo.com | john smith | $39.95 | 35.95 | [ ] etc etc I would like to see this implemented and maybe a global option for all to change as well based on the tld. Is there not any other interest in this? 0 Quote Link to comment Share on other sites More sharing options...
GORF Posted February 11, 2009 Share Posted February 11, 2009 +1 for me... 0 Quote Link to comment Share on other sites More sharing options...
othellotech Posted February 12, 2009 Share Posted February 12, 2009 can you guys give me a sample SQL query? Switching from $9.99 to $14.99 *ALWAYS TEST SQL UPDATES ON A COPY OF YOUR DB FIRST* update tbldomains set recurringamount="14.99" where recurringamount="9.99" and registrar="enom" and registrationperiod=1; *ALWAYS TEST SQL UPDATES ON A COPY OF YOUR DB FIRST* 0 Quote Link to comment Share on other sites More sharing options...
rldev Posted August 18, 2011 Share Posted August 18, 2011 +1. This feature is very necessary. 0 Quote Link to comment Share on other sites More sharing options...
scurrell Posted August 18, 2011 Share Posted August 18, 2011 +1. This feature is very necessary. ....which is why Addons > Bulk Pricing Updater was developed... 0 Quote Link to comment Share on other sites More sharing options...
rldev Posted August 18, 2011 Share Posted August 18, 2011 Don't see it in my installation and I don't see where to download it on the board. 0 Quote Link to comment Share on other sites More sharing options...
striddy Posted August 19, 2011 Share Posted August 19, 2011 Don't see it in my installation and I don't see where to download it on the board. First go to Setup > Addon Modules. You can activate it there. 0 Quote Link to comment Share on other sites More sharing options...
rldev Posted August 19, 2011 Share Posted August 19, 2011 First go to Setup > Addon Modules. You can activate it there. Thank you. 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.