Jump to content

Can't get Bulk Pricing Updater to work


aziom

Recommended Posts

I've just changed my domain name pricing and I'm trying to update the recurring amounts on domain names.

 

I used the Bulk Pricing Updater but I can not get it to work. This is what I have selected:

 

Product: Domain - .com.au

Status: Active, Suspended

Billing Cycle: Domain: 2 year

Currency: AUD

Current Price:

New Recurring Price: 33.00

 

The results I get is:

 

Conditions

Statuses: 'Active','Suspended'

Billing Cycles: 2

Pricing Update Results

Updated Domains with TLD 0 - 0 Affected

 

All my pricing is on AUD and I have many .com.au domains.

 

What am I doing wrong? Or is there is bug in the updater?

 

Thanks

Link to comment
Share on other sites

  • 2 weeks later...
Would someone be kind enough to offer the mysql syntax to update a specific tld price for all customers if the renewal period is set to one year?

 

I haven't worked out the mysql syntax but I have about 100 domain names and this is what I did:

 

1. Make the changes to the domain name pricing first in "Setup > Products/Services > Domain Pricing".

2. Go to "Clients > Domain Registrations" and select a domain name.

3. Click on the checkbox next to "Auto Recalculate on Save" and click on "Save Changes".

4. Repeat step 3 for all domain names where the price has changed.

 

I have submitted a ticket on this issue to WHMCS Support. Hopefully they will fix it with the next update.

Link to comment
Share on other sites

  • WHMCS Support Manager

Hi

As a workaround you could do this on a per-client basis using the mass update tool: http://docs.whmcs.com/Products_Management#Mass_Updating_Services.2FAddons.2FDomains

 

Or the SQL query would be:

 

UPDATE tbldomains SET recurringamount = "x.xx" WHERE domain like ".com" AND registrationperiod = "1";

 

Replace x.xx with the new price, .com with the TLD in question and "1" with the number of years the domain has been registered.

Link to comment
Share on other sites

  • 2 weeks later...
Hi

As a workaround you could do this on a per-client basis using the mass update tool: http://docs.whmcs.com/Products_Management#Mass_Updating_Services.2FAddons.2FDomains

 

Or the SQL query would be:

 

UPDATE tbldomains SET recurringamount = "x.xx" WHERE domain like ".com" AND registrationperiod = "1";

 

Replace x.xx with the new price, .com with the TLD in question and "1" with the number of years the domain has been registered.

 

I suggest to place % in front of .com, otherwise, .com.au domains will be updated also:

 

UPDATE tbldomains SET recurringamount = "x.xx" WHERE domain like "%.com" AND registrationperiod = "1";

 

http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html

 

Regards,

Marco

Link to comment
Share on other sites

I suggest to place % in front of .com, otherwise, .com.au domains will be updated also:

 

UPDATE tbldomains SET recurringamount = "x.xx" WHERE domain like "%.com" AND registrationperiod = "1";

 

http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html

 

Mind sharing the syntax to only update domains which pricing or currency is X? Hopefully the bulk pricing addon is fixed soon so we avoid messing with MySQL.

 

EDIT: Maybe there's a way via SQL to make sure all domain pricing match the current pricing configured at Domain Pricing? That way we should only care to have updated prices and all client's domains are updated.

Edited by Juanzo
Link to comment
Share on other sites

  • 2 weeks later...
Hi

As a workaround you could do this on a per-client basis using the mass update tool: http://docs.whmcs.com/Products_Management#Mass_Updating_Services.2FAddons.2FDomains

 

Or the SQL query would be:

 

UPDATE tbldomains SET recurringamount = "x.xx" WHERE domain like ".com" AND registrationperiod = "1";

 

Replace x.xx with the new price, .com with the TLD in question and "1" with the number of years the domain has been registered.

 

I had the same issue though used this technique until the next version comes out with fix.

Thanks for the help.

Link to comment
Share on other sites

  • 3 months later...
Mind sharing the syntax to only update domains which pricing or currency is X?

 

This is part of your answer.

 

UPDATE tbldomains SET recurringamount = "x.xx" WHERE recurringamount = "y.yy" AND domain like "%.com" AND registrationperiod = "1";

 

That'll set pricing to $x.xx, but only on domains that are currently $y.yy, that are *.com and that are a 1 year renewal cycle.

 

I'm working on the Currency thing - it's a bit more complicated because the domain record itself doesn't know what currency it is - that info is on the client record - so the Query needs to take the clientid from the domain, and lookup the tblclients.id.currency.

 

Maybe there's a way via SQL to make sure all domain pricing match the current pricing configured at Domain Pricing? That way we should only care to have updated prices and all client's domains are updated.
I've asked for that exact thing - they need to fix the Bulk Pricing Updater addon, but ALSO they should have an 'update all now' type of button on the Price Edit screens for products/domains. That way, if you edited your .net pricing, you could click right there and have the .net prices updated for everyone right there. Edited by 9DollarDomains
Link to comment
Share on other sites

I don't understand why WHMCS doesn't fix this...
Stormy, I did talk to them a couple days ago - they say that they HAVE been able to duplicate this, and that a case# has been opened, and that they are going to fix this shortly. This is what they said:

 

I've opened case #3019 with our developers in order to have this resolved for future releases.

This has been scheduled for resolution in the 5.3 series of WHMCS.

Mind sharing the syntax to only update domains which pricing or currency is X?

 

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";

 

Juanzo, I don't know of an easy way to limit this to just certain currencies - that info is kinda spread across the tbldomains and the tblclients and the tblcurrencies tables, so I think this would be a complex 'join' query, that would take more brain cell's than I have - especially if WHMCS does in fact have a fix for the Bulk Pricing Updater on the way very shortly. However, at least for the time being, these examples should hopefully help folks out.

:)

Link to comment
Share on other sites

  • 4 months later...
  • 11 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated