What are the steps for changing the amount for a recurring payment when using PayPal - Website Payments Standard

Question

Scenario is a membership / subscription. The amount to be charged has increased.

Does this require the amount to be updated just at the PayPal end, or are changes also needed at the civi end to ensure that the new amount is specified in the receipt which civi sends out

Answer 1

Depends upon the recurring contribution, if the recurring contribution has a single line item for membership type than its not needed if not then yes its needed so that the line items for subsequent payment are added correctly.

How I did for Paypal Standard is

1. Updated the subscription amount at Paypal.

2. Using sql queries

   2.1 Update the total_amount in contribution recur table

For Single Line item:

1. Find for the template contribution: 
     SELECT id FROM civicrm_contribution 
     WHERE contribution_recur_id = 123
       AND is_template = 1
     ORDER BY id DESC
2. If found update the total_amount field for the contribution and line item line total
    UPDATE civicrm_contribution
    SET total_amount = 100
    WHERE id = 122;

    UPDATE civicrm_line_item
    SET line_total = 100
    WHERE contribution_id = 122;
3. Incase there isn't the template contribution create one using the last contribution for recurring contribution and also line item.
     SELECT id FROM civicrm_contribution 
     WHERE contribution_recur_id = 123
     ORDER BY id DESC;

For Multiple Line item:

1. Find for the template contribution: 
     SELECT id FROM civicrm_contribution 
     WHERE contribution_recur_id = 123
       AND is_template = 1
     ORDER BY id DESC
2. If found update the total_amount field for the contribution and line item line total
    UPDATE civicrm_contribution
    SET total_amount = 120
    WHERE id = 122;

    UPDATE civicrm_line_item
    SET line_total = 100
    WHERE contribution_id = 122 AND membership_type_id = 2; 

3. Incase there isn't the template contribution create one using the last contribution for recurring contribution and also line item.
     SELECT id FROM civicrm_contribution 
     WHERE contribution_recur_id = 123
     ORDER BY id DESC;

HTH

Pradeep