Reward Points Module for ZC v13x

[hem]

Order value would mean that regardless of how many points you have,

if the minimum Value is set to $50, then you cannot redeem any points on smaller orders (it is a method of encouraging larger orders, by only allowing the discount on them.

Thanks Rasyr, that's what I was trying to get at...

Ah- Now I get you. So it would mean an addition to the Reward Points configuration and some method of telling the customer that they must spend at least X amount before they can redeem their points. I suppose this should go in the reward point sidebox.

[Mike_Dean]

Ah- Now I get you. So it would mean an addition to the Reward Points configuration and some method of telling the customer that they must spend at least X amount before they can redeem their points. I suppose this should go in the reward point sidebox.

Yes, you've got it..

Either in a sidebox, or on the Order Total page..

[hem]

Stick it in both sibeboxes and the Redeem Reward Order Total, bung a couple of <div> wrappers around each one and then anyone can disable them through the CSS.

[Mike_Dean]

Hi Andrew,

RP was working ok, then for some reason I am now having an issue.

I have put points onto a customers account, but in Admin they show up as Reward Points Earned, but as you can seem, they don't show up in the Value of Earned section.

Value of Pending: $0.00
Reward Points Earned: 1000
Value of Earned: $0.00

When I go through the checkout process, its shows as:

Current Reward Points:1000 points earned
Value of Redeemed Reward Points:$0.00
Redeem Reward Points: (is un checked)

If I tick the checkbox, then continue to process the order, the order total amount does not get adjusted,

Sub-Total: $175.50

AustPost (Parcel Post - 4 days Estimated Delivery Time)): $10.50

GST: $16.90

Value of Redeemed Reward Points: -$0.00

Total: $186.00

Reward Points earned: 160

Yet, when I go back into Admin, the points have been deducted ?????

Value of Pending: $0.00
Reward Points Earned: 160
Value of Earned: $0.00


I've re-installed the mod and re-tried and its the same

[Mike_Dean]

Hi Andrew,

RP was working ok, then for some reason I am now having an issue.

I have put points onto a customers account, but in Admin they show up as Reward Points Earned, but as you can seem, they don't show up in the Value of Earned section.

Value of Pending: $0.00
Reward Points Earned: 1000
Value of Earned: $0.00

When I go through the checkout process, its shows as:

Current Reward Points:1000 points earned
Value of Redeemed Reward Points:$0.00
Redeem Reward Points: (is un checked)

If I tick the checkbox, then continue to process the order, the order total amount does not get adjusted,

Sub-Total: $175.50

AustPost (Parcel Post - 4 days Estimated Delivery Time)): $10.50

GST: $16.90

Value of Redeemed Reward Points: -$0.00

Total: $186.00

Reward Points earned: 160

Yet, when I go back into Admin, the points have been deducted ?????

Value of Pending: $0.00
Reward Points Earned: 160
Value of Earned: $0.00


I've re-installed the mod and re-tried and its the same

I think it's fixed again..

Had to remove the 3 references from the databse and re-run the rql.. Now the poibnts show as Value of Earned again.

[walkerhxg]

Hi all,

Whatever I do , it always gets :

1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT SUM(`reward_points`) FROM reward_status_track ph WHERE p
in:
[UPDATE reward_customer_points rc SET `pending_points`=`pending_points`-IFNULL((SELECT SUM(`reward_points`) FROM reward_status_track ph WHERE ph.`customers_id`=rc.`customers_id` AND ph.`status`=0 AND ph.`orders_id` NOT IN (SELECT `orders_id` FROM orders)),0);]
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.

Please help me , thx in advance.

PS: How can I uninstall the sql completely?

[hem]

Hi all,

Whatever I do , it always gets :

1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT SUM(`reward_points`) FROM reward_status_track ph WHERE p
in:
[UPDATE reward_customer_points rc SET `pending_points`=`pending_points`-IFNULL((SELECT SUM(`reward_points`) FROM reward_status_track ph WHERE ph.`customers_id`=rc.`customers_id` AND ph.`status`=0 AND ph.`orders_id` NOT IN (SELECT `orders_id` FROM orders)),0);]
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.

Please help me , thx in advance.

PS: How can I uninstall the sql completely?

1. Download and install the latest version.

2. Check http://www.zen-cart.com/forum/showpo...7&postcount=19

[hem]

Hi Andrew,

RP was working ok, then for some reason I am now having an issue.

I have put points onto a customers account, but in Admin they show up as Reward Points Earned, but as you can seem, they don't show up in the Value of Earned section.

Value of Pending: $0.00
Reward Points Earned: 1000
Value of Earned: $0.00

When I go through the checkout process, its shows as:

Current Reward Points:1000 points earned
Value of Redeemed Reward Points:$0.00
Redeem Reward Points: (is un checked)

If I tick the checkbox, then continue to process the order, the order total amount does not get adjusted,

Sub-Total: $175.50

AustPost (Parcel Post - 4 days Estimated Delivery Time)): $10.50

GST: $16.90

Value of Redeemed Reward Points: -$0.00

Total: $186.00

Reward Points earned: 160

Yet, when I go back into Admin, the points have been deducted ?????

Value of Pending: $0.00
Reward Points Earned: 160
Value of Earned: $0.00


I've re-installed the mod and re-tried and its the same

Your redeem ratio was set to 0- re-installing the mod just reset the ratio back to the default (0.01). And yes the points will be removed from the earned as you had ticked the box.

[Mike_Dean]

Your redeem ratio was set to 0- re-installing the mod just reset the ratio back to the default (0.01). And yes the points will be removed from the earned as you had ticked the box.

Ok.. I clearly have a gremiln.. I have not touched or installed anything and now I have this issue again. (Rapidly removing hair..!!!)

I checked the ot_rewards_points and nothing seems to be amiss.

I even copied the original across and no change..

Where do I set (re-set) the ratio ?

[hem]

Right- new version has been sent off to the contribs:

v1.11a
Added an uninstall.sql script to remove Reward Point sql items.
Added Configuration item to set minimum order value to redeem points against.
Added Configuration item to allow redeem of RP against Subtotal or Total (inc. shipping)
Added Reward Points on Attribute Price for products that are Priced By Attribute