Reward Points Module for ZC v13x

Hi

After reading the previous thread and this one, it mentions you were working on a referral system to work with the Reward points system, and I am just wondering if this is still on the wish list or not, or if anyone has a suitable work around for this type of functionality in the meantime.

I think this module looks great, though I haven't fully tested it yet. I wish my programming skills were up to scratch I could try and do something myself but its been years since I did any real programming and I haven't done a lot of PHP before.

hem:

Reward Points Full Suite 1.13a now uploaded

Additions:
Extended RewardPoints class so that external mods can hook into the Reward Points mod
Added code that Points Redeemed on an order are now subtracted from the Points Earned on that order.

Enhancement
Enhanced the Reward Points by Attribute and Reward Points on Sale/Special items code.

Bug Fixes
Fixed SQL bug in Sunrise Period.
Fixed bug in Customer Reward Points pending not being reduced after Sunrise Period

I upgraded to 1.13a and it awards points fine for normal credit processors but when you change the status it no longer moves the points to earned.

Thanks
Ken

Paws4Deals

kenwahl:

I upgraded to 1.13a and it awards points fine for normal credit processors but when you change the status it no longer moves the points to earned.

Thanks
Ken

Paws4Deals

Never mind I think when I tried the sunrise period last time it updated several orders to processed, so I had to change them to earned by hand. Any orders since then work fine with this version. The newer orders are changing to earned ok when I change their status.

Thanks
Ken

mbi15:

Hi

After reading the previous thread and this one, it mentions you were working on a referral system to work with the Reward points system, and I am just wondering if this is still on the wish list or not, or if anyone has a suitable work around for this type of functionality in the meantime.

I think this module looks great, though I haven't fully tested it yet. I wish my programming skills were up to scratch I could try and do something myself but its been years since I did any real programming and I haven't done a lot of PHP before.

There is something in the works (not by me) which is why I've added hooks so external programs can access the reward point system.

Ok, having the same problem of a few others back there.

Initial order and the rewarding of the points works great.

Now when the customer comes back to redeam the points. they go through the order process and clicks on the box to redeem the points. Looking at the totals something isn't getting picked up correctly .

They orer a total of 500.00 widgets. 20.00 shipping and 35.00 tax. total of 555.00.

Now when they redeem their 10.00 of points it should goto....

500 total order.
-10.00 reward points
490.00 subtotal
20.00 shipping
34.30 tax (with no reward points it would be 35.00 tax)

Total 544.30.

I.E. The reward points should be taken off the from the subtotal, and then tax figured from that amount. Right now the points reduction does not show up in the numbers until the total, But it charges the customer tax on the full order before any discounts. I believe it should take whatever discounts first, and then charge tax on that amount.

Anyone else?

Crzipilot:

Ok, having the same problem of a few others back there.

Initial order and the rewarding of the points works great.

Now when the customer comes back to redeam the points. they go through the order process and clicks on the box to redeem the points. Looking at the totals something isn't getting picked up correctly .

They orer a total of 500.00 widgets. 20.00 shipping and 35.00 tax. total of 555.00.

Now when they redeem their 10.00 of points it should goto....

500 total order.
-10.00 reward points
490.00 subtotal
20.00 shipping
34.30 tax (with no reward points it would be 35.00 tax)

Total 544.30.

I.E. The reward points should be taken off the from the subtotal, and then tax figured from that amount. Right now the points reduction does not show up in the numbers until the total, But it charges the customer tax on the full order before any discounts. I believe it should take whatever discounts first, and then charge tax on that amount.

Anyone else?

Just change the sort order of the Reward Payments Order Total module so the points are awarded before the tax is calculated. Also check your Reward Points config- specifically "Allow Redeem of Reward Points on Order Total or Subtotal"

Thanks for the quick response. I have moved the sort order of the reward payments order total module. so the reward points are the first line in figuring total cost. Now on my reward points config, I don't hae a "allow redeem of reward points on order total or subtotal" option. Maybe I need to reinstall??? My checkout currently looks like this. Again not taking the points off before it calculates tax, and the subtotal doesn't add up right..

50 x AAA Widgets 001 $500.00 -$9.80
Value of Redeemed Reward Points: $9.80

       Sub-Total:500.00

Table Rate (Best Way): 20.00

FL TAX 7.0%: 35.00

Total: 542.20

Reward Points earned: 490.2

Any idea why the "allow redeem of reward points on order total or subtotal" wouldn't show up in my config?

Reward Points
Reward Point Status Track Pend: [Pending, Processing] Earn: [Shipped] Reward Point Sunrise Period 0 Reward Point Redeem Minimum 20 Reward Point Redeem Maximum
Reward Point Rounding 0.5
Max transactions to Display in Customer Admin 12
Delete Old Reward Transactions Period 732
Adjust Reward Points for Sales/Specials 1
Allow Reward Points on Free Products 0
Reward Point Sidebox Display
Display Reward Points Sidebox
0= Always
1= Only when logged in
2= Only when logged in and has points
Date Added: 04/17/2008 Last Modified: 04/19/2008

Crzipilot:

Thanks for the quick response. I have moved the sort order of the reward payments order total module. so the reward points are the first line in figuring total cost. Now on my reward points config, I don't hae a "allow redeem of reward points on order total or subtotal" option. Maybe I need to reinstall??? My checkout currently looks like this. Again not taking the points off before it calculates tax, and the subtotal doesn't add up right..

50 x AAA Widgets 001 $500.00 -$9.80
Value of Redeemed Reward Points: $9.80

       Sub-Total:500.00

Table Rate (Best Way): 20.00

FL TAX 7.0%: 35.00

Total: 542.20

Reward Points earned: 490.2

Any idea why the "allow redeem of reward points on order total or subtotal" wouldn't show up in my config?

Reward Points
Reward Point Status Track Pend: [Pending, Processing] Earn: [Shipped] Reward Point Sunrise Period 0 Reward Point Redeem Minimum 20 Reward Point Redeem Maximum
Reward Point Rounding 0.5
Max transactions to Display in Customer Admin 12
Delete Old Reward Transactions Period 732
Adjust Reward Points for Sales/Specials 1
Allow Reward Points on Free Products 0
Reward Point Sidebox Display
Display Reward Points Sidebox
0= Always
1= Only when logged in
2= Only when logged in and has points
Date Added: 04/17/2008 Last Modified: 04/19/2008

Try reinstalling the upgrade.sql-That will add the missing items.

Ok, tried doing that, and got this error....

1062 Duplicate entry '0-0' for key 2
in:
[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);]
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.

Crzipilot:

Ok, tried doing that, and got this error....

1062 Duplicate entry '0-0' for key 2
in:
[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);]
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.

Try the attached version instead.

Ran that update. It did place the items on the menu, but now I have two reward points directories on the config menu. One is blank.....one has all the options on it. I will mess with it and make sure it's figuring it correctly.

thanks

hem:

Just change the sort order of the Reward Payments Order Total module so the points are awarded before the tax is calculated. Also check your Reward Points config- specifically "Allow Redeem of Reward Points on Order Total or Subtotal"

Actually I just noticed that the tax isn't being recalculated for me either. Do we need to modify something in the checkout pages? I allow redeem on sub-total. Even if I move the sort order of 'Reward Points' to the top. Nothing is recalculated other than the total. Subtotal is based on the products and tax is based on the items & shipping in my case. Redeemed points only get incorporated in the Total.

Actually reward points should be fairly similar to a coupon. The coupon order_total module has a few more setting available with regards to taxes than the reward points order_total module does. This the reason that taxes aren't be recalculated or are the values present in the DB, but just not visible/configurable through the UI?

OK so I done everything and when I go into Layout Box COntroller there is no Shopping Cart with Rewards option. How do I activate this.

:smile: wow, can't wait to see if this works on my site

I have found another issue, which personally affects me.

I am using points issued in quantities of 10's.

At the checkout, once points have been redeemed, it is taking the cash value off the points to be issued but not rounding the result.

Infact the points earned figure doesn't seem to add up. Any ideas?

Here is some trial data below.

Sub-Total: £3.04

Value of Redeemed Reward Points: £0.16

Per Item (Best Way): £5.00

Total: £7.88

Reward Points earned: 29.84

bargaindropper:

I have found another issue, which personally affects me.

I am using points issued in quantities of 10's.

At the checkout, once points have been redeemed, it is taking the cash value off the points to be issued but not rounding the result.

Infact the points earned figure doesn't seem to add up. Any ideas?

Here is some trial data below.

Sub-Total: £3.04

Value of Redeemed Reward Points: £0.16

Per Item (Best Way): £5.00

Total: £7.88

Reward Points earned: 29.84

I can see what it's doing- There's 30 RP earned and 0.16 has been subtracted from this. You are right though the Reward Points should be rounded (down I guess).

In that case, it would be a round down. Some may be a round up.

Looking in the Reward Admin for the customer account I tested with, as an example, it shows a balance of 4 points added for the transaction but in the grand total, it shows 5 points added. In the checkout, the points it was allocating after discount was 4.84.

Is it easy to fix? It would be great to have it implemented when I eventually go live.

Cheers

bargaindropper:

In that case, it would be a round down. Some may be a round up.

Looking in the Reward Admin for the customer account I tested with, as an example, it shows a balance of 4 points added for the transaction but in the grand total, it shows 5 points added. In the checkout, the points it was allocating after discount was 4.84.

Is it easy to fix? It would be great to have it implemented when I eventually go live.

Cheers

Yes, I should have something in the next couple of days. I'm trying to get to the bottom of the tax issues raised here too.

Many thanks. Will keep an eye on the thread.