Reward Points Module for ZC v13x

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

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

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.

hem:

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!

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.

I am trying to run rpd.php and this is what I get:

‹lËnÂ0E÷|ÅÈ‹îšðP¤Ž% ¡ HI¨Ôn*'vÁRl#ÛiËßH ua5÷ÌÜ«Á»YóOj$Z(±fUÉa"èViëDýÁ;S¿>I…ãrç„ÚÚZé“W® j|pc…VÔ Ÿ;=oà )Î ø$™%ßȝ×÷zƒFˆéÓâ§Ôõ†ÝÛBKY)á t±¿˜ý›`\Y§%Luɸ @¨¢¬·¾ãr_RWÿ û&©P~³ôÏ\Öb´ØoªÉ™þ.¾hcMWëâ(›##&!zŒ2ŠJ"³gè:9bR¨k,<_&› –£8 =IˆÜ¨Üîï[%{I¢0Ý<Äó žG‹M¥U.…Cû'Ãó5:ØÏ5;œêÎÉ’tŽÿÿxNÉ

Not exactly sure what's going on, just upgraded to v1.29a and unfortunately, Value of Redeemed Reward Points: is doubling up on the checkout confirmation page and actually applying the reward points value twice. Not exactly sure what's going.

Also on the admin side when I configure Point Redeem Method to manual or automatic it makes no difference. In manual mode, the customer is suppose to be able to indicate how much of the value they want to redeem but no option is provided.

I'd greatly appreciate help with this.

BlessIsaacola:

Not exactly sure what's going on, just upgraded to v1.29a and unfortunately, Value of Redeemed Reward Points: is doubling up on the checkout confirmation page and actually applying the reward points value twice. Not exactly sure what's going.

Also on the admin side when I configure Point Redeem Method to manual or automatic it makes no difference. In manual mode, the customer is suppose to be able to indicate how much of the value they want to redeem but no option is provided.

I'd greatly appreciate help with this.

Sounds like something wrong with the mod Order Total- Have you run the RPD just to make sure everything is in the right place?

hem:

Sounds like something wrong with the mod Order Total- Have you run the RPD just to make sure everything is in the right place?

I tried to run rpd.php but it doesn't work, see 2 previous posts.

I hope it doesn't have anything to do with the update sql I ran (like I hopefully didn't create any duplicate of something). I am going to try to uninstall in reinstall.

Has anybody been able to get Reward Point Status Track to work when using Advanced Mode?

Simple mode: 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.

**Advanced mode: **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.

Also, what's the easiest way to move all rewards in** pending** to earned since the advanced mode is not working and all rewards points are stuck in pending.

Hi, can anyone help with this problem? I have installed the lates version of the reward points mode but am getting the display like this -
1 PRODUCT_REWARD_POINT_TAG on product pages and this -

REWARD_POINT_PROMPT 1254
REWARD_POINT_VALUE_PROMPT 0% on account pages. Anywhere the reward points are to show it has the same result.

Thanks

hem:

Sounds like something wrong with the mod Order Total- Have you run the RPD just to make sure everything is in the right place?

Not really sure if something is missing between this mod and 1.3.9b because when I am the payment page the rewards shows two lines for the reward points and actually subtracts it twice. However, if I refresh the screen (basically resubmitting) then one line is gone. Not really sure what's gone wrong but I'd like to know if anybody is successfully using this on 1.3.9b.

Thanks!

pdiamond:

Hi, can anyone help with this problem? I have installed the lates version of the reward points mode but am getting the display like this -
1 PRODUCT_REWARD_POINT_TAG on product pages and this -

REWARD_POINT_PROMPT 1254
REWARD_POINT_VALUE_PROMPT 0% on account pages. Anywhere the reward points are to show it has the same result.

Thanks

Make sure you upload the reward_points.php file from \includes\languages\english\extra_definitions\custom to your custom template. That's where all the definitions are...looks like you're missing that file on the server.

Excellent, that was the problem... Thanks BlessIsaacola :clap:

Andrew, I am using this on zen cart 1.3.9b and these 2 errors are in the log at the moment:

[04-May-2010 20:11:22] PHP Warning:  Invalid argument supplied for foreach() in /*/*/public_html/includes/functions/extra_functions/reward_points_functions.php on line 314
[04-May-2010 20:11:22] PHP Warning:  Invalid argument supplied for foreach() in /*/*/public_html/includes/functions/extra_functions/reward_points_functions.php on line 314

and

[04-May-2010 19:53:39] PHP Parse error:  syntax error, unexpected $end in /*/*/public_html/includes/functions/extra_functions/reward_points_functions.php on line 81

BlessIsaacola:

I tried to run rpd.php but it doesn't work, see 2 previous posts.

I hope it doesn't have anything to do with the update sql I ran (like I hopefully didn't create any duplicate of something). I am going to try to uninstall in reinstall.

On a quick view it looks like you've uploaded the zip file and renamed it to rpd.php

BlessIsaacola:

Andrew, I am using this on zen cart 1.3.9b and these 2 errors are in the log at the moment:

[04-May-2010 20:11:22] PHP Warning: Invalid argument supplied for foreach() in ///public_html/includes/functions/extra_functions/reward_points_functions.php on line 314
[04-May-2010 20:11:22] PHP Warning: Invalid argument supplied for foreach() in ///public_html/includes/functions/extra_functions/reward_points_functions.php on line 314

> 
> and
> 
> ```php
[04-May-2010 19:53:39] PHP Parse error:  syntax error, unexpected $end in /*/*/public_html/includes/functions/extra_functions/reward_points_functions.php on line 81

Thanks for the heads-up. I'll check it in the morning

hem:

On a quick view it looks like you've uploaded the zip file and renamed it to rpd.php

Thanks Andrew! What am I missing? There two files in the folder, rpd.php and rpd.xml. Are you saying I should have something else?

Hey guys I got a problem.

When I go to test my widget to see if it's working I get this.

<br /> <b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/parkourf/public_html/hacash.com/postback.php</b> on line <b>35</b><br /> Success: 174.114.249.159 earned 100 points and is referred by nobody 

Anybody know what is wrong? I just spent 90$ on advertising for the day and was really bummed out to find out I can't figure this out..

My reward points are correct throughout the order and even on the invoice. However, when I change the order status to delivered the incorrect reward points are rewarded. In this case the group discount is not being deducted for points being rewarded, strange as they are deducted in the rest of the order... Is this something that I will have to manually change or am I missing a setting somewhere??

Hi

I'm not sure if this has been covered but...

I noticed there is an issue with assigning Reward Points to an order that has already been discounted with previously earned reward points.

If I choose in the configuration to assign reward point to the sub total. Then a customer will earn points on the value of the order in the shopping cart 'before' it has been discounted using previously earned reward points.

To get around this, and only allocate points for actual cash spent on the goods, I need to configure the mod to assign points of the final total (including shipping).

Is there a way of getting a 3rd option - allocate reward points based on the sub total (not including shipping) but also taking into account discounts from previously earned reward points? e.g.

Goods Sub Total 100.00
Redeemed Reward Points 20.00

Order Sub Total 80.00
Add Shipping 10.00

Grand Total 90.00

I don't really want to be giving customers reward points on shipping fees, or discounts they have already received through previously earned reward points.

Thanks

Paul