Reward Points Module for ZC v13x

[lauriesscraps]

Nevermind, found it. Okay, all the Reward Point tables have been restored to the last backup.

I am now getting an error message at the bottom of the customers>reward points screen.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND status=0 ORDER BY date DESC LIMIT 12' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM reward_status_track WHERE customers_id= AND status=0 ORDER BY date DESC LIMIT 12;]
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.

Do you know what this is about?

[lauriesscraps]

Actually, I fixed it by running the update SQL again. I hope that didn't screw anything up! I am also having an issue with reward points not going straight to earned. I have the sunrise period set to zero, so not sure what else I need to fix. Also, still rewarding points for free gifts even though I have it set to earn points depending on order total. Any ideas?

[nigelt74]

Check this line in the RPD:



Try reinstalling upgrade.sql

Believe me i have done that a few time

[retched]

Is there any way to make it so that the maximum amount of Reward Points redeemed cannot exceed the subtotal?

This is built in if I recal correctly. Otherwise, there is a bit of code you could just add in to make this right.

[hem]

Actually, I fixed it by running the update SQL again. I hope that didn't screw anything up! I am also having an issue with reward points not going straight to earned. I have the sunrise period set to zero, so not sure what else I need to fix. Also, still rewarding points for free gifts even though I have it set to earn points depending on order total. Any ideas?

Set Reward Point Mode to 1 .

Also either set your payments initial order status to something other than Pending or go to Admin->Reward Points and set Reward Point Status Track to Advanced and change all the statuses to Earned

[hem]

Believe me i have done that a few time

Okay, try going to Admin->Tools->Install SQL Patch and copy the following into the query box:

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

Let me know if you get any error

[nigelt74]

Okay, try going to Admin->Tools->Install SQL Patch and copy the following into the query box:

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

Let me know if you get any error

yep get an error

1048 Column 'configuration_group_id' cannot be null
in:
[REPLACE INTO zen_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.
0= Against the subtotal.
1= Against the full order.', @group_id, '9', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');]
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]

yep get an error

1048 Column 'configuration_group_id' cannot be null
in:
[REPLACE INTO zen_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.
0= Against the subtotal.
1= Against the full order.', @group_id, '9', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');]
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.

Ah sorry, forgot to retrieve the @group_id. Try this:

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

[mask2011]

First of all, awesome module, really loving it!

Second, I have a question to limit the issuance of points..

I love being able to issue rewards points for goods that are according to Standard Retail Price (SRP), however when the product is discounted, I would not want to offer rewards points..

Basically, the way we have it in mind is that if a product is charged according to SRP, we'd give free shipping, rewards points and the ability to use certain payment options.. However, if we're providing a discounted rate (which actually means, we're charging them at whole-sale price), we'd not want to offer any benefits, in order for us not to go negative on our profits..

Is there any way right now to implement this?

[hem]

First of all, awesome module, really loving it!

Second, I have a question to limit the issuance of points..

I love being able to issue rewards points for goods that are according to Standard Retail Price (SRP), however when the product is discounted, I would not want to offer rewards points..

Basically, the way we have it in mind is that if a product is charged according to SRP, we'd give free shipping, rewards points and the ability to use certain payment options.. However, if we're providing a discounted rate (which actually means, we're charging them at whole-sale price), we'd not want to offer any benefits, in order for us not to go negative on our profits..

Is there any way right now to implement this?

The easiest way would be to put all your discounted items into a Category called Discounts and then go to Admin->Categories->Reward Points and set the Redeem value of that category to 0.