Jump to content

Auto Generate TLD Pricing Table Excel Spreadsheet


Recommended Posts



I created an excel spreadsheet to automatically generate an SQL insert query for populating the "Domain Pricing" section of WHMCS mainly because I thought it was a bit tedious to create many domains from scratch.


Anyways, it's very crude as I’m not that good with Excel, but it works.


Some information wasn't readily available so i "guessed", those items are marked in orange. The rest of the info is gathered from both Enom and DirectI from my reseller accounts.


Instructions are included.


The gist is you update your cost pricing for the included domains, what markup you want (for retail cost), term and interval of registration, if transfers are supported and it will generate a SQL query to insert all of that information into your database.


Please note, it does not configure everything for you (although it could with continued development).


It specifically doesn't populate the registrar as, this assumes a fresh install of WHMCS (no importing) and with that, the manual importation of domains (as per http://v3manual.whmcs.com/?id=108). I did this mainly out of safety, the order will error out, you accept it and once you are complete update the registrars and everything's peachy.


So, enough of that, a partial screenshot of an example population can be found here: http://www.c-nielsen.com/downloads/WHMCS---TLD-Domain-Pricing.png (forum attachment was too small to show relevant details).


The sheet can be found here: http://www.c-nielsen.com/downloads/WHMCS%20-%20TLD%20Pricing%20SQL%20Insert%20Creator.xls


Right now there's 77 TLD's entered with the above configurability.


The sheet contains contact information for suggestions, corrections and bug reporting.





Link to comment
Share on other sites

  • 1 month later...



I am trying to use this solution, but it appears that 2 rows are out of order for 3.6.1.


The rows Renewal and Transfer need to be reversed. I would do it myself, but the spreadsheet is password protected.


What is happening is that the Transfer row value is being placed in the Renewal row. Can we get an updated file or a password to the excel file?

Link to comment
Share on other sites

Oh, here is the issue I am having.


The renewal amount on many of the domains is set to -1.00 and I cannot figure out why it is doing this. What am I doing incorrectly.


What is the "sale" field for? I see that when I add values to it, the fields after it change from 1 to 2 or vice versa...

Link to comment
Share on other sites

Join the conversation

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

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