Reward Point Mod beta now available

question, we have a brick and mortar shop, people can come in and buy stuff and we tie it to their account via the EPOS .. but their order will end on a different category

will the points only be rewarded to orders on ONE category ? can we setup two ?

Andrew,

Thanks for your hard work

1. Global Redeem group is still not working from my test, does anyone else test it yet?
2. discounted/specials is fixed. It's working.

Regards

NullMind:

hoo, I was about to buy Xrewards ... but now I think i'll wait for this one :D

When do you think it will be ready for a live store ?

Round about now, if no other problems show up and no-one thinks there's a show-stopper feature missing.

fiji:

Andrew,

Thanks for your hard work

1. Global Redeem group is still not working from my test, does anyone else test it yet?
2. discounted/specials is fixed. It's working.

Regards

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---???

Hi,

I just install this modules and found this error :

a. customer > reward points and the error shown
" 1054 Unknown column 'cp.pending_points' in 'field list'
in:
[UPDATE riz_reward_customer_points cp, riz_reward_point_history rp SET cp.pending_points=cp.pending_points-IFNULL((SELECT SUM(rp.reward_points) FROM riz_reward_point_history rp WHERE cp.customers_id=rp.customers_id AND rp.status=0 AND rp.dateIf you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields."

b. and when i click continue checkout button the error show

"1054 Unknown column 'redeem_ratio' in 'field list'
in:
[SELECT redeem_ratio FROM riz_reward_master prp, riz_customers as c, riz_group_pricing as gp WHERE c.customers_id=1 AND gp.group_id=c.customers_group_pricing AND ((prp.scope_id=1 AND prp.scope=4) OR (gp.group_id=c.customers_group_pricing AND prp.scope_id=gp.group_id AND scope=3) OR (prp.scope=0)) ORDER BY prp.scope DESC LIMIT 1;] "

so... anyone can help.

tq

What is the Global Redeem group for? If I turn that to off, will people not be able to redeem against their purchases?

Also, am I able to award points from Admin now?

Thank you

gransazer:

Hi,

I just install this modules and found this error :

a. customer > reward points and the error shown
" 1054 Unknown column 'cp.pending_points' in 'field list'
in:
[UPDATE riz_reward_customer_points cp, riz_reward_point_history rp SET cp.pending_points=cp.pending_points-IFNULL((SELECT SUM(rp.reward_points) FROM riz_reward_point_history rp WHERE cp.customers_id=rp.customers_id AND rp.status=0 AND rp.dateIf you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields."

b. and when i click continue checkout button the error show

"1054 Unknown column 'redeem_ratio' in 'field list'
in:
[SELECT redeem_ratio FROM riz_reward_master prp, riz_customers as c, riz_group_pricing as gp WHERE c.customers_id=1 AND gp.group_id=c.customers_group_pricing AND ((prp.scope_id=1 AND prp.scope=4) OR (gp.group_id=c.customers_group_pricing AND prp.scope_id=gp.group_id AND scope=3) OR (prp.scope=0)) ORDER BY prp.scope DESC LIMIT 1;] "

so... anyone can help.

tq

Which version did you download (it's in the readme.txt file).

Berserker:

What is the Global Redeem group for? If I turn that to off, will people not be able to redeem against their purchases?

Also, am I able to award points from Admin now?

Thank you

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.

hem:

Which version did you download (it's in the readme.txt file).

i think latest version (1.0.3b)

gransazer:

i think latest version (1.0.3b)

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.

hem:

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 ?

hem:

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.

hem:

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
4. active two sidebox
5. create a new user to order a product
6. fist time order, I changed the order to delivered, so the pending point changed to 50 points earned.
7. place second order, I couldn't use the 50 points in my account. <see picture 1,2,3>
8. in the "my account", no point display box. <see pic 4>

Any idea?

Regards

hem:

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 :)

fiji:

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
4. active two sidebox
5. create a new user to order a product
6. fist time order, I changed the order to delivered, so the pending point changed to 50 points earned.
7. place second order, I couldn't use the 50 points in my account. <see picture 1,2,3>
8. 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.

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.' '.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']).' '.CUSTOMER_EARNED_POINT_TAG.'</div><div class="cartBoxPendingPoints">'.GetCustomersPendingPoints($_SESSION['customer_id']).' '.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 ?

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

one more, when removing an order, I get :(

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

hem:

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''), ');

Andrew

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

any ideas ?

NullMind:

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.