Reward Points Module for ZC v13x

[retched]

Is there a way to automatically include the total of the reward points and NOT to give a checkbox for it?

That is when the customer comes to step 2 of 3, they already see the cart with the discount calculated?

[hem]

Yes this is definitely installed, but I do not see that box at all.

when I run the rdp.php to check the install, this is the only error I get.

Allow Redeem of Reward Points on Order Total or Subtotal- record missing in configuration!!!

Okay- go to Admin->Tools->Install SQL Patch and paste in the following:

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 , 'Allow Redeem of Reward Points on Order Total or Subtotal', 'REWARD_POINTS_ALLOW_TOTAL', '0', 'Allow points to be redeemed against the full order (including shipping) or only against the subtotal.<br />0= Against the subtotal.<br />1= Against the full order.', @group_id, '9', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');

[hem]

Is there a way to automatically include the total of the reward points and NOT to give a checkbox for it?

That is when the customer comes to step 2 of 3, they already see the cart with the discount calculated?

I don't understand the point of that- then you are just talking about a regular discount rather than a Reward/Loyalty scheme.

[gj91]

Okay- go to Admin->Tools->Install SQL Patch and paste in the following:

This sort of helped, but I think I have an install issue where there are more then one installs of rewards points.

If I go to admin I see 4 rewards points not 1.

Should I go delete everything or is this a database issue.

This is the error I get when I go to install rewards points again.

1062 Duplicate entry 'MODULE_ORDER_TOTAL_REWARD_POINTS_REDEEM_RATIO' for key 2
in:
[insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Redeem Ratio', 'MODULE_ORDER_TOTAL_REWARD_POINTS_REDEEM_RATIO', '0.01', 'Amount given per Reward Point.', '6', '3', now())]
If 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.

[hem]

This sort of helped, but I think I have an install issue where there are more then one installs of rewards points.

If I go to admin I see 4 rewards points not 1.

Should I go delete everything or is this a database issue.

This is the error I get when I go to install rewards points again.

1062 Duplicate entry 'MODULE_ORDER_TOTAL_REWARD_POINTS_REDEEM_RATIO' for key 2
in:
[insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Redeem Ratio', 'MODULE_ORDER_TOTAL_REWARD_POINTS_REDEEM_RATIO', '0.01', 'Amount given per Reward Point.', '6', '3', now())]
If 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.

There's an SQL script called remove_multiple_config_items in the RP zip file. Run this in the same Install SQL Patches and that should solve your problem.

[gj91]

There's an SQL script called remove_multiple_config_items in the RP zip file. Run this in the same Install SQL Patches and that should solve your problem.

This got rid of the multiple items in configuration but I still get the duplicate entry when I go to install ot_rewards.

1062 Duplicate entry 'MODULE_ORDER_TOTAL_REWARD_POINTS_REDEEM_RATIO' for key 2

[hem]

This got rid of the multiple items in configuration but I still get the duplicate entry when I go to install ot_rewards.

1062 Duplicate entry 'MODULE_ORDER_TOTAL_REWARD_POINTS_REDEEM_RATIO' for key 2

That's correct. You've already installed it once, it does not need installing again.

[retched]

I don't understand the point of that- then you are just talking about a regular discount rather than a Reward/Loyalty scheme.

Consider the discount scheme:

400 = 4%
500 = 5%
600 = 7%

Instead of a redeem and spend, have an accruing balance of points. The more points you earn, the higher the discount on the order.

[hem]

Consider the discount scheme:

400 = 4%
500 = 5%
600 = 7%

Instead of a redeem and spend, have an accruing balance of points. The more points you earn, the higher the discount on the order.

Ah, got you. So in that scheme the reward points earned would never drop but continue accumulating...

It would need another Order Total mod but I could probably build it out of the Tiered Reward Point mod that already exists...

[retched]

Ah, got you. So in that scheme the reward points earned would never drop but continue accumulating...

It would need another Order Total mod but I could probably build it out of the Tiered Reward Point mod that already exists...

Oh I didn't know this mod already existed? I had mangled this mod to get it to work like that one