Changing prices

[Boston]

Hello,

 

Is there a way to change webhosting package prices so that all the recurring amounts etc. change for customers automaticly? Or do we have to change manually every customers recurring prices?

 

Manually it might best to do the changes in masses via mysql

[Matt]

Yep, a query in phpMyAdmin would be the simplest and only way. Something like this:

 

UPDATE tblhosting SET amount='75' WHERE amount='100';

 

That example would change all recurring amounts of 100 to 75.

 

Matt

[chickendippers]

It would be handy to have a button somewhere in the admin that basically does that.

[urevised]

I Agree. Something like this:

 

"You have changed the price for this package. Would you also like to update the pricing for all current packages?"

 

Would be very useful to me.

[AndyW]

This would be very nice. Especially as the query would not work for multiple packages having the same initial price.

[WHMCS Andrew]

for multiple products with same initial but different new you could do

UPDATE tblhosting SET amount='75' WHERE amount='100' and packageid = 0000000001;

[Telfie]

While I can see that this is an easy option to do via mySQL ( if you have the tools ) but I think that as 'urevised' mentioned the option to update existing prices when updating any products ( domains included ) should be available.

 

An extra field could be added to the domain / hosting account record which indicated that that the price on that item was not to be changed. If you wanted to get really fancy, it could be set so that if your new price is lower than the existing price for that product then reduce the price but not raise the price if it is higher. That way existing customers can be protected from price rises if necessary.

 

So

0 = change regardless

1 = change if new price less than existng

 

 

Just a thought

[Inmeso]

I agree, this would be a very nice function to be added in WHMCS.

[marquis_ce]

for multiple products with same initial but different new you could do

UPDATE tblhosting SET amount='75' WHERE amount='100' and packageid = 0000000001;

 

How can i run this command?

[sparky]

In a whmcs custom php file

or in {php}...{/php} tags in a tpl

[handsonwebhosting]

marquis_ce

 

To run that command you can use PHPMYADMIN from inside your hosting control panel and then enter that command in the Execute SQL portion

[cele303]

Yep, a query in phpMyAdmin would be the simplest and only way. Something like this:

 

UPDATE tblhosting SET amount='75' WHERE amount='100';

 

That example would change all recurring amounts of 100 to 75.

 

Matt

 

Hi,

 

Can you tell me what would be correct query to update domain prices from PMA ?

 

Renewal prices ?

 

Thanks

[ghpk]

I handy button would save many whmcs customers, I recently had a very long argument with a customer wanting to renew the domain on OLD pricing.

[SilverNodashi]

While I can see that this is an easy option to do via mySQL ( if you have the tools ) but I think that as 'urevised' mentioned the option to update existing prices when updating any products ( domains included ) should be available.

 

An extra field could be added to the domain / hosting account record which indicated that that the price on that item was not to be changed. If you wanted to get really fancy, it could be set so that if your new price is lower than the existing price for that product then reduce the price but not raise the price if it is higher. That way existing customers can be protected from price rises if necessary.

 

So

0 = change regardless

1 = change if new price less than existng

 

 

Just a thought

 

A good thought, and great idea I would like to vote for this option too. While I'd like to see some (bandwidth prices, VPS / dedicated / colocation, software license, etc) products prices update on all client's profiles, others (shared & reseller accounts) need not to change

[ServWise.com]

I'm a little shocked that WHMCS works this way, in another system all reoccurring charges are taken from the main product plan prices set "Unless" a price override has been specifically set on the users plan. This to me is the logical way to do it and having to manually change the prices in SQL is less than ideal. I agree this needs to be implemented ASAP, when changing a price structure you should at least have the option to also update all customer prices.

 

Is this also the situation with domain renewals, if so, is it the renewal prices that is set for the customer or the registration price as these can be very different, also if our wholesale renewal price changes or exchange rates change I can see situations where customers could actually be paying less than we are being charged.

[RandyC]

I believe it is implemented in v4, and nice bum of an extremely old thread (about 15 months old)

[ServWise.com]

Doesn't seem to mention anything in the feature list for V4.

[Juanzo]

I don't see anything either so, for the time being, we should use phpMyAdmin to do this.