Chris74 Posted July 6, 2013 Share Posted July 6, 2013 (edited) Hi I've just imported our customers from a different system and I'm having a few problems. Firstly, it seems that there were quite a few domains in our old system that had been moved away, but were still in the database. These got imported into WHMCS. When the cron ran, it generated a load of invoices for these domains with the due date of 00/00/0000. So I can easily identify and remove the invoices, based on their due date - but there are too many of them to view each invoice manually and delete each domain. The importer script seems to have set all domains to auto invoice. So there are a couple of things I need to do. 1. Set all domains in the database to not auto invoice. We can then ask the customers to switch that on if they want. Does anyone know the mysql syntax to do that in a query? 2. I'd like to identify the domains that shouldn't be there. It seems the domainsync cron can identify these, but it doesn't do anything about them. You'd think it would simply add a to do item to investigate each domain that cannot be found at the registrar - or set the domain to some status so that it can be easily identified. It doesn't seem to do anything. Does anyone know how I can clean this up? I'd really appreciate your advice. Thank you. Edited July 6, 2013 by Chris74 0 Quote Link to comment Share on other sites More sharing options...
Chris74 Posted July 7, 2013 Author Share Posted July 7, 2013 In the end I ran the domainsync cron every minute until it had been through all domains. I then then searched the report emails for the word "Error:" and manually copy pasted all the errored domains into a list. That was the only way I could find to do it. It would be good if WHMCS could create a "To Do" item if it finds a domain that errored during the domain sync cron - then we could be prompted to investigate these, instead of having to look at the cron report manually. 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted July 8, 2013 WHMCS Support Manager Share Posted July 8, 2013 Hi, That's probably the best way to do it, the domain sync script runs batches of 50 so not to overload your domain registrar, you can schedule it to run several times per day. We welcome suggestions for new features at http://requests.whmcs.com 0 Quote Link to comment Share on other sites More sharing options...
hostservice_71 Posted May 7, 2014 Share Posted May 7, 2014 We welcome suggestions for new features at http://requests.whmcs.com Just came across this thread and wondered if this had been implemented already, 3/4 of a year later? I just discovered the sync-cron and started using it today, relying heavily on it after 10 years of AWBS experience where this was a default check 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.