Reward Points Module for ZC v13x

[hem]

yea i did read that file, i think the files uploading , running the module, and admin set are correct, but i'm not sure if i run the sql correctly? but i got the success information after i run it. here's the sql:

    CREATE TABLE `reward_master` (
    `rewards_products_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `scope` INT( 1 ) NOT NULL DEFAULT '0',
    `scope_id` INT( 11 ) NOT NULL DEFAULT '0',
    `point_ratio` DOUBLE( 15, 4 ) NOT NULL DEFAULT '1',
    `bonus_points` DOUBLE( 15, 4 ) NULL,
    `redeem_ratio` DOUBLE( 15, 4 ) NULL,
    `redeem_points` DOUBLE( 15, 4 ) NULL,
    UNIQUE `unique_id` ( `scope` , `scope_id` ));

    INSERT INTO `reward_master` (`rewards_products_id` ,`scope` ,`scope_id` ,`point_ratio` ,`bonus_points`, `redeem_ratio`, `redeem_points`) VALUES (NULL , '0', '0', '1.0000', NULL, 0.01, NULL);

    CREATE TABLE `reward_customer_points` (
    `customers_id` INT( 11 ) NOT NULL PRIMARY KEY,
    `reward_points` DOUBLE( 15, 4 ) NOT NULL DEFAULT '0',
    `pending_points` DOUBLE( 15, 4 ) NOT NULL DEFAULT '0');

    CREATE TABLE `reward_status_track` (
    `rewards_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
    `customers_id` INT( 11 ) NOT NULL ,
    `orders_id` INT( 11 ) NOT NULL ,
    `date` DATETIME NOT NULL ,
    `reward_points` DOUBLE( 15, 4 ) NOT NULL ,
    `status` TINYINT( 1 ) NOT NULL,
    UNIQUE (`orders_id`));

    REPLACE INTO `configuration_group` (`configuration_group_id` ,`configuration_group_title` ,`configuration_group_description` ,`sort_order` ,`visible`) VALUES (NULL , 'Reward Points', 'Reward Point Module Configuration', '50' , '1');

    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 , 'Reward Point Mode', 'REWARD_POINT_MODE', '0', 'Select the Reward Point Mode<br />0= Reward Points are fixed to the product prices and are calculated individually.<br />1= Reward Points are calculated on the Order Total or Subtotal (depending on the setting of the <strong>Allow Redeem of Reward Points on Order Total or Subtotal</strong> configuration).', @group_id, '0', 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 , 'Reward Point Sidebox Display', 'SHOW_REWARD_POINTS_BOX_OPTION', '0', 'Display Reward Points Sidebox<br />0= Always<br />1= Only when logged in<br />2= Only when logged in and has points', @group_id, '1', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1'', ''2''), ');

    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 , 'Reward Point Status Track', 'REWARD_POINTS_STATUS_TRACK', '', '<b>Simple mode:</b> All new reward points are set to Pending and are changed to Earned when the Order Status changes. If the Order Status is then changed back to Pending then the reward points are transfered back from Earned.<br /><br /><b>Advanced mode:</b> Set the order status items that will trigger a transfer of the reward points between pending and earned. Points are transfered when the status changes between the "Pending" and "Earned". Status items set to "Ignore" will have no effect if the Order Status changes to it.', @group_id, '2', NULL, now(), 'UseRewardPointStateFunction' , 'SetRewardPointStateFunction(');

    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 , 'Reward Point Sunrise Period', 'REWARD_POINTS_SUNRISE_PERIOD', '0', 'The number of days after which points pending become points earned. Set to 0 for no sunrise period.', @group_id, '3', NULL, now(), NULL , NULL);

    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 , 'Reward Point Redeem Minimum', 'REWARD_POINTS_REDEEM_MINIMUM', '0', 'This is the minimum amount of earned points needed before they can be redeemed.', @group_id, '3', NULL, now(), NULL , NULL);

    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 , 'Reward Point Redeem Maximum', 'REWARD_POINTS_REDEEM_MAXIMUM', '0', 'This is the maximum amount of earned points that can be redeemed against a single order.<br /><i>Note: this can be a absolute value (eg 1000) or a percentage (20%).</i>', @group_id, '4', NULL, now(), NULL , NULL);

    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 , 'Reward Point Rounding', 'REWARD_POINTS_ROUNDING', '0.5', 'Rounding value- This is added to each products price before it is rounded down to 0 decimal places to calculate product Reward Points (default 0.5)', @group_id, '5', NULL, now(), NULL , NULL);

    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 , 'Max Transactions to Display in Customer Admin', 'REWARD_POINTS_MAX_TRANSACTIONS', '12', 'Select the maximum number of records to show on the Pending Reward Points table in Customer Reward Point admininstration.', @group_id, '6', NULL, now(), NULL , NULL);

    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 , 'Delete Old Reward Transactions Period', 'REWARD_POINTS_HOUSEKEEPING', '90', 'Set the age (in days) to keep the reward point transactions. Outstanding reward points pending after this period will be lost. Set to 0 to keep all transactions.', @group_id, '7', NULL, now(), NULL , NULL);

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

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

    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 , 'Set Minimum Order Value to Redeem Points Against', 'REWARD_POINTS_MINIMUM_VALUE', '0', 'Set the minimum value that the order should be in order for it to qualify for reward point redeem.', @group_id, '10', NULL, now(), NULL , NULL);

    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 , 'Limit Maximum Customers on Listings', 'REWARD_POINTS_CUSTOMER_LIMIT', '50', 'Set the maximum number of records to appear on each page under Customer Reward Point admininstration page.', @group_id, '11', NULL, now(), NULL , NULL);

    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 , 'Display Products Reward Points When Zero', 'REWARD_POINTS_ALWAYS_DISPLAY', '1', 'Set whether a products reward points are displayed when zero.<br />0= Don\'t display 0 Reward Points.<br />1= Always display reward points even when zero.', @group_id, '12', 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 , 'Set New Account Reward Points', 'REWARD_POINTS_NEW_ACCOUNT_REWARD', '0', 'Set the amount of points awarded to a customer when an account is created. The points can either be added to \'Earned\' which will allow the customer to redeem the points straight away; Or the points can be added to \'Pending\' in which case the customer will receive the points after their first successful order.', @group_id, '13', NULL, now(), 'UseRewardPointNewAccountAwardFunction' , 'SetRewardPointNewAccountAwardFunction(');

i did a test again, i created 5 new accounts myself, then i got the points earned for each account. but when the customers creat the accounts, still some got points earned, some got nothing.

Do you have different methods for account creation? Easy Checkout or something similar?

[myworld20091]

Do you have different methods for account creation? Easy Checkout or something similar?

no i dont have any thing such as easy checkout, i use the default account creation page and zencart default template.
for those customers who got points earned or not when creating account, i was trying to compare their emails, names, countries, and placed orders or not, but no result. they seem to be random.

[1kell]

Great mod so easy to install. Is there any way I can turn off the total reward points in the checkout area, UNLESS the customer has ticked the newsletter subscribe box, or if that is too difficult, unless I have approved them for reward points?

[paupauchu]

I have installed the Reward Points Module version 1.23a and found 3 problems, appreciate if anyone can help:

1. Even I have set the Category Point Ratio or / and the Product Point Ratio, but they can't overwrite the Global Point Ratio, which means I always get the the same for all products.

2. If I set the Global Point Ration to 0, the sidebox rewards of the items in the cart will show "-1" reward points.

3. If I redeem the points (e.g. as $20). and on the invoice, it will show reward points earned : 130. But I find the client record is updated to have 150 points pending instead of 130 (i.e. without deducting the 20)

Sub-total: $150.0
Shipping: $13.0
Quantity Discount: -$14.0
Value of Redeemed Reward Points: -$20.0
Total: $129.0
Reward Points earned: 130

Any ideas for the above. Thank you very much!!

Paul

[hem]

I have installed the Reward Points Module version 1.23a and found 3 problems, appreciate if anyone can help:

1. Even I have set the Category Point Ratio or / and the Product Point Ratio, but they can't overwrite the Global Point Ratio, which means I always get the the same for all products.

2. If I set the Global Point Ration to 0, the sidebox rewards of the items in the cart will show "-1" reward points.

3. If I redeem the points (e.g. as $20). and on the invoice, it will show reward points earned : 130. But I find the client record is updated to have 150 points pending instead of 130 (i.e. without deducting the 20)

Sub-total: $150.0
Shipping: $13.0
Quantity Discount: -$14.0
Value of Redeemed Reward Points: -$20.0
Total: $129.0
Reward Points earned: 130

Any ideas for the above. Thank you very much!!

Paul

The latest version is v1.26a and resolves all of these problems

[paupauchu]

The latest version is v1.26a and resolves all of these problems

Thanks! But I find the below link to download the v1.26a doesn't work, even I have tried to remove the "www" after the ".com".

http://www.omnicia.com/www/Zencart%2...s%20Module.zip

Has the file been moved or where any other links can I get the file?

Many thanks!!

Paul

[hem]

Thanks! But I find the below link to download the v1.26a doesn't work, even I have tried to remove the "www" after the ".com".

http://www.omnicia.com/www/Zencart%2...s%20Module.zip

Has the file been moved or where any other links can I get the file?

Many thanks!!

Paul

http://www.omnicia.com/Zencart%20Rew...s%20Module.zip should work...

[monkeyjr47906]

I apologize if this has already been discussed. Is there a way to set up the site so it is Rewards points only? Like when you buy credits from a stock photo site.

[hem]

I apologize if this has already been discussed. Is there a way to set up the site so it is Rewards points only? Like when you buy credits from a stock photo site.

It's a good idea and should be doable with a couple of small changes. Let me look into it.

[monkeyjr47906]

It's a good idea and should be doable with a couple of small changes. Let me look into it.

Just checking in, in regard to my question about customers being able to request or purchase credits for shopping like a stock photo site.