evolve hosting

I'll step out of the discussion. It seemed like this was being over thought / over complicated.

I wasn't going to reply but my reason for asking him why he was asking all of these questions is because I thought they were already answered and/or self explanatory.

Why are you asking all of these questions? You would go through and manually renew any other domains that you wanted through the client portal afterwards. If you don't want to renew for any longer at the moment, you'll do nothing and wait until your annual invoice arrives the next year to renew again.

Which domain registrar are you using and how do you have this configured on the admin side of WHMCS?

You installed the module that OpenSRS themselves developed and maintain? I'd suggest contacting them for an update. https://help.opensrs.com/hc/en-us/articles/204237763-Install-and-use-the-OpenSRS-Domains-Pro-module-for-WHMCS Are they actively developing it or do you have an outdated module installed? https://marketplace.whmcs.com/product/2070-opensrs-domains-pro

They sort of serve 2 different purposes. Take a look at the docs for more details: https://docs.whmcs.com/PayPal_Basic https://docs.whmcs.com/PayPal_Checkout

Thank you for answering him. I couldn't figure out why he kept asking these same questions so I didn't answer.

If it's implemented properly, you don't need to worry about 'losing a valuable domain'. You'd set a date to send the invoice and the script would run a query on the database to fetch all domains with an expiration date within 365 days of the date to send the invoice. Am I missing something else?

I'm not a WHMCS coder but something along the lines of single_renew_date = mm/dd/ and expiration_date<= 365 days out ; however that would be translated into workable code

That's the problem. I don't want to give up that syncing feature for most of the customers. Another way would be to do it by client group but it also needs more granular controls. I doubt it could be done by writing a hook but maybe I'm wrong and it's possible?

Sorry I don't know the exact answer but I think it has to use the 'order' function. I never had any luck with the code you're trying to use (caused a site error too).

Is this for a domain, hosting, or other service? Does it have the right module assigned to the product and the correct choice selected under module settings for the product setup? If it's for a domain or ssl cert (or similar) do you have enough funds in your reseller account? Any fraud module enabled that might be restricting the processing of the renewal?

You should be able to use the Auto Release module. https://docs.whmcs.com/Auto_Release

You also need to look at your Automation settings. Domain Sync Enabled Sync Next Due Date Domain Sync Notify Only I haven't tried to adjust these very much but I'd like to. I think to make it work, WHMCS would need to add more granular control to the 'sync next due date' by allowing us to set this on a per customer basis. Does anyone have any further insight?

Does this table exist in your database? tblusers_clients