Reward Point Mod beta now available

[hem]

Thanks for the feedback guys.

1. Yes, I did worry about the RENAME sql line but could not find an IF EXISTS clause that would allow the sql to pass gracefully. I think I will take it out of the install.sql and put it in a pre 1.03 patch to be run before the main install.

2. I'll check the Global Redeem- thanks for the heads up.

3. And sorry- the Reward Points is still based on the base price. I will add a config item to select which price you want to base the points on. Also I think we need another config to select whether you can get points from a free item.

I think I will remove the dependency on the order.php core file. I'm a bit worried that this will mean that there will be a lot more sql transactions so I'll have to look into how to reduce this load but it needs to be done to "free" the mod and make it seamlessly work with other modifications.

PTC- Thanks for the interesting logic problem- I will look into it.

[pinetreecandles]

I really like the points admin. Thanks for all your hard work on this andy

[lankeeyankee]

Hi Andy and everyone!

I don't know if you have seen this yet or if this will help you add/fix functionality by comparing what this mod does, but Jaycode posted the xrewards module that he did a big overhaul on. I have attached it here for comparison/evaluation. I haven't tried any of the rewards mods yet, going to install them on test sites soon to compare.

Matt

[hem]

Hi Andy and everyone!

I don't know if you have seen this yet or if this will help you add/fix functionality by comparing what this mod does, but Jaycode posted the xrewards module that he did a big overhaul on. I have attached it here for comparison/evaluation. I haven't tried any of the rewards mods yet, going to install them on test sites soon to compare.

Matt

It's a nice tight little mod. Thanks for the heads up and I look forward to seeing the comparisons.

[hem]

I really like the points admin. Thanks for all your hard work on this andy

It'll be great when it works

[fiji]

the x-rewards is working, but a little simple. It will give the point to customer after they place an order. not require admin to do anything.

The x-rewards solved two problems. One is the point based on discount price and two is don't have to add customer to group to refeem the point.

andrew, if you can combine it to your project, that will be the most powerful addon. :)

[hem]

The x-rewards solved two problems. One is the point based on discount price and two is don't have to add customer to group to refeem the point.

Well, in fairness the second point is a bug in my mod- There is a Global Redeem but does not seem to be working- I'm looking at it right now.

[hem]

Interim fix. Fixes the Global Redeem not displaying in Admin->Customer->Reward Points and PTC's interesting logic puzzle which occured when all points were shifted between pending and earned and back again.

Unzip attached file to admin\ and replace the version there.

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

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

[NullMind]

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

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