Reward Points Module for ZC v13x

Quote:

---

Originally Posted by aztintpimp

I want to use this module to make a website striclty for rewards points sort of like credit card miles site or coke rewards. I want to add points to cusomters everytime they refer a client to my brick and mortar location.
2 qustions. Will this work like that?

If so would someone be willing to help me install for a fee. I have tried and tried and tried to no avail. I have read thousands of post and read and reread the install stuff I still cant get it.

Thanks in advance

---

Check your PM

OK this update on Reward Points is now active in the downloads area. NO UPGRADE NEEDED. In this update I have created and upgrade folder and created a upgrade.txt file. Maybe this will be a lot easier for the installer when installing. NO VERSION CHANGE STILL V2.1a.

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.

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);
                }
    }

---

---

This is great! Can you tell me the code to put it in the sidebox as well?

I have a fundamental misunderstanding of how to configure this module. I want it to give everyone 10 points for every dollar they spend. Then to redeem, I want the points to be worth 100 points = $1. I am not sure I understand how to do this (there are so many different configuration areas in different menus!) Can someone explain it in simple terms? Thanks.

Also, in the Order Total Modules section, whenever I configure the "Reward Points Tiered Discount" module it turns off the "Reward Points" module so that it's just a red dot again... I can't get both of these "on" at the same time--are they one or the other for some reason? What gives?

I have another question... my shopping cart template is HEAVILY modified. I tried using WinMerge to get the rewards points stuff into it but they were too different for it to make any sense. Can someone extract the relevant (rewards points) lines of code and tell me where they are, so I can figure out where to put them in my cart? Thanks so much. I couldn't find them myself--I looked!

Quote:

---

Originally Posted by WebKat

I have another question... my shopping cart template is HEAVILY modified. I tried using WinMerge to get the rewards points stuff into it but they were too different for it to make any sense. Can someone extract the relevant (rewards points) lines of code and tell me where they are, so I can figure out where to put them in my cart? Thanks so much. I couldn't find them myself--I looked!

---

You can probably get this information yourself by doing a file compare of the Rewards Points files against a vanilla set of Zen Cart files...

I updated Reward Point to version 2.0b no major changes except the tpl_product_info_display.php file in the rewards points 2.0a package is missing the following code which displays the reward points on each on the product pages. This has been missing in previous version.


<!--bof Product Reward Points block --> <h2 id="productRewardPoints" class="productRewardPoints"> <?php /** * display the product reward points */ include($template->get_template_dir('/tpl_product_reward_points.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_product_reward_points.php'); ?> </h2> <!--eof Product Reward Points block -->

The update has been uploaded waiting on zen approval.

Quote:

---

Originally Posted by DivaVocals

You can probably get this information yourself by doing a file compare of the Rewards Points files against a vanilla set of Zen Cart files...

---

Actually I think I was thinking about a different module, because this one doesn't seem to edit the shopping cart. But it should. Is there a way to get the shopping cart to display something like "you will earn XX reward points for this order" underneath the total or something? I tried to hack it in based on the sidebox code but it was a miserable failure...

Why do you want it to show in the first step of the shopping cart. The customer see's they will earn xxxx number of reward point on the product info page if they purchase the item. If and when they put the item in there cart they will see they are going to earn xxxx number of points in the Reward Points side box if you have it enabled. When your customer go's to checkout they will see it in there total they are getting xxxx number of Reward Points for this order. I guess I do not understand what it is you are saying or the issue you are having.

I guess it's just that when people get to the shopping cart, they're not looking at the sideboxes anymore... it would be nice if it showed the total reward points available in the cart in the general cart area...

You could get them with:

Code:

---

<?php
    $products = $_SESSION['cart']->get_products();
    $reward_points=GetRewardPoints($products);
if ($reward_points > 0) {
echo '<div>';
echo 'REWARD POINTS: ' . $reward_points;
echo '</div>';
}
?>

---

Might need to jazz that up a bit ...

Thanks Linda for this code. This works great on the shopping cart page.
Webkat if here's a snapshot. If you want to know where I added the code I will be glad to show you.

Attachment 10377

Webkat there is also a Define Pages - Shopping Cart. The mod adds the ability to edit your shopping cart instructions via admin using the Define Pages Editor. I thought I would share that with you too.
http://www.zen-cart.com/downloads.php?do=file&id=607

Quote:

---

Originally Posted by countrycharm

Thanks Linda for this code. This works great on the shopping cart page.
Webkat if here's a snapshot. If you want to know where I added the code I will be glad to show you.

---

Oh that's perfect--if you could give me the code snippet right before it so I can find where to put it... is it the exact code that Linda posted? Thanks!

Quote:

---

Originally Posted by countrycharm

Webkat there is also a Define Pages - Shopping Cart. The mod adds the ability to edit your shopping cart instructions via admin using the Define Pages Editor. I thought I would share that with you too.
http://www.zen-cart.com/downloads.php?do=file&id=607

---

I'll have a look at it... in the meantime if you want to see what I mean... go to http://opalessenceshop.com and put (anything) in your cart and look at how I have my shopping cart set up and you will see what I mean. It's still getting tweaked for user-friendliness and readability. I may take the credit card/etc logos off the left because they crowd it a little if you have the browser window too narrow... opinions welcome.

Yes the one Linda posted. Check you PM.

Thanks so much! It does exactly what I want! I really think that once customers are at the cart, they're not going to look at the sidebox anymore. You may want to consider adding that bit of code to the download package.

I think I will add it in a later version.

When awarding someone extra reward points it would be cool to have a checkbox to send them an email letting them know about it... just a suggestion.

I'm having a problem with reward points getting stuck as "pending" for many of my customers. They have to be manually transferred over and it's become very time consuming / inefficient. Could someone please take a look at my config and tell me if my settings are incorrect? Do I need to have a sunrise period set in order for my points to automatically transfer to "earned"?Attachment 10413

Click the Reward Point Status Track, click advance set the reward points to Ignore and see what happens.

Quote:

---

Originally Posted by countrycharm

Click the Reward Point Status Track, click advance set the reward points to Ignore and see what happens.

---

Do you mean I should set all of the rules to "ignore" like in the attached screenshot?

Attachment 10417

Yes if you set all the rules to ignore does it work now.

I have the rewards points module installed and I have gone to the section where I determine how much the points are worth before but for some reason I cannot find it on my admin page. Please help!
Ex.
10,000 points=$5 or 10,000 points= 10% off

What zen cart version are you using? What other add ons have you installed after Reward Points?

Quote:

---

Originally Posted by countrycharm

Yes if you set all the rules to ignore does it work now.

---

It's still not working for me even with all the rules set to ignore. Points are still pending.

In the Cataloge and Customers menu when I attempt to access the rewards points I am returned to the homepage of my store (completely navigated away from admin).

Any advice would be appreciated.

What zen cart version are you using? The points gets transferred when you change the Status of a order of a customer from pending to something else.

Check and make sure you you folder structure is correct.

1. Unzip the contribution.

2. Change the admin folder name to match the name of your custom directory and ftp to your sever.

3. Change the custom folders to match the name of your custom template.

Thanks changing the admin to my admin name and ftp the folders worked a charm! TYVM

OK, ive looked and looked and cant find the answer.

I have downloaded the latest 1.5 version and tried to install it. But when I get to the SQL Query Executor I submit it and get this.

WARNING: An Error occurred, please refresh the page and try again.

Any ideas? :shocking:

Quote:

---

Originally Posted by memorydave

OK, ive looked and looked and cant find the answer.

I have downloaded the latest 1.5 version and tried to install it. But when I get to the SQL Query Executor I submit it and get this.

WARNING: An Error occurred, please refresh the page and try again.

Any ideas? :shocking:

---

What version of zen cart are you using? What Server version are you using?

Quote:

---

Originally Posted by countrycharm

What version of zen cart are you using? What Server version are you using?

---

Im using 1.5 just updated a week ago, and the latest download here http://www.zen-cart.com/downloads.php?do=file&id=704

Quote:

---

Originally Posted by memorydave

OK, ive looked and looked and cant find the answer.

I have downloaded the latest 1.5 version and tried to install it. But when I get to the SQL Query Executor I submit it and get this.

WARNING: An Error occurred, please refresh the page and try again.

Any ideas? :shocking:

---

Quote:

---

But when I get to the SQL Query Executor I submit it and get this.

WARNING: An Error occurred, please refresh the page and try again.

---

Did you open up the new.sql file and copy and paste the file or did you try to upload the whole file to Admin->Tools->Install SQL Patch. You have to open up the file and copy and past it.

Quote:

---

Originally Posted by countrycharm

Did you open up the new.sql file and copy and paste the file or did you try to upload the whole file to Admin->Tools->Install SQL Patch. You have to open up the file and copy and past it.

---

I tried both and both gave the same message

Quote:

---

Originally Posted by memorydave

I tried both and both gave the same message

---

Use the uninstall.sql and retry installing it again. You are the only one who is having this problem at the moment. If this doesn't work instead of trying to tell you what to try if you give me temporary access to you ftp and admin I will take a peek at it for you. If not I can not set here and tell you whats going on with it.

Quote:

---

Originally Posted by countrycharm

Use the uninstall.sql and retry installing it again.

---

I tried that and it worked! Thanks a bundle

Now I have got it working on my mirror site I'll try on the main site. Fingers crossed

Thank you so much for your time. It has really helped me out

Quote:

---

Originally Posted by memorydave

I tried that and it worked! Thanks a bundle

Now I have got it working on my mirror site I'll try on the main site. Fingers crossed

Thank you so much for your time. It has really helped me out

---

Np problem, I'm glad it worked out for you.

My reward points are not subtracting after a customer cancels an order. They are stuck as pending and I have to manually subtract them from each refunded and cancelled order... I read earlier in this thread that they should subtract automatically after a cancel or refund.

Any idea what might be wrong here?

Quote:

---

Originally Posted by swamyg1

My reward points are not subtracting after a customer cancels an order. They are stuck as pending and I have to manually subtract them from each refunded and cancelled order... I read earlier in this thread that they should subtract automatically after a cancel or refund.

Any idea what might be wrong here?

---

I will answer this later.

Quote:

---

Originally Posted by swamyg1

My reward points are not subtracting after a customer cancels an order. They are stuck as pending and I have to manually subtract them from each refunded and cancelled order... I read earlier in this thread that they should subtract automatically after a cancel or refund.

Any idea what might be wrong here?

---

If your customer cancels an order the Reward Points will not move from pending. You will have to manually remove them. If you change the status of and order they will be move from pending to earn unless you have setup the Reward Point Status Track under configuration to get the module to run like you want. Bottom line you will have to remove them manually. Hem the author said they would remove if still pending but I never seen that happen.

I know that during checkout, in the cart, the customer will see their new and previous rewards points balance. Is there a way for a customer to view their balance before making a purchase? The sidebox only shows the points which will be earned for the current purchase. It would be really nice if I could directly give the customer access to their balance.

Quote:

---

Originally Posted by johnny roastbeef

I know that during checkout, in the cart, the customer will see their new and previous rewards points balance. Is there a way for a customer to view their balance before making a purchase? The sidebox only shows the points which will be earned for the current purchase. It would be really nice if I could directly give the customer access to their balance.

---

Reward Points already has that feature built into the side box if you have it switch on. Go to tools/layout boxes and switch it on Box Name: reward_points.php. This will show the customer what points they have in there cart and how many they already have earned if any. One more thing is if you go to admin/modules/order total and set the ot_reward_points to Automatic it will show the customer how many points they have on the order page.

Quote:

---

Originally Posted by countrycharm

Reward Points already has that feature built into the side box if you have it switch on. Go to tools/layout boxes and switch it on Box Name: reward_points.php. This will show the customer what points they have in there cart and how many they already have earned if any. One more thing is if you go to admin/modules/order total and set the ot_reward_points to Automatic it will show the customer how many points they have on the order page.

---

Or ot_reward_points_display one or the other. I can't quiet remember.

Attachment 10512

Quote:

---

Originally Posted by countrycharm

Click the Reward Point Status Track, click advance set the reward points to Ignore and see what happens.

---

I have the same problem, points don't move from Pending to Earned, I tried status both ways, simple and advance.

Any help would be appreciated.

It appears that when I update the status of an order manually within Zencart Admin, the points move to earned but when I Processes a shipment via Shipworks which updates the status of an order to 'Shipped' the points don't move.

Any ideas why?

I am using Zencart 1.50.

Quote:

---

Originally Posted by Coins2012

It appears that when I update the status of an order manually within Zencart Admin, the points move to earned but when I Processes a shipment via Shipworks which updates the status of an order to 'Shipped' the points don't move.

Any ideas why?

I am using Zencart 1.50.

---

Quote:

---

It appears that when I update the status of an order manually within Zencart Admin, the points move to earned

---

This is how Reward Points suppose to work out of the box. I don't use Shipworks so I can't help you there. I guess you can hire someone to get it to work with Shipworks. No plans in the near future to make it work with Reward Points.

Quote:

---

Originally Posted by countrycharm

This is how Reward Points suppose to work out of the box. I don't use Shipworks so I can't help you there. I guess you can hire someone to get it to work with Shipworks. No plans in the near future to make it work with Reward Points.

---

I got it working by setting the Sunrise to 1 but I am not sure why it would work if I change the status manually vs my shipping software Shipworks which also updates the status to 'Shipped' after processing, I am sure something gets triggered when doing it manually vs Shipworks which does it via API I guess.

thanx,

Im sorry if this has been covered, but I cant find an answer to it.

Is there a way of showing what points individual items have.

I have seen how to show a running total, but is it possible for people to see what points you would get if you bought the item?

Quote:

---

Originally Posted by memorydave

Im sorry if this has been covered, but I cant find an answer to it.

Is there a way of showing what points individual items have.

I have seen how to show a running total, but is it possible for people to see what points you would get if you bought the item?

---

The total points for and item is displayed on the product info page if you have it set to do so. It is also displayed at the first step of checkout.

Quote:

---

Originally Posted by countrycharm

The total points for and item is displayed on the product info page if you have it set to do so.

---

How do I set it to do so? It isn't showing on mine

Quote:

---

Originally Posted by memorydave

How do I set it to do so? It isn't showing on mine

---

A link to your site will be helpful.

Quote:

---

Originally Posted by countrycharm

A link to your site will be helpful.

---

Mazda Bongo shop

Quote:

---

Originally Posted by memorydave

Mazda Bongo shop

---

Download a copy of your includes/templates/YOUR_TEMPLATE/templates/tpl_product_info_display.php
and insert this code anywhere you want Reward Points to show on the product info page. If you do not have that file download it from includes/templates/template_default/templates/tpl_product_info_display.php
You must not have the recent version of Reward Points installed or you didn't rename the custom folder to YOUR_TEMPLATE name that you are using before uploading to your server. That file is already included in the module.

PHP Code:

---

<!--bof Product Reward Points block -->
<h2 id="productRewardPoints" class="productRewardPoints">
<?php
/**
 * display the product reward points
 */
   include($template->get_template_dir('/tpl_product_reward_points.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_product_reward_points.php');
   ?>
</h2>
<!--eof Product Reward Points block -->

---

Quote:

---

Originally Posted by countrycharm

Download a copy of your includes/templates/YOUR_TEMPLATE/templates/tpl_product_info_display.php
and insert this code anywhere you want Reward Points to show on the product info page. If you do not have that file download it from includes/templates/template_default/templates/tpl_product_info_display.php
You must not have the recent version of Reward Points installed or you didn't rename the custom folder to YOUR_TEMPLATE name that you are using before uploading to your server. That file is already included in the module.

PHP Code:

---

<!--bof Product Reward Points block -->
<h2 id="productRewardPoints" class="productRewardPoints">
<?php
/**
 * display the product reward points
 */
   include($template->get_template_dir('/tpl_product_reward_points.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_product_reward_points.php');
   ?>
</h2>
<!--eof Product Reward Points block -->

---

---

You sir are a magician. Thank you so much for your help (again)

Quote:

---

Originally Posted by memorydave

You sir are a magician. Thank you so much for your help (again)

---

You are very welcome. I'm glad you got it all worked out.

I've got the rewards system installed and enabled and its working great, but I would like to modify the 'XXX reward points' that displays on the product info page.

I would like to make the rewards points text a hyperlink to the EZ page that I have set up explaining how the rewards point system works instead of having the customers scroll down to the footer to click the link.

Possible? Code snippet would be wonderful!

Thanks!

Quote:

---

Originally Posted by Limitless

I've got the rewards system installed and enabled and its working great, but I would like to modify the 'XXX reward points' that displays on the product info page.

I would like to make the rewards points text a hyperlink to the EZ page that I have set up explaining how the rewards point system works instead of having the customers scroll down to the footer to click the link.

Possible? Code snippet would be wonderful!

Thanks!

---

WebKat did that but I don't remember how she did it. Maybe she will answer your post.

Quote:

---

Originally Posted by countrycharm

WebKat did that but I don't remember how she did it. Maybe she will answer your post.

---

I found where I need to change it (extra definitions) but I am a php idiot.

Glad to hear its possible.

Thanks.

Quote:

---

Originally Posted by Limitless

I've got the rewards system installed and enabled and its working great, but I would like to modify the 'XXX reward points' that displays on the product info page.

I would like to make the rewards points text a hyperlink to the EZ page that I have set up explaining how the rewards point system works instead of having the customers scroll down to the footer to click the link.

Possible? Code snippet would be wonderful!

Thanks!

---

Here is what I added to my tpl_product_info_display.php file:

PHP Code:

---

<!--bof Product Reward Points block --> 
<p style="font-size:1em;">Earn <?php /** * display the product reward points */ include($template->get_template_dir('/tpl_product_reward_points.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_product_reward_points.php'); ?> for this purchase!</p>
<!--eof Product Reward Points block -->

---

I added it right after this code, but this code may be altered from the original--I can't remember:

PHP Code:

---

<h2 id="productPrices" class="productGeneral">
<?php
// base price
  if ($show_onetime_charges_description == 'true') {
    $one_time = '<span >' . TEXT_ONETIME_CHARGE_SYMBOL . TEXT_ONETIME_CHARGE_DESCRIPTION . '</span><br />';
  } else {
    $one_time = '';
  }
  echo $one_time . ((zen_has_product_attributes_values((int)$_GET['products_id']) and $flag_show_product_info_starting_at == 1) ? TEXT_BASE_PRICE : '') . zen_get_products_display_price((int)$_GET['products_id']);
?></h2>

---

And in includes/languages/english/extra_definitions/custom/reward_points.php I have this:

HTML Code:

---

Line #3 : define('PRODUCT_REWARD_POINT_TAG', '<a href="/index.php?main_page=points">reward points</a>');

---

Quote:

---

Originally Posted by WebKat

And in includes/languages/english/extra_definitions/custom/reward_points.php I have this:

HTML Code:

---

Line #3 : define('PRODUCT_REWARD_POINT_TAG', '<a href="/index.php?main_page=points">reward points</a>');

---

---

I think that was the bit I was missing.

Quote:

---

Originally Posted by countrycharm

This is how Reward Points suppose to work out of the box. I don't use Shipworks so I can't help you there. I guess you can hire someone to get it to work with Shipworks. No plans in the near future to make it work with Reward Points.

---

It's not just Shipworks that is doing this. We are having an issue with the Paymate module as well. The orders return fine & update from "Pending" to "Delivered" however the Reward points are not updating & stay in Pending.

We run a download based store, so the more automated the better as we are wanting to focus more on customer service & support than manually updating orders all day.

2: I have noticed that the rewards points either round up, or down and that they only are able to be cashed in $5 amounts. So, I earnt 25 points, I received 50 points, my new total is now 1275 points, however I can only cash out at $10 not $12.75. Is this a built in feature, or is this something we have overlooked in the setup?

I would also like to see in the future a reward point history that the customers can view in their account. We are offering a promotion to earn reward points, I wouldn't feel right about it if we couldn't notify the customer or have them at least see an account history.

The points system is a good system.

Cheers.

IRIS - Karen
www.irissimulations.com/cart

Quote:

---

Originally Posted by iris - karen

It's not just Shipworks that is doing this. We are having an issue with the Paymate module as well. The orders return fine & update from "Pending" to "Delivered" however the Reward points are not updating & stay in Pending.

We run a download based store, so the more automated the better as we are wanting to focus more on customer service & support than manually updating orders all day.

2: I have noticed that the rewards points either round up, or down and that they only are able to be cashed in $5 amounts. So, I earnt 25 points, I received 50 points, my new total is now 1275 points, however I can only cash out at $10 not $12.75. Is this a built in feature, or is this something we have overlooked in the setup?

I would also like to see in the future a reward point history that the customers can view in their account. We are offering a promotion to earn reward points, I wouldn't feel right about it if we couldn't notify the customer or have them at least see an account history.

The points system is a good system.

Cheers.

IRIS - Karen
www.irissimulations.com/cart

---

Quote:

---

It's not just Shipworks that is doing this. We are having an issue with the Paymate module as well. The orders return fine & update from "Pending" to "Delivered" however the Reward points are not updating & stay in Pending.

---

Go to your admim/configuration/Reward Points, set the Reward Point Status Track to advance,
and tick the Delivered: box to earned and see what happens. You have to play with different combination to see what will work and what doesn't work for you.

Quote:

---

2: I have noticed that the rewards points either round up, or down and that they only are able to be cashed in $5 amounts. So, I earnt 25 points, I received 50 points, my new total is now 1275 points, however I can only cash out at $10 not $12.75. Is this a built in feature, or is this something we have overlooked in the setup?

---

go to your admim/configuration/Reward Points, and set the Reward Point Redeem Minimum, and the Reward Point Redeem Maximum of earned points that can be redeemed against a single order.

Go to Modules/order total Reward Points set the Point Redeem Method.
Select how the customer redeems their points:
Automatic will select all Reward Points earned by the customer.
Manual will allow the customer to enter a number of points to redeem.
In both cases the total number allowed to redeem is capped by the order total and the 'Reward Point Redeem Maximum' configuration setting.

Quote:

---

I would also like to see in the future a reward point history that the customers can view in their account. We are offering a promotion to earn reward points, I wouldn't feel right about it if we couldn't notify the customer or have them at least see an account history.

---

The customer has that feature now. Every order they purchase they can see it from there account. It shows the Reward Point history of how many Reward Points they earned with each order they purchase.

Quote:

---

Originally Posted by countrycharm

go to your admim/configuration/Reward Points, and set the Reward Point Redeem Minimum, and the Reward Point Redeem Maximum of earned points that can be redeemed against a single order.

---

Cheers :D Worked

Quote:

---

Go to Modules/order total Reward Points set the Point Redeem Method.
Select how the customer redeems their points:
Automatic will select all Reward Points earned by the customer.
Manual will allow the customer to enter a number of points to redeem.
In both cases the total number allowed to redeem is capped by the order total and the 'Reward Point Redeem Maximum' configuration setting.

---

I like it! Works great - +1 cookie!

Quote:

---

The customer has that feature now. Every order they purchase they can see it from there account. It shows the Reward Point history of how many Reward Points they earned with each order they purchase.

---

But there's no summary page or a way to show if an admin has added to their account. Is there a way to get the mod to do it? Like a banking statement?

I'm still having issues with the manual/automatic settings nothing seems to work. We're moving servers next week, i'll try a fresh installation and put through some fake orders and see if it was a conflict somewhere.

Thanks for your help!
~K

Quote:

---

Originally Posted by iris - karen

Cheers :D Worked


I like it! Works great - +1 cookie!



But there's no summary page or a way to show if an admin has added to their account. Is there a way to get the mod to do it? Like a banking statement?

I'm still having issues with the manual/automatic settings nothing seems to work. We're moving servers next week, i'll try a fresh installation and put through some fake orders and see if it was a conflict somewhere.

Thanks for your help!
~K

---

Quote:

---

But there's no summary page or a way to show if an admin has added to their account. Is there a way to get the mod to do it? Like a banking statement?

---

When you add Reward Points to one of your customers accounts send them and email letting them know. There is no plan of creating additional summary page for that. You could always hire someone to do it for you if you need that feature.

Quote:

---

I'm still having issues with the manual/automatic settings nothing seems to work. We're moving servers next week, i'll try a fresh installation and put through some fake orders and see if it was a conflict somewhere.

---

Yes I would try it out on a clean install to see if it will work for you. I always install modules on a test site to get them to work like I want them to before I install them to a live site, that way you know always know if they will work or not.

I see no way for customer to redeem their points earned. :(

Please could someone help me? I am using 2 payment methods (PayPal and FreeCharge) there is no place to input points if a customer wishes to use them.

Everything else is perfect!

Quote:

---

Originally Posted by SoEl05

I see no way for customer to redeem their points earned. :(

Please could someone help me? I am using 2 payment methods (PayPal and FreeCharge) there is no place to input points if a customer wishes to use them.

Everything else is perfect!

---

Okay I figured it out, it was simple oversight but will leave my fix for anyone with similar issue.

1st I double checked all files installed. Then I went to Admin --> Modules ---> Order Total.

I needed to turn on Reward Points. I then set this to manual. Problem solved!

I would like to re-write the wording shown in the box on the checkout page so if anyone knows which file I need to change I would sure appreciate it!!

Same taxe problem here :

Code:

---

Sub-Total: ...................................11.00
Group Discount 10% : ..................-$1.10
Value of Redeemed Reward Points:    0.27
Forida TAX 7.0%:..........................$0.69

Total:..........................................$10.32

---

Tax is 0.69 for 7% which means is has been calculated on 9.9 which is 11-10%=9.9.
Tax has to be calculated on (11-10%-0.27)= 9.63 x7%= $0.67.

Adding a rule in the Advanced rules does not soved the problem, the rules are applied for points calculation, so it affects on which total the points are earned but not how the redeemed amount is in the order total modules.

I also played with the sort order in the order total modules, but it doesn't modify anything.

As this have been said somewhere before in the thread, the configuration has to get a setting so that it can do the good calculation.

This mod is great, it's sad if we cannot use it because of this little but blocking mystake.

Hubert

Quote:

---

Originally Posted by SoEl05

I would like to re-write the wording shown in the box on the checkout page so if anyone knows which file I need to change I would sure appreciate it!!

---

use the developer tools in the admin area put the text you'd like to find in the bottom row first box. Catalogue selected in the drop down list and php only in the next. Then follow the file paths shown at the top.

regarding the tax problem
(#2068 just two lines before)

I think reward points module have to get an "Include Tax" and "Re-calculate tax" settings as to_coupon.php has.

Can someone tell us if adding these keys in the configuration table would be enough so that a order total function from the default install would see it and do the calculation ?

I would appreciate if someone could clarify this feature:

Delete Old Reward Transactions Period
Set the age (in days) to keep the reward point transactions. Outstanding reward points pending after this period will be lost. Set to 0 to keep all transactions.

Is this mean that any points that are earned will not be deleted no matter what? I setup this module using Sunrise Period of 1 so pending points become earned the next day but I like these earned points to be deleted after 30 days but looks like the system doesn't delete earned points?

Below is my setup and any input would be appreciated.

Attachment 10792

OK, noone answering my tax question but many people seems to use this module.

So can you please answer, don't you have tax in your Order Total ?
Don't you notice that tax are not well calculated and if they are right please can you explain me your setup so that I get the tax calculated on Sub-Total less reward points redeemed ?

I must be missing something, no ?

Thanks for your help

Hubert

Quote:

---

Originally Posted by hubert

OK, noone answering my tax question but many people seems to use this module.

So can you please answer, don't you have tax in your Order Total ?
Don't you notice that tax are not well calculated and if they are right please can you explain me your setup so that I get the tax calculated on Sub-Total less reward points redeemed ?

I must be missing something, no ?

Thanks for your help

Hubert

---

When folks don't answer it may very well mean they don't have an answer to give.. did you search the support thread to see if there is an answer posted already?? (use the thread search to search this thread vs the forum search)

Quote:

---

Originally Posted by DivaVocals

When folks don't answer it may very well mean they don't have an answer to give.. did you search the support thread to see if there is an answer posted already?? (use the thread search to search this thread vs the forum search)

---

Of course I did, and the only thing I see is another question like mine with no answer.
Such a great module with so many features with this little (but blocking) mistake seems incredible.

I can't believe other people are using it with a miscalculation in the taxes in order total neither believe so many people are using Zen Cart without tax calculation.

So there was not enough questions and answers to make me sure of either I'm missing something or the error is there and cannot be circumvented.

Quote:

---

Originally Posted by hubert

Of course I did, and the only thing I see is another question like mine with no answer.
Such a great module with so many features with this little (but blocking) mistake seems incredible.

I can't believe other people are using it with a miscalculation in the taxes in order total neither believe so many people are using Zen Cart without tax calculation.

So there was not enough questions and answers to make me sure of either I'm missing something or the error is there and cannot be circumvented.

---

It is entirely possible that this module could have such an error with no resolution (especially since the original author is no longer actively maintaining this add-on), and it's also entirely possible that people have just decided to live with it.. It's also possible that those who have the answer are just not sharing.. **shrugs** My suggestion is that if the feature/fix is important to you that perhaps you might want to consider paying a developer to make the required changes for you..

Quote:

---

Originally Posted by hubert

Same taxe problem here :

Code:

---

Sub-Total: ...................................11.00
Group Discount 10% : ..................-$1.10
Value of Redeemed Reward Points:    0.27
Forida TAX 7.0%:..........................$0.69

Total:..........................................$10.32

---

Tax is 0.69 for 7% which means is has been calculated on 9.9 which is 11-10%=9.9.
Tax has to be calculated on (11-10%-0.27)= 9.63 x7%= $0.67.

Adding a rule in the Advanced rules does not soved the problem, the rules are applied for points calculation, so it affects on which total the points are earned but not how the redeemed amount is in the order total modules.

I also played with the sort order in the order total modules, but it doesn't modify anything.

As this have been said somewhere before in the thread, the configuration has to get a setting so that it can do the good calculation.

This mod is great, it's sad if we cannot use it because of this little but blocking mystake.

Hubert

---

Disclaimer... I have never used this mod....

However it looks like it is behaving like a "payment" module rather than an "order total" module.
Much like coupons are an order total module.
and gift vouchers are a payment module.

Order total modules can calculate before taxes.
But Payment modules have to process AFTER taxes are calculated.

Comparing the differences between order total and payment modules may shed some light on this for you.

Quote:

---

However it looks like it is behaving like a "payment" module rather than an "order total" module.
Much like coupons are an order total module.
and gift vouchers are a payment module.

Order total modules can calculate before taxes.
But Payment modules have to process AFTER taxes are calculated.

---

Thanks, perhaps I misplaced some files, I'll verify. Thanks you for the clue.

Hubert

Quote:

---

Originally Posted by hubert

Thanks, perhaps I misplaced some files, I'll verify. Thanks you for the clue.

Hubert

---

No misplaced files, this module is an Order Total one, all files are ot_.
I'll have do dig into PHP files to see how to add tax calculation option, but I'm not sure to succeed as I'm not a PHP coder.

Thank you very much for taking care of my question.

Hubert

Any replies to post 2071 would be appreciated, trying to figure out if it's possible for the earned points to expire within the time limit set in the settings.

Thanx,

I keep reading and maybe it's because I've been on so long, I have it set it so every dollar spent = 1 point but how do I make it so every 15 points redeemed can equal $1.00. Can someone please advise. I'm sure I'm just thinking too much.

Also, did anyone figure out how to make it to it doesn't round up at all? So if they purchase something for $4.99 it only gives them 4 points not 5? Even if they purchase something for $4.75 it rounds up. And if it's $4.49 or down it's 4 points.

Sorry, also, I see a .sql file called prep_IPN_RP_orders.sql what is this for?
Does this work with Paypal IPN yet?

Does anyone know where I go to enter an expiration date for reward points? I want them to expire 1 year after they have been earned.

Thank you,

Configuration > Reward Points > Delete Old Reward Transactions Period (set it to 365).

Quote:

---

Originally Posted by Athens Collectibles

Configuration > Reward Points > Delete Old Reward Transactions Period (set it to 365).

---

Thank you.

reward points tag.

I have a problem, my reward points in the product listing and side boxes and everywhere else is showing as "PRODUCT_REWARD_POINT_TAG" etc.

Not as it should be doing.

I have searched this thread and I have found others who had the same problem got it solved by making sure they had uploaded the files to the correct place. But all the threads are years old and are for older version. But I have tried and it still doesnt work.

The site is Mazda Bongo

Obviously I am using a theme, so im wondering if thats the problem

Does anybody know how to disable the reward points box for Group Discount customers on the checkout page?

These customers are already getting a large discount and we don't want to give them reward points on top of that.

Quote:

---

Originally Posted by memorydave

reward points tag.

I have a problem, my reward points in the product listing and side boxes and everywhere else is showing as "PRODUCT_REWARD_POINT_TAG" etc.

Not as it should be doing.

I have searched this thread and I have found others who had the same problem got it solved by making sure they had uploaded the files to the correct place. But all the threads are years old and are for older version. But I have tried and it still doesnt work.

The site is Mazda Bongo

Obviously I am using a theme, so im wondering if thats the problem

---

This is cause by not uploading the files in the right place or all the file didn't upload. In any case the error you are having is cause by the extra_definitions/reward_points file not being found or is in the wrong place. To correct the problem make sure the Reward Points custom template folder is name to whatever template name you are using.
includes/languages/english/extra_definitions/your_template/reward_points.php

Quote:

---

Originally Posted by countrycharm

This is cause by not uploading the files in the right place or all the file didn't upload. In any case the error you are having is cause by the extra_definitions/reward_points file not being found or is in the wrong place. To correct the problem make sure the Reward Points custom template folder is name to whatever template name you are using.
includes/languages/english/extra_definitions/your_template/reward_points.php

---

OK great. My theme is called /theme185/. Now inside the /extra_definitions/ folder there are only two folders. One is called "custom" and one is called "classic" Do I need to rename the "custom" folder (where reward_points.php is located along with one other file called "IncExTaxMod_defines.php") to "theme185" or do I need to make a new folder called "theme185" and upload it to this new folder?

Quote:

---

Originally Posted by memorydave

OK great. My theme is called /theme185/. Now inside the /extra_definitions/ folder there are only two folders. One is called "custom" and one is called "classic" Do I need to rename the "custom" folder (where reward_points.php is located along with one other file called "IncExTaxMod_defines.php") to "theme185" or do I need to make a new folder called "theme185" and upload it to this new folder?

---

You need to create a folder within the extra_definitions/ folder named theme185 and put the files in there. Any time you install a module and you see a custom folder, a your_template folder change the name to whatever your theme folder is named. Same with the admin folder.

Quote:

---

Originally Posted by swamyg1

Does anybody know how to disable the reward points box for Group Discount customers on the checkout page?

These customers are already getting a large discount and we don't want to give them reward points on top of that.

---

You will have to uninstall it in admin/modules/order total/reward points.

Quote:

---

Originally Posted by countrycharm

You need to create a folder within the extra_definitions/ folder named theme185 and put the files in there. Any time you install a module and you see a custom folder, a your_template folder change the name to whatever your theme folder is named. Same with the admin folder.

---

Again thank you for taking the time to help me. It is very much appreciated

Quote:

---

Originally Posted by memorydave

Again thank you for taking the time to help me. It is very much appreciated

---

Your very welcome. I assume that fixed it for you. You didn't mention if it did. If it did just say so, so the next time someone else has this same problem they will know what to do.

hi how do i get my reward points to not round up if anything i need to round down to the nearest pound.
we are giving 0.02p for every point earned, £1 = 1 point.

I think my question may have been overlooked.

I'd like to know if there's a way to exclude group discount customers from using their reward points, or disabling reward points for these customers completely. I would appreciate any help with this if possible.

Quote:

---

Originally Posted by cli12

hi how do i get my reward points to not round up if anything i need to round down to the nearest pound.
we are giving 0.02p for every point earned, £1 = 1 point.

---

Go to admin/configurations/Reward Points config/ Reward Point Rounding and change the value from 0.0 to 0.75 and click update.

Quote:

---

Originally Posted by swamyg1

I think my question may have been overlooked.

I'd like to know if there's a way to exclude group discount customers from using their reward points, or disabling reward points for these customers completely. I would appreciate any help with this if possible.

---

If you would look back one page you will see that I did indeed answer your question..

to get the points to show up as just a number instead of $400.00 , i used the following code edit in super_orders.php

change:

Code:

---

<?php
        for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
          echo ' <tr>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
' </tr>' . "\n";
        }

---

to:

Code:

---

<?php
        for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
                if ($order->totals[$i]['class'] == 'ot_reward_points_display') {
                $display_title = $order->totals[$i]['title'];
                $display_text = substr(ltrim($order->totals[$i]['text'],"$"),0,-3);
      }
      else {
                $display_title = $order->totals[$i]['title'];
                $display_text = $order->totals[$i]['text'];
      }               
               
echo ' <tr>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $display_title . '</td>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $display_text . '</td>' . "\n" .
' </tr>' . "\n";
        }

---

One issue I still have though: when I 'Edit Order Totals' and change the Reward Points Earned, it changes in Super Orders but the actual amount awarded in RPM doesn't change. Any ideas?

I also have Super Orders and Edit Orders installed, and wanted the Reward Points to transfer from Pending to Earned when the order is paid (Complete). I don't use batch updating, so my workaround is just when the order is updated in Super Orders, check the status and run the appropriate Reward Points function.

In super_order.php, under case 'update_order': , after this:

Code:

---

// OK, we have our Customer Notified Status Number, now update the Order Status History Table     
          update_status($oID, $status, $customer_notified, $comments);
// Is the Customer Notified Status Number a 1, then send the customer and E-Mail with the status update.         
          if ($customer_notified == '1') {
            email_latest_status($oID);
          }

---

I added this:

Code:

---

if(($check_status->fields['orders_status'] < 5 && $status == 5)){
          //if previous status was Pending, Shipped, or Returned AND new status is Complete/Paid
          TransferCustomerPointsFromPending($oID);
          $messageStack->add_session('Pending points transferred for Order ' . $oID , 'success');
}
if(($check_status->fields['orders_status'] == 5 && $status < 5)){
          //if previous status was Complete Paid AND new status is Pending, Shipped, or Returned
          //take back the points if somehow they un-pay
          TransferCustomerPointsToPending($oID);
          $messageStack->add_session('Earned points transferred back to Pending for Order ' . $oID , 'success');
}

---

Does anyone have a report already written to show Points Redeemed per customer over time? (Just looking for a way to track how much $ we're "giving away".)

Thanks all in advance!

Could someone try to answer the question below please, I already posted it few weeks ago with no response.



I would appreciate if someone could clarify this feature:

Delete Old Reward Transactions Period
Set the age (in days) to keep the reward point transactions. Outstanding reward points pending after this period will be lost. Set to 0 to keep all transactions.

Is this mean that any points that are earned will not be deleted no matter what? I setup this module using Sunrise Period of 1 so pending points become earned the next day but I like these earned points to be deleted after 30 days but looks like the system doesn't delete earned points?