CiviCRM Community Forums (archive)

Whenever someone makes a recurring (monthly) contribution to our organization, I'd like their membership (if they have one) to be current (as long as the recurring contribution continues).

Is there a way to do this in Civi?

Sorry for not being clear! The situation we have is:

1. An individual pays their $25 membership fee, and as a result their membership should be current for one year.

2. During that year, the member responds to a special appeal, and becomes a monthly donor - donating $10/month.

3. As long as the monthly donation continues, their membership should always remain current (so we need to use is_override).

Contributions could come in from many different contribution pages (or by cheque or other source), and the contributor may, and likely won't, have logged into the website before making the contribution.

As far as I can tell, there's no way to have a notification sent to someone whenever a new recurring contribution begins, so I'm wondering if there's a way to do it automatically.

I hope this makes things clearer - thanks Kurund!

Thanks Kurund. I don't think auto-renew will work in this case, but we may have a workaround.

This query will need to be modified to account for date ranges, but I think we're on the right track!

UPDATE civicrm_membership
JOIN civicrm_contribution
ON civicrm_membership.contact_id=civicrm_contribution.contact_id
SET civicrm_membership.is_override='1' AND civicrm_membership.status_id='2'
WHERE civicrm_contribution.contribution_type_id='23' OR civicrm_contribution.contribution_recur_id is not null;