Reward Points Module for ZC v13x

[Kezza]

Any feedback on this?

do you have edit orders or super orders mod installed?

[leilanddale]

do you have edit orders or super orders mod installed?

Now I do yes. I installed it during the past week or so. Before that, no.

[Kezza]

Now I do yes. I installed it during the past week or so. Before that, no.

http://www.zen-cart.com/forum/showpo...&postcount=153

http://www.zen-cart.com/forum/showpo...postcount=1683

[leilanddale]

http://www.zen-cart.com/forum/showpo...&postcount=153

http://www.zen-cart.com/forum/showpo...postcount=1683

Thanks!

I already have the latest of both installed. We've never edited any orders as both these modules were only installed over the last 7 days or so.

So ultimately, even before I installed the two addons, it never auto updated the points.

[delia]

So ultimately, even before I installed the two addons, it never auto updated the points.

I'm not seeing it happen either. But I wanted the points set to earned from the start since I want it to be totally automatic. So I guess setting the order status to paid with a.net payment is the first status and there's no trigger because there's no change?

So how do you set them to earned at first?

[akai0231]

Hi hem,

Thank you sooooo much!

BUT

I have done what you said again and again. But it still 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.

Hello Hem,
I have the same problem.
Any suggestion to solve it?

TX in advanced.

[hem]

Hello Hem,
I have the same problem.
Any suggestion to solve it?

TX in advanced.

From the readme.txt:

!!!WARNING!!! YOU NEED AT LEAST MySQL VERSION 4.2.0 TO RUN THIS MOD

[robbin21973]

I have read the FAQ through and am having a problem setting the redeem value for each point. I know I can go to the "group reward redeem" and create a group and set the value however it seems like every new customer will default at .01 and I am going to have to manually go in and change it.

I want it to that when anyone signs up or makes a purchase, it automatically calculates at .05 per reward point. How can I do this?

I have read through this posting and cannot seem to find it other than making a group after the fact.

Thank you.
polishpotterystore.com/shopping

[robbin21973]

I'm sorry, but I have that part down, I have already set how many points various products/categories are worth. My issue with with how much each point is redeemed for. It appears as if you can change it but only after the fact. I want to make it a default for the points to be worth 5%, or .05 each, not .01.

[y051313]

Hi All

Doese anyone konw if the PayPal IPN problem has been fixed?

Thanks
Davis