Answers.Body: <p>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.</p>
  <p>How I did for Paypal Standard is</p>
  <ol>
  <li><p>Updated the subscription amount at Paypal.</p>
  </li>
  <li><p>Using sql queries</p>
  <p>2.1 Update the total_amount in contribution recur table</p>
  </li>
  </ol>
  <p><strong>For Single Line item:</strong></p>
  <pre><code>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;
  </code></pre>
  <p><strong>For Multiple Line item:</strong></p>
  <pre><code>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;
  </code></pre>
  <p>HTH</p>
  <p>Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-01-28T06:53:37.893Z
Answers.Text: Thanks.  a) Both step 3's are missing something: there is nothing created, just an id is found.  b) is not possible (and safer) to do this via API?  If not, that seems like a gap in the API.
Answers.UserDisplayName: Aidan
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-01-28T11:11:08.357Z
Answers.Text: It may be possible to use API4 to do above as per my queries but you wont be able to do using api3. Also it would be any problem if we use COntribution api3 or api4 incase of single line item. But multiple line item i doubt hence i choose sql queries
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-01-27T22:14:38.557Z
Answers.LastActivityDate: 2022-01-27T22:14:38.557Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>Scenario is a membership / subscription. The amount to be charged has increased.</p>
  <p>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</p>
  
Tags: <civimember><recurring-contributions><paypal>
Title: What are the steps for changing the amount for a recurring payment when using PayPal - Website Payments Standard
ThreadText: # What are the steps for changing the amount for a recurring payment when using PayPal - Website Payments Standard
  
  (Asked by: username_0 on 2022-01-27)
  
  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
  
  **Tags:** civimember, recurring-contributions, paypal
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-01-27. Score: 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
  
  Updated the subscription amount at Paypal.
  
  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
  
  > **Comments:**
  > **username_2**: Thanks.  a) Both step 3's are missing something: there is nothing created, just an id is found.  b) is not possible (and safer) to do this via API?  If not, that seems like a gap in the API.  
  > **username_1**: It may be possible to use API4 to do above as per my queries but you wont be able to do using api3. Also it would be any problem if we use COntribution api3 or api4 incase of single line item. But multiple line item i doubt hence i choose sql queries  
  
  ---
  
  