Reward Points Module for ZC v13x

Hi

I have been using this mod fine for a while now, However i had my first preorder today and for preorders i give double (x2) reward points.

However this was not given to the customer so i tried a preorder myself and it is still only given the standard 1:1 ratio.

My preorder products clearly show twice the amount of reward points for each pound. So an item costing £20 gives 40 points.

But once checked out only 20 points are added to the account.

I have my Global Ratio set to 0.035 so that 100 points is equal to £3.50. For the preorders i set the ratio of points to each pound at 2.000.

Why is the check out not given double reward points on these products?

Quote:

---

Originally Posted by DarrenQ

Hi

I have been using this mod fine for a while now, However i had my first preorder today and for preorders i give double (x2) reward points.

However this was not given to the customer so i tried a preorder myself and it is still only given the standard 1:1 ratio.

My preorder products clearly show twice the amount of reward points for each pound. So an item costing £20 gives 40 points.

But once checked out only 20 points are added to the account.

I have my Global Ratio set to 0.035 so that 100 points is equal to £3.50. For the preorders i set the ratio of points to each pound at 2.000.

Why is the check out not given double reward points on these products?

---

Hmmmm- let me check. There's been a bit of tinkering around with that area of code recently so I wonder if I've broken the product redeem feature.

Quote:

---

Originally Posted by hem

Hmmmm- let me check. There's been a bit of tinkering around with that area of code recently so I wonder if I've broken the product redeem feature.

---

Ok

Thank you for taking a look :clap:

Hi guys!

I'm having a bit of a problem and to be honest, I started reading this thread, about 25 pages all in all and yeah...not easy to find an answer, so forgive me if it's mentioned before.

When a customer checks out and uses a discount coupon or GV which ends up giving a zero balance, they are still being asked to select a payment method.

How do I get this fixed that they don't get asked for a payment method when having a zero Total Order balance?

Quote:

---

Originally Posted by hem

Hmmmm- let me check. There's been a bit of tinkering around with that area of code recently so I wonder if I've broken the product redeem feature.

---

Any New on this? I am rubbish at code so there was no point in me looking at anything lol

Quote:

---

Originally Posted by DarrenQ

Any New on this? I am rubbish at code so there was no point in me looking at anything lol

---

Check your setting for Reward Point Mode- Make sure it is set to 0.

Quote:

---

Reward Point Mode
Select the Reward Point Mode
0= Reward Points are fixed to the product prices and are calculated individually.
1= Reward Points are calculated on the Order Total or Subtotal (depending on the setting of the Allow Redeem of Reward Points on Order Total or Subtotal configuration).

---

Quote:

---

Originally Posted by leilanddale

Hi guys!

I'm having a bit of a problem and to be honest, I started reading this thread, about 25 pages all in all and yeah...not easy to find an answer, so forgive me if it's mentioned before.

When a customer checks out and uses a discount coupon or GV which ends up giving a zero balance, they are still being asked to select a payment method.

How do I get this fixed that they don't get asked for a payment method when having a zero Total Order balance?

---

What version are you using. The latest version is always available off of my website and v1.33 is available for download from Zencart.

Quote:

---

Originally Posted by hem

What version are you using. The latest version is always available off of my website and v1.33 is available for download from Zencart.

---

I'm using the 1.33a version downloaded from ZenCart.

Quote:

---

Originally Posted by hem

What version are you using. The latest version is always available off of my website and v1.33 is available for download from Zencart.

---

And your website is where? :P

Quote:

---

Originally Posted by hem

Check your setting for Reward Point Mode- Make sure it is set to 0.

---

Yes that worked thank you:clap:

Is there any way I can exclude reward points from my COWOA customers?

Quote:

---

Originally Posted by Unicorn

Is there any way I can exclude reward points from my COWOA customers?

---

As there is no account to attach the Reward Points to, does it make any difference?

Quote:

---

Originally Posted by leilanddale

Hi guys!

I'm having a bit of a problem and to be honest, I started reading this thread, about 25 pages all in all and yeah...not easy to find an answer, so forgive me if it's mentioned before.

When a customer checks out and uses a discount coupon or GV which ends up giving a zero balance, they are still being asked to select a payment method.

How do I get this fixed that they don't get asked for a payment method when having a zero Total Order balance?

---

Any update on this? I'm using the latest version downloaded from Zen Cart modules.

Quote:

---

Originally Posted by hem

As there is no account to attach the Reward Points to, does it make any difference?

---

One of the reasons I didn't install COWOA is because of this. The customer cannot use those points so they shouldn't appear as they will likely expect to be able to use them in the future.

Quote:

---

Originally Posted by leilanddale

Any update on this? I'm using the latest version downloaded from Zen Cart modules.

---

I tested it here and it is working exactly as it should- No payment method is being asked for on purchases with a zero total. Are you using any other checkout mod that might be causing this?

Quote:

---

Originally Posted by jetx

One of the reasons I didn't install COWOA is because of this. The customer cannot use those points so they shouldn't appear as they will likely expect to be able to use them in the future.

---

Would a better idea be to display something like "If you had an account you would have earned X reward points on this purchase". That would encourage more people to create an account with you.

Quote:

---

Originally Posted by hem

Would a better idea be to display something like "If you had an account you would have earned X reward points on this purchase". That would encourage more people to create an account with you.

---

Yeah, that seems to be the only option.

But I'm afraid it would have a negative impact, as there's that whole "hahaaaa!" feeling to it. "Look what you didn't get!!" is a bad thing in checkout where the customers need to feel good about their purchase, no?

Most of my customers are COWOA atm, and although I'd stress this in the login section where the customers choose an account or COWOA, it gets more complicated than it should have been.

thank you hem
does this update fix pronlem with paypal??

Hi

Is there a way to display the amount of points on the product page in this format;

Worth "x amount" Reward Points

at the moment it is displayed

"x amount" Reward Points

Thanks

Quote:

---

Originally Posted by DarrenQ

Hi

Is there a way to display the amount of points on the product page in this format;

Worth "x amount" Reward Points

at the moment it is displayed

"x amount" Reward Points

Thanks

---

So far i have tried changin the tpl_products_reward_points.php code to this;

Code:

---

echo PRODUCT_REWARD_POINT_TAG.' '.$reward_points' 'PRODUCT_REWARD_POINT_TAG_1.;

---

and added 'PRODUCT_REWARD_POINT_TAG_ into the reward_points.php in the extra definitions directory.

But this doesn't seem to work. I just blanks my page. If i remove the last 'PRODUCT_REWARD_POINT_TAG_1.; from the line in tpl it works again. What am i missing?

Quote:

---

Originally Posted by hem

Would a better idea be to display something like "If you had an account you would have earned X reward points on this purchase". That would encourage more people to create an account with you.

---

How about removing the reference to the bonus points from order total alltogether, would that work..? The customer would see the points in the sidebar box when logged in... And then maybe just have general info on reward points on main page or on page 4 or something.

If anyone is wanting to display a different message for COWOA custmers, here's how I did it...as for having a negative impact, I haven't noticed.
In fact, I have had customers sign up for a full account and ask if they can have their points from their COWOA order, which I'm always glad to do!
The good thing about this mod is the points do get stored against the COWOA order so you can see how many points to transfer across to the full account.

Add the following defines to file includes/languages/english/modules/order_total/ot_reward_points_display.php

Code:

---

define('MODULE_ORDER_TOTAL_REWARD_POINTS_DISPLAY_COWOA_TITLE', 'With a full account, you could have earned');
define('MODULE_ORDER_TOTAL_REWARD_POINTS_DISPLAY_COWOA_TAG', 'points!');
define('FONT_RED','<font color="red">');
define('UNFONT','</font>');

---

Add the code below shown in red to function process() in file includes/modules/order_total/ot_reward_points_display.php

Code:

---

    function process()
        {
                global $order;

                $reward_points=GetRewardPoints($order->products);
               
                $GlobalRewardPointRatio=GetGlobalRewardPointRatio();
                $AdjustValue=GetRewardPointAdvancedCalculateValue();
                $reward_points+=$AdjustValue*$GlobalRewardPointRatio;
               
                if(isset($_SESSION['redeem_value']))
                {
                        /*
                        $redeem_ratio=GetRedeemRatio($_SESSION['customer_id']);
                        $reward_points=$reward_points/$redeem_ratio;
                        $reward_points=$reward_points-$_SESSION['redeem_value'];
                        $reward_points=$reward_points*$redeem_ratio;
                        */
                        $reward_points=$reward_points-($GlobalRewardPointRatio*$_SESSION['redeem_value']);
                }

                if($reward_points<0)
                $reward_points=0;
               
                $reward_points=zen_round($reward_points,0);
                $_SESSION['REWARD_POINTS_EARNED']=$reward_points;
               
                if ($_SESSION['COWOA']) {
                $this->output[] = array('title' => FONT_RED . MODULE_ORDER_TOTAL_REWARD_POINTS_DISPLAY_COWOA_TITLE . '&nbsp;' . $reward_points . '&nbsp;' . MODULE_ORDER_TOTAL_REWARD_POINTS_DISPLAY_COWOA_TAG . UNFONT,
                              'text' => '',
                              'value' => 0);
                } else {
                $this->output[] = array('title' => $this->title . ':',
                              'text' => $reward_points,
                              'value' => 0);
                }
    }

---

Quote:

---

Originally Posted by damiantaylor

If anyone is wanting to display a different message for COWOA custmers, here's how I did it...as for having a negative impact, I haven't noticed.
In fact, I have had customers sign up for a full account and ask if they can have their points from their COWOA order, which I'm always glad to do!
The good thing about this mod is the points do get stored against the COWOA order so you can see how many points to transfer across to the full account.

---

Nice one Damian- Do you mind if I include that in the mod as a supplemental addon?

Quote:

---

Originally Posted by damiantaylor

If anyone is wanting to display a different message for COWOA custmers, here's how I did it...

---

Thanks, but this just gave me a blank checkout_payment..?

Hi Andrew,
You can use that code, no problem.

Unicorn,
Are you using the latest version of the mod? If memory serves correctly I have 1.33a.
Does your original process() function look like this:

Code:

---

    function process()
        {
                global $order;

                $reward_points=GetRewardPoints($order->products);
               
                $GlobalRewardPointRatio=GetGlobalRewardPointRatio();
                $AdjustValue=GetRewardPointAdvancedCalculateValue();
                $reward_points+=$AdjustValue*$GlobalRewardPointRatio;
               
                if(isset($_SESSION['redeem_value']))
                {
                        /*
                        $redeem_ratio=GetRedeemRatio($_SESSION['customer_id']);
                        $reward_points=$reward_points/$redeem_ratio;
                        $reward_points=$reward_points-$_SESSION['redeem_value'];
                        $reward_points=$reward_points*$redeem_ratio;
                        */
                        $reward_points=$reward_points-($GlobalRewardPointRatio*$_SESSION['redeem_value']);
                }

                if($reward_points<0)
                $reward_points=0;
               
                $reward_points=zen_round($reward_points,0);
                $_SESSION['REWARD_POINTS_EARNED']=$reward_points;
               
                $this->output[] = array('title' => $this->title . ':',
                              'text' => $reward_points,
                              'value' => 0);
    }

---

A blank page usually means a php syntax error or an undefined field.

Quote:

---

Originally Posted by damiantaylor

Hi Andrew,
You can use that code, no problem.

Does your original process() function look like this:


A blank page usually means a php syntax error or an undefined field.

---

Yes, it does... May have gotten a synax error, though I cannot figure out where and why. I'll have another look at it! :)

try commenting out the bit of added code, so the function would look like this:

Code:

---

    function process()
        {
                global $order;

                $reward_points=GetRewardPoints($order->products);
               
                $GlobalRewardPointRatio=GetGlobalRewardPointRatio();
                $AdjustValue=GetRewardPointAdvancedCalculateValue();
                $reward_points+=$AdjustValue*$GlobalRewardPointRatio;
               
                if(isset($_SESSION['redeem_value']))
                {
                        /*
                        $redeem_ratio=GetRedeemRatio($_SESSION['customer_id']);
                        $reward_points=$reward_points/$redeem_ratio;
                        $reward_points=$reward_points-$_SESSION['redeem_value'];
                        $reward_points=$reward_points*$redeem_ratio;
                        */
                        $reward_points=$reward_points-($GlobalRewardPointRatio*$_SESSION['redeem_value']);
                }

                if($reward_points<0)
                $reward_points=0;
               
                $reward_points=zen_round($reward_points,0);
                $_SESSION['REWARD_POINTS_EARNED']=$reward_points;
/*       
                if ($_SESSION['COWOA']) {
                $this->output[] = array('title' => FONT_RED . MODULE_ORDER_TOTAL_REWARD_POINTS_DISPLAY_COWOA_TITLE . '&nbsp;' . $reward_points . '&nbsp;' . MODULE_ORDER_TOTAL_REWARD_POINTS_DISPLAY_COWOA_TAG . UNFONT,
                              'text' => '',
                              'value' => 0);
                } else {
*/
                $this->output[] = array('title' => $this->title . ':',
                              'text' => $reward_points,
                              'value' => 0);
//                }
    }

---

If that works, I think it must be one of the defines that hasn't been defined:

Code:

---

FONT_RED
MODULE_ORDER_TOTAL_REWARD_POINTS_DISPLAY_COWOA_TITLE
MODULE_ORDER_TOTAL_REWARD_POINTS_DISPLAY_COWOA_TAG
UNFONT

---

Quote:

---

Originally Posted by hem

I tested it here and it is working exactly as it should- No payment method is being asked for on purchases with a zero total. Are you using any other checkout mod that might be causing this?

---

The only other payment methods I'm using are 2Checkout and PayPal Express.

I updated my order status using super orders batch update and none of the orders have had their points moved from pending to earned.

I'm using Advanced which state Pend: [Order Processing] Earn: [Order Completed]

Why haven't the points updated.

Hi i was wondering if anybody had an answer to this problem.

I am trying to change the message for reward points shown in the product page. at the moment it says "33 reward points"
However i would like it to display as "Worth 33 Reward Points"

How can i move the Number of points?

So far i have tried changing the tpl_products_reward_points.php code to this;

Code:

---

echo PRODUCT_REWARD_POINT_TAG.' '.$reward_points' 'PRODUCT_REWARD_POINT_TAG_1.;

---

and added 'PRODUCT_REWARD_POINT_TAG_1.; into the reward_points.php in the extra definitions directory.

But this doesn't seem to work. I just blanks my page. If i remove the last 'PRODUCT_REWARD_POINT_TAG_1.; from the line in tpl it works again. What am i missing?

try

Code:

---

echo PRODUCT_REWARD_POINT_TAG . ' ' . $reward_points . ' ' . PRODUCT_REWARD_POINT_TAG_1;

---

I recently updated my reward points module to the new version and it wiped all my reward points that I had in my store already. Hem mentioned that I can restor the sql tables and they will all come back, but I do not know where these are to restore them. I did back up my site before I did that so are the sql tables you are referring to in the back up files somewhere? If so, can someone tell me exactly where they are found in the system files so I can restore them?

Also, the reward points are no longer being shown on the product description pages. Is this something that is new with the updated module? If so that is fine, I just was afraid that I had done something wrong.

Thanks in advance to anyone that can help me. And thanks to hem for putting up with me up till now.

Laurie

Can anybody help me with my problem? Does anybody know how I can restore my erased reward points through restoring the sql tables?

Thank you in advance.

Laurie- you should have three SQL tables backed up: reward_customer_points.sql, reward_status_track.sql and reward_master.sql (they might have zen_ prepended to the names if you use that option in ZenCart). If you run these using Admin->Tools->SQL Patch, that will reload the tables with the backed up data.

Quote:

---

Originally Posted by DarrenQ

Hi i was wondering if anybody had an answer to this problem.

I am trying to change the message for reward points shown in the product page. at the moment it says "33 reward points"
However i would like it to display as "Worth 33 Reward Points"

How can i move the Number of points?

So far i have tried changing the tpl_products_reward_points.php code to this;

Code:

---

echo PRODUCT_REWARD_POINT_TAG.' '.$reward_points' 'PRODUCT_REWARD_POINT_TAG_1.;

---

and added 'PRODUCT_REWARD_POINT_TAG_1.; into the reward_points.php in the extra definitions directory.

But this doesn't seem to work. I just blanks my page. If i remove the last 'PRODUCT_REWARD_POINT_TAG_1.; from the line in tpl it works again. What am i missing?

---

Remove the full stop from after PRODUCT_REWARD_POINT_TAG

Quote:

---

Originally Posted by DigitalShadow

I updated my order status using super orders batch update and none of the orders have had their points moved from pending to earned.

I'm using Advanced which state Pend: [Order Processing] Earn: [Order Completed]

Why haven't the points updated.

---

Is the other mod built on a version of Zencart earlier than v1.3.8? I have had issues in the past with Order based mods that rewrite the core orders.php file. Ones not based on v1.3.8 do not use the observer/notifier system so they never call the Reward Point functions.

To check, download the RPD (ftp://ftp.omnicia.com/rpd.zip) and extract the two files to the root of your store. Run this under your browser by typing "www.MY_STORE_ADDRESS.com/rpd.php" and check the final section (Special Rules Check). You should see the following:

Quote:

---

Special Rules Check
Found ->notify('NOTIFY_ORDER_DURING_CREATE_ADDED_ORDER_HEADER' in includes/classes/order.php
Found ->notify('NOTIFY_MODULE_CREATE_ACCOUNT_ADDED_ in includes/modules/create_account.php
Found ->notify('NOTIFY_LOGIN_SUCCESS'); in includes/modules/pages/login/header_php.php

---

Quote:

---

Originally Posted by hem

Laurie- you should have three SQL tables backed up: reward_customer_points.sql, reward_status_track.sql and reward_master.sql (they might have zen_ prepended to the names if you use that option in ZenCart). If you run these using Admin->Tools->SQL Patch, that will reload the tables with the backed up data.

---

I tried looking for these files and I am not seeing them. Even did a file search for them. Where would they be located? Sorry to bother again. Thanks for your help.

Quote:

---

Originally Posted by lauriesscraps

I tried looking for these files and I am not seeing them. Even did a file search for them. Where would they be located? Sorry to bother again. Thanks for your help.

---

Most likely where your browser downloads files to and then possibly inside a zip file if that is what your backup program created.

I used Core FTP to transfer the files from the server to my external hard drive so the files look the same as they do on the server. They didn't download to a temp folder like my other internet downloads do. I am sorry to be so difficult. I know this is simple, I guess I just need to get the same page as everyone else.

Quote:

---

Originally Posted by damiantaylor

try

Code:

---

echo PRODUCT_REWARD_POINT_TAG . ' ' . $reward_points . ' ' . PRODUCT_REWARD_POINT_TAG_1;

---

---

Great thank you that sorted it. :clap:

I do have another problem now though, where can i find the file to edit the display in the sidebox for the reward points.

Now i have changed the prouct display text it is now jut say 33 worth in the shopping basket [more] sidebox?

Ok installed the latest version Brand new install(is there a tutorial somewhere on exactly hoe to configure it)

anyway it didn't work, so I reuploaded all files, and then manually checked they all went up

I have run th rpd file and these were the lines that came up in red

MySQL Database Check

customers_id- field missing in zen_reward_customer_points!!!
reward_points- field missing in zen_reward_customer_points!!!
pending_points- field missing in zen_reward_customer_points!!!
rewards_id- field missing in zen_reward_status_track!!!
customers_id- field missing in zen_reward_status_track!!!
orders_id- field missing in zen_reward_status_track!!!
date- field missing in zen_reward_status_track!!!
reward_points- field missing in zen_reward_status_track!!!
status- field missing in zen_reward_status_track!!!
Allow Redeem of Reward Points on Order Total or Subtotal- record missing in zen_configuration!!!

Everything else was fine

I had run the sql-new thingie via the zencart install sql patches link

I f i do it again will it fix it?

Only these ones appear show in red
zen_reward_customer_points- table found.
customers_id- field missing in zen_reward_customer_points!!!
reward_points- field missing in zen_reward_customer_points!!!
pending_points- field missing in zen_reward_customer_points!!!
zen_reward_status_track- table found.
rewards_id- field missing in zen_reward_status_track!!!
customers_id- field missing in zen_reward_status_track!!!
orders_id- field missing in zen_reward_status_track!!!
date- field missing in zen_reward_status_track!!!
reward_points- field missing in zen_reward_status_track!!!
status- field missing in zen_reward_status_track!!!
zen_configuration- table found.
Allow Redeem of Reward Points on Order Total or Subtotal- record missing in zen_configuration!!!

When i check in phpmyadmin those fields do appear to be in those tables

Quote:

---

Originally Posted by nigelt74

Only these ones appear show in red
zen_reward_customer_points- table found.
customers_id- field missing in zen_reward_customer_points!!!
reward_points- field missing in zen_reward_customer_points!!!
pending_points- field missing in zen_reward_customer_points!!!
zen_reward_status_track- table found.
rewards_id- field missing in zen_reward_status_track!!!
customers_id- field missing in zen_reward_status_track!!!
orders_id- field missing in zen_reward_status_track!!!
date- field missing in zen_reward_status_track!!!
reward_points- field missing in zen_reward_status_track!!!
status- field missing in zen_reward_status_track!!!
zen_configuration- table found.
Allow Redeem of Reward Points on Order Total or Subtotal- record missing in zen_configuration!!!

When i check in phpmyadmin those fields do appear to be in those tables

---

I think that might be a false positive- What version of PHP and MySQL are you running?

I have tried searching this rather large thread for answers, but none of my key words get a result. So here goes.

I just installed this module on my cart. My business has been in operation for 2 years now, and I have a lot of loyal customers. I would like to give my existing customers reward points to match the orders that they have made. Is there a simple way to do this?

Thanks

Sharni

Quote:

---

Originally Posted by hem

I think that might be a false positive- What version of PHP and MySQL are you running?

---

PHP Version 5.2.12
MySQL 5.0.90-community

But it still doesn't work as in when i make an order and mark it as dispatched no reward points are awarded

I'll add a link to the rpd file

http://nigel.geek.nz/sbo_shop/rpd.php

Quote:

---

Originally Posted by lauriesscraps

I used Core FTP to transfer the files from the server to my external hard drive so the files look the same as they do on the server. They didn't download to a temp folder like my other internet downloads do. I am sorry to be so difficult. I know this is simple, I guess I just need to get the same page as everyone else.

---

Can anyone help me with this please?

Quote:

---

Originally Posted by lauriesscraps

I recently updated my reward points module to the new version and it wiped all my reward points that I had in my store already. Hem mentioned that I can restor the sql tables and they will all come back, but I do not know where these are to restore them. I did back up my site before I did that so are the sql tables you are referring to in the back up files somewhere? If so, can someone tell me exactly where they are found in the system files so I can restore them?

Also, the reward points are no longer being shown on the product description pages. Is this something that is new with the updated module? If so that is fine, I just was afraid that I had done something wrong.

Thanks in advance to anyone that can help me. And thanks to hem for putting up with me up till now.

Laurie

---

Points are stored on the MySQL database. If you upgraded to the newer version and made sure to use the UPGRADE.SQL file included, you should not have lost your points. However, if you went "NEW.SQL", then your databases were demolished and new data was made.

If you upgraded, did you check to see if there was new code for the new version and the old?

I did use the update.sql but it had errors so I then used the new.sql. I know that is why, but I backed up all my files from the server through Core FTP to my EHD. So I was wondering if there was a file from that back up that would have the old rewards points stored so I can just restore that file.

I did not check for new coding. Not sure what you mean by that, but I did not check for new coding. Any suggestions?

Would doing a complete restore of all the files in my back up do it? If so I can do that but I do not want to wipe any orders I have recieved since the back up was done, and I don't want to erase any products that were added. Does anybody know which files I should avoid restoring as to not erase the orders and products that were added since the back up?

Thanks again.

I'm trying to figure this out. Either its me or Reward Points is ignoring the category based rewards. Example:

I have my categories set up to give 0 rewards for the category "Gift Certificates". However, I still see the Gift Certificates awarding points as if I didn't even tell Rewards Points to award 0.

To further this, the item's product page reflects 0 points in the item display.

Can anyone help?

Quote:

---

Originally Posted by lauriesscraps

Would doing a complete restore of all the files in my back up do it? If so I can do that but I do not want to wipe any orders I have recieved since the back up was done, and I don't want to erase any products that were added. Does anybody know which files I should avoid restoring as to not erase the orders and products that were added since the back up?

Thanks again.

---

Not really. Database data and files are two different notes.

If you didn't do a back up of your database schemas prior to doing the update, then there is no reversal on this. You would need the SQL coding for your entire database available. Just backing up your files isn't enough. This is why whenever you do anything involving the database, it's a good idea to go to your hosting control panel and log into likely phpMyAdmin and do a complete backup of all your databases (even those not necessarily of ZenCart) before doing such work.

I would check with your host to see if they provide any automated back up and see if they a copy of your MySQL somewhere.

If you do a restore, there is a way to avoid losing your data. Restores normally involve doing a "IF THIS TABLE EXISTS, DELETE IT" sort of thing... So you may want to remove the CREATE TABLE coding. Secondly, any inserts should be changed from INSERT INTO to INSERT IGNORE INTO. This way you prevent duplicates. Doing this will tell MySQL to insert all of the data from the backup before you did MySQL ignoring any conflicts. This way you keep your current data and add your backup data.

This may sound a bit complicated but just remember before you begin... BACKUP EVERYTHING...

Trying it now. I hope it works. Long process and I have never done it before. Thanks for the information. I hope it saves me! THANK YOU, THANK YOU, THANK YOU!!!

If you need help with this I can help you through it. Otherwise, make sure you get the backup just in case something goes wrong.

Quote:

---

Originally Posted by retched

If you need help with this I can help you through it. Otherwise, make sure you get the backup just in case something goes wrong.

---

Thank you. I might, but I have a tutorial that HostMonster has created for this so I will give it a try, but I have downloaded a back up. Now I just have to do another backup before I do it. This seems so confusing! UGH! Thanks, I will let you know what happens.

Actually, I do have one question, how do I now which database to use. I have one called "_zc01 (106)". Is that the one? The others that are even close all say "_znc...something".

Quote:

---

Originally Posted by lauriesscraps

Thank you. I might, but I have a tutorial that HostMonster has created for this so I will give it a try, but I have downloaded a back up. Now I just have to do another backup before I do it. This seems so confusing! UGH! Thanks, I will let you know what happens.

Actually, I do have one question, how do I now which database to use. I have one called "_zc01 (106)". Is that the one? The others that are even close all say "_znc...something".

---

An easy way to answer this would be to check configure.php file for your ZenCart installation.

Open includes/configure.php in a text editor and look for define('DB_PREFIX', 'zen_');

Anything with the value listed in the second set of quotes, in my example 'zen_' is the database for ZenCart.

As for which database, look for define('DB_DATABASE', 'betadata');. That will list your zencart database. In my example, that is 'betadata'.

Still can't get it to work

I turned on my error log and I have this error

[09-Aug-2010 14:38:22] StoreRewardPoints called but SESSION['REWARD_POINTS_EARNED'] not found

This seems to happen when i place the order

Quote:

---

Originally Posted by nigelt74

Still can't get it to work

I turned on my error log and I have this error

[09-Aug-2010 14:38:22] StoreRewardPoints called but SESSION['REWARD_POINTS_EARNED'] not found

This seems to happen when i place the order

---

While installing, did you make sure to make all of the changes in each folder?

Quote:

---

Originally Posted by retched

An easy way to answer this would be to check configure.php file for your ZenCart installation.

Open includes/configure.php in a text editor and look for define('DB_PREFIX', 'zen_');

Anything with the value listed in the second set of quotes, in my example 'zen_' is the database for ZenCart.

As for which database, look for define('DB_DATABASE', 'betadata');. That will list your zencart database. In my example, that is 'betadata'.

---

Could I find this configure.php file under admin? If so, it does not show any text like this. Do I need to be looking for it somewhere else? Thanks!

Quote:

---

Originally Posted by lauriesscraps

Could I find this configure.php file under admin? If so, it does not show any text like this. Do I need to be looking for it somewhere else? Thanks!

---

The configure.php file I'm referring to is /catalog/includes/configure.php.

Essentially that is the <root of the zencart>/includes/configure.php

Quote:

---

Originally Posted by retched

An easy way to answer this would be to check configure.php file for your ZenCart installation.

Open includes/configure.php in a text editor and look for define('DB_PREFIX', 'zen_');

Anything with the value listed in the second set of quotes, in my example 'zen_' is the database for ZenCart.

As for which database, look for define('DB_DATABASE', 'betadata');. That will list your zencart database. In my example, that is 'betadata'.

---

I found the file, sorry, looking in the wrong place. I found this text:

Quote:

---

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'UNHere_zc01');
define('DB_SERVER_PASSWORD', 'Password here');
define('DB_DATABASE', 'UNHere_zc01');
define('USE_PCONNECT', 'false');
define('STORE_SESSIONS', 'db');

---

The text in red was changed as to not give out sensitive information. But there is nothing next to DB_PREFIX but there is the zc01 that I saw once I was in the CPanel under databases. So I am assuming that is it. Thanks again. I will give this a try in the morning.

Quote:

---

Originally Posted by retched

While installing, did you make sure to make all of the changes in each folder?

---

If you mean change the folder names to my template then yes as can be seen here

http://nigel.geek.nz/sbo_shop/rpd.php

and as for the bits that show up in red, those bits all exist in the database, i checked

Quote:

---

Originally Posted by lauriesscraps

I found the file, sorry, looking in the wrong place. I found this text:


The text in red was changed as to not give out sensitive information. But there is nothing next to DB_PREFIX but there is the zc01 that I saw once I was in the CPanel under databases. So I am assuming that is it. Thanks again. I will give this a try in the morning.

---

What you were typing made me believe that you were referring to a prefix, this is a suffix you're talking about now.

Essentially use the name of the database that is given by the configure.php file. That is the database where zencart is installed.

Quote:

---

Originally Posted by nigelt74

Still can't get it to work

I turned on my error log and I have this error

[09-Aug-2010 14:38:22] StoreRewardPoints called but SESSION['REWARD_POINTS_EARNED'] not found

This seems to happen when i place the order

---

Quote:

---

Originally Posted by nigelt74

If you mean change the folder names to my template then yes as can be seen here

http://nigel.geek.nz/sbo_shop/rpd.php

and as for the bits that show up in red, those bits all exist in the database, i checked

---

Ok. So you get those error messages you posted in your last message and then this one about SESSION[] not being stored...

Are you absolutely sure that you edited the files in the right manner?

In addition, when you created the tables and the modifications to the table, did you make sure that the datatypes of the table match those that rewards points are looking for?

Quote:

---

Originally Posted by retched

Ok. So you get those error messages you posted in your last message and then this one about SESSION[] not being stored...

Are you absolutely sure that you edited the files in the right manner?

In addition, when you created the tables and the modifications to the table, did you make sure that the datatypes of the table match those that rewards points are looking for?

---

according to the readme i have, there are no files to be edited.
There are 3 folders to be renamed which i have done
There is an sql script to be actioned, in my case it was new.sql
all of which i have done,

The sql script created the tables, so the datatypes should be correct, just no information is being put in them and the rpd file is showing those fields as being missing.

the datatypes appear correct to me looking at them through phpmyadmin

and yes my database uses a prefix zen_, but as you can see the rpd picks that up

-------------edit----------------------------

I'll state this now

It is working to a point, when i add products to my cart reward points are displayed in the left hand column, however when i check out, the reward points vanish they are not listed as pending nor are they applied, they are goneburger

Quote:

---

Originally Posted by nigelt74

I'll state this now

It is working to a point, when i add products to my cart reward points are displayed in the left hand column, however when i check out, the reward points vanish they are not listed as pending nor are they applied, they are goneburger

---

Is the order total modules installed and set to "True" in admin?

Quote:

---

Originally Posted by retched

Is the order total modules installed and set to "True" in admin?

---

you beat me to it

I just ticked the "reward points earned" and that fixed it, not sure how I missed that


I am still getting this in red though

Allow Redeem of Reward Points on Order Total or Subtotal- record missing in zen_configuration!!!

and I know it is set to zero(against subtotal) in admin

Quote:

---

Originally Posted by nigelt74

you beat me to it

I just ticked the "reward points earned" and that fixed it, not sure how I missed that


I am still getting this in red though

Allow Redeem of Reward Points on Order Total or Subtotal- record missing in zen_configuration!!!

and I know it is set to zero(against subtotal) in admin

---

0 is generally interpreted as FALSE in php or "not there" in PHP. Try setting it to 1 and rerun it.

Quote:

---

Originally Posted by retched

0 is generally interpreted as FALSE in php or "not there" in PHP. Try setting it to 1 and rerun it.

---

makes no difference

Quote:

---

Originally Posted by nigelt74

makes no difference

---

Try to run your checkout again. If it works, this might one of those false positives.

If it doesn't, then you may want to check on the SQL you used to install.

I am working with my hosting company right now to get the MySQL file from a back up that was done by them on 7/31 which was a day before the wipe.

So As I am doing this, I also noticed that even with the updates, I am stll having a problem with my points going straight to earned. They are still being put into pending even when the sunrise period is set at zero.

Any ideas on that one? Thanks!

ok, I got MySQL file backup, now I just have to import it into the database. My hosting company says it would be too hard for me to make those changes to the way I import the file and it would be a lengthy process so he suggested getting someone to help.

He said:

Quote:

---

The main gist of this is that you're going to have to remove some drop commands and modify some inserts, save the file with the changes and then import the dump in PHPMyAdmin

---

So I am too afraid to do it myself for fear I would screw everything up even worse. Can you help me with it or anyones else help me so I don't screw it up? Let me know what you would need if you are willing. Thank you.

Quote:

---

Originally Posted by lauriesscraps

ok, I got MySQL file backup, now I just have to import it into the database. My hosting company says it would be too hard for me to make those changes to the way I import the file and it would be a lengthy process so he suggested getting someone to help.

He said:


So I am too afraid to do it myself for fear I would screw everything up even worse. Can you help me with it or anyones else help me so I don't screw it up? Let me know what you would need if you are willing. Thank you.

---

Laurie- just send the files to me, I think I still have access to your site.

Quote:

---

Originally Posted by nigelt74

PHP Version 5.2.12
MySQL 5.0.90-community

But it still doesn't work as in when i make an order and mark it as dispatched no reward points are awarded

I'll add a link to the rpd file

http://nigel.geek.nz/sbo_shop/rpd.php

---

Check this line in the RPD:

Quote:

---

Allow Redeem of Reward Points on Order Total or Subtotal- record missing in zen_configuration!!!

---

Try reinstalling upgrade.sql

Quote:

---

Originally Posted by hem

Laurie- just send the files to me, I think I still have access to your site.

---

I only have one file. Should there be more? I also do not have your email, so if you could PM me with it that would be great!

You have access to my Zen Admin and to the FTP. They way they told me to do it required for me to import the file through the CPanel.

Let me know what you need.

Quote:

---

Originally Posted by lauriesscraps

I only have one file. Should there be more? I also do not have your email, so if you could PM me with it that would be great!

You have access to my Zen Admin and to the FTP. They way they told me to do it required for me to import the file through the CPanel.

Let me know what you need.

---

Actually, the file is in my root directory. Is is has my username and then zc01.sql. Let me know if you need anything else.

Thank you!

Quote:

---

Originally Posted by lauriesscraps

ok, I got MySQL file backup, now I just have to import it into the database. My hosting company says it would be too hard for me to make those changes to the way I import the file and it would be a lengthy process so he suggested getting someone to help.

He said:


So I am too afraid to do it myself for fear I would screw everything up even worse. Can you help me with it or anyones else help me so I don't screw it up? Let me know what you would need if you are willing. Thank you.

---

This actually was what I was talking to you about in my post in regards to the change some of the SQL coding from INSERT INTO to INSERT IGNORE INTO and remove the delete tables. But I think you're getting help on this already. :)

Quote:

---

Originally Posted by lauriesscraps

Actually, the file is in my root directory. Is is has my username and then zc01.sql. Let me know if you need anything else.

Thank you!

---

I don't see it. I can see a series of SimpleScript backups, is it one of those?

Quote:

---

Originally Posted by hem

I don't see it. I can see a series of SimpleScript backups, is it one of those?

---

Nevermind, found it. Okay, all the Reward Point tables have been restored to the last backup.

OH MY GOSH!!! Thank you! I just have to add a few that look like got overrided from orders over the last couple weeks but that is much better than having 3 pages of reward points to add! THANK YOU! You, once again, rock my world. I promise I will try to leave you alone now. Hahaha, thank you!

Quote:

---

Originally Posted by hem

Nevermind, found it. Okay, all the Reward Point tables have been restored to the last backup.

---

I am now getting an error message at the bottom of the customers>reward points screen.

Code:

---

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 'AND status=0 ORDER BY date DESC LIMIT 12' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM reward_status_track WHERE customers_id= AND status=0 ORDER BY date DESC LIMIT 12;]
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.

---

Do you know what this is about?

Actually, I fixed it by running the update SQL again. I hope that didn't screw anything up! I am also having an issue with reward points not going straight to earned. I have the sunrise period set to zero, so not sure what else I need to fix. Also, still rewarding points for free gifts even though I have it set to earn points depending on order total. Any ideas?

Quote:

---

Originally Posted by hem

Check this line in the RPD:



Try reinstalling upgrade.sql

---

Believe me i have done that a few time

Quote:

---

Originally Posted by Rasyr

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

---

This is built in if I recal correctly. Otherwise, there is a bit of code you could just add in to make this right.

Quote:

---

Originally Posted by lauriesscraps

Actually, I fixed it by running the update SQL again. I hope that didn't screw anything up! I am also having an issue with reward points not going straight to earned. I have the sunrise period set to zero, so not sure what else I need to fix. Also, still rewarding points for free gifts even though I have it set to earn points depending on order total. Any ideas?

---

Set Reward Point Mode to 1 .

Also either set your payments initial order status to something other than Pending or go to Admin->Reward Points and set Reward Point Status Track to Advanced and change all the statuses to Earned

Quote:

---

Originally Posted by nigelt74

Believe me i have done that a few time

---

Okay, try going to Admin->Tools->Install SQL Patch and copy the following into the query box:

Code:

---

REPLACE INTO `configuration`
(`configuration_id` ,`configuration_title` ,`configuration_key` ,`configuration_value` ,`configuration_description` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)
VALUES (NULL , 'Allow Redeem of Reward Points on Order Total or Subtotal', 'REWARD_POINTS_ALLOW_TOTAL', '0', 'Allow points to be redeemed against the full order (including shipping) or only against the subtotal.<br />0= Against the subtotal.<br />1= Against the full order.', @group_id, '9', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');

---

Let me know if you get any error

Quote:

---

Originally Posted by hem

Okay, try going to Admin->Tools->Install SQL Patch and copy the following into the query box:

Code:

---

REPLACE INTO `configuration`
(`configuration_id` ,`configuration_title` ,`configuration_key` ,`configuration_value` ,`configuration_description` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)
VALUES (NULL , 'Allow Redeem of Reward Points on Order Total or Subtotal', 'REWARD_POINTS_ALLOW_TOTAL', '0', 'Allow points to be redeemed against the full order (including shipping) or only against the subtotal.<br />0= Against the subtotal.<br />1= Against the full order.', @group_id, '9', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');

---

Let me know if you get any error

---

yep get an error

1048 Column 'configuration_group_id' cannot be null
in:
[REPLACE INTO zen_configuration (configuration_id ,configuration_title ,configuration_key ,configuration_value ,configuration_description ,configuration_group_id ,sort_order ,last_modified ,date_added ,use_function ,set_function) VALUES (NULL , 'Allow Redeem of Reward Points on Order Total or Subtotal', 'REWARD_POINTS_ALLOW_TOTAL', '0', 'Allow points to be redeemed against the full order (including shipping) or only against the subtotal.
0= Against the subtotal.
1= Against the full order.', @group_id, '9', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');]
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.

Quote:

---

Originally Posted by nigelt74

yep get an error

1048 Column 'configuration_group_id' cannot be null
in:
[REPLACE INTO zen_configuration (configuration_id ,configuration_title ,configuration_key ,configuration_value ,configuration_description ,configuration_group_id ,sort_order ,last_modified ,date_added ,use_function ,set_function) VALUES (NULL , 'Allow Redeem of Reward Points on Order Total or Subtotal', 'REWARD_POINTS_ALLOW_TOTAL', '0', 'Allow points to be redeemed against the full order (including shipping) or only against the subtotal.
0= Against the subtotal.
1= Against the full order.', @group_id, '9', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');]
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.

---

Ah sorry, forgot to retrieve the @group_id. Try this:

Code:

---

SET @group_id = '';
SELECT (@group_id := `configuration_group_id`) FROM `configuration_group` WHERE `configuration_group_title` LIKE 'Reward Points';

REPLACE INTO `configuration`
(`configuration_id` ,`configuration_title` ,`configuration_key` ,`configuration_value` ,`configuration_description` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)
VALUES (NULL , 'Allow Redeem of Reward Points on Order Total or Subtotal', 'REWARD_POINTS_ALLOW_TOTAL', '0', 'Allow points to be redeemed against the full order (including shipping) or only against the subtotal.<br />0= Against the subtotal.<br />1= Against the full order.', @group_id, '9', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');

---

First of all, awesome module, really loving it!

Second, I have a question to limit the issuance of points..

I love being able to issue rewards points for goods that are according to Standard Retail Price (SRP), however when the product is discounted, I would not want to offer rewards points..

Basically, the way we have it in mind is that if a product is charged according to SRP, we'd give free shipping, rewards points and the ability to use certain payment options.. However, if we're providing a discounted rate (which actually means, we're charging them at whole-sale price), we'd not want to offer any benefits, in order for us not to go negative on our profits..

Is there any way right now to implement this?

Quote:

---

Originally Posted by mask2011

First of all, awesome module, really loving it!

Second, I have a question to limit the issuance of points..

I love being able to issue rewards points for goods that are according to Standard Retail Price (SRP), however when the product is discounted, I would not want to offer rewards points..

Basically, the way we have it in mind is that if a product is charged according to SRP, we'd give free shipping, rewards points and the ability to use certain payment options.. However, if we're providing a discounted rate (which actually means, we're charging them at whole-sale price), we'd not want to offer any benefits, in order for us not to go negative on our profits..

Is there any way right now to implement this?

---

The easiest way would be to put all your discounted items into a Category called Discounts and then go to Admin->Categories->Reward Points and set the Redeem value of that category to 0.

Actually, in my store it works a bit different.. Discounted products would be normal products (showing as SRP products on my site) but my members will have discount coupons to enter during check-out to enjoy the lower price..

So, in this case, is there a way to limit rewards accrual (and maybe even redemption) only on sales that do not have a discount coupon applied to it?

Quote:

---

Originally Posted by hem

Ah sorry, forgot to retrieve the @group_id. Try this:

Code:

---

SET @group_id = '';
SELECT (@group_id := `configuration_group_id`) FROM `configuration_group` WHERE `configuration_group_title` LIKE 'Reward Points';

REPLACE INTO `configuration`
(`configuration_id` ,`configuration_title` ,`configuration_key` ,`configuration_value` ,`configuration_description` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)
VALUES (NULL , 'Allow Redeem of Reward Points on Order Total or Subtotal', 'REWARD_POINTS_ALLOW_TOTAL', '0', 'Allow points to be redeemed against the full order (including shipping) or only against the subtotal.<br />0= Against the subtotal.<br />1= Against the full order.', @group_id, '9', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');

---

---

Nope still get the same issue, however it seems to work fine.

and on a completely different note and probably not overly important

Is there a way to

a) reset all rewards point to the global value OR
b) a way to find only the categories products that have rewards points set on them

I have just realised that on a particular store there are around 3-400 categories, subcategories, and I can guarantee I'll be the one expected to track down the errant rewards points when the store owner forgets where she has applied them

Quote:

---

Originally Posted by mask2011

Actually, in my store it works a bit different.. Discounted products would be normal products (showing as SRP products on my site) but my members will have discount coupons to enter during check-out to enjoy the lower price..

So, in this case, is there a way to limit rewards accrual (and maybe even redemption) only on sales that do not have a discount coupon applied to it?

---

If you are using an Order Total mod to handle the discount coupons go to Admin->Config->Reward Points and select Advanced Reward Point Calculation Rules. Add a rule to subtract on that mod.

Quote:

---

Originally Posted by nigelt74

and on a completely different note and probably not overly important

Is there a way to

a) reset all rewards point to the global value OR
b) a way to find only the categories products that have rewards points set on them

I have just realised that on a particular store there are around 3-400 categories, subcategories, and I can guarantee I'll be the one expected to track down the errant rewards points when the store owner forgets where she has applied them

---

Do you have PhpMyAdmin installed on your/her site? If so use the following SQL:

Code:

---

SELECT `cd`.`categories_name` , r.`point_ratio`
FROM `reward_master` AS r, `categories_description` AS cd
WHERE `r`.`scope` =1
AND `r`.`scope_id` = `cd`.`categories_id`;

---

Note: you may have to change the table names if you use a prepend like 'zen_'

Hey Andrew,

First of all, thanks so much for supporting people here to get the mod to do what we want it to. You're really a wonderful help!

As for the suggestion of adding an Advanced Rule to subtract the ot_discount module, that worked, but only partially.. It does deduct some points, but not all. Let me try and illustrate:

- Customer A orders Product B at SRP $79.90
- Customer A checks out without a discount coupon and gets 80 Rewards Points

The above works excellent..

However, what I would like is:

- Customer A orders Product B at SRP $79.90
- Customer A checks out with discount coupon and pays only $60
- Customer A will not get any Rewards Points for this order

At this moment, Customer A gets 60 Rewards Points because thats the value of his order. But I would want it to not give any points.. Is there any way I could update the configuration to do that? Or is there some place in the code where I could apply the change to make this work?

Appreciate your suggestions!

Quote:

---

Originally Posted by mask2011

Hey Andrew,

First of all, thanks so much for supporting people here to get the mod to do what we want it to. You're really a wonderful help!

As for the suggestion of adding an Advanced Rule to subtract the ot_discount module, that worked, but only partially.. It does deduct some points, but not all. Let me try and illustrate:

- Customer A orders Product B at SRP $79.90
- Customer A checks out without a discount coupon and gets 80 Rewards Points

The above works excellent..

However, what I would like is:

- Customer A orders Product B at SRP $79.90
- Customer A checks out with discount coupon and pays only $60
- Customer A will not get any Rewards Points for this order

At this moment, Customer A gets 60 Rewards Points because thats the value of his order. But I would want it to not give any points.. Is there any way I could update the configuration to do that? Or is there some place in the code where I could apply the change to make this work?

Appreciate your suggestions!

---

What happens if the customer "mixes and matches"- has an order with some discounted items and some regular? Do they receive any points in this situation?

hehe good point :) Logically, they should receive points for those items that are SRP, however that might be very difficult to track.

As most of the coupons are general coupons, with some of them having a "product restriction" on them, I think it would be extremely difficult (technically) to ensure that points are allocated for those products that are without a discount-coupon applied to them and give no points for discounted products.. Zen Cart doesnt allow you to apply multiple coupons to a cart, so if I were to add 2 products that have a discount option, and I would apply 2 coupons, it would only take the second coupon and apply it to my cart.

I would recommend my customers to create multiple orders in this case. For those cases where the customer does create a single order with a mixed (discount and non-discount) products set, I would assume the easiest way is to either split the order or perhaps give no points on check-out and do a manual allocation of points to that customer for the non-discounted products.

So, short answer: if the code is modular enough and written in such a way that it checks by product, it'd be wonderful.. If it is not, I am totally fine to say: apply a coupon and lose any points for products in your cart.. :)

I've installed this mod and it's awesome... exactly what I'm looking for.

I would like to know if there's any way to add "advanced rules" to the points displaying in the sidebox. I have a number of order total modules (better together, group discount, etc.) and I have enabled advanced rules in Configuration > Rewards points so I get the correct total of reward points after discounts are applied. But they show the original number of reward points in the sidebox.

Do you guys know how to fix this?

@hem: did u happen to have any additional suggestions that might make it possible to provide no rewards points for discounted products? perhaps I could hard-code it somewhere in the code? Like if ot_coupon is applied, rewards = 0 or something as rough as that?