Smarter e-mails

[ju5t]

Every so often we would like to communicate to all customers on a specific server. WHMCS allows you to do this but there is one problem.

We have customers with multiple webhosting packages. These are likely on different servers. WHMCS only has 2 options to contact them. E-mail them all or send an e-mail for every domain. Neither is very professional if the e-mail affects just a single server.

I am looking for a solution to email all customers on a single server and include all of the domains affected. If we select server X, we send 1 e-mail and in that e-mail we'd like to say 'this affects the following domains'.

This doesn't necessarily have to be in WHMCS, a cool solution based on Mailchimp or similar products is also an option.

Is there someone who can help us on the short term?

[WHMCS Peter]

Hi @ju5t,

Here's an SQL query which would allow you to export the affected customers directly from the database, to CSV for upload to a service such as MailChimp for your email blast:

SELECT 
`firstname`,
`lastname`,
`email`
FROM `tblclients` 
WHERE 
`id` IN (SELECT `userid` FROM `tblhosting` WHERE `server` = SERVER_ID_HERE AND `domainstatus` IN ('Active', 'Suspended'));

Replace SERVER_ID_HERE with the affected server ID from tblservers. You can see this by editing a server too, in the address bar.

Use your favourite tool (such as PHPMyAdmin) to export this data to .csv and upload it per MailChimps requirements.

Hopefully this is a viable workaround for you.

[ju5t]

I will ask Mailchimp how we should format the input for them to parse it like we would like.

The query, as @brian! mentioned, isn't what we're after. What you've posted is what WHMCS supports already and that's exactly what we don't want. We prefer not to use raw SQL either as that limits who can send the e-mails to our customers. 

For the record: this was and still is a commercial job.

Edited June 18, 2020 by ju5t