Reward Point Mod beta now available

[gransazer]

Try copying and pasting the contents of the install.sql file to Admin->Tools->Install SQL Patches but skip the RENAME on the first line- That should sort the problem.

i already try many time, still got this problem or should i re-install ?

[fiji]

Fiji- can you give me the steps and I try and recreate it- Also when you look at the customer list- Is the Redeem Ratio showing up against any customer with Group Pricing set to ---None---???

Andrew,
I just did it again in the flash clean 138a copy.
There are some problems I met.
I will upload some picture below.

[fiji]

Fiji- can you give me the steps and I try and recreate it- Also when you look at the customer list- Is the Redeem Ratio showing up against any customer with Group Pricing set to ---None---???

1. Copy all php file (included two new files) to my store.
2. patch SQL in the zip file and Patch second SQL which you updated.
3. admin-order total - install two mod
3. active two sidebox
4. create a new user to order a product
5. fist time order, I changed the order to delivered, so the pending point changed to 50 points earned.
6. place second order, I couldn't use the 50 points in my account. <see picture 1,2,3>
7. in the "my account", no point display box. <see pic 4>

Any idea?

Regards

[Berserker]

The global redeem is the redeem value of all products that are not within Group Pricing. If you want a global switch off- set this to 0.

And yes, reward points in Admin is now available. Admin->Customers->Reward Points.

Excellent! Time to install it then :)

[hem]

1. Copy all php file (included two new files) to my store.
2. patch SQL in the zip file and Patch second SQL which you updated.
3. admin-order total - install two mod
3. active two sidebox
4. create a new user to order a product
5. fist time order, I changed the order to delivered, so the pending point changed to 50 points earned.
6. place second order, I couldn't use the 50 points in my account. <see picture 1,2,3>
7. in the "my account", no point display box. <see pic 4>

Any idea?

Regards

Fiji- Can you do me a favour and go to Admin->Customers->Group Rewards and make sure that the Global Redeem value is set, thanks.

[NullMind]

I try to use this code on the cart sidebox

if ($_SESSION['cart']->count_contents() > 0) {
$content .= '<hr />';
$content .= '<div class="cartBoxTotal">' . $currencies->format($_SESSION['cart']->show_total()) . '</div>';


// reward points starts
$reward_points=0;

$content='<div id="'.str_replace('_', '-', $box_id . 'Content').'" class="sideBoxContent">';
foreach($_SESSION['cart']->get_products() as $product)
$reward_points+=GetRewardPoints($product['id'])*$product['quantity'];

if($reward_points>0)
$content.='<div class="cartBoxRewardPoints">'.(int)$reward_points.'&nbsp;'.REWARD_POINTS_IN_CART _TAG.'</div>';
else
$content.='<div id="cartBoxEmpty">'.NO_REWARD_POINTS_IN_CART_TAG.'</div>';
if(isset($_SESSION['customer_id'])) $content.='<div class="cartBoxEarnedPoints">'.GetCustomersRewardPoints($_SESSION['customer_id']).'&nbsp;'.CUSTOMER_EARNED_POINT_TAG.'</div><div class="cartBoxPendingPoints">'.GetCustomersPendingPoints($_SESSION['customer_id']).'&nbsp;'.CUSTOMER_PENDING_POINT_TAG.'</div>';
else
$content.='<div id="cartBoxEmpty">'.CUSTOMER_NOT_LOGGED_IN_TAG.'</div>';
$content.='</div>';
// reward points end


$content .= '<br class="clearBoth" />';
}

but while it shows the reward points, it makes the cart content disapeer .. any ideas how I can do this ?

[NullMind]

Ok, I get the following errors

Admin->Catalog->Reward Points:

Fatal error: Call to undefined function getrewardpointrecord() in /.../admin/reward_points.php on line 125

Customers - > Reward Points

Fatal error: Call to undefined function cleanuprewardpointhistory() in /.../customers_reward_points.php on line 25

Group rewards redeem

Fatal error: Call to undefined function getrewardpointrecord() in /.../admin/group_reward_points.php on line 132

[NullMind]

one more, when removing an order, I get

Fatal error: Call to undefined function deleteorderrewardpoints() in /.../orders.php on line 168

[NullMind]

Interim fix #2. This will handle the calculation of reward points for discounted/specials and free items.

Unzip the attached file into includes\functions\extra_functions

Then copy and paste the following into Admin->Tools->Install SQL Patches:

SET @group_id = '';
SELECT (@group_id := `configuration_group_id`) FROM `configuration_group` WHERE `configuration_group_title` LIKE 'Reward Points';

REPLACE INTO `configuration` 
(`configuration_id` ,`configuration_title` ,`configuration_key` ,`configuration_value` ,`configuration_description` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)
VALUES (NULL , 'Adjust Reward Points for Sales/Specials', 'REWARD_POINTS_SPECIAL_ADJUST', '0', 'How to calculate Reward Points<br />0= Always use the base price.<br />1= Use price less Discounts and Specials.', @group_id, '7', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');

REPLACE INTO `configuration` 
(`configuration_id` ,`configuration_title` ,`configuration_key` ,`configuration_value` ,`configuration_description` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)
VALUES (NULL , 'Allow Reward Points on Free Products', 'REWARD_POINTS_ALLOW_ON_FREE', '0', 'Set how points are rewarded for free products.<br />0= Free products give 0 Reward Points.<br />1= Allow Reward Points on free products.', @group_id, '8', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');

This will add two more config items to Admin->Configuration->Reward Points

Andrew

I found that it's when I use this file that I get all the undefined errors

any ideas ?

[hem]

Andrew

I found that it's when I use this file that I get all the undefined errors

any ideas ?

you've copied the reward_points_function.php into your Admin- It's supposed to go into the Catalog side.