Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

[mvstudio]

Hello. I've upgraded to the newest version thinking it would fix the issues I had but they didn't get resolved with the upgrade.

1) If customer uses his/her reward points to pay for the order, the reward points given for that order are 0. Is there any way to give reward points to the customer on scenarios like this?
2) If customer uses his/her reward points to pay for the order, there is a difference of exactly $0.01 cent added to the total value of points used. Example below.

Subtotal: $33.30
Shipping: $6.00
Membership discount: -$3.33
Value of Reward Points: -$29.98 <- should be -$29.97
Total: $5.99 <- should be $6.00

I'm not using edit orders.
If anyone could shed some light on these issues I would really appreciate it.

[Shiftypow]

Hi, I am looking to introduce a points system to our site. What I want to do is when I sell a bike you get so many points to put towards accessories. Is there a way to do it in a points way or is it always physical money? An example someone buys a bike you get 30 points to spend. so you could spend e.g 15 on shoes etc.............

[EmmaThePoly]

Hello, I was wondering if there would be a way to view how many points a customer has on their account by going to the 'my account' page? Is there a PHP script I can use to call the value? Thanks :)

[lindasdd]

Hi, I am looking to introduce a points system to our site. What I want to do is when I sell a bike you get so many points to put towards accessories. Is there a way to do it in a points way or is it always physical money? An example someone buys a bike you get 30 points to spend. so you could spend e.g 15 on shoes etc.............

Isn't the point spending scenario you described the same as 'physical money'?

[lindasdd]

Hello, I was wondering if there would be a way to view how many points a customer has on their account by going to the 'my account' page? Is there a PHP script I can use to call the value? Thanks :)

This isn't built in.

I wanted the same thing so I created it. I can give you some basics, but keep in mind this is specific to the Tableau template.

Also keep in mind I am not a 'programmer'. I hacked this together. It has been working for a couple months with no error logs, but it could be garbage

Here is a quick run down for my site: :

1) add the link to the My Account Page
on includes\templates\tableau\templates\tpl_modules_account_menu.php insert the following after line 11:
<li class="communications"><?php echo ' <a href="' . zen_href_link(FILENAME_ACCOUNT_REWARDS, '', 'SSL') . '">' . MY_ACCOUNT_REWARDS . '</a>'; ?></li>


2) In includes\languages\english\extra_definitions\account.php
Add something like the following after line 23:
define('MY_ACCOUNT_REWARDS','Rewards/Store Credit');

3) Create a file includes\templates\tableau\templates\tpl_account_rewards_default.php and put this in it:
<?php
/**
* Page Template
*
* Loaded automatically by index.php?main_page=account_rewards.<br />
* View or change Customer Account Information
*
* @package templateSystem
* @copyright Copyright 2003-2005 Zen Cart Development Team
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: tpl_account_rewards_default.php 3848 2006-06-25 20:33:42Z drbyte $
* @copyright Portions Copyright 2003 osCommerce
*/
?>
<div class="centerColumn" id="accountPassword">

<h1 class="back"><?php echo HEADING_TITLE; ?></h1>
<div class="required alert forward"><?php echo FORM_REQUIRED_INFORMATION; ?></div>

<?php require($template->get_template_dir('tpl_modules_account_menu.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_account_menu.php'); ?>

<div class="account-info-wrapper">


<fieldset>
<legend><?php echo REWARD_POINT_TITLE; ?></legend>
<?php
$total_points=getCustomersRewardPoints($_SESSION['customer_id']);
if(defined(MODULE_ORDER_TOTAL_REWARD_POINTS_STATUS) && MODULE_ORDER_TOTAL_REWARD_POINTS_STATUS==true)
{
$redeem_ratio=GetRedeemRatio($_SESSION['customer_id']);
$points_value=$currencies->format($total_points*$redeem_ratio);
}
else
if(defined(MODULE_ORDER_TOTAL_REWARD_POINTS_DISCOUNT_STATUS) && MODULE_ORDER_TOTAL_REWARD_POINTS_DISCOUNT_STATUS==true)
{
$row=GetRewardPointDiscountRow($total_points);
$value=($row!=null?$row['discount']:0);

if(MODULE_ORDER_TOTAL_REWARD_POINTS_DISCOUNT_TYPE==0)
$points_value=$value."%";
else
$points_value=$currencies->format($value);
}

echo '<label class="inputLabel">'.REWARD_POINT_PROMPT.'</label>'.'<label class="inputLabel">'.$total_points.'</label>';
echo '<br class="clearBoth" />';
echo '<label class="inputLabel">'.REWARD_POINT_VALUE_PROMPT.'</label>'.'<label class="inputLabel">'.$points_value.'</label>';
echo '<br class="clearBoth" />';
echo '<a href="https://www.lindasdietdelites.com/pages/rewards-48.html">Rewards Info</a>';
?>
<br class="clearBoth" />
</fieldset>
</div>
</div>

4) Make sure includes/extra_datafiles/reward_points_filenames.php includes the following:
define('FILENAME_ACCOUNT_REWARDS','account_rewards');

5) Create a folder includes/modules/pages/account_rewards

6) Create a file includes/modules/pages/account_rewards/header_php.php and put this in it:

<?php
/**
* Header code file for the Account History page
*
* @package page
* @copyright 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
* @version $Id: header_php.php 3160 2006-03-11 01:37:18Z drbyte $
*/
// This should be first line of the script:
$zco_notifier->notify('NOTIFY_HEADER_START_ACCOUNT_REWARDS');


if (!$_SESSION['customer_id']) {
$_SESSION['navigation']->set_snapshot();
zen_redirect(zen_href_link(FILENAME_LOGIN, '', 'SSL'));
}

require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
$breadcrumb->add(NAVBAR_TITLE_1, zen_href_link(FILENAME_ACCOUNT, '', 'SSL'));
$breadcrumb->add(NAVBAR_TITLE_2);


// This should be last line of the script:
$zco_notifier->notify('NOTIFY_HEADER_END_ACCOUNT_REWARDS');
?>

7)

[Shiftypow]

I have installed the mod and set up the points what works absolutely great but I have a few questions. When I bought an item and got points as a pretend customer I couldn't spend them straight away? Is there a way to change this at all? Also in the admin section I had to assign the pretend customer a "pricing group" for the reward points is this correct or am I doing it wrong? Finally last question when I logged back in as a customer once I had been given the points I tried to get an item purely with my points but it would not allow me and said I had to choose a payment option can this be bypassed also? Thank you

[DragonLady]

I just installed this, and it *seems* to be working fine. But I'm a bit fuzzy about how to set it so 25 points = $1.00 off the subtotal only?

Also, what happens when the old reward transaction period ends? Do those points just "expire"? If so, does the customer get a warning notice before it happens?

[hubert]

Hello,

I had an old version installed on ZC 1.5.0, as I'm in the process of upgrading to 1.5.4, I've installed the 2.5e version.
I didn't do any deep testing but as far as I've been I have a calculation problem.

My checkout confirmation page shows me :
$70.25 | Sub-Total:
-$2.30 | Value of Redeemed Reward Points:
$5.20 | FL TAX 7.0%:
$7.77 | Tip:
$4.00 | Delivery Area (Green Zone):
$84.92 | Total:
68 Reward Points earned:

Of course my subtotal is right, then why my taxes are 5.20 ?
Tax 70.25*0.07 = 4.9175

Let's imagine tax are on subtotal-points, i.e. 70.25-2.30=67.95
67.95*0.07=4.7565

Let's do that math the other way
5.20/0.07=74,285714286

I don't see any combination of 70.25+ ?? that gives me 74.28.

Points earned are ok since you get points on SubTotal-Points 70.25-2.30=67.95 rounded = 68.

Taxes should be calculated on the same amount, no ? so taxes should be (70,25-2,3)*0,07= 4.7565 and not 5.20.
If I try with delivery
(67,95+4)*0,07 = 5.0365
with tip
(67,95+7,77)*0,07 = 5.30


What I would line is point and taxes calculated on SubTot-RedeemedPoints cause there's no taxe on tips neither on delivery.
So my checkout should be
$70.25 | Sub-Total:
-$2.30 | Value of Redeemed Reward Points:
$4.76 | FL TAX 7.0%:
$7.77 | Tip:
$4.00 | Delivery Area (Green Zone):
$84.48 | Total:
68 Reward Points earned:


I'm lost.

[hubert]

Hello,

I had an old version installed on ZC 1.5.0, as I'm in the process of upgrading to 1.5.4, I've installed the 2.5e version.
I didn't do any deep testing but as far as I've been I have a calculation problem.

My checkout confirmation page shows me :
$70.25 | Sub-Total:
-$2.30 | Value of Redeemed Reward Points:
$5.20 | FL TAX 7.0%:
$7.77 | Tip:
$4.00 | Delivery Area (Green Zone):
$84.92 | Total:
68 Reward Points earned:

Of course my subtotal is right, then why my taxes are 5.20 ?
Tax 70.25*0.07 = 4.9175

Let's imagine tax are on subtotal-points, i.e. 70.25-2.30=67.95
67.95*0.07=4.7565

Let's do that math the other way
5.20/0.07=74,285714286

I don't see any combination of 70.25+ ?? that gives me 74.28.

Points earned are ok since you get points on SubTotal-Points 70.25-2.30=67.95 rounded = 68.

Taxes should be calculated on the same amount, no ? so taxes should be (70,25-2,3)*0,07= 4.7565 and not 5.20.
If I try with delivery
(67,95+4)*0,07 = 5.0365
with tip
(67,95+7,77)*0,07 = 5.30


What I would line is point and taxes calculated on SubTot-RedeemedPoints cause there's no taxe on tips neither on delivery.
So my checkout should be
$70.25 | Sub-Total:
-$2.30 | Value of Redeemed Reward Points:
$4.76 | FL TAX 7.0%:
$7.77 | Tip:
$4.00 | Delivery Area (Green Zone):
$84.48 | Total:
68 Reward Points earned:


I'm lost.

I'm answering myself, and first sorry guys, Reward Point was not the culprit. The thing is the tax class parameter of each shipping and order total module appearing in the invoice, in fact everything which is not to be included in tax calculation has to have its tax class to None.

Thanks myself

[hubert]

Hello,

I've just notice a problem and I would like to know if it's my ZC 1.5.4 doing that or a general behavior.

Just login, build a cart then go to checkout and ask for reward points rebate, go till checkout confirmation but don't confirm, then go back to your cart and back to checkout.

On step 2, the Your frame show total with the reward points from your previous run, and then the reward points frame shows available points on this new Sub-Total. If you go to step 3, everything goes back to normal, i.e. the reward points are not over-calculated but in step 2 the infos given are wrong.

Let me give you the scenario,
-Run 1-
you buy $100, you have enough to get 20 % (the max) reward points rebate.
Checkout step 2 shows you that you're eligible to 20$ reward points rebate.
You ask for your rebate and go to step 3.
-Run 2-
On step 3 you don't confirm the order but instead you go back...say to a product page.
You go to checkout.
On checkout step 2 the Your total frame shows (Sub-Total) 100 - (Reward points) 20 (= 80)
The reward points frame show $ 16 rebate available (which is 20% of 80).
___

If you let the checkbox checked (I'm in automatic mode), on step three you get back to 100-20.
If you uncheck the box, you get 100 with no reward points at all.

Do you have the same behavior on your site ?