Reward Points Module for ZC v13x

[Mike_Dean]

I see what you mean now. I never noticed that before. All my testing I never had the amount to redeem exceed the subtotal. Good catch.

I'm not a coder so I'm not sure what the side effects will be on changing the code from:

$order_total = $order->info['total'];

to

$order_total = $order->info['subtotal'];

I guess that's what test sites are for

Hi PTC..

Did the mod on this code work ? I dont want people to be able to redeem points against shipping fees, only against the goods.

So I'm curious if this worked, if so, which file was it that you changed ?

Thanks,
Mike

[Mike_Dean]

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

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

[Mike_Dean]

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

Thanks Andrew, Perhaps I worded this question wrong.

The config you suggest decides the minmum amount of points IearnedI before they can be redeemed.

What I'm looking for is the minimum amount of an order value before a customer can use reward points against the order,

Lets say the minimum is 100$ (but should be adjustable)
And the customer has 150 points earned.

Eg.. A customer adds $75 in value of goods in his/her cart, as its's under the $100, they cannot use any of their 150 points available.

Same customer increases the vaue of the goods in their cart to $100, in this case, the 150 points they have available then become redeemable against that order.

I have products that are only worth $2.50 so I dont want a customer using points against low order values.

I know I can adjust the maximum redeemable award points per order. But I'd rather try and get a customer to increase the cart value first..!