Cowboy Posted November 8, 2022 Share Posted November 8, 2022 I am looking through the WHMCS database in phpmyadmin and I am only seeing some of the data relating to my clients and my hosting business. I can see transactions, but I can't see invoice details in any table. Also, can't find clients' domains, renewal dates, etc, etc. Is this being kept in a remote database somewhere? If so where and why is this being done? Is it to prevent me from migrating my data to a different system? The data belongs to me, not WHMCS. Am I wrong in assuming that if they are remote storing some of the data tables this would be a serious breach of ethics? 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted November 8, 2022 WHMCS Support Manager Share Posted November 8, 2022 Hi @Cowboy, All data is stored in the MySQL database on your server. These specific pieces of data are located in the following tables: tblinvoices tblinvoiceitems tbldomains 0 Quote Link to comment Share on other sites More sharing options...
DennisHermannsen Posted November 8, 2022 Share Posted November 8, 2022 7 hours ago, Cowboy said: Is this being kept in a remote database somewhere? If so where and why is this being done? Is it to prevent me from migrating my data to a different system? The data belongs to me, not WHMCS. How the heck did you assume that WHMCS would store your data in a remote database that you do not have access to? The company WHMCS doesn't store any of your data, except for the info you entered when you ordered the license. 0 Quote Link to comment Share on other sites More sharing options...
Angelo Bilianis Posted April 13 Share Posted April 13 Where is all the data located for the Store please? I found everything but can't find anything for index.php?rp=/store, thank you in advance! 0 Quote Link to comment Share on other sites More sharing options...
Kane William Posted April 16 Share Posted April 16 The WHMCS system relies on a MySQL database to manage and store its data. - Invoice records are mainly stored in the tblinvoices table, with associated line items kept in the tblinvoiceitems table. - Information about client domains, including renewal dates, is located in tables such as tblhosting and tbldomains. Thanks 0 Quote Link to comment Share on other sites More sharing options...
twhiting9275 Posted April 17 Share Posted April 17 On 4/13/2025 at 9:47 AM, Angelo Bilianis said: Where is all the data located for the Store please? I found everything but can't find anything for index.php?rp=/store, thank you in advance! You might want to create a new thread instead of hijacking a 2 year old one. If you're talking about 'products', you need to create those inside of the WHMCS admin area. If you're talking about the look and feel (ie: which to display where), you can edit the template to do this. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.