Update Domain Pricing by fixed percentage

[CMYKreative]

As the subject says, what's the easiest way to update "all" domain pricing by a fixed % across the board?

 

I don't think WHMCS can do this by default, but are there any recommended plugins that can do this?

 

Thanks in advance!

[sentq]

check the domain order extended module

[brian!]

check the domain order extended module

just so you know, sentq is referring to the ModulesGarden addon, "Domain Orders Extended For WHMCS" - it's a $100 per year, but does far more than just update the pricing!

 

https://www.whmcs.com/appstore/2950/Domain-Orders-Extended-For-WHMCS.html

 

in theory, you could update the domain pricing using SQL, e.g. to update domain renewal prices for existing customers, you could use the following - ALWAYS REMEMBER TO BACKUP THE DATABASE BEFORE TRYING THIS!

 

UPDATE tbldomains SET recurringamount = recurringamount*1.1;

that would update the current renewal price by 10%

 

however, to do the same for the register, transfer and new renewal prices is more involved,. e.g if you wanted to change the 1-year register price by 10%, you could use...

 

UPDATE tblpricing SET msetupfee = msetupfee*1.1 where type = 'domainregister' and msetupfee != '-1';

the complicated part would be using one query to combine all 10 years and the three domain types...

 

unless you were intending to do this on a regular basis (and are using all 10 years), if it were me, i'd be running 3 basic queries for each year (register/transfer and renew) - that would lessen the risk of errors being introduced.

[CMYKreative]

Thank you both, we'll check out the addon.

 

Thanks for the help.

[sentq]

Thank you both, we'll check out the addon.

 

Thanks for the help.

you may try brian solution first, it has what you need i think