Jump to content

Export a full list of the services with their prices


HarryAdney

Recommended Posts

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

Link to comment
Share on other sites

  • 1 year later...
  • WHMCS Technical Analyst II

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.

 

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.

Guest
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.

×
×
  • 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