Reward Points Module for ZC v13x

Quote:

---

Originally Posted by Sailman

I need all Reward Points to be posted automatically as Earned, without having order status changes, etc.
We will redeem the points off-line in a different manner. Using the Advanced/Order Status in the Admin doesn't change anything. All points still go to Pending and I must manually change them to Earned in Admin/Customers/Reward Points.

I have messed with some of the functions, but only succeeded in crashing it. Is there a place where a few lines of code will put all points in the cart automatically to Earned?

---

If you set the Sunrise Period to 0 this should do it.

The sunrise period is set to 0 and all selections in Admin/Advanced Order Status are set to "Earned", but I still must either change the order status or manually change them to Earned in Customers/Reward Points.

I was hoping there was a change to a couple of lines in one of the PHP pages that might write them all to Earned in the db.

Thanks for the response, and Happy New Year!

Quote:

---

Originally Posted by Sailman

The sunrise period is set to 0 and all selections in Admin/Advanced Order Status are set to "Earned", but I still must either change the order status or manually change them to Earned in Customers/Reward Points.

I was hoping there was a change to a couple of lines in one of the PHP pages that might write them all to Earned in the db.

Thanks for the response, and Happy New Year!

---

if you go to "Your Admin->Configuration->Reward Points->Reward Point Status Track" set this to Advanced mode and set all dots to earned.
this will fix your problem.

Quote:

---

Originally Posted by Sailman

The sunrise period is set to 0 and all selections in Admin/Advanced Order Status are set to "Earned", but I still must either change the order status or manually change them to Earned in Customers/Reward Points.

I was hoping there was a change to a couple of lines in one of the PHP pages that might write them all to Earned in the db.

Thanks for the response, and Happy New Year!

---

There should be no lines to change as that functionality is already built in. What version of the mod are you using?

Hem:

I am using RW Version 1.40. The sunrise period is set to 0 and all the radio buttons in Status Track are set to Earned. It is probably a conflict with the Super Orders mod. But in my case, we don't want to use "Pending" for any reason, and all redeeming and subtraction of points from accounts will be done manually thru the Admin. The ability to redeed points on-line is disabled, and no money values are shown for the points. Points are points and can only be redeemed for one certain category, whose prices are modified "free" items. When a Reward Item is added to the cart, we will check the point values and redeem and subtract from the total in the customer account if he has enough points.

Everything works fine, but the accumulated points are set to the DB as "Pending" and I have to go in and either change the order status to anything or move them in the Customers/Reward Points in the Admin. All I would ask is that the points are written to Earned automatically when the order is placed, like the 100 points we give for New Accounts. That works fine. I have tried repeatedly to mimic that function, but only succeeded in crashing it.

Quote:

---

Originally Posted by Sailman

Hem:

I am using RW Version 1.40. The sunrise period is set to 0 and all the radio buttons in Status Track are set to Earned. It is probably a conflict with the Super Orders mod. But in my case, we don't want to use "Pending" for any reason, and all redeeming and subtraction of points from accounts will be done manually thru the Admin. The ability to redeed points on-line is disabled, and no money values are shown for the points. Points are points and can only be redeemed for one certain category, whose prices are modified "free" items. When a Reward Item is added to the cart, we will check the point values and redeem and subtract from the total in the customer account if he has enough points.

Everything works fine, but the accumulated points are set to the DB as "Pending" and I have to go in and either change the order status to anything or move them in the Customers/Reward Points in the Admin. All I would ask is that the points are written to Earned automatically when the order is placed, like the 100 points we give for New Accounts. That works fine. I have tried repeatedly to mimic that function, but only succeeded in crashing it.

---

Ah, that makes sense. There is a new version of Super Orders being released that should sort this out.

For a quick fix- try this:

Edit includes/classes/observers/class.reward_points.php:

On line 94, add the following:

PHP Code:

---

$status=STATUS_PROCESSED; 


---

This should do what you are looking for. The other options will work but require someone to log into Admin before they are transferred.

Quote:

---

Originally Posted by hem

For a quick fix- try this:

Edit includes/classes/observers/class.reward_points.php:

On line 94, add the following:

PHP Code:

---

$status=STATUS_PROCESSED; 


---

This should do what you are looking for. The other options will work but require someone to log into Admin before they are transferred.

---

Andrew:

I hate to be a particular pain, but I have tried this: (line 94 is a blank line in Notepad++)

if(REWARD_POINTS_ALLOW_TOTAL=='0')
$status=($order->info['subtotal']>0?STATUS_PENDING:STATUS_PROCESSED);
else
$status=($order->info['total']>0?STATUS_PENDING:STATUS_PROCESSED);
$status=STATUS_PROCESSED;
if($status==STATUS_PENDING) // Place reward points into pending if awaiting payment/status change
$sql="INSERT INTO ".TABLE_REWARD_CUSTOMER_POINTS." SET customers_id='".$customer_id."', pending_points='".$reward_points."' ON DUPLICATE KEY UPDATE pending_points=pending_points+".$reward_points.";";
else // Reward points and or coupons have covered the price of the purchase- place into processed
$sql="INSERT INTO ".TABLE_REWARD_CUSTOMER_POINTS." SET customers_id='".$customer_id."', reward_points='".$reward_points."' ON DUPLICATE KEY UPDATE reward_points=reward_points+".$reward_points.";";
$db->Execute($sql);

It still puts the points into Pending. I tried a few permutations of the surrounding code to try to get it to write the points as Earned in the db no matter whether they were Pending or Earned, but it either didn't do anything different or crashed. Possible line numbering difference between our editors...... So close to success, but no cigar......

Is there a known conflict between Rewards Points and Gift Certificates?

When a customer uses a Gift Certificate to pay a part of the total and then applies Reward Points for the balance the reward points are entered as a wrong number

example...
total due is $55.17
pay with Gift Cert $51.00
pay with Reward Points $4.17

The balance should be zero but this is what happens on step 3 of checkout....

Sub-Total: $42.00
FedEx Ground (FedEx Ground® ):$9.70
CA TAX 8.25%: $3.47

Gift Certificates: -$51.00
Value of Redeemed Reward Points: -$-46.83

Total: $51.00

Reward Points earned: 48

..
When the customer realized this was not correct he went ahead and paid the wrong amount with his credit card to complete the purchase. BUT the credit card was not actually charged and the order came through as if it were paid.

How can I fix this? I'm using zc138a and rp140a
Thanks

hi all

i want to know whether it is possible to redeem reward points for a particular category??

thanks

Hello there,

Just installed this mod and it works quite nicely, but I'm trying to accomplish something particular for one of my stores and quite frankly I have no clue how to do it.

I want to offer reward points for a certain group. I sell a membership which offers them a certain discount and along with the discount I want this particular group to enjoy the reward points program. My problem is I don't want the regular customer who haven't purchase this membership to see the rewards points anywhere, nor enjoy of the reward points at all, is this possible with this mod? and if so, how can I accomplish hiding the points earned from non members?

Thanks in advance!

Quote:

---

Originally Posted by mvstudio

Hello there,

Just installed this mod and it works quite nicely, but I'm trying to accomplish something particular for one of my stores and quite frankly I have no clue how to do it.

I want to offer reward points for a certain group. I sell a membership which offers them a certain discount and along with the discount I want this particular group to enjoy the reward points program. My problem is I don't want the regular customer who haven't purchase this membership to see the rewards points anywhere, nor enjoy of the reward points at all, is this possible with this mod? and if so, how can I accomplish hiding the points earned from non members?

Thanks in advance!

---

you might be able to do it with something like the dual pricing and hidden wholesale mods.

the hidden mod wraps this around code to hide it:

PHP Code:

---

if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0') { 

// Here's where your module code goes

} 


---

so only wholesale customers can see it.

Kezza

I've had this module installed for quite a while, months actually, and the only thing that doesn't seem to work for me is the automatic moving off reward points from "pending" to "earned".

I'm sorry if a fix has been mentioned before. :(

I've basically given up on trying to get it to work and currently have it set where I have to change the order status to move it to the "earned". I thought I'd give it a shot and see if anyone has a bit more info on maybe getting that to work.

Quote:

---

Originally Posted by Kezza

if you go to "Your Admin->Configuration->Reward Points->Reward Point Status Track" set this to Advanced mode and set all dots to earned.
this will fix your problem.

---

Isn't it wrong to set all of them to earned? I ask because what if, as in my case, you have a "Order Cancelled/Refunded" status. By selecting earned in that instance it would mean that the person would still be earning the points, which in my opinion is wrong. The points should then be ignored.

You also have statuses like PayPal where some pay using their checking account via PayPal and therefore you need to wait for payment. In this instance it would be wrong to award those points as well seeing that you haven't even gotten paid for what was originally bought and ultimately you therefore are giving away points that could be used to purchased something else. In this instance the points should be "Pending" until PayPal releases the funds.

In one instance PayPal auto changes the status to the correct one once the funds have been released. On the other you have to change the status yourself. Regardless, the reward points system should then follow the statuses as you've set them to either release the reward points to "Earn", "Ignore" or place them into "Pending" based on your selection.

Hello Hem..

Wanna make sure Super Orders plays nice with Rewards Points.. Apparently there are a few outstanding issues to address.. (I gathered some of the posts I found here) Since Edit Orders 3.03 (which includes your fix to the Rewards Points issue:clap:) will adress the outstanding issue with Rewards Points and Edit Orders, I'd like to make sure Super Orders plays nice too..

May I contact you under separate cover about this??:smile:

Quote:

---

Originally Posted by hem

hmmmmm- looks like something that Super Order is bringing to the table- It must assume all values in the order are cash values.

---

Quote:

---

Originally Posted by fiji

I found a problem.
If use "Super Orders" to change order status, the pending points won't add to earn point.

---

Quote:

---

Originally Posted by beadfaery

I've just installed the Super Orders mod and have been having a play with it. The only problem I can see is that if I want to edit an order, it changes the Reward Points to a $ value intead of points value. eg; if the customer received 50 points....when I edit the order it changes it to $50.00 :wacko:

I've searched this thread to see if an answer was already here, but didn't find anything.
Is there something I need to do to fix this problem??

Thanks in advance :smile:

Still loving this mod hem :clap: Thanks heaps....you really need to sort something so we can all shout you a guiness or a cuppa :D

---

Quote:

---

Originally Posted by retched

I'm having similar problems between Super Orders and Edit Orders what generally happens is that any number entered where total points are are converted to a $0.00 like entry (example, I enter 400, the number is converted to $400).

The only way for this to be fixed is to take apart the edit order mod and determine how it gets values then add in custom coding so that when you modify the value of the points, it doesn't change on you.

Another, less practical, way of fixing this would be to go into your MySQL DB with a tool like phpMyAdmin and have it at that way. But again, this is NOT ideal for beginner's.

---

Quote:

---

Originally Posted by Kezza

you might be able to do it with something like the dual pricing and hidden wholesale mods.

the hidden mod wraps this around code to hide it:

PHP Code:

---

if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0') { 

// Here's where your module code goes

} 


---

so only wholesale customers can see it.

Kezza

---

Thanks Kezza for your reply, I managed to make it work more or less to my needs but still have a few things that I want to modify. your suggestion though wouldn't work in my case.
The store has both retail and wholesale. Wholesale of course has no benefits but a large discount, no discounts, no coupons, no gift certificates, obviously no reward points either. For the retail I offer a purchased membership with an annual 10% discount on everything in the store for members only, and I want to add the reward points to this membership. I'm using discount group for this membership to work, so reward points would have to work only with discount groups and not with the regular retail.

Also the way I have it set up, the reward points don't show on product listing instead only the total of reward points earned is shown during checkout, so what I'm really trying to accomplish is show reward points only for this particular discount group, and not the rest of regular clients, does it make any sense? I'm thinking with an if statement on the checkout pages I might be able to make it work, but I'm still working on that.

Thanks for any help :smile:

I want my site to reward customers for sharing a lnkto me on Facebook or sending e-mail referrals (after their referral makes a purchase). I see two rewards modules, this one and one by nemicus I think. It is ok for my customers to get points for purchases but that is not my focus. I want a button that says "share on facebook" or share through e-mail that then pops up with a unique referral link for that customer and keeps track when the referral makes a purchase. Is this or another rewards module customizable for that or is their another app that does this? Thank you.

Quote:

---

Originally Posted by mvstudio

Thanks Kezza for your reply, I managed to make it work more or less to my needs but still have a few things that I want to modify. your suggestion though wouldn't work in my case.
The store has both retail and wholesale. Wholesale of course has no benefits but a large discount, no discounts, no coupons, no gift certificates, obviously no reward points either. For the retail I offer a purchased membership with an annual 10% discount on everything in the store for members only, and I want to add the reward points to this membership. I'm using discount group for this membership to work, so reward points would have to work only with discount groups and not with the regular retail.

Also the way I have it set up, the reward points don't show on product listing instead only the total of reward points earned is shown during checkout, so what I'm really trying to accomplish is show reward points only for this particular discount group, and not the rest of regular clients, does it make any sense? I'm thinking with an if statement on the checkout pages I might be able to make it work, but I'm still working on that.

Thanks for any help :smile:

---

why not try changing the statement to something like this:

PHP Code:

---

if ($_SESSION['customers_group_pricing'] && $_SESSION['customers_group_pricing'] != '1') { 

// Here's where your module code goes

} 


---

then add a RAW SQL query for customers->customers_group_pricing

Kezza

in that last statment it should be 0 not 1, so should read:

PHP Code:

---

['customers_group_pricing'] != '0') 


---

Quote:

---

Originally Posted by leilanddale

I've had this module installed for quite a while, months actually, and the only thing that doesn't seem to work for me is the automatic moving off reward points from "pending" to "earned".

I'm sorry if a fix has been mentioned before. :(

I've basically given up on trying to get it to work and currently have it set where I have to change the order status to move it to the "earned". I thought I'd give it a shot and see if anyone has a bit more info on maybe getting that to work.

---

Any feedback on this?

Quote:

---

Originally Posted by leilanddale

Any feedback on this?

---

do you have edit orders or super orders mod installed?

Quote:

---

Originally Posted by Kezza

do you have edit orders or super orders mod installed?

---

Now I do yes. I installed it during the past week or so. Before that, no.

Quote:

---

Originally Posted by leilanddale

Now I do yes. I installed it during the past week or so. Before that, no.

---

http://www.zen-cart.com/forum/showpo...&postcount=153

http://www.zen-cart.com/forum/showpo...postcount=1683

Quote:

---

Originally Posted by Kezza

http://www.zen-cart.com/forum/showpo...&postcount=153

http://www.zen-cart.com/forum/showpo...postcount=1683

---

Thanks!

I already have the latest of both installed. We've never edited any orders as both these modules were only installed over the last 7 days or so.

So ultimately, even before I installed the two addons, it never auto updated the points.

Quote:

---

Originally Posted by leilanddale

So ultimately, even before I installed the two addons, it never auto updated the points.

---

I'm not seeing it happen either. But I wanted the points set to earned from the start since I want it to be totally automatic. So I guess setting the order status to paid with a.net payment is the first status and there's no trigger because there's no change?

So how do you set them to earned at first?

Quote:

---

Originally Posted by walkerhxg

Hi hem,

Thank you sooooo much!

BUT

I have done what you said again and again. But it still doesn't work. :frusty:

( zen-cart1.3.8+MySQL 4.0.27-log+PHP4.4.7 )

I installed the 'new.sql' and got this:

17 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
Note: 10 statements ignored. See "upgrade_exceptions" table for additional details.

I clicked "Layout Box Controller" and got :

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 'SELECT SUM(`reward_points`) FROM reward_status_track ph WHERE p
in:
[UPDATE reward_customer_points rc SET `pending_points`=`pending_points`-IFNULL((SELECT SUM(`reward_points`) FROM reward_status_track ph WHERE ph.`customers_id`=rc.`customers_id` AND ph.`status`=0 AND ph.`orders_id` NOT IN (SELECT `orders_id` FROM orders)),0);]
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.

---

Hello Hem,
I have the same problem.
Any suggestion to solve it?

TX in advanced.

Quote:

---

Originally Posted by akai0231

Hello Hem,
I have the same problem.
Any suggestion to solve it?

TX in advanced.

---

From the readme.txt:

!!!WARNING!!! YOU NEED AT LEAST MySQL VERSION 4.2.0 TO RUN THIS MOD

I have read the FAQ through and am having a problem setting the redeem value for each point. I know I can go to the "group reward redeem" and create a group and set the value however it seems like every new customer will default at .01 and I am going to have to manually go in and change it.

I want it to that when anyone signs up or makes a purchase, it automatically calculates at .05 per reward point. How can I do this?

I have read through this posting and cannot seem to find it other than making a group after the fact.

Thank you.
polishpotterystore.com/shopping

I'm sorry, but I have that part down, I have already set how many points various products/categories are worth. My issue with with how much each point is redeemed for. It appears as if you can change it but only after the fact. I want to make it a default for the points to be worth 5%, or .05 each, not .01.

Hi All

Doese anyone konw if the PayPal IPN problem has been fixed?

Thanks
Davis

I still have this unanswered question.....

Quote:

---

Originally Posted by gonewild

Is there a known conflict between Rewards Points and Gift Certificates?

When a customer uses a Gift Certificate to pay a part of the total and then applies Reward Points for the balance the reward points are entered as a wrong number

example...
total due is $55.17
pay with Gift Cert $51.00
pay with Reward Points $4.17

The balance should be zero but this is what happens on step 3 of checkout....

Sub-Total: $42.00
FedEx Ground (FedEx Ground® ):$9.70
CA TAX 8.25%: $3.47

Gift Certificates: -$51.00
Value of Redeemed Reward Points: -$-46.83

Total: $51.00

Reward Points earned: 48

..
When the customer realized this was not correct he went ahead and paid the wrong amount with his credit card to complete the purchase. BUT the credit card was not actually charged and the order came through as if it were paid.

How can I fix this? I'm using zc138a and rp140a
Thanks

---

i got it installed and everything but when i go to the admin > tools > lay out boxes controls. theirs no option for rewards program. but i do have options in the module and in the config part so i set it to display when logged in and it doesn't any ideas.
thanks

one more thing i changed the name of my admin folder would that have anything to do with it

i need help with uninstalling the rewards system.
to see the error please go to my test site
test/themeltingpotonline.net/shop and put something in your shopping cart, proceed to the checkout. on the second page (payment information) you will see the yellow warning on top of the page that 2 files are missing... i deleted the sql table related to the mod and don't have the files for the mod in the test site. why is it still warning?

here is the error i need to solve...
i don't have any rewards files in zencart (i don't want to anymore) and i deleted all tables that had rewards in it. are there still tables that hold data about the mod that need to be deleted?:frusty:

[SCR]http://test.themeltingpotonline.net/pix/errormessage.jpg[/SCR]

I have a fresh install of Zen Cart.
I have installed this module BUT it does not display the reward points on the product listing/description.
Can you please tell me why this is happening?
Thank-you in advance.
Kind Regards Casey

I placed my previous product_info_display.php file in the current store and now it is working.
:unsure:

Casey

You should check if the file is the same before you use the php from an older cart into a newer one. Use Winmerge to compare the original with the the file from your working (old) cart. Otherwise, you just may have "downgraded" that file. if the file number is still the same you can keep it this way with the old file just pasted in. but if the file has a higher numer you may use winmerge to make the changes and updates to the newer file.

Quote:

---

Originally Posted by stevefriedman71

You should check if the file is the same before you use the php from an older cart into a newer one. Use Winmerge to compare the original with the the file from your working (old) cart. Otherwise, you just may have "downgraded" that file. if the file number is still the same you can keep it this way with the old file just pasted in. but if the file has a higher numer you may use winmerge to make the changes and updates to the newer file.

---

Thanks for your reply.
I can't work out why this module is not working.
It will not even work in a classic custom fresh install.
I make sure I have the files installed etc.

I have checked the files against winmerge and can see where changes are etc but still nothing seems to be working.

PLEASE HELP! :frusty:

Kind Regards Casey

Quote:

---

Originally Posted by stevefriedman71

You should check if the file is the same before you use the php from an older cart into a newer one. Use Winmerge to compare the original with the the file from your working (old) cart. Otherwise, you just may have "downgraded" that file. if the file number is still the same you can keep it this way with the old file just pasted in. but if the file has a higher numer you may use winmerge to make the changes and updates to the newer file.

---

The tpl_product_info_display.php file in the rewards points 1.33 package is missing the following code which displays the reward points on each on the product pages.

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

---

I got that from the older version (1.28)

I am also having a problem at the checkout and a few options in admins.

Firstly, when I click 'confirm the order', i would be expect to be taken to the payment processor to enter cc details (alertpay, paypal etc) but instead it hangs on 'Your order is being processed, please wait..' page. Thinking it might be a problem re-directing to alertpay etc I installed Check/Money order, but it was the same result.

In admin the following dont do anything either:

Configuration>Reward Points>Reward Point Status Track (clicked but no options to choose)
Configuration>Reward Points>Set New Account Reward Points (Clicked but no options to choose)
Configuration>Reward Points>Advanced Reward Point Calculation Rules (Clicked but no options to choose)


Anyway, think I will be moving back to the previous version (1.28) because I know that one works fine. There seems to be too many bugs in v1.33. Excellent module all the same.

I just figured the reason for hanginf on the page that says its processing the order has something to do with Fast and Easy Checkout, just in case anyone else is having same issue.

I will see if I can sort it, and if I do I will post my findings here.

Just in case anyone else is having same issue, if you set Configuration > Fast and Easy Checkout > One Page Checkout to false it works fine then.

Quote:

---

Originally Posted by hem

Okay- go to Admin->Tools->Install SQL Patch and paste in the following:

---

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''), ');

---

I tried this code but I still get the error when running rpd.php:
Allow Redeem of Reward Points on Order Total or Subtotal- record missing in configuration!!!

Any help here?

I have instaleld this setup, version 1.28a. Howver now instead of displaying anything.. the pages seem to break when they reach the code...
and stop loading any further... I've heard that 1.33 is broken so I chose the version that was said to be working in this forum.

Tráthnóna dea Andrew from Dublin, this is George from Athens.

I am doing some final work on my Athens Collectibles Zen Cart store (under construction) and looked in the forums for a Reward Point module. I downloaded and installed your "Reward Point Full Suite" Version 1.33a.

To be honest, I had some trouble at the beginning but found my way. You may want to make a note of the following points for a future update:

- Readme.txt : refers to Version 1.32a

- /includes/templates/custom/templates/tpl_document_product_info_display.php : Version id in RP module is 5369/23.12.2006 while latest Zen Cart version is 16242/08.05.2010. Files differ in line 18:

RP module line 18:

PHP Code:

---

<?php echo zen_draw_form('cart_quantity', zen_href_link(zen_get_info_page($_GET['products_id']), zen_get_all_get_params(array('action')) . 'action=add_product'), 'post', 'enctype="multipart/form-data"') . "\n"; ?>

---

Zen Cart line 18:

PHP Code:

---

<?php echo zen_draw_form('cart_quantity', zen_href_link(zen_get_info_page($_GET['products_id']), zen_get_all_get_params(array('action')) . 'action=add_product', $request_type), 'post', 'enctype="multipart/form-data"') . "\n"; ?>

---

- /includes/templates/custom/templates/tpl_product_info_display.php : Version id in RP module is 5369/23.12.2006 while latest Zen Cart version is 16242/08.05.2010. Files differ in line 19:

RP module line 19:

PHP Code:

---

<?php echo zen_draw_form('cart_quantity', zen_href_link(zen_get_info_page($_GET['products_id']), zen_get_all_get_params(array('action')) . 'action=add_product'), 'post', 'enctype="multipart/form-data"') . "\n"; ?>

---

Zen Cart line 19:

PHP Code:

---

<?php echo zen_draw_form('cart_quantity', zen_href_link(zen_get_info_page($_GET['products_id']), zen_get_all_get_params(array('action')) . 'action=add_product', $request_type), 'post', 'enctype="multipart/form-data"') . "\n"; ?>

---

Additionally, the RP file is missing a whole block of code as reported in post #1740 above (thanks dropbob for pointing this out). The missing code makes the reward points appear in each product listing page.

Details of my installation are as follows, in case it matters:

Host: Bluehost
Apache Version 2.2.17
PHP Version 5.2.16
MySQL Version 5.1.47-community-log

Zen Cart Version 1.3.9h

Other add-on modules installed:
- Automated currency update
- Add page to information box
- Blank sidebox
- Greek language pack
- Language-Currency links in header

The module works fine and I'm very pleased with it. It is exactly what I needed and my only (very serious) issue is that it doesn't work with PayPal IPN although the readme file suggests that this was solved in version 1.30a.

I will detail what exactly happens in case this could help in solving the PayPal issue. Apologies in advance if this post is becoming too long.

- I set a product named "Test Book" with a price of €1.
- I created a customer with first name=Test and last name=Customer
- Test Customer purchased the Test Book and paid with cheque. 5 points were automatically added to the customer's account as "Pending" and were transferred to "Earned" when I changed the order status to "shipped".
-So far, so good. The same customer purchased the same "Test Book" for a second time. The customer redeemed the previously earned 5 points for €0.05 and the order total of €0.95 (after redemption of points) was paid with a credit card via PayPal.
- The credit card was accepted by PayPal and the transaction was completed with the customer returning to my "Thank You" page.
- The customer received the following email from PayPal (I have masked some details for security purposes):

http://athenscollectibles.info/image...o_customer.jpg

- The merchant (me) received the following email from PayPal:

http://athenscollectibles.info/image...o_merchant.jpg

The order shows as follows in my Administration (Customers>Orders):

[SCR]http://athenscollectibles.info/images/zen_cart_forums/order_status.jpg[/SCR]

- In Customers>Reward Points the customer has zero points earned and zero points pending!

- My Configuration>Reward Points settings are:

Quote:

---

Reward Point Mode: 1
Reward Point Sidebox Display: 0
Reward Point Status Track: Pend: [Pending] Earn: [Processing, Shipped]
Reward Point Sunrise Period: 0
Reward Point Redeem Minimum: 0
Reward Point Redeem Maximum: 0
Reward Point Rounding: 0.0
Max Transactions to Display in Customer Admin: 12
Delete Old Reward Transactions Period: 180
Adjust Reward Points for Sales/Specials: 1
Allow Reward Points on Free Products: 0
Allow Redeem of Reward Points on Order Total or Subtotal: 0
Set Minimum Order Value to Redeem Points Against: 0
Limit Maximum Customers on Listings: 50
Display Products Reward Points When Zero: 1
Set New Account Reward Points: 300 points added to earned
Advanced Reward Point Calculation Rules: Advanced Rules Enabled

---

- As you can see in the third line of settings, points should go to "earned" when the order status is "Processing" but this doesn't happen when payment is via PayPal although it does with Cheque or Cash on Delivery payments.

- Customers>PayPal IPN shows the above order as Transaction Type=unique and Payment Status=completed. Although two previous test orders were shown with Transaction Type=cart and Payment Status=completed, none of the three test orders assigned the reward points to the customer's account. I don't obviously know the reason for the different transaction types but I hope that you do.

Finally, when I try to get your diagnostic tool from http://www.omnicia.com/rpd.zip as advised in the readme file or even access omnicia.com, I get a Forbidden error.

Again, apologies for the very long post. Rather than just advising that the mod does not work properly with PayPal IPN, I tried to give you all the facts and settings hoping that this might help in identifying and correcting the issue. I haven't seen you around in this support thread since January but I hope that you will read this and say hello.

Please understand that it is vital for me to know if the PayPal issue can be fixed or not (preferably the first)!

Wishes for "Oíche mhaith" from Greece.

George

many many post ago somebody put in a wish list that reward point can only redeemable toward selected categories.

Has this been done??

Thanks

Fabulous Mod Andrew, Thank you!!!!

I've implemented Version 1.40a, and everything works great so far. I do have a couple changes I would like to make if anyone has a quick answer for me.

I am not offering reward points for purchases, but only manually giving points for people who send me testimonial pics and other items outside the shopping cart.

On the product_info_display page is there an easy code change that would change the "number of points earned from purchasing this product" to "the number of points this product costs"?

Another workaround could also be setting up the correct point system so it will display the points on the product info page as usual, then somehow disabling the "points earned" section when checking out. Visually, it would look the same as the previous idea, but definitely my second choice.

I may also want to change the shopping cart sidebox info from "the number of points earned from this subtotal" to "the number of points they've earned and can use for this order".

These items aren't must-haves, just something that could help my marketing efforts.

Thank you in advance!

Kim :D

Hi Kim,

Quote:

---

Fabulous Mod Andrew, Thank you!!!!

---

Couldn't agree more, it's really great! :smile:

Quote:

---

I've implemented Version 1.40a

---

Unless my glasses need changing :cool: I can't see a version 1.40 offered. Do you have a secret source and, if so, could you share it with us please? :huh:

From your Administration page select Tools>Developers Tool Kit. go to the last row of boxes, enter the text you want to change in the left box, All Files - Catalog/Admin in the second box and click the Search button. This will show you where the "unwanted text" is. If I get hold of version 1.40 I could be more specific.

Anxious to see yours and Andrew's reply. Have a nice day.

I'm having a devil of a time with this.

I just installed it on a site for a customer, we're unable to edit a variety of the options - status track, new acct rewards points, and the advanced reward point calculation. In addition to that...there is no link for the reward point system under the catalog menu or in the customer menu either :(

Anyone have any ideas why this might be happening ?

I'm not an expert on this mod but I find that it works perfectly (with the exception of PayPal IPN as you will see in my post above) and is highly configurable. I had similar problems when I installed it and took me a long time reading the first 600 posts of this thread before I realised that I had not copied some files from the admin folder. Everything was clear and working after I identified and copied the missing files. Are you probably in a similar situation?

Hi George,

I downloaded the mod yesterday from Andrew's site. The version number was straight off the readme file. It didn't specifically say on the title of the zip file that it was 1.40, which is why I went to the readme to verify the version when making my previous post.

You mentioned removing unwanted text. I've disabled everything that talks about points earned when purchasing items (product info template and the sidebox options). But, what I wanted is some replacement code to change those sections I mentioned above to pull how many points it would cost for the product or subtotal, not how many points earned.

I've been playing around with it some more and think I have a solution without changing the code. Here is my workaround so far:

1. I disabled the "Reward Points Earned" module under Admin:Modules:Order Total. This removed the calculation and reference to points earned in the shopping cart subtotal.
2. I left tpl_product_info_display code exactly how Andrew created it, but then added my own wording "This product costs" right before the coding (ie, "This product costs 2 reward points).
3. Under Admin:Catalog:Reward Points, I set the same ratio of points that I set up in Admin:Customer:Group Reward Redeem

I'm still playing with the ratio to make sure the redemption value doesn't exceed the product subtotal, but I'm very happy with the way it is running so far.

Update to my previous post . . .

I set the ratio back to .01 which is the default. So, my redemption value is 1 point=1 penny.

In order to make the ratio show correctly on my tpl_product_info_display, instead of making the ratio .01 as well, I had to make it 100.0 (Admin:Catalog:Reward Points). Now it displays: FREE with 199 reward points

You can see it in action at: http://cricketvinylsupplies.com/inde...&products_id=3

I hope this is of use to others . . .

Kim

Hi Kim,

Thanks for coming back. When you say you downloaded the mod from Andrew's site, do you mean the omnicia.com which gives me a "Forbidden" error? I found a cached page in Google with the Reward Points 1.40 offered for download but the link doesn't work.

The design of your Zen Cart site is fantastic, especially the drop-down menu. Very professional job! (just thought to mention a typo discovered accidentally: You have RELIGION & SPRITUALITY under the QUOTE GALLERY tab of the menu).

With regard to modifications, I've followed the same route as you mentioned for the tpl_product_info_display file with this and a few more files. I also added Greek language files as my site is bi-lingual (I added a languages/greek folder where I copied the files from languages/english folder and sub-folders and then edited to replace English definitions with the corresponding Greek.

As I was typing this reply, I received notice of your next post. I see what you have done with the "FREE with xxx reward points". I have followed a different approach with "xxx reward points" in the item description and the side column box showing all the time. Your site is live but mine http://athenscollectibles.info is under construction with 4-5 test products so you are welcome to see how the mod works from loading the home page to the end of checkout (I have made extensive amendments with CSS).

If you visit my site and since I cannot load Andrew's site, would it be a big trouble for you to send me the zip file downloaded? If not, you may upload it to the form in my Contact us page as long as it's not over 8MB. I would be grateful :bigups:

A final question for you: do you use PayPal IPN and, if yes, have you checked whether the mod works with it?

It's past midnight here so I have to go to bed as a good young boy old guy should. Have a nice evening and congratulations for the design of your sites (mine pales in comparison).

How long does it take for reward point to appear in Admin > Customers > Reward Points? I installed the module, did a test checkout, and nothing appears.

They should appear immediately as pending or earned!

Hmm, strange. I installed the New.sql file and added the modules under Admin > Modules > Order Total. Is there something that I could have missed? Thank you.

It seems that you have installed it correctly. As I had some problems at the beginning and they turned out to be caused by missing files, double check that all files in /includes and /admin folders and sub-folders have been copied. I know it sounds silly, but I had missed some files and everything was normal as soon as I copied everything in the right place.

It is still not working. Can you think of anything else that may be wrong? I have all the files an installed the New.sql file. Thank you for the help.

Don't you see something like in the attached when you select Customers>Reward Points? If you do, something in the other settings might be preventing addition of points to customer accounts.

The points are neither showing up under "Pending" nor under "Earned". Thank you for the help so far.

I assume from your reply that you do see the screen as in the picture but all columns show 0. If you don't mind, could you give me your link and I'll make a test order to see how it works. I'm no expert in this mod but, having installed and configured it very recently, I may see something in the process.

Correct. I see the table you showed, but all fields are marked with a "0".

I do not have it enabled now, so as not to have a bunch of customers ask what these reward points are. I have tried multiple test orders, but nothing. It would be nice if the module's author would stick around to answer questions...

I have had this module installed for a while, but just now noticed that I do not see the global points redeem screen anymore under the customers tool bar. Do you know why that is and what I might do to fix that? I ran the update SQL patch and that didn't do anything but add and extra Reward points tab under configuration.

I also do not see the reward points under customer anymore.

Thank you for your help.

If you are talking about the "Set Global Reward Point ratio", this is set in Catalog > Reward Points (mine is 5.0). You set the Global Points Ratio in Customers > Group Reward Redeem (I have it 0.01). What my settings mean is that a customer gets 5 points for each base currency unit spent (€, £, $ or whatever is the store's base currency) and each point is worth 1/100 of the currency unit. So, a customer spending $100 will get 500 points redeemable for $5, effectively 5% of the order deducted when the points will be used in the future.

As there are many questions around and my answers are based on personal experience, I think it would be nice if Andrew came in and clarified some points. In my case, the only issue I have is that points are not calculated when the customer pays via PayPal and this is really serious as payments via PayPal (or with a credit card processed by PayPal) are the majority. Otherwise, the module works perfectly and is exactly what I needed.

in customers_reward_points.php

have error :

PHP 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 'REWARD_POINTS_CUSTOMER_LIMIT' at line 1
in:
[select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_group_pricing, r.pending_points, r.reward_points, gp.group_name, rm.redeem_ratio from customers as c LEFT JOIN (reward_customer_points as r) ON (r.customers_id=c.customers_id) LEFT JOIN(group_pricing as gp) ON (gp.group_id=c.customers_group_pricing) LEFT JOIN(reward_master as rm) ON ((c.customers_group_pricing!=0 AND rm.scope=3 AND rm.scope_id=c.customers_group_pricing) OR (c.customers_group_pricing=0 AND rm.scope=0 AND rm.scope_id=0)) WHERE c.customers_lastname LIKE 'P%' ORDER BY c.customers_lastname LIMIT REWARD_POINTS_CUSTOMER_LIMIT;]
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 


---

Does anyone have Rewards module is working when someone using Google checkout to process the payment,

In this post http://www.zen-cart.com/forum/showth...gle#post624735 Kenwah says it s working.

However it seems that Google checkout avoids the whole zen cart, yet if you block Google checkout from only being visible when someone is signed in , it violates Google's TOS and they can suspend your checkout account. :oops:


if so please let me know how I go about doing it? Thanks so much. :yes:

Is there any setting that makes this not applicable with discount codes?

I don't want customers to be able to use the rewards and a discount code at the same time, is this possible??

Trying to completely uninstall this mod and have a few issues.

I have removed everything that contained reward or points from my files and ran the uninstall SQL. But I can still see Reward Points listed 3 times in admin>configuration.

How do I get rid of them?

I'm not sure if this is a bug or my misunderstanding of how group rewards work, but I have a customer I have added to a Discount Pricing Group in Admin->Customers->Customers because I want to give them a percentage discount on everything they buy.

Now, if I go to Admin->Customers->Reward Points and edit the customer reward points, say I add a few points to their earned, the Discount Pricing Group is set to --none-- so they no longer receive their percentage discounts when they buy.

When I initially went in to the reward points screen, I could see their Discount Pricing Group name under the heading Pricing Group.
When I click to edit the customer there is a dropdown Set new Pricing Group/Redeem Ratio that only contains 1 option, which is --none-- I'm guessing that's where the problem is?

Is this a small bug or a feature I'm missing the point of?

hey everyone - sorry if this has already been covered, i couldn't find this info on the pages i read through.

I've installed everything that came with version 1.4 of the module (from Andrews website directly). I've even had my hosting company help me, as I'm not sure what I'm doing & am learning as i go - with a lot of hiccups along the way!

When I use the diagnostics tool, I no longer have any files or folders showing in red, but i have the following showing in red in the "MySQL Database Check" section:

customers_id- field missing in reward_customer_points!!!
reward_points- field missing in reward_customer_points!!!
pending_points- field missing in reward_customer_points!!!
rewards_id- field missing in reward_status_track!!!
customers_id- field missing in reward_status_track!!!
orders_id- field missing in reward_status_track!!!
date- field missing in reward_status_track!!!
reward_points- field missing in reward_status_track!!!
status- field missing in reward_status_track!!!
Allow Redeem of Reward Points on Order Total or Subtotal- record missing in configuration!!!

I've done all the SQL patches I can find inside the module, and so has my hosting company. I'm almost begin told to give up on the module at this point, because it seems like this issue can't be fixed!
(extra info - version 1.33a, the one for DL through zen cart, it also had the same files showing in red when i installed it, which is why i tried this version)

Could anyone help me with this? tell me how to fix it? where to get the info to fix it?
I"m no programmer, I don't really knwo what i'm doing here, so I can't figure this out on my own. I"d really appreciate anyone helping me with this that can - i'd love to be able to fix this issue & use this mod!

I am lost.

I want reward points to be earned against regular priced items not items on sale. So can two items be purchased, one sale item and one regular item and still have it compute reward points correctly?

I want each product to be computed by this equation. PRICE X 0.05

Meaning if you buy something for $100. Your reward points will be $100*0.05. Basically you earn a nickel for every dollar you spend.

I want ... okay enough. Can someone please help set this up?

I think that you can do it. I have set the Global Reward Point Ratio to 5.00 with Catalog > Reward Points. This gives 5 points for every currency unit ($, €, £ or whatever your base currency is) spent, which is redeemed for 0.01 per point. That covers your question about the formula.

If you go to Configuration > Reward Points > Adjust Reward Points for Sales/Specials you can set it to 0 or 1 depending on what you want to do. Each of the options is explained there.

Although I have not played with it, I see that you can define a different Reward Point Ratio for a product. Go to Catalog > Reward Points where you will see the Global Ratio of 5.0000 in the box on the top right of the screen. Then, select a category and a product. You will find another box titled "Set Product Reward Point ratio:" where you can enter a different ratio for the individual product. In your case, if you don't want some products to earn points, enter 0.0000 in the box.

As I said, I have not tried it but this should be the purpose of setting a ratio on a product basis. You may for example want items of sale to get 2 rather than 5 points for every dollar spent, or you may want some other products advertised as earning 20 points per dollar. I can't see any way to do it automatically, so I assume that this should be done manually for each product differentiating from the global setting.

If you try and it works this way, you may want to post your experience here for other users to learn and benefit. Good luck!

Quote:

---

Originally Posted by Athens Collectibles

I think that you can do it. I have set the Global Reward Point Ratio to 5.00 with Catalog > Reward Points. This gives 5 points for every currency unit ($, €, £ or whatever your base currency is) spent, which is redeemed for 0.01 per point. That covers your question about the formula.

If you go to Configuration > Reward Points > Adjust Reward Points for Sales/Specials you can set it to 0 or 1 depending on what you want to do. Each of the options is explained there.

Although I have not played with it, I see that you can define a different Reward Point Ratio for a product. Go to Catalog > Reward Points where you will see the Global Ratio of 5.0000 in the box on the top right of the screen. Then, select a category and a product. You will find another box titled "Set Product Reward Point ratio:" where you can enter a different ratio for the individual product. In your case, if you don't want some products to earn points, enter 0.0000 in the box.

As I said, I have not tried it but this should be the purpose of setting a ratio on a product basis. You may for example want items of sale to get 2 rather than 5 points for every dollar spent, or you may want some other products advertised as earning 20 points per dollar. I can't see any way to do it automatically, so I assume that this should be done manually for each product differentiating from the global setting.

If you try and it works this way, you may want to post your experience here for other users to learn and benefit. Good luck!

---

I will try that and get back to you. Thanks!

Quote:

---

Originally Posted by Sharni

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

---

I couldn't find an answer, so I wrote one. Here is the code. You should copy this code and create a .php file with it. Place that file on your web server and replace the top line for connections with your own DB connection info. Execute the script by accessing it through your browser.

I have our sunrises period in the admin set to 31 so I wrote this to check whether the order is older than 30 days. You may adjust this to meet your needs.

This comes with NO warranty or guarantee. It did exactly what I needed it to though. The rewards points module creates 3 tables, one of which is only used to track the reward ratio of different categories, products, groups etc. . .

The additional two tables are what's important here. These tables are properly addressed in my lil' script.

Enjoy! John

BACKUP YOUR DB!!!

PHP Code:

---


<?php
// hour minute second month day year

require 'connections.php';
$sunrises = (30 * 24 * 60 * 60); //days x hours x minutes x seconds
$now = time();
$issue_rewards = array();
$query = mysql_query("SELECT * FROM orders_total WHERE class ='ot_subtotal'");

$cID = '';
$date = '';

while($row = mysql_fetch_assoc($query)){
    
    $updates = array();
    $query2 = mysql_query("SELECT * FROM orders_status_history WHERE orders_id ='$row[orders_id]'");
    while($row2 = mysql_fetch_assoc($query2)){
        
        $updates[] = $row2['orders_status_id'];
    }
    
    if(in_array('3', $updates) && !in_array('5', $updates) && !in_array('6', $updates) && !in_array('111', $updates) && !in_array('107', $updates) && !in_array('109', $updates)){
    $round_val = round($row['value'], PHP_ROUND_HALF_DOWN);
    //2008-01-18 18:16:51
$o_get_date_time = mysql_query("SELECT * FROM orders WHERE orders_id ='$row[orders_id]'");
    while($this_date_time = mysql_fetch_assoc($o_get_date_time)){
    $dt_parts = explode(' ', $this_date_time['date_purchased']);
    $dt_date = $dt_parts[0];
    $dt_time = $dt_parts[1];
    $cID = $this_date_time['customers_id'];
    $date = $this_date_time['date_purchased'];
    }
    
    $d_parts = explode('-', $dt_date);
    $mo = $d_parts[1]; $da = $d_parts[2]; $yr = $d_parts[0];
    $t_parts = explode(':', $dt_time);
    $hr = $t_parts[0]; $mn = $t_parts[1]; $se = $t_parts[2]; 
    $odate_secs = mktime($hr, $mn, $se, $mo, $da, $yr);
    //$recompile = $yr.'-'.$mo.'-'.$da.' '. $hr.':'.$mn.':'.$se;//testing here
    

    $date_math = $now - $odate_secs;
    if($date_math < $sunrises){
    //insert these points as pending
        echo $count . ": OK! Order ID: " . $row['orders_id'] . '  Will Get: ' . $round_val . ' ' . $recompile . ' PENDING<br />';
        
        mysql_query("INSERT INTO reward_status_track (rewards_id,customers_id,orders_id,date,reward_points,status) VALUES ('',$cID,$row[orders_id],'$date',$round_val,'0')") or die(mysql_error());
        $exisitng_check = mysql_query("SELECT * FROM reward_customer_points WHERE customers_id ='$cID'") or die(mysql_error());
        $exis_chk_nums = mysql_num_rows($exisitng_check);
        if($exis_chk_nums < 1){
        mysql_query("INSERT INTO reward_customer_points (customers_id,reward_points,pending_points) VALUES ($cID,'0',$round_val)") or die(mysql_error());
        }else{
            while($existing_record = mysql_fetch_assoc($exisitng_check)){
            //$existing_rp = $existing_record['reward_points'];
            $existing_pp = $existing_record['pending_points'];
            }
            //$new_rp = $existing_rp + $round_val;
            $new_pp = $existing_pp + $round_val;
            mysql_query("UPDATE reward_customer_points SET pending_points=$new_pp WHERE customers_id=$cID") or die(mysql_error());
        }
    }else{
    //insert these points as earned
        echo $count . ": OK! Order ID: " . $row['orders_id'] . '  Will Get: ' . $round_val . ' ' . $recompile . ' EARNED!<br />';
        
                
        mysql_query("INSERT INTO reward_status_track (rewards_id,customers_id,orders_id,date,reward_points,status) VALUES ('',$cID,$row[orders_id],'$date',$round_val,'1')") or die(mysql_error());
        $exisitng_check = mysql_query("SELECT * FROM reward_customer_points WHERE customers_id ='$cID'") or die(mysql_error());
        $exis_chk_nums = mysql_num_rows($exisitng_check);
        if($exis_chk_nums < 1){
        mysql_query("INSERT INTO reward_customer_points (customers_id,reward_points,pending_points) VALUES ($cID,$round_val,'0')") or die(mysql_error());
    }else{
            while($existing_record = mysql_fetch_assoc($exisitng_check)){
            $existing_rp = $existing_record['reward_points'];
            //$existing_pp = $existing_record['pending_points'];
            }
            $new_rp = $existing_rp + $round_val;
            //$new_pp = $existing_pp + $round_val;
            mysql_query("UPDATE reward_customer_points SET reward_points=$new_rp WHERE customers_id=$cID") or die(mysql_error());
        }
    
    
    }

}


}    
?>

---

Quote:

---

Originally Posted by carley

hey everyone - sorry if this has already been covered, i couldn't find this info on the pages i read through.

I've installed everything that came with version 1.4 of the module (from Andrews website directly). I've even had my hosting company help me, as I'm not sure what I'm doing & am learning as i go - with a lot of hiccups along the way!

When I use the diagnostics tool, I no longer have any files or folders showing in red, but i have the following showing in red in the "MySQL Database Check" section:

customers_id- field missing in reward_customer_points!!!
reward_points- field missing in reward_customer_points!!!
pending_points- field missing in reward_customer_points!!!
rewards_id- field missing in reward_status_track!!!
customers_id- field missing in reward_status_track!!!
orders_id- field missing in reward_status_track!!!
date- field missing in reward_status_track!!!
reward_points- field missing in reward_status_track!!!
status- field missing in reward_status_track!!!
Allow Redeem of Reward Points on Order Total or Subtotal- record missing in configuration!!!

I've done all the SQL patches I can find inside the module, and so has my hosting company. I'm almost begin told to give up on the module at this point, because it seems like this issue can't be fixed!
(extra info - version 1.33a, the one for DL through zen cart, it also had the same files showing in red when i installed it, which is why i tried this version)

Could anyone help me with this? tell me how to fix it? where to get the info to fix it?
I"m no programmer, I don't really knwo what i'm doing here, so I can't figure this out on my own. I"d really appreciate anyone helping me with this that can - i'd love to be able to fix this issue & use this mod!

---

Also - Is there a way to make it so my wholesale customers do NOT get reward points for any of their purchases? Since they already get a heavily discounted price in many cases, i don't wish to give hem points as well.

Well I tried diff configs and still cannot get it right. I tried PM'ing the author with no response or either that he's too busy.

well, i did really want to use this module, it seems great. but after reading all 178pgs of posts, not finding anyone else mentioning the issues the RPD is finding with missing lines in the SQL file, and after posting twice myself, without any reply or comment in response, and after trying to PM the author, only to find his inbox is full & msg can't be sent - I'm giving up.

I found another reward points mod for zencart, made by a company, and they're following up with people-supporting their mod & answering questions in their forum without people having to wait too long. and it's also free. so I'm going it a shot instead.
Oh well, this mod does seem better than the 1 i'm going to try, but it's not much better if it won't work & is missing things :(

I am having the same problem that someone else is having - I just placed a test order and I saw the points at checkout, I can see them in my order status in the admin, but they are not appearing under the CUSTOMERS > REWARD POINTS screen...

It was working at one time.....I did tests months ago and they worked fine - now we are getting ready to launch the program and it does not work.

We did upgrade to 1.3.9H a few weeks ago - but would think that should not have any cause for this.

Does anyone have any ideas why they are not appearing?!?!?!

Thank you!

Even more weird is that I just placed another test order, used points from the old test I did....at checkout I applied the points i had to the order....and saw that I was to earn 395 points for the new order...order went through fine and when I looked at CUSTOMER > REWARD POINTS i can see that the points WERE removed from the earned column....but there are no new PENDING points for this order.....

?!?!?!?!!?

Quote:

---

Originally Posted by Athens Collectibles

I think that you can do it. I have set the Global Reward Point Ratio to 5.00 with Catalog > Reward Points. This gives 5 points for every currency unit ($, €, £ or whatever your base currency is) spent, which is redeemed for 0.01 per point. That covers your question about the formula.

If you go to Configuration > Reward Points > Adjust Reward Points for Sales/Specials you can set it to 0 or 1 depending on what you want to do. Each of the options is explained there.

Although I have not played with it, I see that you can define a different Reward Point Ratio for a product. Go to Catalog > Reward Points where you will see the Global Ratio of 5.0000 in the box on the top right of the screen. Then, select a category and a product. You will find another box titled "Set Product Reward Point ratio:" where you can enter a different ratio for the individual product. In your case, if you don't want some products to earn points, enter 0.0000 in the box.

As I said, I have not tried it but this should be the purpose of setting a ratio on a product basis. You may for example want items of sale to get 2 rather than 5 points for every dollar spent, or you may want some other products advertised as earning 20 points per dollar. I can't see any way to do it automatically, so I assume that this should be done manually for each product differentiating from the global setting.

If you try and it works this way, you may want to post your experience here for other users to learn and benefit. Good luck!

---

Well the author finally got back to me. Looks like this rounds UP in whole points.

I have it set in global for all products at .005. So if someone purchases for $189.99 their points are 0.94995 which rounds up to 1 full point.
to redeem in orders total I have it set at 1 point equals 1 dollar.

I DON"T think the author wants to be bothered with questions so for the future anyone seeking to ask him, forget it. He's maybe just too busy to deal with it anymore.

"Reward Point Rounding
Rounding value- This is an adjustment to each product price before it is rounded to 0 decimal places to calculate product Reward Points (default 0.0)"

Does anyone know what this means or how it adjusts? Becase like in my example above. "So if someone purchases for $189.99 their points are 0.94995 which rounds up to 1 full point." I don't want it to round up. I want it to round down. So this amount should not be getting any points. Now if the total was $379.98 the points would be$1.8999 which should be only 1 point.

All in all, it seems like a good mod, seems there is a lot of confusion as the instructions aren't that clear. After 179 pages you would think all the questions would be answered.

I am using Zen Cart v1.3.9h, installed. I installed Rewards Points Module 1.40a. I have it set up in the Order Totals Module Reward Points Tiered Discounts of 5% for 100 points. When I test an order, in step 2 of 3 the Rewards Point Tiered Discouts Available displays properly. Once selected and applied to the order in step 3 of 3 Order Confirmation (Order Total) it displays as Total Reward Discount Amount: (500%) with the correct dollar value being taken of the total order.

I am not a programmer and have searched for hours to try to figure out how to move the decimal point over in the display or something? Can someone please help me?

Thanks in advance.

Is there a way to call the values of the Table Discounts? Like the values that I set in the config.

When I go to the Rewards Points page where it lists all the customers under A, B, C, D, E etc. I noticed that I have A LOT more customers with last names starting with A, B, C, D, etc. but it only shows like 50.

Do I need to change a setting somewhere?

Is there a link to a page 1 or 2. There should be some sort of pagination available.

Quote:

---

Originally Posted by retched

Is there a link to a page 1 or 2. There should be some sort of pagination available.

---

You would think but no.

Configuration > Reward Points > Limit Maximum Customers on Listings is 50 by default. You could change it to a larger number, say 100. I don't have a very large number of test customers and haven't tried, but a zero or blank value might set it to unlimited. Let us know if you try it and works this way or not.

Happy Easter to all!

Quote:

---

Originally Posted by Athens Collectibles

Configuration > Reward Points > Limit Maximum Customers on Listings is 50 by default. You could change it to a larger number, say 100. I don't have a very large number of test customers and haven't tried, but a zero or blank value might set it to unlimited. Let us know if you try it and works this way or not.

Happy Easter to all!

---

Thank you.

Setting it to blank will give a MySQL error.

Setting it to 0 will show no customers.

I set it to 1,000,000 LOL. I don't like it that way though. I think the author should modify it to where you can set it at around 50 with pages like 1, 2 and 3 if you have more than 50 per page.

I have one in the B section with 200 customers, it's a pita to see all 200 customers load.

Quote:

---

I think the author should modify it to where you can set it at around 50 with pages like 1, 2 and 3 if you have more than 50 per page.

---

I couldn't agree more, unfortunately I'm not the author but I wish I was because it's an excellent mod.

Thanks for your reply which clarifies what happens with zero or blank values.

Quote:

---

Originally Posted by Athens Collectibles

I couldn't agree more, unfortunately I'm not the author but I wish I was because it's an excellent mod.

Thanks for your reply which clarifies what happens with zero or blank values.

---

Noted and added to the todo list for v1.50

Welcome back to the forums Andrew! :D

Quote:

---

Originally Posted by hem

Noted and added to the todo list for v1.50

---

honey do's. DO IT! :D

suggestion also for honey do's

allow points to be had in this format x.xx instead of just round whole numbers. it'd be nice for people to get points for a 50 dollar order but not allow them to get one full point.

in my case. I allow .005 for every dollar spent. so 50 dollars spent would be 25 cents.

also am i missing it here?

can we NOT allow reward points to be had if an item is already on sale or discounted? why should we give reward points for something already on sale.

if this isn't in the current version then please add it to the honey do list. thanks.

Okay, so I understand that orders being refunded need to be set to "Pending" to remove the rewarded points.

This is a problem because when orders are canceled, refunded, reversed. . . we don't set them back to "Pending" because they're not "Pending" they're canceled, refunded, reversed. . .

I have a list of possible order statuses from our order_status table.

1 1 Pending
2 1 Processing
3 1 Delivered
4 1 Update
5 1 Canceled
6 1 Refunded
100 1 Google New
101 1 Google Processing
103 1 Google Digital Processed
105 1 Google Shipped
107 1 Google Refunded
109 1 Google Shipped and Refunded
111 1 Google Canceled

I have been through most of the files included with the mod and can not figure out how/where to make the adjustments necessary to have this function as I need.

I'm using the sunrise period. I would only like to move pending points to rewarded points after the sunrise period if the status is Delivered.

After that, if an order status is set to Canceled, Refunded, Google Canceled, Google Refunded. . . I would like to remove the points that were awarded.

Please tell me how.

Thanks, John

Maybe I just needed a nice long break. I think I've found the answer!

In admin/includes/functions/extra_functions/reward_points_functions.php

Code:

---

function UpdateOrderRewardPointsStatus($order_id,$zc_status)
{
    global $messageStack;
   
    if(REWARD_POINTS_STATUS_TRACK=='') // Simple mode
    if($zc_status!=1) // If status has changed from Pending. . .

---

would need to be

Code:

---

function UpdateOrderRewardPointsStatus($order_id,$zc_status)
{
    global $messageStack;
   
    if(REWARD_POINTS_STATUS_TRACK=='') // Simple mode
    if($zc_status!=1 && $zc_status!=2 && $zc_status!=5 && $zc_status!=6) // If status has changed from Pending. . .

---

Okay, I've noticed that since the integration of this mod, it seems as though the sunrises period is not being respected.

The function mentioned above is the entire reason why. I had noticed that a customer would place an order on the 5th and they'd have points rewarded by the 9th even though our sunrises = 31.

This function is moving points from pending to rewarded as soon as the admin makes comments on an order and gives a status other than "pending". This is double uncool because not all orders are marked as "pending" when placed.

Zencart gives us an option of the default status when an order is placed. We use "processing" for normal orders and "pending" for check/money order orders.

So the check for the status should dig a little deeper. Aside from that, we update orders regularly and normally starting on day 2 of the order with tracking info or other info about when their order may ship.

I have tweaked the function a bit. Now when an order is update it does nothing in regards to transferring points unless the status is one of our "refunded", "canceled", "google canceled" or "google refunded". In those cases it will now delete the status tracker record as well as rewarded or pending points == to the amount of points earned on that particular order.

You can see our order status id's above which will hopefully help the following code make sense.

Code:

---

function UpdateOrderRewardPointsStatus($order_id,$zc_status)
{
    global $messageStack;
   
    if(REWARD_POINTS_STATUS_TRACK==''){ // Simple mode
    if($zc_status==5 || $zc_status==6 || $zc_status==107 || $zc_status==111){
    DeleteOrderRewardPoints($order_id);}
    }else{ // Advanced mode
    if(($record=GetLastRewardPointHistoryRecord($order_id))){
      if(($state=GetState($zc_status))!=STATUS_IGNORE && $status_change=($record->fields['status']!=$state)){
      if($state==STATUS_PROCESSED){
        TransferCustomerPointsFromPending($order_id);
      }else{
        TransferCustomerPointsToPending($order_id);}
        }}}
}

---

I just installed this and was wondering does anyone have a link to where I can see it in action?

I am kind of lost on how I want the points set up and how to come up with the FAQ sheet for it so I need some ideas lol.

Thanks guys!

Quote:

---

was wondering does anyone have a link to where I can see it in action?

---

I have it installed and (almost fully) tested on my Athens Collectibles site.

There are links to the FAQ page on the left side column, or you can link to the Customer Reward Program page directly to read the terms. Obviously, your terms could be different, but you may get some ideas from reading mine.

Quote:

---

Originally Posted by Athens Collectibles

I have it installed and (almost fully) tested on my Athens Collectibles site.

There are links to the FAQ page on the left side column, or you can link to the Customer Reward Program page directly to read the terms. Obviously, your terms could be different, but you may get some ideas from reading mine.

---

Great! Thanks a bunch!

:oops: I have no idea what I did but now on my product description page I get this error.

146 Table 'fromprop_zc1.zen_reward_master' doesn't exist
in:
[SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute FROM zen_reward_master prp, zen_products p, zen_products_to_categories p2c WHERE p.products_id='2574' AND p2c.products_id='2574' AND ((prp.scope_id=p.products_id AND prp.scope='2') OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='1') OR (prp.scope='0')) ORDER BY prp.scope DESC LIMIT 1;]


and now my Rewards Point Page says it doesn't exist. Here is my site in case you need it http://www.frompropertorocker.com

Thanks!