Adding price over 100 million, it will revert to 99999999.99

[dwi2015]

Any other way to change max amount pricing in WHMCS, because every time i add pricing over 100 milion it will revert to 99999999.99.

 

Thanks.

[dwi2015]

I want to add price for a product, and that product have price over 100 milion, but every time i save the setting it will revert to 99999999.99.

 

Any other way to change max amount for pricing?

 

Thank you.

[brian!]

I suspect the only way you could do this would be to modify the database table structure of tblpricing - it's length is currently set at 10, which is why you can't have numbers greater than 99999999.99

 

what you would need to do is alter those table settings to 11, 12 or more (depending on your maximum price).

 

I posted a similar response in the thread below - though that was about increasing decimal places, yours is increasing the decimal length - so you don't want to alter the 2 decimal places, you want to alter the 10 in the decimals of the setupfees and billing cycles.

 

http://forum.whmcs.com/showthread.php?90090-More-demicals-in-configurable-options&p=379431#post379431

 

two very important things to remember.

 

1. backup the database before doing this.

2. understand the comment in that thread from WHMCS support - if you have a test WHMCS setup, try this on that first!

 

Shouldn't be any adverse effects from this work around but, as always, this has not been fully tested and cannot be supported by WHMCS. So be sure to test the changes before you apply them to a production install of WHMCS.