Reward Points Module for ZC v13x

[lnsenterprises]

so afr the only issue I tend to have now is the pic below...all apparently seems to be working correctly so try the uninstall and re-install of the sql first and see what happens....any idea on how to get this removed in the pic attached

[countrycharm]

so afr the only issue I tend to have now is the pic below...all apparently seems to be working correctly so try the uninstall and re-install of the sql first and see what happens....any idea on how to get this removed in the pic attached

If you would read a page back you might find what the problem is.

[lnsenterprises]

If you would read a page back you might find what the problem is.

NEWSFLASH...yes I did see this...You are getting that error because you didn't upload the definition file or you didn't upload it to the right directory. It goes in includes/languages/english/extra_definitions/custom/reward_points.php. If the file didn't upload it will cause that

and yes I did install it correctly...

[DivaVocals]

NEWSFLASH...yes I did see this...You are getting that error because you didn't upload the definition file or you didn't upload it to the right directory. It goes in includes/languages/english/extra_definitions/custom/reward_points.php. If the file didn't upload it will cause that

and yes I did install it correctly...

CountryCharm is right.. the only reason you see that text is due to a missing language file.. So let me ask this.. includes/languages/english/extra_definitions/custom/reward_points.php. Is the folder the rest of your template files sit in called "custom"? If not then this is the issue.. You need to re-name "custom" to match your template's folder name..

[lnsenterprises]

all on my end is fine....I have been modding etc for years....I am un-installing it and trying fresh to see what happens I can see his point, yet doesnt mean he is correct as something else may cause it....If I find out what I will post no worries

[DivaVocals]

all on my end is fine....I have been modding etc for years....I am un-installing it and trying fresh to see what happens I can see his point, yet doesnt mean he is correct as something else may cause it....If I find out what I will post no worries

It means that there is an issue with the language file.. whether that mean it's missing or corrupted.. the cause is a language file..

[antoniobb]

another issue
in admin>customers>orders, it shows "Reward Points earned: $0.00",
i check the sql table zen_orders_total, for the order, text is 35, value is 0.0000
what do i show "Reward Points earned: 35" in the admin order page?
what do i fix it?

I'm having the same problem.... hope someone replys with a solution... it does not affect on the customer side, it is only on the admin

[silkhouse]

when a customer check out with paypal IPN (not paypal express checkout), will he get store credit automatically? Does anyone has ever make this module work with paypal IPN before?

Thank you.
ps： my zen-cart is 1.38A

[silkhouse]

i was confirmed by numinix that the following module can not do that:
http://www.zen-cart.com/downloads.php?do=file&id=1487

[Coins2012]

v1.5 version: http://www.zen-cart.com/downloads.php?do=file&id=704

Feature Question: the rewards program allows the automatic expiration of PENDING points by setting a future expiration in days:

admin > config > rewards points config > Delete Old Reward Transactions Period = 30 days (for example below)

For example, a customer buys product, receives 1000 points that are PENDING until the order has shipped, triggering the 1000 points to move from PENDING to EARNED. If the order does not ship in 30 days, the PENDING points expire. No problem, tested and works fine.

What I want to do is expire EARNED points in 30 days. For example, a customer buys product, receives 1000 points that are PENDING. The the order is shipped, triggering the 1000 points to move from PENDING to EARNED. If the customer does not use/redeem the EARNED 1000 points in 30 days, the EARNED points automatically expire. A "Use 'em or Loose'em" scenario.

Does this feature exist in the Mod? If not, any pointers on how to create this function ... Help greatly appreciated!

I don't think you will get an answer to your question because I asked the same question perhaps a month or two ago, I think the module is not setup for that so I got one of my family members write me a code which I run daily, it's not the perfect way but itworks, you could set it up as a cron job if you like to run it daily, here is the code below:

<?php

try {
$dbh = new PDO("mysql:host=localhost;dbname=DATABASE_NAME", 'DATABASE_NAME_Points', '1qwer13');

$Totalquery = "Update reward_customer_points
SET reward_points = 0.00
Where customers_id not in (select customers_id from reward_status_track)";


$Totalstmt = $dbh->prepare($Totalquery);
$Totalstmt ->execute();

echo 'Total Task Completed';

}
catch(PDOException $e)
{
echo $e->getMessage();
}

?>

Basically when you set up your reward points module pending points to expire in 30 days, the reward_status_track table keeps only 30 days of records so what the code does if it's not in the track table then it sets the points to Zero.

You have to run this daily though, if not then the deleted records will be lost and won't be able to zero the reward points that are older than 30 days.

I am sure some people here could make it much better and full proof and run it as a cron job.

I am not an expert in code writing but was able to figure things out to solve my problem.

Hope this helps,