: WHMCS Bulk Pricing Updater Their is a Bulk Pricing Updater addon in WHMCS which works well to update hosting accounts pricing but I am unable to update the domain pricing through that every

@Heady270

The WHMCS forums have a couple of suggestions.

9DollarDomains says:


Here are some examples of manual SQL Queries that should work as a work around until this is fixed by WHMCS.


This will set all you one year .com domains to renew at .99

UPDATE tbldomains SET recurringamount = "12.99" WHERE domain like "%.com" AND registrationperiod = "1";

This will set all your one year .net domains that are currently at .97, to a new renewal price of .49

UPDATE tbldomains SET recurringamount = "13.49" WHERE recurringamount = "11.97" AND domain like "%.net" AND registrationperiod = "1";




dpatricio says:


Insted of touching database, which is dangerous, check this module instead:
www.whmcs.com/appstore/2590/Prices-AutoCalc.html

Vote Up Vote Down