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?
Printable View
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?
Okay- go to Admin->Tools->Install SQL Patch and paste in the following:Quote:
Originally Posted by gj91
Quote:
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''), ');
I don't understand the point of that- then you are just talking about a regular discount rather than a Reward/Loyalty scheme.Quote:
Originally Posted by retched
This sort of helped, but I think I have an install issue where there are more then one installs of rewards points.Quote:
Originally Posted by hem
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.Quote:
Originally Posted by gj91
This got rid of the multiple items in configuration but I still get the duplicate entry when I go to install ot_rewards.Quote:
Originally Posted by hem
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.Quote:
Originally Posted by gj91
Consider the discount scheme:Quote:
Originally Posted by hem
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...Quote:
Originally Posted by retched
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 :mellow:Quote:
Originally Posted by hem