Reward Points Module for ZC v13x

[hem]

Hi,

Is there a way to set the minimum order value that must be reached before Reward Points can be used ?

Eg, Can I set a minimum say $100 order value before a customer can use points ?


Cheers,
Mike

Yes- it's in the Reward Point configuration and is called 'Reward Point Redeem Minimum'.

[Rasyr]

Yes- it's in the Reward Point configuration and is called 'Reward Point Redeem Minimum'.

I thought that that meant the minimum number of points that needed to be earned before they could be spent, not a minimum dollar value on an order before the points could be spent.

Was I mistaken?

[walkerhxg]

Hi Folks,

I have installed this mod but it doesn't works.( zen-cart1.3.8+MySQL 4.0.27-log+PHP4.4.7 )

I installed the 'new.sql' and got this:

17 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
Note: 10 statements ignored. See "upgrade_exceptions" table for additional details.

I clicked "Layout Box Controller" and got :

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.

[walkerhxg]

The problem maybe "reward_points_functions.php"? When I deleted it and clicked "Layout Box Controller",it works. But when I reload it , "Layout Box Controller" doesn't work.

Hi Folks,

I have installed this mod but it doesn't work.( zen-cart1.3.8+MySQL 4.0.27-log+PHP4.4.7 )

I installed the 'new.sql' and got this:

17 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
Note: 10 statements ignored. See "upgrade_exceptions" table for additional details.

I clicked "Layout Box Controller" and got :

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.

[hem]

I thought that that meant the minimum number of points that needed to be earned before they could be spent, not a minimum dollar value on an order before the points could be spent.

Was I mistaken?

It's minimum number of RP required to redeem. I can't really see the purpose of tying it to the order value- $5 worth of redeemed points is $5 redeemed points regardless.

[Rasyr]

It's minimum number of RP required to redeem. I can't really see the purpose of tying it to the order value- $5 worth of redeemed points is $5 redeemed points regardless.

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.

[Mike_Dean]

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

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

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

Getting back to this one.

Is this something you think you could add Andrew, and how long would it take..?

I'm thinking of hanging on until this option becomes available (if possible)


Thanks for the wonderful support and great Mod..