CiviCRM Community Forums (archive)

I’m trying to work out how to do membership renewals using Google Checkout.   

There are two fees to our membership payment system:–
      (1)   Membership type which is either ordinary or joint.
      (2)   An optional insurance fee

I thought I could achieve this using  [CiviCRM  » CiviContribute  » Manage Contribution Page  » Membership Settings] and ticking the “Separate Membership Payment” box.

The Separate Membership Payment should do this:

If this option is checked AND the contribution page includes a separate contribution amount block - two transactions will be generated: one for the membership fee amount; and one for the selected contribution amount. (This option is NOT available for PayPal Website Payments Standard.)

So, when I configure Contribution Amounts I get a membership sign up page which offers radio buttons depending on what membership the contact wants to take and another set of radio buttons depending on what insurance they want.

(http://bec-cave.org.uk/temp/CCP1.JPG)

Selecting Ordinary Membership and Insurance and pressing the Continue button links to a summary and the Google Checkout button.

(http://bec-cave.org.uk/temp/CCP2.JPG)

Separate Membership Payment was not being picked up by Google Checkout and only the first amount was being presented for billing. I got around this by editing civicrm/CRM/Core/Payment/Google.php by adding $item2.

        //Create a new shopping cart object
        $merchant_id  = $this->_paymentProcessor['user_name'];   // Merchant ID
        $merchant_key = $this->_paymentProcessor['password'];    // Merchant Key
        $server_type  = ( $this->_mode == 'test' ) ? 'sandbox' : '';
       
        $cart =  new GoogleCart($merchant_id, $merchant_key, $server_type);
        $item1 = new GoogleItem($params['item_name'],'', 1, $params['amount'], $params['currencyID']);
        $cart->AddItem($item1);

        //$cart  =  new GoogleCart($merchant_id, $merchant_key, $server_type);
        $item2 = new GoogleItem($params['item_name'],'', 2, $params['amount'], $params['currencyID']);
        $cart->AddItem($item2);
This works as far as sending the correct amount to Google but the contribution saved in CiviContribute only picks up the first amount. Also , when the value of the contribution is zero, then the Google Checkout button is not displayed.

So... Questions:

1. How can I get CiviContribute to record all the contributions?
2. How do I discard Contributions with zero value from the cart?
3. Is it possible to get the contribution label to show on the summary screen instead of "Contribution Amount"?
4. When the data is passed to Google Checkout to process the items show up as "Online Contribution-Name of Contribution Page". Could this also append the contribuition label? eg Subs, Insurance, Magazine Subscription etc.
5. Is there another way of achieving this? I investigated a new domain and membership type for insurance but it didn't fly.

The "Separate Membership Transaction" warning should read as "This option is NOT supported for PayPal Website Payments standard AND google checkout). Both these methods are callback based methods and doing two transactions is more complicated and hence we've skipped it.

Can u check and test if this works without the seperate payment membership option. i.e. we clump both the amounts in one amount

thanx

lobo

Also a side effect of this is that the contribution amounts need to also include the membership fee. This means that a member has to choose there membership level (of which there are 7) and then their other fee uplifts. With 2 fee uplifts that means I need 14 price options. With 3 price uplifts it gets even more complicated.

Separate payments would clearly be slicker here. I could go for other payment processors but Google pricing is very sharp (free until 2008 and then far less the PayPal).

Chatting with Lobo about this - and we're not currently planning to support separate payments for the "callback-based" processor options as they're much more complicated to deal with and hard to debug etc. Hopefully Google will move to offering an API based solution in the near future :-)

I'm also puzzling over these two problems.
1) How do you deal with one person paying for a "Joint Membership"?

2) How do you stop people applying for memberships which there not entitled to? (We have a load of Life members from a funding raising exercise many many years ago).   Would be nice if there were some rules around this. For instance if a probationary member was renewing they would only be offered that membership level.

1) Currently, you can create memberships that cover "related contacts" - and offer those online. However, you would have to manually add the related contact / relationship (perhaps based on some custom fields that you add via a profile on the signup page).

2) I think there's quite a bit of room for improvement / additional functionality in CiviMember's "online renewal" feature. It would be great if you would help push this forward by detailing out requirements on the "Phase 2 specifications" page ( http://wiki.civicrm.org/confluence//x/uzI ) -  and then getting some  discussion going with other CiviMember users to help validate / generalize the approach and options.

I've worked out that I can filter the Memberships Renewal to only show the contacts current membership by adding this:

    {if $row.current_membership AND $context EQ "makeContribution"}
        ....
    {/if}

civicrm\templates\CRM\Contribute\Form\Contribution\MembershipBlock.tpl

        <table id="membership-listings" class="no-border">
        {foreach from=$membershipTypes item=row }
           {if $row.current_membership AND $context EQ "makeContribution" }
           <tr {if $context EQ "makeContribution" OR $context EQ "thankContribution" }class="odd-row" {/if}valign="top">
               {if $showRadio }
                   {assign var="pid" value=$row.id}
                   <td>{$form.selectMembership.$pid.html}</td>
               {/if}
              <td>
                   <strong>{$row.name}</strong><br />
                   {$row.description} &nbsp;
                   {if ($membershipBlock.display_min_fee AND $context EQ "makeContribution") AND $row.minimum_fee GT 0 }
                       {if $is_separate_payment OR ! $form.amount.label}
                           {ts 1=$row.minimum_fee|crmMoney}(membership fee - %1){/ts}
                       {else}
                           {ts 1=$row.minimum_fee|crmMoney}(contribute at least %1 to be eligible for this membership){/ts}
                       {/if}
                   {/if}
                       
              </td>
           
               <td>
                 {if $row.current_membership AND $context EQ "makeContribution" }
                  <br /><em>{ts 1=$row.current_membership|crmDate 2=$row.name}Your current <strong>%2</strong> membership expires on %1.{/ts}</em>
                 {/if}
              </td>
           </tr>
      {/if}        
        {/foreach}

Now the contact is only offered the option of renewing the membership they currently have. However...the tricky bit is filtering the contributions to only show the ones relevant to that membership level. I thought I could do this in the templates as well but on investigation it doesn't look so easy. Where does the array for the Fixed Contribution Options get built?

Thanks Dave, That's exactly what I was after!!