Reward Points Module for ZC v13x

https://www.zen-cart.com/downloads.php?do=file&id=704

First mistake found- There's a bug in the update.sql. If uploaded a new version to the contributions and am attaching the corrected version here.

Andrew

Not sure if I missed it, but is there a way to prevent "gift certeficates" from counting toward points ? otherwise it's a double wammy

second, I am using the latest beta, do I need to re-run upgrade.sql ?

And BTW, my site is live and running the contribution .. if anybody wishes to check it out :)

http://rcnut.com/Reward-Points-FAQ-ezp-16

http://rcnut.com/

NullMind:

And BTW, my site is live and running the contribution .. if anybody wishes to check it out :)

http://rcnut.com/Reward-Points-FAQ-ezp-16

http://rcnut.com/

I like the FAQ- Nice work. I'll be sending my dad to your site, he's the RC nut in the family.

NullMind:

Andrew

Not sure if I missed it, but is there a way to prevent "gift certeficates" from counting toward points ? otherwise it's a double wammy

second, I am using the latest beta, do I need to re-run upgrade.sql ?

No- it should work straight out of the box.

I'll check the GV issue, thanks for the heads up.

Hem,

For some reason, I still have the same problem I had when I installed the old version regarding the account/login page. It has nothing to do with orders.php but im not sure which file causes it.

The problem is that there is too much space between the title and the text form. I have Easy Sign Up and Login installed.

Thx

Is there any way to make it so that the maximum amount of Reward Points redeemed cannot exceed the subtotal?

Feature Request -- the ability to select how many Reward Points to spend..

NullMind:

Andrew

Not sure if I missed it, but is there a way to prevent "gift certeficates" from counting toward points ? otherwise it's a double wammy

second, I am using the latest beta, do I need to re-run upgrade.sql ?

If you go to Admin|Catalog|Reward Points, you can set teh Point value for ALL products and also set different Point values for categories and/or individual products.

For Example, we give 2 points for every dollar spent on books or PDFs. Except for one group of Cloth Bound books, where we give 6 points per dollar spent, and Gift Certificates which get/give zero points when purchased.

Rasyr:

Feature Request -- the ability to select how many Reward Points to spend..

Already on the list (Reward Points- Advanced Redeem)

Berserker:

Hem,

For some reason, I still have the same problem I had when I installed the old version regarding the account/login page. It has nothing to do with orders.php but im not sure which file causes it.

The problem is that there is too much space between the title and the text form. I have Easy Sign Up and Login installed.

Thx

Any chance of a URL?

Hello,

Attached an image to show the changes after the mod was installed. Not sure which file caused it but probably one of the file under "includes" folder.

Thx

Berserker:

Hello,

Attached an image to show the changes after the mod was installed. Not sure which file caused it but probably one of the file under "includes" folder.

Thx

In the stylesheet_reward.css , delete "width:20em;" in the first label.inputLabel.:smartalec:

Fiji

andrew,

I am using your new "update.sql" in this post.
Do I have to update the Database?
When I use the update.sql, the system shows:
"1050 Table 'reward_master' already exists
in:
[RENAME TABLE reward_product_points TO reward_master;]
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."

any idea?

andrew,

I try the paypal again, it still not working in paypal mod:

1. make a $30 order, use the $20 point to check out, customer paid $10 in credit card via paypal. But both customer and admin didn't receive the confirmation email.
   Customer didn't receive the 30 ponit in pending either.

anyone tried the paypal?

andrew, paypal is not working in point mod

I try the paypal again, it still not working in paypal mod:

1. make a $30 order, use the $20 point to check out, customer paid $10 in credit card via paypal.
   1.1) both customer and admin didn't receive the confirmation email.
   1.2) Customer didn't receive the 30 ponit in pending either.

2. make another order and check out via paypal withour using point.
   2.1) all received comfimation email
   2.2) still No points in pending

Conclusion:
Use paypal to check out, no points in pending.
Use point to check out via paypal, no points in pending. no confirmation email. But do have the order number in the admin and history

anyone tried the paypal?

I just went to install and now I have a big fat error throughtout my whole site

1146 Table 'imperial_zc1.zen_reward_status_track' doesn't exist
in:
[SELECT ph.*, o.orders_status FROM zen_reward_status_track ph, zen_orders o WHERE ph.orders_id=o.orders_id AND ph.dateIf 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.

http://www.imperialgiftsnwares.com.au

help please, what did I do wrong?

imperialis:

I just went to install and now I have a big fat error throughtout my whole site

1146 Table 'imperial_zc1.zen_reward_status_track' doesn't exist
in:
[SELECT ph.*, o.orders_status FROM zen_reward_status_track ph, zen_orders o WHERE ph.orders_id=o.orders_id AND ph.dateIf 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.

http://www.imperialgiftsnwares.com.au

help please, what did I do wrong?

See the earlier post in this thread regarding the bug with the update.sql file. If this is the first time you've installed the mod then run new.sql not update.sql

Instructions to bypass this bug:

1. Go to folder \admin\includes\functions\extra_functions\
2. Rename reward_points_functions.php to reward_points_functions.xxx
3. You can now access the Admin CP
4. Go to Tools->Install SQL PAtch
5. Enter the following SQL: RENAME TABLE reward_points_history TO reward_status_track
6. Then rename reward_points_functions.xxx back to reward_points_functions.php

Note: This will not work if you use prefixes on your database. In this case either run new.sql or rename the table using phpmysql

fiji:

andrew, paypal is not working in point mod

I try the paypal again, it still not working in paypal mod:

1. make a $30 order, use the $20 point to check out, customer paid $10 in credit card via paypal.
   1.1) both customer and admin didn't receive the confirmation email.
   1.2) Customer didn't receive the 30 ponit in pending either.

2. make another order and check out via paypal withour using point.
   2.1) all received comfimation email
   2.2) still No points in pending

Conclusion:
Use paypal to check out, no points in pending.
Use point to check out via paypal, no points in pending. no confirmation email. But do have the order number in the admin and history

anyone tried the paypal?

Fiji- I've checked out the functionality of the PayPal mod that comes with ZenCart and it does work. Is there any chance that you have installed another mod that has changed or overwritten the checkout_process.php file???