How can we improve WHMCS?

Currently, the WHMCS affiliate system only supports commissions for products and services (via tblhosting.relid). Domain orders are explicitly excluded, as noted in the official documentation.

As a result, it is not possible to assign or track affiliate commissions for domain purchases, despite many businesses relying on domain registrations as core revenue — especially when working with marketing partners, influencers, or resellers who refer domain customers.

After investigating the schema, we’ve confirmed that:

* Affiliate commissions are stored in tblaffiliatesaccounts, with relid referencing tblhosting.id
* Domain orders are stored in tbldomains and have no relation to tblhosting, meaning domain sales are ignored by the affiliate system
* No mechanism currently exists to link domain transactions to affiliates

Suggested Implementation:

1. Add support for domain-related affiliate tracking, either:

* By introducing a domainrelid column in tblaffiliatesaccounts
* Or by allowing relid to flexibly reference either tblhosting.id or tbldomains.id, with a supporting type column ('hosting' / 'domain')

2. Update commission calculation and reporting logic to:

* Include domain-based transactions (registrations, renewals, transfers)
* Respect existing affiliate settings (one-time/recurring, commission rates)

3. Allow domain orders to be attributed to affiliates via referral tracking (cookie/session) just like products.

Use Case & Business Justification:

We have active partnerships that refer customers specifically for domain registrations. Without affiliate support for domains, we’re forced to manually track and reward commissions — which is error-prone, non-transparent, and unscalable.

Supporting domain commissions will:

* Enable fair compensation for affiliate referrals
* Strengthen WHMCS as a full-featured billing system
* Align the affiliate system with common registrar business models

Thanks!