[SOLVED] send email to member when credit card expires with ARB?

It's the expiration date of the subscription as CBSubs sees it. That's basically as good as it's going to get from CBSubs perspective.

maybe I don't understand how CBsubs works with ARB actually. Can an ARB have an expiration date farther out than 1 year if the subscription is for only 1 year? I thought the expiration date moved every year as the ARB was automatically paid but the expiration date of the credit card dictated how many of these would occur. So, that means the expiration date in CBsubs may be moved out another year if there's still time on the ARB.

When a renewal payment is received CBSubs will extend their current subscription by the duration of the plan. If a renewal is not received it'll expire on their expiration date. If the gateway uses scheduled API in CBSubs instead if IPNs and CBSubs fails to make a payment it won't renew and will expire on their expiration date otherwise the renewal will extend it by the duration of the plan.

ok, so in that case there is no way to know when the ARB will truly expire and thus email the user beforehand as I'd like. It sounds like the only way to handle this is to simply let the user expire. Thanks

There is one last possibility I just thought of (with Authorize.net): The only place where the credit-card expiration date (without credit-card number of course) might be stored is in the corresponding payment subscription notification at the first payment. By exploring that table in PhpMyAdmin you might be able to find it. But there you are on your own to find a corresponding SQL query, as the information is probably inside a logging field, without guarantee that the format stays the same in future versions.

However this will never cover the case where the card's credit doesn't allow a payment, or the card is cancelled before expiration.

Authorize.net AIM is our only gateway where that card expiration date information may be available in the history logs. We replace the card number by XXXX's in all logs as required by PCI-DSS standards. Just as a reminder (I'm sure Authorize.net already required that: With Authorize.net AIM method, your server must be PCI-DSS certified.

as a request, could you somehow set the credit card expiration date as a field in cbsubs? That way we could use it to auto-send an email explaining that the subscription with corresponding CC will end at which time a new subscription will need to be paid for. Or, we, as a company, may wish that they call us so we can manually replace expiring CC with a new card in the ARB so that the current subscription will continue without interruption.