Custom Product Report

[artie290]

So I have 30 customers signed up for this custom product. I want to do a database query to pull the Product custom fields from these 30 products. If you could help that would be fantastic, I really need this. Any help would be much appreciated or if someone could point me in the right direction.

 

Headers for Report would be;

 

Customer Name Product Name Product Custom Field1.......Product Custom Field10

-------------- ------------- ---------------------- ----------------------

 

Help from WHMCS Team

 

I do know you would need to use tblhosting to get the packageID.

 

The packageID is the id under tblproducts and the relid for tblcustomfields.

 

You would need a rather complex query to perform what you are doing.

 

Also, you might look into using the API to get this information as well:

 

http://docs.whmcs.com/API:Get_Clients_Products

 

This would pull the custom fields values for the products based on the product ID(pid) and return it in an array.