Reward Points Module for ZC v13x

[pinetreecandles]

Sorry- I haven't been ignoring you lot- The other side of my job kicked in and I've been out on travels but I'm back now.

Top priority is to get to the bottom of the PayPal issue. I don't understand why the transaction type would affect how PayPal IPN redirects back to checkout_process.php. It's also interesting that GVs are also affected. I'm guessing that what ever the problem is it is affecting all the credit mods- I should have a better read this afternoon- I have just completed setting up my test rig with PayPal's Sandbox...

Watch this space.

Thanks for the update

[pinetreecandles]

Andy-

Here is some good news, at least for those of us who use 2checkout. I just ran a live test using 2checkout and everything worked as it should. Confirmation emails were sent and received and points went to pending. When I updated the order status, the points went to earned as they should.

I then made a purchase using points as well as credit card through 2checkout and again, every went as it should. Emails received and earned points removed as well as new points earned. Worked like a charm

The next test I'm going to do is pay with a paypal account via 2checkout and see what happens. A new feature they have is paying with your paypal account through 2checkout. I will report back with my results after.

[Berserker]

Hello,

No problems here with Protx.

[MeltDown]

Wow - Very well constructed and complete add-on! Installed and succesfully running it through the hoops on Zen version 1.3.6. (I have a manual credit card POS so no PayPal testing here)

Previously I had the shopping_cart_sidebox_with_checkout_button_and_product_image_1.1 add-on installed and was pleased with it. (It is a 1-page add-on that modifies tpl_shopping_cart.php) Because I didn't want to lose the image and checkout button in the sidebox I merged the modified tpl_shopping_cart.php with the tpl_shopping_cart_with_rewards.php from this add-on. After quite a bit of live-store testing in both IE and FF, the modification doesn't seem to have negatively influenced the Rewards add-on. If anyone is interested, here is the modified tpl_shopping_cart_with_rewards.php:

<?php
/**
 * Side Box Template for a shopping cart with reward points
 *
 * @package templateSystem
 * @copyright Copyright 2008 Andrew Moore
 * @copyright Portions Copyright 2003-2005 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 */
  $content ="";
  $reward_points=0;
  
  $content .= '<div id="' . str_replace('_', '-', $box_id . 'Content') . '" class="sideBoxContent">';
  if ($_SESSION['cart']->count_contents() > 0) {
  $content .= '<div id="cartBoxListWrapper">' . "\n" . '<ul>' . "\n";
    $products = $_SESSION['cart']->get_products();
    for ($i=0, $n=sizeof($products); $i<$n; $i++) {
      $content .= '<li>';
      if($products[$i]['products_priced_by_attribute'])
       $reward_points+=(GetRewardPoints($products[$i]['id'],$products[$i]['attributes'])*$products[$i]['quantity']);
      else
       $reward_points+=(GetRewardPoints($products[$i]['id'])*$products[$i]['quantity']);
      
      if (($_SESSION['new_products_id_in_cart']) && ($_SESSION['new_products_id_in_cart'] == $products[$i]['id'])) {
        $content .= '<span class="cartNewItem">';
      } else {
        $content .= '<span class="cartOldItem">';
      }

      $content .= $products[$i]['quantity'] . BOX_SHOPPING_CART_DIVIDER . '</span><a href="' . zen_href_link(zen_get_info_page($products[$i]['id']), 'products_id=' . $products[$i]['id']) . '">';

      if (($_SESSION['new_products_id_in_cart']) && ($_SESSION['new_products_id_in_cart'] == $products[$i]['id'])) {
        $content .= '<span class="cartNewItem">';
      } else {
        $content .= '<span class="cartOldItem">';
      }

      $content .= zen_image(DIR_WS_IMAGES . $products[$i]['image'], $products[$i]['name'], IMAGE_SHOPPING_CART_WIDTH, IMAGE_SHOPPING_CART_HEIGHT) . '<br>' . $products[$i]['name'] . '</span></a></li>' . "\n";

      if (($_SESSION['new_products_id_in_cart']) && ($_SESSION['new_products_id_in_cart'] == $products[$i]['id'])) {
        $_SESSION['new_products_id_in_cart'] = '';
      }
    }
    $content .= '</ul>' . "\n" . '</div>';
  } else {
    $content .= '<div id="cartBoxEmpty">' . BOX_SHOPPING_CART_EMPTY . '</div>';
  }

  if ($_SESSION['cart']->count_contents() > 0) {
    $content .= '<hr />';
    $content .= '<div class="cartBoxTotal">' . $currencies->format($_SESSION['cart']->show_total()) . '</div>';
    $content .= '<div class="cartBoxRewardPoints">' . (int)$reward_points . '&nbsp;' . PRODUCT_REWARD_POINT_TAG . '</div>';
    $content .= '<br class="clearBoth" />';
    $content .= '<a href="' . zen_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL') . '">' . zen_image_button(BUTTON_IMAGE_CHECKOUT, BUTTON_CHECKOUT_ALT) . '</a>';
  }

  if (isset($_SESSION['customer_id'])) {
    $gv_query = "select amount
                 from " . TABLE_COUPON_GV_CUSTOMER . "
                 where customer_id = '" . $_SESSION['customer_id'] . "'";
   $gv_result = $db->Execute($gv_query);

    if ($gv_result->RecordCount() && $gv_result->fields['amount'] > 0 ) {
      $content .= '<div id="cartBoxGVButton"><a href="' . zen_href_link(FILENAME_GV_SEND, '', 'SSL') . '">' . zen_image_button(BUTTON_IMAGE_SEND_A_GIFT_CERT , BUTTON_SEND_A_GIFT_CERT_ALT) . '</a></div>';
      $content .= '<div id="cartBoxVoucherBalance">' . VOUCHER_BALANCE . $currencies->format($gv_result->fields['amount']) . '</div>';
    }
  }
  $content .= '</div>';
?>

The store where this is installed is: BeadedLily

Thanks for such a great mod!!

[hem]

Wow - Very well constructed and complete add-on! Installed and succesfully running it through the hoops on Zen version 1.3.6. (I have a manual credit card POS so no PayPal testing here)

Hey, nice merge. Well done.

[MeltDown]

Hey, nice merge. Well done.

You can thank WinMerge for that - Great tool!

2 Questions: How do I make it so that all points automatically move to the earned category? (I have a manual POS so I'll have control over what gets processed )

And: I must have a setting wrong somewhere or something. My test client has earned 255 points. In the Customer Reward Points Admin I transferred all pending points to earned. However, if I login as that test client and attempt to redeem on a new purchase, the points are recognized but they have no value:

You may click to redeem any collected Reward Points. Your redeemed points will be applied to the total and reflected in your cart after to click continue.

Current Reward Points:255 points earned
Value of Redeemed Reward Points:0.00EUR
Redeem Reward Points:

Thanks for your help!

[hem]

Sheesh!!! I've spent nearly a day just trying to set PayPal up in Sandbox mode. I'm rapidly coming to the conclusion that the fault is PayPals.

[MeltDown]

And: I must have a setting wrong somewhere or something. My test client has earned 255 points. In the Customer Reward Points Admin I transferred all pending points to earned. However, if I login as that test client and attempt to redeem on a new purchase, the points are recognized but they have no value:


Thanks for your help!

Hello again - Any thoughts on why my earned points have no value if redeemed? I'm hoping it's not an indication of greater issues

You may click to redeem any collected Reward Points. Your redeemed points will be applied to the total and reflected in your cart after to click continue.

Current Reward Points:255 points earned
Value of Redeemed Reward Points:0.00EUR
Redeem Reward Points:

Thanks for any comments

[hem]

Hello again - Any thoughts on why my earned points have no value if redeemed? I'm hoping it's not an indication of greater issues



Thanks for any comments

You need to set a Global Redeem Points ratio- Yours is currently set to 0- hence no redeem value.

[MeltDown]

You need to set a Global Redeem Points ratio- Yours is currently set to 0- hence no redeem value.

That did the trick - This mod continues to function beautifully, despite its complexities!