Reward Points Module for ZC v13x

[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.

[kenwahl]

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

[hem]

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.

[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?

[hem]

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"

[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

[hem]

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.

[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.

[hem]

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.