👀 Choose SSD-powered VPS servers for increased speed, power, and security! Now 50% off- starting from only $3.19/mo.
This article provides a guide for how to sort TLDs alphabetically in WHMCS.
Default TLD Order in WHMCS
By default, WHMCS will sort TLDs in the order in which they are created/imported, with each subsequently added TLD appending the current TLDs.
The output can be difficult to navigate.
How to Sort TLDs Alphabetically in WHMCS
To sort TLDs alphabetically in WHMCS, run the following SQL query on the WHMCS database:
SET @counter = -1;
UPDATE tbldomainpricing SET tbldomainpricing.order = @counter := @counter + 1
ORDER BY tbldomainpricing.extension ASC;The TLDs will now be sorted alphabetically in WHMCS.
Conclusion
You now know how to sort TLDs alphabetically in WHMCS.
