Reward Points Module for ZC v13x

Mike_Dean:

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

It worked fine for me...

NullMind:

Andrew

I could have swore it worked before, I know I tested it .. but it was with the beta, wonder fi somthing changed, but when changing order status with Super Orders, it will not redeem the credits (when moving order to status that should redeem)

Andrew, Nullmind,

It does work with super orders. I installed it the day it was made final and completed a number of orders already with the points transferring to earned. Today I recieved my first order paid by RP's and it also worked great.

Thanks for a fantastic mod.:hug: I will buy you a cuppa towards the end of the month. Have you got a paypal account where we can donate?

hem:

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?

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.

Rasyr:

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.

Louis:

Andrew, Nullmind,

It does work with super orders. I installed it the day it was made final and completed a number of orders already with the points transferring to earned. Today I recieved my first order paid by RP's and it also worked great.

Thanks for a fantastic mod.:hug: I will buy you a cuppa towards the end of the month. Have you got a paypal account where we can donate?

Well, there's my guilty secret (and the reason why I'm having difficulty getting to the bottom of the PayPal IPN problem)- PayPal don't like me since I successfully did a Chargeback on them (legitimately) because I refused to pay any admin fees on an order that an online merchant had messed up on (don't worry, they were using osCommerce).

hem:

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.

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

walkerhxg:

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:

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

Rasyr:

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

Rasyr:

It worked fine for me...

Thanks working for me too...

Louis:

Andrew, Nullmind,

It does work with super orders. I installed it the day it was made final and completed a number of orders already with the points transferring to earned. Today I recieved my first order paid by RP's and it also worked great.

Thanks for a fantastic mod.:hug: I will buy you a cuppa towards the end of the month. Have you got a paypal account where we can donate?

no, my problem is, when using "batch update" to move the invoices to the shipped category (where the points become available) .. the points are still left "pending"

Andrew, would it be easy to have a method/button on the clients list to "recheck pending" and markt hem awarded if the pending invoices have been moved to the proper category ?

NullMind:

Andrew, would it be easy to have a method/button on the clients list to "recheck pending" and markt hem awarded if the pending invoices have been moved to the proper category ?

It's already done automatically by the syncing code.

Are you using simple or advanced Reward Point Status Track???

Mike_Dean:

Rasyr:

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.

hem:

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

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.

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.

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?