Reward Points Module for ZC v13x

[fiji]

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.


Fiji

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

[fiji]

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?

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

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

[hem]

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

[imperialis]

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

I did what you said and I get this error
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 'SQL: RENAME TABLE reward_points_history TO reward_status_track' at line 1
in:
[SQL: RENAME TABLE reward_points_history TO reward_status_track ;]
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.

I am new to zencart so i could have done anything wrong

[hem]

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

[Rasyr]

Something odd......

IF I try to place an order using Reward Points, and I ALSO try to use a Gift Certificate as well (if the GC amount is not higher than entire order), it requires me to select a billing method. If the GC and the Redeem amounts are (combined) more than the entire order, it still requires me to select a payment method.

However, if I try to place the order with JUST a Gift Certificate, and the GC amount is larger than the order, then I don't have to select a payment method.

So... whatever it doing the check as to whether payment method is required to be select isn't including the amount to be redeemed in it.

Also -- regarding my issue with Rewards Points and the redeeming applying towards shipping....

I found the following code in ot_rewards_points.php -- in the process() function

if(isset($_SESSION['redeem_value']))
{
$points_redeeming=GetCustomersRewardPoints($_SESSION['customer_id']);
if(REWARD_POINTS_REDEEM_MAXIMUM>0 && $points_redeeming>REWARD_POINTS_REDEEM_MAXIMUM)
$points_redeeming=REWARD_POINTS_REDEEM_MAXIMUM;

$redeem_ratio=GetRedeemRatio($_SESSION['customer_id']);
$points_worth=$points_redeeming*$redeem_ratio;
$order_total = $order->info['total'];

if($points_worth>$order_total)
{
$points_worth=$order_total;
$points_redeeming=zen_round($points_worth/$redeem_ratio,2);
}

$order->info['total']=zen_round($order->info['total']-$points_worth, 2);

$this->output[] = array('title' => MODULE_ORDER_TOTAL_REWARD_POINTS_VALUE,
'text' => '-'.$currencies->format($points_worth),
'value' => $points_worth);

$_SESSION['redeem_value']=$points_redeeming;
}

I have marked the two lines that I consider important in color-- the lines which show that the file is working on the Order Total, not on the Order Subtotal, which is what I am needing.

Wait! I just NOW (while writing this) figured out, that if I change $order->info['total'] to $order->info['subtotal'] in the Blue line, then that limits the number of points redeemed to be no more than the Subtotal, and thus, it will solve my issue about redeeming points also discounting the shipping.

I also have the problem where folks whose orders are being changed from Pending to Paid are not updating and moving the points from Pending to Earned. However I also had the admin email notification turned off, so I have set it to an email address I created just for it, and turned it on in the Configuration area, so maybe that will get the points to change properly.

This is a great module!! And I am loving it immensely!! I just hope you can help get my other issues worked out.

[pinetreecandles]

Look at the image I posted. The Total = Subtotal + Shipping - Reward Point

I had thought it was (and am wanting it to be)

Total = (Subtotal - Reward Point) + Shipping

So, if I have an $8.50 book, and Shipping costs $3.13 and I have 1000 Reward Points, that my final total is $3.13, NOT $1.63 (as shown in the image I posted)

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