Reward Points Module for ZC v13x

[GG01]

Great module.

Will it work in the newly released upgrade version 1.3.9?

[hem]

Great module.

Will it work in the newly released upgrade version 1.3.9?

It worked fine when I tested it on the beta release last week.

[hem]

What might be interesting would be to see if anyone is using v1.3.9 with the Paypal IPN mod- Have the issues with PayPal IPN been sorted?

[BlessIsaacola]

Andrew,
I am wondering if you can provide the best way to update our database. I noticed both your new.sql and the update.sql are the same file.

What's the best approach to just update our database with new configuration. It looks to me like this last line is the only thing new since last update:

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, 'Advanced Reward Point Calculation Rules', 'REWARD_POINTS_ADVANCED_CALCULATE_TABLE', '-ot_gv,-ot_coupon', 'Advanced configuration of Reward Point calculations. This will be the figure that total Reward Points are adjusted by. This also affects the maximum value that any points can be redeemed against.', @group_id, '14', NULL, now(), 'UseRewardPointAdvancedCalculateTableFunction', 'SetRewardPointAdvancedCalculateTableFunction(');

[hem]

Andrew,
I am wondering if you can provide the best way to update our database. I noticed both your new.sql and the update.sql are the same file.

What's the best approach to just update our database with new configuration. It looks to me like this last line is the only thing new since last update:

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, 'Advanced Reward Point Calculation Rules', 'REWARD_POINTS_ADVANCED_CALCULATE_TABLE', '-ot_gv,-ot_coupon', 'Advanced configuration of Reward Point calculations. This will be the figure that total Reward Points are adjusted by. This also affects the maximum value that any points can be redeemed against.', @group_id, '14', NULL, now(), 'UseRewardPointAdvancedCalculateTableFunction', 'SetRewardPointAdvancedCalculateTableFunction(');

I think the update.sql has a couple of IGNOREs but apart from that you are right. If you a updating from v1.27a then you don't have to apply the sql patch as there has been no changes to the tables.

[BlessIsaacola]

I think the update.sql has a couple of IGNOREs but apart from that you are right. If you a updating from v1.27a then you don't have to apply the sql patch as there has been no changes to the tables.

So you're saying it safe to just use the update.sql even though some of the stuff are already in DB? I am upgrading from 1.23 so I do need 1 configuration option that I believe is missing sin 1.23 unless there is more.

Thanks!

[GG01]

I would really like to offer free shipping as a promotional coupon and still allow the customer to get full reward points on the subtotal.

Is there a way to offer a coupon with free shipping (coupon value would be $0 and Free Shipping box checked) and not have it deduct reward points since it was the shipping that was brought to $0.00 rather than product being discounted?

Thank you.