Updating ID Protection pricing

[dahamsta]

I need to update the pricing for this on existing domains and the Bulk Pricing Updater doesn't seem to support it. Where is this stored in the DB?

[WHMCS John]

Hi,

The bulk pricing updater does allow you to update existing domain prices. Just make sure you select the Domain options from the "Product" and "Billing Cycle" menus.

 

We've a step-by-step guide at http://blog.whmcs.com/?t=44602

[dahamsta]

I don't see any way to update ID Protection pricing there John, as per title.

[WHMCS John]

Hi,

ID Protection is included in the "Recurring Amount" of the domain, so you would need to use the "Current Price" field to differentiate between those domains with ID Protection and those without.

[dahamsta]

TBH, given that some of my clients are on different prices, I'd prefer to do this via the database. Can you tell how it's managed in the database please?

[WHMCS John]

It's the tbldomains.recurringamount field in the database.

You can check the tbldomains.idprotection field to see whether ID Protection is active or not.

[cenourinha]

SQL Query for those who want to update their price automatically:

 

UPDATE `tbldomains` SET `recurringamount` = 'NEWPRICE' WHERE `recurringamount` = 'ACTUALPRICE' AND `idprotection` LIKE 'on';

 

Replace:

ACTUALPRICE = Value of the actual domain price

NEWPRICE = Value with the price of the ID Protection

[saadsalman]

If you want to update the price for all domains that have ID Protection enabled, you can use this query to add a fixed amount to the recurring amount:

UPDATE `tbldomains` SET `recurringamount` = `recurringamount` + 'FIXEDAMOUNT' WHERE `idprotection` = 'on';

FIXEDAMOUNT = A fixed amount to add to domains having ID Protection enabled. Enter the new price if you were giving it for free before or add the difference if you are going to increase the cost of ID Protection.

Edited April 12, 2014 by saadsalman

[Ankur Kumar]

Can you please help me with SQL query to disable ID protection for each client .

 

I want to empty the column "idprotection" . This will disable all clients id protection but since i am not a mysql expert , i want to know the sql query

 

 

If you want to update the price for all domains that have ID Protection enabled, you can use this query to add a fixed amount to the recurring amount:

UPDATE `tbldomains` SET `recurringamount` = `recurringamount` + 'FIXEDAMOUNT' WHERE `idprotection` = 'on';

FIXEDAMOUNT = A fixed amount to add to domains having ID Protection enabled. Enter the new price if you were giving it for free before or add the difference if you are going to increase the cost of ID Protection.