Changes

* Search the [https://members.pumpingstationone.org/mm/people/ member site]  for an existing profile using '''both''' the PayPal email address and the name found in the RT ticket.   

* Search the [https://members.pumpingstationone.org/mm/people/ member site]  for an existing profile using '''both''' the PayPal email address and the name found in the RT ticket.   

** Doing both searches is important as someone may have changed their name, for example in the case of marriage.  The PayPal payment email might also have changed and in this case, the RT ticket that is generated appears otherwise indistinguishable from a new subscription.   

** Doing both searches is important as someone may have changed their name, for example in the case of marriage.  The PayPal payment email might also have changed and in this case, the RT ticket that is generated appears otherwise indistinguishable from a new subscription.   

** Additionally, if a PayPal subscription becomes suspended, given our current PayPal product, it appears that we can reactivate the profile, but that is not the case.  Only with PayPal Pro can we manipulate (other than cancel) the member's PayPal subscription.  If the member follows the procedure outlined in the suspended subscription email, then they will create a new subscription.  In this case, we need to both reactivate the original member profile, and resolve the suspended RT ticket sitting in the deathrow queue.

** Additionally, if a PayPal subscription becomes suspended, given our current PayPal product, it appears that we can reactivate the profile, but that is not the case.  Only with PayPal Pro can we manipulate (other than cancel) the member's PayPal subscription.  If the member follows the procedure outlined in the suspended subscription email, then they will create a new subscription.  In this case, we need to both reactivate the original member profile, and resolve the suspended RT ticket sitting in the cancelled queue.

==== If an existing profile is found then: ====

==== If an existing profile is found then: ====

* Go to https://members.pumpingstationone.org/mm/member_list/ and change the Membership start date to the date of the new subscription

* Go to https://members.pumpingstationone.org/mm/member_list/ and change the Membership start date to the date of the new subscription

* Resolve the pending ticket(s) in Member Payments:deathrow if any

* Resolve the pending ticket(s) in Member Payments: cancelled if any

** Most new members will not have a ticket in deathrow. This would only occur if the member started a new membership to resolve a suspended subscription.

** Most new members will not have a ticket in cancelled. This would only occur if the member started a new membership to resolve a suspended subscription.

==== If no existing profile is found on the member's site:====

==== If no existing profile is found on the member's site:====

* PayPal subscription suspended for non-payment (the subscription charge was unsuccessful) usually due to an expired or change in credit card number, but the member has not updated PayPal to use the new card.  PayPal will generally send the suspension email about 10 days after the dues were to be collected.

* PayPal subscription suspended for non-payment (the subscription charge was unsuccessful) usually due to an expired or change in credit card number, but the member has not updated PayPal to use the new card.  PayPal will generally send the suspension email about 10 days after the dues were to be collected.

** RT ticket is automatically generated with a subject of the form: "Automatic payments from <PayPal profile name> were suspended"

** RT ticket is automatically generated with a subject of the form: "Automatic payments from <PayPal profile name> were suspended"

** Modify the RT ticket Subject field (Basics tab of the RT ticket) and append " - MM/DD>" where MM/DD is 3 days from the date of suspension.  Change the Status field to "deathrow" and click Save Changes.

** Modify the RT ticket Subject field (Basics tab of the RT ticket) and append " - MM/DD>" where MM/DD is 3 days from the date of suspension.  Change the Status field to "cancelled" and click Save Changes.

** From the Customer email field in the RT ticket, look up the member profile: https://members.pumpingstationone.org/mm/people/

** From the Customer email field in the RT ticket, look up the member profile: https://members.pumpingstationone.org/mm/people/

** Set the Membership status field to: Suspended

** Set the Membership status field to: Suspended

** Compare the Membership start date from the member profile with the most recent PayPal transaction.  Usually the day of the month should match, but sometimes the member is credited a few extra days when the onboarding process doesn't happen in a timely manner.  If the member profile day is no greater than a week after the PayPal transaction day of the month, then use the member profile day.  Otherwise use the PayPal transaction day.  In general, the PayPal subscription day is a better indicator of when dues are due, than the member profile, Membership start date.

** Compare the Membership start date from the member profile with the most recent PayPal transaction.  Usually the day of the month should match, but sometimes the member is credited a few extra days when the onboarding process doesn't happen in a timely manner.  If the member profile day is no greater than a week after the PayPal transaction day of the month, then use the member profile day.  Otherwise use the PayPal transaction day.  In general, the PayPal subscription day is a better indicator of when dues are due, than the member profile, Membership start date.

** The membership is valid until the end of the current subscription month (calculated as one month after the last PayPal transaction date, and possibly a few days after that as determined in the previous step).

** The membership is valid until the end of the current subscription month (calculated as one month after the last PayPal transaction date, and possibly a few days after that as determined in the previous step).

** Modify the RT ticket Subject field (Basics tab of the RT ticket) and append " - MM/DD>" where MM/DD is the membership end date.  Change the Status field to "deathrow" and click Save Changes.

** Modify the RT ticket Subject field (Basics tab of the RT ticket) and append " - MM/DD>" where MM/DD is the membership end date.  Change the Status field to "cancelled" and click Save Changes.

* Member requests cancellation by email

* Member requests cancellation by email

* Suspended account more than 2 weeks overdue  

* Suspended account more than 2 weeks overdue