Webmasters Stack Exchange is a question and answer site for pro webmasters. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 time it gives this message

Updated Domains with TLD 0 - 0 Affected

I have Google searched the problem and it seems a known issue which has yet to be addressed by WHMCS. In the meantime is there a workaround for this problem?

share|improve this question
Can you please explain more? What you do and what happens? – Ali Hashemi Dec 18 '13 at 15:04
Two suggestions were posted on the WHMCS forums after you posted this question. – mezzo Dec 10 '14 at 22:39

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.

  1. This will set all you one year .com domains to renew at $12.99

    UPDATE tbldomains SET recurringamount = "12.99" WHERE domain like "%.com" AND registrationperiod = "1";
  2. This will set all your one year .net domains that are currently at $11.97, to a new renewal price of $13.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: http://www.whmcs.com/appstore/2590/Prices-AutoCalc.html

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.