Export a full list of the services with their prices

[HarryAdney]

Hi everyone,

Anyone know if there's a way to export all of the services I've setup in WHMCS along with the prices I've set up for them? I've used the Products/Services page to copy and paste the services into a spreadsheet, but the only columns available are:

Product, Name, Type, Pay Type, Stock, Auto Setup

Maybe there's a 3rd party module you know of?

Thanks for any help.

Martin

[bnb]

I am also looking to export all products, product groups and prices. How can we do this?

[WHMCS Stephen]

Hello @HarryAdney and @bnb,

From your description, you may require a custom report to achieve this.

Our Services report in WHMCS should provide you with the data you require and for you to export at https://docs.whmcs.com/Reports#Services

If you need to drill down into this data more information about customizing reports can be found at https://docs.whmcs.com/customization/custom-reports/ this will allow you to create any data set you need.

For advanced DB interaction please refer to https://developers.whmcs.com/advanced/db-interaction/

On checking this community, an alternative solution with no heavy lifting code-wise was provided in a thread.

It's an SQL command that you can run directly in phpMyAdmin on your WHMCS database that will give you the output you require which you can then export.

 

SELECT
CONCAT(firstname,' ',lastname) AS Name,
tblclients.companyname,
tblclients.email,
tblproducts.name AS Product,
tblhosting.domain,
tblhosting.paymentmethod,
tblhosting.billingcycle,
tblhosting.amount,
tblhosting.nextduedate,
tblhosting.nextinvoicedate
FROM tblhosting
INNER JOIN tblproducts
ON tblhosting.packageid = tblproducts.id
INNER JOIN tblclients
ON tblhosting.userid = tblclients.id
WHERE tblclients.status = 'Active'
ORDER BY Name;

This can also be refactored to suit your requirements for generating a report in WHMCS or exporting the data in phpMyAdmin.

Of note, this is only to export the data set for reporting requirements.