Reward Points Module for ZC v13x

18 Apr 2008, 21:47

#1

hem

Totally Zenned

Join Date:: Sep 2007
Posts:: 1,281
Plugin Contributions:: 4

Reward Points Module for ZC v13x

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

18 Apr 2008, 22:08

#2

hem

Totally Zenned

Join Date:: Sep 2007
Posts:: 1,281
Plugin Contributions:: 4

Re: Reward Points Module for ZC v13x

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.

18 Apr 2008, 23:04

#3

nullmind

Zen Follower

Join Date:: Jul 2007
Posts:: 129
Plugin Contributions:: 0

Re: Reward Points Module for ZC v13x

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 ?

18 Apr 2008, 23:07

#4

nullmind

Zen Follower

Join Date:: Jul 2007
Posts:: 129
Plugin Contributions:: 0

Re: Reward Points Module for ZC v13x

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/

18 Apr 2008, 23:14

#5

hem

Totally Zenned

Join Date:: Sep 2007
Posts:: 1,281
Plugin Contributions:: 4

Re: Reward Points Module for ZC v13x

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.

18 Apr 2008, 23:15

#6

hem

Totally Zenned

Join Date:: Sep 2007
Posts:: 1,281
Plugin Contributions:: 4

Re: Reward Points Module for ZC v13x

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.

18 Apr 2008, 23:23

#7

berserker

Totally Zenned

Join Date:: May 2006
Posts:: 712
Plugin Contributions:: 0

Re: Reward Points Module for ZC v13x

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

18 Apr 2008, 23:28

#8

rasyr

Zen Follower

Join Date:: Aug 2006
Posts:: 233
Plugin Contributions:: 0

Re: Reward Points Module for ZC v13x

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

18 Apr 2008, 23:30

#9

rasyr

Zen Follower

Join Date:: Aug 2006
Posts:: 233
Plugin Contributions:: 0

Re: Reward Points Module for ZC v13x

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

18 Apr 2008, 23:36

#10

rasyr

Zen Follower

Join Date:: Aug 2006
Posts:: 233
Plugin Contributions:: 0

Re: Reward Points Module for ZC v13x

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.

19 Apr 2008, 00:00

#11

hem

Totally Zenned

Join Date:: Sep 2007
Posts:: 1,281
Plugin Contributions:: 4

Re: Reward Points Module for ZC v13x

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

Already on the list (Reward Points- Advanced Redeem)

19 Apr 2008, 00:02

#12

hem

Totally Zenned

Join Date:: Sep 2007
Posts:: 1,281
Plugin Contributions:: 4

Re: Reward Points Module for ZC v13x

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?

19 Apr 2008, 03:07

#13

berserker

Totally Zenned

Join Date:: May 2006
Posts:: 712
Plugin Contributions:: 0

Re: Reward Points Module for ZC v13x

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

19 Apr 2008, 04:37

#14

fiji

New Zenner

Join Date:: Oct 2007
Posts:: 42
Plugin Contributions:: 0

Re: Reward Points Module for ZC v13x

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

19 Apr 2008, 05:21

#15

fiji

New Zenner

Join Date:: Oct 2007
Posts:: 42
Plugin Contributions:: 0

Re: Reward Points Module for ZC v13x

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?

19 Apr 2008, 05:41

#16

fiji

New Zenner

Join Date:: Oct 2007
Posts:: 42
Plugin Contributions:: 0

Re: Reward Points Module for ZC v13x

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?

19 Apr 2008, 05:53

#17

fiji

New Zenner

Join Date:: Oct 2007
Posts:: 42
Plugin Contributions:: 0

Re: Reward Points Module for ZC v13x

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?

19 Apr 2008, 06:43

#18

imperialis

Zen Follower

Join Date:: Apr 2008
Posts:: 123
Plugin Contributions:: 0

Re: Reward Points Module for ZC v13x

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?

19 Apr 2008, 08:33

#19

hem

Totally Zenned

Join Date:: Sep 2007
Posts:: 1,281
Plugin Contributions:: 4

Re: Reward Points Module for ZC v13x

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:

Go to folder \admin\includes\functions\extra_functions\
Rename reward_points_functions.php to reward_points_functions.xxx
You can now access the Admin CP
Go to Tools->Install SQL PAtch
Enter the following SQL: RENAME TABLE reward_points_history TO reward_status_track
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

19 Apr 2008, 08:40

#20

hem

Totally Zenned

Join Date:: Sep 2007
Posts:: 1,281
Plugin Contributions:: 4

Re: Reward Points Module for ZC v13x

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