Reward Points Module for ZC v13x

retched:

Have you checked your MySQL DB for the configuration items?

Or run RPD?

emtecmedia:

Hi,

Is there any news on support for Paypal IPN? It's taking me so long each day updating the points manually for paypal orders...

Thanks.

Have you tried using Paypal Express instead- It works fine with that.

Justapeddler:

Finally I resolved my issue thanks to this post: http://www.zen-cart.com/forum/showpost.php?p=846837&postcount=1807

Followed it and finally I can try this reward point addon!

Now I have a question: Is it possible to set a level in the reward point? e.g. 0-$100 orders are given 5% reward points, $100-$300 orders are given 8% and $300+ are given 10%.

Yes- Just the Tiered Discount's Order Total instead.

I have just installed this module and everything seems to work well but I don't have the click to redeem button at checkout.

I am testing this module and I gave a user 100 points.

I have also ran the diagnostic tool and all files are there, nothing shows up in red.

Do I need to wait for some sort of period before the points can be used, or is earned ready to use.

As you can see I have 10$ earned, but no button to click to redeem.

I am using paypal IPN but i'm only at the checkout point before I even select a payment option.

You may click to redeem any collected Reward Points. Your redeemed points will be applied to the total and reflected in your cart after you click continue.

Current Reward Points:100 points earned ($10.00)
Value of Redeemed Reward Points:$10.00 (100)

Hi gj91

There isn't a button right now, but a box where the customer types in the number of reward points he/she wishes to redeem in step 2 of the checkout process.

So, from my site...

You can see how much money in Reward Points you have avaiable. One point = 1p, so in this example, the screen tells us that we have 3099 point = £30.99.

You then type in the number of points you want to redeem. You can redeem none, or any number between 1 point (1p) and the full value of your bill (assuming you have enough points). If you choose not to redeem any, you will be able to keep building them up for 6 months from the date of issue.

In this order, we redeemed all our points. (Note, you are typing in 'points', not 'money', so don't use a decimal point.

I guess there was a problem with the previous 'tick box to redeem your reward points' system, so Hem changed it.

Paul

ardhill:

Hi gj91

There isn't a button right now, but a box where the customer types in the number of reward points he/she wishes to redeem in step 2 of the checkout process.

So, from my site...

You can see how much money in Reward Points you have avaiable. One point = 1p, so in this example, the screen tells us that we have 3099 point = £30.99.

You then type in the number of points you want to redeem. You can redeem none, or any number between 1 point (1p) and the full value of your bill (assuming you have enough points). If you choose not to redeem any, you will be able to keep building them up for 6 months from the date of issue.

In this order, we redeemed all our points. (Note, you are typing in 'points', not 'money', so don't use a decimal point.

I guess there was a problem with the previous 'tick box to redeem your reward points' system, so Hem changed it.

Paul

There was a change? Is it posted?

Have you installed ot_reward_points under Admin->Modules->Order Total. Once you do this you can set the Redeem Method to Manual (customer enters number of points) or Automatic (user ticks a checkbox to use available points).

hem:

Have you installed ot_reward_points under Admin->Modules->Order Total. Once you do this you can set the Redeem Method to Manual (customer enters number of points) or Automatic (user ticks a checkbox to use available points).

Yes this is definitely installed, but I do not see that box at all.

when I run the rdp.php to check the install, this is the only error I get.

Allow Redeem of Reward Points on Order Total or Subtotal- record missing in configuration!!!

ardhill:

Hi gj91

There isn't a button right now, but a box where the customer types in the number of reward points he/she wishes to redeem in step 2 of the checkout process.

So, from my site...

You can see how much money in Reward Points you have avaiable. One point = 1p, so in this example, the screen tells us that we have 3099 point = £30.99.

You then type in the number of points you want to redeem. You can redeem none, or any number between 1 point (1p) and the full value of your bill (assuming you have enough points). If you choose not to redeem any, you will be able to keep building them up for 6 months from the date of issue.

In this order, we redeemed all our points. (Note, you are typing in 'points', not 'money', so don't use a decimal point.

I guess there was a problem with the previous 'tick box to redeem your reward points' system, so Hem changed it.

Paul

I do not see the box area at all, but the layout looks like it is making room for the box, just nothing there.

This is all I see

gj91:

I do not see the box area at all, but the layout looks like it is making room for the box, just nothing there.

This is all I see

Maybe your settings do not allow that low amount to be redeemed?

Is there a way to automatically include the total of the reward points and NOT to give a checkbox for it?

That is when the customer comes to step 2 of 3, they already see the cart with the discount calculated?

gj91:

Yes this is definitely installed, but I do not see that box at all.

when I run the rdp.php to check the install, this is the only error I get.

Allow Redeem of Reward Points on Order Total or Subtotal- record missing in configuration!!!

Okay- go to Admin->Tools->Install SQL Patch and paste in the following:

SET @group_id = '';
SELECT (@group_id := configuration_group_id) FROM configuration_group WHERE configuration_group_title LIKE 'Reward Points';

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 , 'Allow Redeem of Reward Points on Order Total or Subtotal', 'REWARD_POINTS_ALLOW_TOTAL', '0', 'Allow points to be redeemed against the full order (including shipping) or only against the subtotal.<br />0= Against the subtotal.<br />1= Against the full order.', @group_id, '9', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');

retched:

Is there a way to automatically include the total of the reward points and NOT to give a checkbox for it?

That is when the customer comes to step 2 of 3, they already see the cart with the discount calculated?

I don't understand the point of that- then you are just talking about a regular discount rather than a Reward/Loyalty scheme.

hem:

Okay- go to Admin->Tools->Install SQL Patch and paste in the following:

This sort of helped, but I think I have an install issue where there are more then one installs of rewards points.

If I go to admin I see 4 rewards points not 1.

Should I go delete everything or is this a database issue.

This is the error I get when I go to install rewards points again.

1062 Duplicate entry 'MODULE_ORDER_TOTAL_REWARD_POINTS_REDEEM_RATIO' for key 2
in:
[insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Redeem Ratio', 'MODULE_ORDER_TOTAL_REWARD_POINTS_REDEEM_RATIO', '0.01', 'Amount given per Reward Point.', '6', '3', now())]
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.

gj91:

This sort of helped, but I think I have an install issue where there are more then one installs of rewards points.

If I go to admin I see 4 rewards points not 1.

Should I go delete everything or is this a database issue.

This is the error I get when I go to install rewards points again.

1062 Duplicate entry 'MODULE_ORDER_TOTAL_REWARD_POINTS_REDEEM_RATIO' for key 2
in:
[insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Redeem Ratio', 'MODULE_ORDER_TOTAL_REWARD_POINTS_REDEEM_RATIO', '0.01', 'Amount given per Reward Point.', '6', '3', now())]
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.

There's an SQL script called remove_multiple_config_items in the RP zip file. Run this in the same Install SQL Patches and that should solve your problem.

hem:

There's an SQL script called remove_multiple_config_items in the RP zip file. Run this in the same Install SQL Patches and that should solve your problem.

This got rid of the multiple items in configuration but I still get the duplicate entry when I go to install ot_rewards.

1062 Duplicate entry 'MODULE_ORDER_TOTAL_REWARD_POINTS_REDEEM_RATIO' for key 2

gj91:

This got rid of the multiple items in configuration but I still get the duplicate entry when I go to install ot_rewards.

1062 Duplicate entry 'MODULE_ORDER_TOTAL_REWARD_POINTS_REDEEM_RATIO' for key 2

That's correct. You've already installed it once, it does not need installing again.

hem:

I don't understand the point of that- then you are just talking about a regular discount rather than a Reward/Loyalty scheme.

Consider the discount scheme:

400 = 4%
500 = 5%
600 = 7%

Instead of a redeem and spend, have an accruing balance of points. The more points you earn, the higher the discount on the order.

retched:

Consider the discount scheme:

400 = 4%
500 = 5%
600 = 7%

Instead of a redeem and spend, have an accruing balance of points. The more points you earn, the higher the discount on the order.

Ah, got you. So in that scheme the reward points earned would never drop but continue accumulating...

It would need another Order Total mod but I could probably build it out of the Tiered Reward Point mod that already exists...

hem:

Ah, got you. So in that scheme the reward points earned would never drop but continue accumulating...

It would need another Order Total mod but I could probably build it out of the Tiered Reward Point mod that already exists...

Oh I didn't know this mod already existed? I had mangled this mod to get it to work like that one :mellow: