TLD renew price wrong

Started by Fusionhost, July 30, 2013, 12:39:08 PM

Fusionhost

Hi Guys,

I'm having an issue with Hostbill.  Basically domains are set at 10.95, renewal and transfer are at 10.95 but when I go to renew any domain it comes up as 8.95.

Any ideas?

Regards,
Jon

P.S.  The verification for each post is a nightmare!
fusionhost - www.fusionhost.co.uk
Leading British Cloud Web Hosting Provider

tallship

#1
You've got three posts in now, so you don't have to worry about the anti-SPAM measures any longer :)

There's been some really whacky stuff going on lately, really weird things breaking.

For example, I sent out an one-off invoice to a customer for about $1000 this morning. When I checked later, they had apparently paid the same amount twice, presumably because it said they still owed the money? And then there's another invoice for that amount in their account that says it is unpaid.

When I logged in as customer, it said they owed $0

I thought, "Heck I'll just delete that invoice" - so I did. And now it shows a credit of $1000
Bradley D. Thornton - Manager Network Services, NorthTech Computer   TEL: +1.310.388.9469 (US) | +44.203.318.2755 (UK) | +61.390.088.072 (AU) | +41.43.508.05.10 (CH)
Registered Linux User #190795 - "Ask Bill why the string in [MS-DOS] function 9 is terminated by a dollar sign. Ask him, because he can't answer. Only I know that." - Dr. Gary Kildall.

Fusionhost

The issue is the customer will get invoices 8.95 instead of the correct amount of 10.95
fusionhost - www.fusionhost.co.uk
Leading British Cloud Web Hosting Provider

thetrusteeco

Hello Fusionhost,

I think you're saying: the domains were at 8.95 and you increased the price to 10.95, and customers that had their domains at 8.95 are still seeing them at 8.95, not at 10.95, for renewals.  If I am misunderstanding you, please clarify.

Hostbill doesn't automatically change the renewal price for a existing domain if you increase the renewal prices listed for the TLD.  If you want to update the prices for the existing domains you have 3 options:
1) Go into each affected domain (not the TLD) and change the renewal price manually (works but is time consuming).
2) Use the "Bulk Price Update" function and toggle-on "Update recurring prices of related domains/accounts" (sometimes doesn't work; depends on domains volume and server specs)
3) Go straight into MySQL and fix it there.  We've found this to be the easiest way, but I'll explain Option #2 (the HostBill way).

To use Bulk Price Update (if you haven't before):
1) Go to your applicable domains order page, scroll to the bottom, and click the link "Bulk Price Update"
2) Toggle-on the TLD that you want to update, scroll to the bottom, change the price as needed, and then toggle-on the Update recurring prices of related domains/accounts Option.  Notes: I'd recommend doing 1 TLD at a time if you use the "Update recurring prices of related domains/accounts" option.
You will need to change the domain price from 10.95 to something else and then back again using the "Bulk Price Update" function.

Hope that helps.  As I said the "Bulk Price Update" doesn't always work.  You need a lot of free RAM if you have a lot of domains. We found #3 (the MySQL method) to be the easiest for us.  If you don't know SQL, use option #1 if option #2 doesn't work.
"No man really becomes a fool until he stops asking questions"
Charles Proteus Steinmetz

nibb

#4
What Thetrusteeco said is correct.

Updating the prices on domains will update it for new orders, not existing ones, because the idea is to each package, domain or services independent, this means every customer could had a different price per domain.

You will need to update the renewal price of existing domains individually or in bulk.

You set a price on the product.
Customer orders.
Price is set for that domain and customer.

If you then change the price in the domain product, it will not change it that customer, just for new orders.

This may seem strange, because you expect it to update it on all customers, but actually this is a desired outcome, as you don“t want to overwrite custom prices a customer could have for this domain or package. If that is the case, we would have people complaining on how to set a custom renewal price for a specific customer since changing the product price would change that customer as well.

tallship

This should be how all order pages work too, right? i.e., I have hidden order pages where people use direct cart links, but later I want to offer the product at a different price (higher or lower), but I don't want the prices for the existing clients monthly recurring charges to change.

Correct?
Bradley D. Thornton - Manager Network Services, NorthTech Computer   TEL: +1.310.388.9469 (US) | +44.203.318.2755 (UK) | +61.390.088.072 (AU) | +41.43.508.05.10 (CH)
Registered Linux User #190795 - "Ask Bill why the string in [MS-DOS] function 9 is terminated by a dollar sign. Ask him, because he can't answer. Only I know that." - Dr. Gary Kildall.

nibb

Well with hostbill yes, it should work.

In my previous systems it actually worked like the initial posted asked. So I was a little confused after coming to hostbill at first.

In my previous system the prices where globally, so if you changed the product price, it changed for all customers that had them.

The problem then was when you tried to have different prices for different customers, or products.

With hostbill this is possible as a far as I know, renewal prices are per customer, do not change when a product price changes.

So yes, you could make a hidden order page with one product price, if customers order from it, they have that price, if others other the same product from another order page, they have that price, and if you upgrade price in one order page it will only do so for new orders at that point, not previous orders. That is how I get it at least.

Of course you can also go directly to a customer and change only his product price to be different. That works as well.

tallship

Excellent :)

Now I can delete a bunch of order pages that I know I really didn't need.
Bradley D. Thornton - Manager Network Services, NorthTech Computer   TEL: +1.310.388.9469 (US) | +44.203.318.2755 (UK) | +61.390.088.072 (AU) | +41.43.508.05.10 (CH)
Registered Linux User #190795 - "Ask Bill why the string in [MS-DOS] function 9 is terminated by a dollar sign. Ask him, because he can't answer. Only I know that." - Dr. Gary Kildall.