Reward Points Module for ZC v13x

Quote:

---

Originally Posted by hem

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.

Code:

---

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?

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?

Quote:

---

Originally Posted by hem

Check this line in the RPD:



Try reinstalling upgrade.sql

---

Believe me i have done that a few time

Quote:

---

Originally Posted by Rasyr

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.

Quote:

---

Originally Posted by 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?

---

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

Quote:

---

Originally Posted by nigelt74

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:

Code:

---

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

Quote:

---

Originally Posted by hem

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

Code:

---

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.

Quote:

---

Originally Posted by nigelt74

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:

Code:

---

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

---

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?

Quote:

---

Originally Posted by 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?

---

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.