Warren Posted January 29, 2020 Share Posted January 29, 2020 Hi All, Am I overlooking something or is there not a way to export domain pricing into CSV? Cheers, Warren 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted January 31, 2020 Share Posted January 31, 2020 Hi Warren, On 29/01/2020 at 18:19, Warren said: Am I overlooking something or is there not a way to export domain pricing into CSV? I can't recall anyone ever asking about exporting domain pricing from WHMCS before - they usually ask about importing. 🙂 if you're talking about exporting the TLD pricing (.com, .net) etc, then there isn't an in-built solution for that - although you could write a report to do it, or a direct SQL query as it would primarily be a join between the tbldomainpricing and tblpricing database tables - then it's just a case of figuring out if you want to filter by type (register/transfer or renew), by currency, by client group (e.g pricing slabs) etc. if you're asking about your clients existing domains, and their pricing, then you could use the Domains report to export those specific prices to csv. 0 Quote Link to comment Share on other sites More sharing options...
Warren Posted February 2, 2020 Author Share Posted February 2, 2020 On 31/01/2020 at 2:16 PM, brian! said: Hi Warren, I can't recall anyone ever asking about exporting domain pricing from WHMCS before - they usually ask about importing. 🙂 if you're talking about exporting the TLD pricing (.com, .net) etc, then there isn't an in-built solution for that - although you could write a report to do it, or a direct SQL query as it would primarily be a join between the tbldomainpricing and tblpricing database tables - then it's just a case of figuring out if you want to filter by type (register/transfer or renew), by currency, by client group (e.g pricing slabs) etc. if you're asking about your clients existing domains, and their pricing, then you could use the Domains report to export those specific prices to csv. Thanks Brian, This is specifically just exporting domain pricing to a CSV file. as I want to display pricing on a separate wordpress website. I know there are bridges for WHMCS and WordPress but I prefer keeping WHMCS and WordPress isolated from each other for security.  0 Quote Link to comment Share on other sites More sharing options...
brian! Posted February 3, 2020 Share Posted February 3, 2020 Hi Warren, 19 hours ago, Warren said: This is specifically just exporting domain pricing to a CSV file. as I want to display pricing on a separate wordpress website. I know there are bridges for WHMCS and WordPress but I prefer keeping WHMCS and WordPress isolated from each other for security. aahh - if it's just about showing WHMCS pricing on an external (e.g outside of WHMCS) site, then you could use Data Feeds for that. specifically, there are two for domain pricing - one that shows a TLD price for a specific period, currency, type (reg/tran) etc, and a more generic feed that creates a basic domain pricing table for all of your priced TLDs. I would suggest not using too many feeds of the first option on any single page (i'm thinking single figures ideally) as it can slow download times; and the second pricing table feed might need some CSS/coding work to match your WordPress design. there is also an undocumented separate domain pricing page within WHMCS itself - domain.com/(your whmcs directory)/domain/pricing/ (the actual url slightly depends on your Friendly URL settings) - which may or may not be of use to you at some point. 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.