Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

One thing I notice , and I also think I've mentioned in some previous thread, is that in Advanced Reward Point Calculation Rules, there's no ot_total to subtract to.

This configuration, has a strange behavior and it's coming or built from a jscript.

Sometimes I see a t_total but never the ot_total
I remember that I've saw this array, but never quite understood why it was not reading the proper name.

Quote:

---

Originally Posted by chibipaw

Thanks for the point. Sometimes its just really hard to sift through the threads without missing critical pieces.
Looks like your code allowed redemption of the rewards points at check out.
but I have noticed now that a customer can check out, but the points are not actually subtracted from the customer's account. Are you having that problem too, or is there another patch for that?

---

I check the file again, and for some reason I didnt' change to what I've posted here:

See if this works ( at includes/modules/order_toral/ot_rewards_points.php around line 122 )
So change the zen_draw_hidden_field('redeem_checkout_flag',true) to zen_draw_hidden_field('redeem_checkout_flag',1)

PHP Code:

---

 if(MODULE_ORDER_TOTAL_REWARD_POINTS_TYPE=="Automatic")
               $prompt=zen_draw_checkbox_field('redeem_flag',true,isset($_SESSION['redeem_value']),'').' '.zen_draw_hidden_field('redeem_checkout_flag',1);
              else
               $prompt =zen_draw_input_field('redeem_points',isset($_SESSION['redeem_points'])).' '.zen_draw_hidden_field('redeem_checkout_flag',1); 


---

I'm using the simple calculation mode, but I think this is working.
But also check if the Advanced Reward Point Calculation Rules are ok. As I mentioned, I think this is not working very well.

Thank you SO much! This seems to be working for me, and I have the advanced rules enabled.

I'm not sure if it's entirely working. I'm getting for some reason less 10 points on the check-out.
I'm on mobile, so cant give a example, but check if it's resetting points when clearing / changing a basket, and if the calculations are ok during the all check-out process.

I just tried a very convoluted process of adding products, selecting reward points to redeem, removing products, unchecking redeem points, in various combinations and the reward points were always accurate. I didn't go right through to the order confirmation though - is that where you are having trouble?

I just noticed though that I had done some previous editing on this file e.g. changing line 26 to function __construct()

There may be other changes too, it was a while since I did that.

Probably I have something wrong, but I haven't yet figure out what
...
Do you use the round number ( in the configuration ? )
I have 0.5.....
But again, I cant give the right info since I'm on mobile. But if it's working for you, thats cool.

My reward point rounding is set to 0.0

Other settings:

Reward Point Status Track : Simple
Adjust Reward Points for Sales/Specials : 1
Advanced Reward Point Calculation Rules : Advanced Rules Enabled

Most other settings are at 0

I've implemented the changes from post #202.
Quick test looks like the points are finally being subtracting.
My rounding is set to 0.025.
I have not noticed rounding problems yet. But then I haven't really fine tune examine the results yet.

Quote:

---

Originally Posted by chibipaw

I've implemented the changes from post #202.
Quick test looks like the points are finally being subtracting.
My rounding is set to 0.025.
I have not noticed rounding problems yet. But then I haven't really fine tune examine the results yet.

---

I've upgraded my zen cart to the newest version and now my reward points are working right up to the redeem part. They are being calculated correctly but when the customer tries to redeem them it doesn't work. Will someone try and fix this module or would I be best issuing gift certificate balances for the amounts on every account and looking for something more reliable? If there is an official fix could someone please help me with this as I'm not hugely knowledgeable about coding and things or can you recommend a more reliable module? Thank you so much.

It's quite a simple fix as explained in https://www.zen-cart.com/showthread....55#post1318755

There are two instances where you have to change "true" to "1"

Thank you so much Paul3648. I had only changed the one instance. Seems to be working now.

Well, probably it's the way it works.... but for i.e:

A 8.5 order gives 85 points. Ok.
Lets say that the customers redeems 100 points.
But on checkout_confirmation page:

Sub-Total: 8,50€
Shipping : 1,50€
-1,00€ ( the amount for 100 points ):
Total: 9,00€

And the customers gets 75 reward points.

So, I thought that the customers would use his points, and receive the actual 85 points. But it's subtracting 10 points from the 85 ( so the points that the customers used for this purchase. )

But maybe this is explain in some older threads... I haven't check.

Another thing, that it's happening and I think it's confused, it's even if I clear the basket, and add some other product, on checkout_payment
the 100 points (for this example the last 100 reward points used ) are still there. And I think, that when clearing the basket , all that info should be clear too. ( I think )..... or maybe not.

Are you using it in advanced mode?
I've played with it and didnt have issues with circular points since the customers only get pending points, not earned points until I manually change their products to the "delivered" status.

Quote:

---

Originally Posted by mesnitu

A 8.5 order gives 85 points. Ok.
Lets say that the customers redeems 100 points.
But on checkout_confirmation page:

Sub-Total: 8,50€
Shipping : 1,50€
-1,00€ ( the amount for 100 points ):
Total: 9,00€

And the customers gets 75 reward points.

---

He's getting 75 points because he's actually paying 7,50€. I think this is correct.

Quote:

---

Originally Posted by mesnitu

Another thing, that it's happening and I think it's confused, it's even if I clear the basket, and add some other product, on checkout_payment
the 100 points (for this example the last 100 reward points used ) are still there. And I think, that when clearing the basket , all that info should be clear too. ( I think )..... or maybe not.

---

I think this is also correct, because the customer has already indicated he wants to redeem the points, so they are automatically selected in the same session.

There's another issue that I can't reproduce at xampp with PHP Version: 5.6.15 (Zend: 2.6.0) , and the online server with PHP Version: 5.6.28 (Zend: 2.6.0)

But if no advance Advanced Reward Point Calculation Rules are set , no modules are set there, it returns

Code:

---

[18-Nov-2016 10:40:29 Europe/Lisbon] PHP Warning:  Invalid argument supplied for foreach() in /home/public/includes/functions/extra_functions/reward_points_functions.php on line 314

---

PHP Code:

---

function GetRewardPointAdvancedCalculateValue()
{
    $value=0;
    
    $module_list=GetRewardPointAdvancedCalculateTable();

        foreach($module_list as $module)
     if($module['action']=="Subtract")
      $value-=GetOrderTotalValue($module['module']);
     else
      $value+=GetOrderTotalValue($module['module']);
          
    return $value;
} 


---

Looks like surrounding this foreach to loop only if there are odules to calculate , solves the warnings.

PHP Code:

---

function GetRewardPointAdvancedCalculateValue()
{
    $value=0;
    
    $module_list=GetRewardPointAdvancedCalculateTable();
    
     if (!empty($module_list)) {
     
        foreach($module_list as $module)
     if($module['action']=="Subtract")
      $value-=GetOrderTotalValue($module['module']);
     else
      $value+=GetOrderTotalValue($module['module']);
    }
      
    return $value;
} 


---

But, again, I can't reproduce on xampp...probably the php version.

I just installed this mod and it's working well EXCEPT that order notification emails aren't being sent out. I don't get a copy as the store admin and the customer isn't getting a copy, either.

What could've made this happen?

Quote:

---

Originally Posted by izar74

Hi again,

I've got this error:

HTML Code:

---

[25-May-2015 15:22:01] PHP Fatal error:  1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2')
                                OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id A' at line 3 :: SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute
                                FROM reward_master prp, products p, products_to_categories p2c
                                WHERE p.products_id='101'"'
                                AND p2c.products_id='101'"'
                                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; ==> (as called by) /var/www/vhosts/.../httpdocs/includes/functions/extra_functions/reward_points_functions.php on line 62 <== in /var/www/vhosts/.../httpdocs/includes/classes/db/mysql/query_factory.php on line 155

---

Check the file but it seem all fine... the line 51 to 62 of reward_points_functions.php look like this:

PHP Code:

---

if(zen_get_products_price_is_free($products_id)==false || REWARD_POINTS_ALLOW_ON_FREE=='1') // Allow RP on free items (Admin settable)
    {
        $sql = "SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute 
                FROM ".TABLE_REWARD_MASTER." prp, ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_TO_CATEGORIES." p2c 
                WHERE p.products_id='" . $products_id . "'
                AND p2c.products_id='" . $products_id . "'
                AND ((prp.scope_id=p.products_id AND prp.scope='".SCOPE_PRODUCT."') 
                OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='".SCOPE_CATEGORY."')
                OR (prp.scope='".SCOPE_GLOBAL."'))
                ORDER BY prp.scope DESC LIMIT 1;";

        $result=$db->Execute($sql); 


---

The specific of the server are:
Database: MySQL 5.1.73
Versione PHP: 5.3.3 (Zend: 2.3.0) PHP Memory Limit: 128M

I'm a little bit unsure of what that error could be... any guess would be helpful :smile:

---

I have this same error on a new installation of the Reward Points plugin.

Any reason why this appears?

Can't seem to get this to work the way I want it to :-(

Item cost $8.00
Reward Points should be 8

Each Reward point should have CASH VALUE of $0.10

Pending Value is CORRECT $0.80

But Available is 0%

What am I doing incorrect?

The points are PENDING until you approve them. You can set it up to approve them automatically, but the only way I managed to do that is by changing the Sunrise Period to 1 instead of 0.

In admin, go to Configuration / Reward Point Configuration. Look for "Reward Point Sunrise Period" and set this to 1.

All pending points will move to EARNED after 24 hours.

You can see the pending points by going to Customers / Reward Points and sorting by Points Pending.

Hope this helps!

Thanks, but doesn't make a difference.

I'll just hack it to make it work the way I want it too!

Quote:

---

Originally Posted by jmsnyder23

The points are PENDING until you approve them. You can set it up to approve them automatically, but the only way I managed to do that is by changing the Sunrise Period to 1 instead of 0.

In admin, go to Configuration / Reward Point Configuration. Look for "Reward Point Sunrise Period" and set this to 1.

All pending points will move to EARNED after 24 hours.

You can see the pending points by going to Customers / Reward Points and sorting by Points Pending.

Hope this helps!

---

Hoping this is just an improper setting issue.

I have a product set for 3x the points for a sale, but in check out it still calculates the global point setting.

Anyone?

Quote:

---

Originally Posted by gigi3

Hoping this is just an improper setting issue.

I have a product set for 3x the points for a sale, but in check out it still calculates the global point setting.

Anyone?

---

Solved:

Reward Point Mode was set to 1, to calculate based on order totals. Switched it to 0, now based on product prices.

Has anyone tried this with v1.5.5 ?

Quote:

---

Originally Posted by jodean

Has anyone tried this with v1.5.5 ?

---

I would like to know this as well, if it works, I have 1.5.5A I want to use this but it does not specify that it will work for this version. Please advise.

This is probably a dumb question for all of you, but I downloaded this and wanted to read the "read me" info in its entirety, like it says It shows this:

Reward Points 2.5e

Purpose
Installation
How to Use
Upgrading from v2.1b or less to v2.5e
Credits History
License


PURPOSE

Reward Points 2.5e Loyalty Card Suite lets your customer checkout and earn Reward Points on your store.
Please check your host's PHP version. This module will NOT work for hosting configurations using PHP versions older than 5.2.x
Reward Points 2.5e was tested for Zen Cart 1.5.0 through Zen Cart 1.5.4 compatibility only.
A compatibility issue was found in Reward Points Admin/orders.php file when installing or upgrading From v2.1b or Less to the current version of Reward Points v2.5de

The compatibility issue is with zen cart versions 1.5.0, v1.5.1, v1.5.2, v1.5.3. Reward Points uses the admin/orders.php from the current version of zen cart which is v1.5.4.
When using v1.5.4 orders.php file in Reward Points Admin/orders.php, you would get a blank white screen when changing orders status.
Zen cart v1.5.4 orders.php file has new calls (for PCI compliance) to a new function named
zen_record_admin_activity.

This was causing the problem, so to solved the issue for these zen cart versions v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, once for all, we included a plugin created by lat9 into Reward Points. The files that were add by using lat9 plugin ZC1.5.4 - Admin Plugin Backward Compatibility are listed on the installation page, Other Files Use In Reward Points:.
Any issues which arise when attempting to use this module with Zen Cart v1.3.9 may be attributed to the differences between the older Zen Cart versions.
If you are still running an older version of Zen Cart we strongly recommend that you upgrade as there have been many security enhancements made in Zen Cart v1.5.0 through v1.5.4.

Reward Points v2.5e IS NOT COMPATIBLE WITH VERSIONS OF ZEN CART PRIOR TO ZEN CART 1.5.0!!
There will be no support provided for Zen Cart v1.3.9 with v2.5e of Reward Points.

*** READ EVERYTHING IN THIS README BEFORE YOU BEGIN ***

After following the installation instructions (and any additional instructions as needed), it is very strongly recommended that you read through the ENTIRE "How to Use" section. There you will find out exactly what Reward Points does.

Ready to get started? Just follow the installation instructions.
Any questions, just hit the forums: http://www.zen-cart.com/showthread.p...-now-available

New support thread here: http://www.zen-cart.com/showthread.p...Support-Thread

But on the "How to use" which is what i want to read, it will not let me click on it or read it =( Does someone have the text that should be in the HOW TO USE, and know why the links arnt working in the READ me to fully read everything like it reccomends?

can see the reward point in checkout page but not able to apply or redeem it. Kindly help

Quote:

---

Originally Posted by WiccanWitch420

This is probably a dumb question for all of you, but I downloaded this and wanted to read the "read me" info in its entirety, like it says It shows this:

......

But on the "How to use" which is what i want to read, it will not let me click on it or read it =( Does someone have the text that should be in the HOW TO USE, and know why the links arnt working in the READ me to fully read everything like it reccomends?

---

Maybe try downloading it again. I can see and read the How To Use tab just fine.

Reward Points is EASY to use.

To Setup Reward Points
Go to ADMIN->Configuration->Reward Points Configuration and setup the configuration how you want Reward Points to operate.

Switch on the 'Shopping Cart with Rewards' sidebox using Admin->Tools->Layout Box Controller. There is also a "Reward Points" sidebox which displays points in cart and points earned (if logged in)

Install the Reward Point Order Total module using Admin->Modules->Order Total. There is also a "Reward Points earned" module which displays the points earned at checkout

You can edit Global/Category/Product reward points using Admin->Catalog->Reward Points

You can set global and group Reward Point redeem ratios using Admin->Customer->Group Reward Redeem

You can set and change earned and pending points for each customer using Admin->Customer->Reward Points

The Point Ratio is the number of reward points you award per unit of base price.
So a Point Ratio of 1 will award 10 reward points for every $10, £10 etc spent.
The currency used is decided by how the prices are stored for the products.
The Global Point Ratio is used for every product, unless overwritten by a Category Point Ratio (if set).
The Category Point Ratio is overwritten by a Product Point Ratio (if set).
If you install the Reward Points Order Total Module you can also set a Redeem Ratio. This is set to 0.01 as default so each point redeemed is worth 1 cent/pence.
The Global Reward Point Redeem setting is found under Customers->Group Reward Redeem
Admin can set a Mode configuration item to select whether points are rewarded by product or are rewarded by order (sub)total.
Admin can fine tune how points are awarded or redeemed against based against other Order Total modules such as Group Pricing and Gift Vouchers.
That's it you now have Full Reward Point/Loyalty Card Suite Installed..

Quote:

---

Originally Posted by diptimoy

can see the reward point in checkout page but not able to apply or redeem it. Kindly help

---

Gonna need more information if you expect anyone to be able to help. What version of the module, Zen Cart, etc? Have you searched the thread? Many have had problems with this and any version of Zen Cart 1.5.5

Quote:

---

Originally Posted by jodean

Has anyone tried this with v1.5.5 ?

---

I had a client upgrading to 1.5.5 who was using this. We make a fix that works, but not sure it will translate to other stores. If you're interested in testing it out, PM me for details.

Has anyone come up with the sidebox fix for Zen Cart 1.5.5? Everything was a fresh install using rewards version 2.5

Cheers

Robert

Ok, I fixed the problem. When it comes to Zen 1.5.5, I had to add a responsive_classic folder to the ncludes-->modules-->sideboxes-->add the responsive_classic folder here-->then the 2 files for the sidebox, from this plugin. Hope this is a help to others who are in the same spot as myself.

Cheers

Robert

I have this installed and working properly, EXCEPT that purchases from excluded categories STILL earn the global reward points during checkout.

Global Reward Point ratio is 10.000
One category has a ratio of 0.000
The products in the excluded category also have ratios of 0.000

But when a customer buys an item in the excluded category, they're still awarded reward points.

Why is this? And how can I fix it?

I keep trying to upgrade to the new script as the admin section is not showing up and this is what i get.

WARNING: An Error occurred, please refresh the page and try again.
Any thoughts. Thak you.

The module is functioning on the front end just fine. I cannot access the admin setting for this mod.

I am using ZC version 1.5.1

Quote:

---

Originally Posted by MagicMan

I keep trying to upgrade to the new script as the admin section is not showing up and this is what i get.

WARNING: An Error occurred, please refresh the page and try again.
Any thoughts. Thak you.

The module is functioning on the front end just fine. I cannot access the admin setting for this mod.

I am using ZC version 1.5.1

---

Check your logs folder for an error log with the exact error. That will help determine the file causing the error.

Hello everyone, can someone help me with this reward point issue. Im using new zencart version 1.5.5e and reward point v2.5e. am follow the doc step by step. when am install this mod. the issue is, reward point not calculated. Let say customer have reward point 100. when customer want to order new item price is $10, and then insert the redeem point, 2 only, in the last step of shipping the total still same $100. it supposed be like $98. what is the problem guys, pls help me solve this problem, I really appreciate if someone can help. tq.

Quote:

---

Originally Posted by madi5091

Hello everyone, can someone help me with this reward point issue. Im using new zencart version 1.5.5e and reward point v2.5e. am follow the doc step by step. when am install this mod. the issue is, reward point not calculated. Let say customer have reward point 100. when customer want to order new item price is $10, and then insert the redeem point, 2 only, in the last step of shipping the total still same $100. it supposed be like $98. what is the problem guys, pls help me solve this problem, I really appreciate if someone can help. tq.

---

There are many posts in this thread with those having problems with this plugin and ZC 1.5.5. See this post for a possible fix:
https://www.zen-cart.com/showthread....28#post1329128

Hello,
I have installed this on 1.5.4. Everything seems to be working well (or displayed properly) on both storefront and admin site. However, during checkout, after ticking it for automatic reduction at Step 2, it won't display on Step 3. It did show total reward points earned, but no reduction or whatsoever.

Appreciate if anyone could point where to check on this.. Thank you in advance!

I'd like to use this on 1.5.5e. Is it compatible?

Quote:

---

Originally Posted by redpeach

I'd like to use this on 1.5.5e. Is it compatible?

---

Yes and no. It is not compatible out of the box, it has some minor issues. Yes as in you can make it work by the patches posted in this thread.
Start by is post:
https://www.zen-cart.com/showthread....39#post1317639

i'm use zencart 1.5.1 and installed Reward Points Full Suite v2.5.
When i test to pay with paypal standard (it's go paypal site and return). I can see the reward point in checkout page but after payment, no points pending or earned.
but if i test to pay with Western Union (it's not go the third part site). all works well, i can see points pending, then earned after delivery.
need kindly help! thanks you very much.

Known issue. This is more or less abandonware.
Read my previous post, which is right before your post for details and workarounds.

Quote:

---

Originally Posted by coldfire0078

i'm use zencart 1.5.1 and installed Reward Points Full Suite v2.5.
When i test to pay with paypal standard (it's go paypal site and return). I can see the reward point in checkout page but after payment, no points pending or earned.
but if i test to pay with Western Union (it's not go the third part site). all works well, i can see points pending, then earned after delivery.
need kindly help! thanks you very much.

---

Quote:

---

Originally Posted by chibipaw

Known issue. This is more or less abandonware.
Read my previous post, which is right before your post for details and workarounds.

---

Thank you very much for your reply, this is a big problem that bother me a long time, in the previous post, I did not find a solution to this problem. I would like to ask if you can give me a hint. Thanks again.

Quote:

---

Originally Posted by chibipaw

Known issue. This is more or less abandonware.
Read my previous post, which is right before your post for details and workarounds.

---

Thank you very much for your reply, this is a big problem that bother me a long time, in the previous post, I did not find a solution to this problem. I would like to ask if you can give me a hint. Thanks again.

The solution is spelled out in detail.
here is the link again. You should read the thread carefully starting from that point as I have said in my previous post and it span multiple pages. If you didnt find the discussion of the problem and solution, you didnt read thoroughly enough.
https://www.zen-cart.com/showthread....39#post1317639

Quote:

---

Originally Posted by coldfire0078

Thank you very much for your reply, this is a big problem that bother me a long time, in the previous post, I did not find a solution to this problem. I would like to ask if you can give me a hint. Thanks again.

---

Quote:

---

Originally Posted by chibipaw

The solution is spelled out in detail.
here is the link again. You should read the thread carefully starting from that point as I have said in my previous post and it span multiple pages. If you didnt find the discussion of the problem and solution, you didnt read thoroughly enough.
https://www.zen-cart.com/showthread....39#post1317639

---

I change the includes/modules/order_toral/ot_rewards_points.php around line 122
zen_draw_hidden_field('redeem_checkout_flag',true) to zen_draw_hidden_field('redeem_checkout_flag',1), but still not working.
am i do it right?

I change the includes/modules/order_toral/ot_rewards_points.php around line 122
zen_draw_hidden_field('redeem_checkout_flag',true) to zen_draw_hidden_field('redeem_checkout_flag',1), but still not working.
am i do it right?
If i test to pay with Western Union (it's not go the third part site). all works well, i can see points pending, then earned after delivery. but pay with paypal standard still not working.

Never tested with PayPal, etc, but I'm going to need to get this working with it.
Quite a pity that this module is abandoned.
Can you explain more specifically what happens with PayPal payment. I never use it, so don't even know what the rewards points module should do, or even, if was working in previous zc versions.

So, when a customer pays with PayPal , what happens to the points? They get lost ?

Well... there's an old post that says that this module never worked with PayPal standard, but it seems to work with express
https://www.zen-cart.com/showthread....33#post1289733

Quote:

---

Originally Posted by mesnitu

Well... there's an old post that says that this module never worked with PayPal standard, but it seems to work with express
https://www.zen-cart.com/showthread....33#post1289733

---

Thank you for your reply, Is The lastest version still not work with paypal standard? Is anybody use paypal standard with Reward Points and works well?

I don't know why you are still using standard - the point is that express has been the best choice for years - and costs you nothing extra. Just switch and quit agonizing. This module is not abandoned - just no one has written up and packaged the few changes needed at this point. I have a customer who will be upgrading to 1.5.5f soon so I will either post all changes needed in one post or else update the mod. I do not want to become responsible for it tho - that is why things don't get packaged. I'm not enough of a coder to maintain this. Anyone else want to join forces with me?

I just installed this and on admin I don't see a way to configure this. I am using php 1.5.5 also am I supposed to upload the init_zc154_compatibility?

Do you get any log errors ?

What logs? zencart or server? I will check

zencart log folder

Where is zencart logs? Another note the MYSQL needs to be updated; I did the following: This makes it so goes to MyIsam engine and utf8 collate

PHP Code:

---

CREATE TABLE reward_master (
rewards_products_id int(11) NOT NULL auto_increment,
scope int(1) NOT NULL DEFAULT '0',
scope_id int(11) NOT NULL DEFAULT '0',
point_ratio double(15,4) NOT NULL DEFAULT '1',
bonus_points double(15,4) NULL,
redeem_ratio double(15,4) NULL,
redeem_points double(15,4) NULL,
UNIQUE unique_id (scope , scope_id),
PRIMARY KEY (rewards_products_id)
) ENGINE=MyISAM DEFAULT COLLATE utf8_general_ci; 


---

You'll fing your /logs folder at the root of your site.

Nothing there but index.php and index.html

Ok now I see it had to enter it manually on phpmyadmin. This module needs to be updated; the following needs to be done

In includes/modules/order_total/ot_reward_points.php, ot_reward_points_discount.php, ot_reward_points_display
the functions needs to be changed for example

change

PHP Code:

---

function ot_reward_points() 
    { 


---

to this:

PHP Code:

---

function __construct() { 


---

All those files mentioned above; also like I mentioned the mysql needs to be updated. Which I will upload when I complete that. also the zc_154 init files I dont think needed

I am going to submit a new version but here is an updated mysql

PHP Code:

---

CREATE TABLE reward_master (
rewards_products_id int(11) NOT NULL auto_increment,
scope int(1) NOT NULL DEFAULT '0',
scope_id int(11) NOT NULL DEFAULT '0',
point_ratio double(15,4) NOT NULL DEFAULT '1',
bonus_points double(15,4) NULL,
redeem_ratio double(15,4) NULL,
redeem_points double(15,4) NULL,
UNIQUE unique_id (scope , scope_id),
PRIMARY KEY (rewards_products_id)
) ENGINE=MyISAM DEFAULT COLLATE utf8_general_ci;

INSERT INTO reward_master (rewards_products_id , scope , scope_id , point_ratio , bonus_points, redeem_ratio, redeem_points)
VALUES (NULL , '0', '0', '1.0000', NULL, 0.01, NULL);

CREATE TABLE reward_customer_points (
customers_id int(11) NOT NULL,
reward_points double(15,4) NOT NULL DEFAULT '0',
pending_points double(15,4) NOT NULL DEFAULT '0',
PRIMARY KEY (customers_id)
) ENGINE=MyISAM DEFAULT COLLATE utf8_general_ci;


CREATE TABLE reward_status_track (
rewards_id int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL ,
orders_id int(11) NOT NULL ,
date DATETIME NOT NULL ,
reward_points double(15,4) NOT NULL ,
status tinyint(1) NOT NULL,
UNIQUE (orders_id),
PRIMARY KEY (rewards_id)
) ENGINE=MyISAM DEFAULT COLLATE utf8_general_ci;

SELECT @groupid:=configuration_group_id FROM configuration_group
WHERE configuration_group_title= 'Reward Points';
DELETE FROM configuration WHERE configuration_group_id = @groupid  AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @groupid AND configuration_group_id != 0;


INSERT INTO configuration_group VALUES (NULL , 'Reward Points', 'Reward Point Module Configuration', '50' , '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SELECT @cgi:=configuration_group_id FROM configuration_group WHERE configuration_group_title = 'Reward Points';

INSERT 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 , 'Reward Point Mode', 'REWARD_POINT_MODE', '0', 'Select the Reward Point Mode<br />0= Reward Points are fixed to the product prices and are calculated individually.<br />1= Reward Points are calculated on the Order Total or Subtotal (depending on the setting of the <strong>Allow Redeem of Reward Points on Order Total or Subtotal</strong> configuration).', @cgi, '0', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');

INSERT 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 , 'Reward Point Sidebox Display', 'SHOW_REWARD_POINTS_BOX_OPTION', '0', 'Display Reward Points Sidebox<br />0= Always<br />1= Only when logged in<br />2= Only when logged in and has points', @cgi, '1', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1'', ''2''), ');

INSERT 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 , 'Reward Point Status Track', 'REWARD_POINTS_STATUS_TRACK', '', '<b>Simple mode:</b> All new reward points are set to Pending and are changed to Earned when the Order Status changes. If the Order Status is then changed back to Pending then the reward points are transfered back from Earned.<br /><br /><b>Advanced mode:</b> Allows you to select the order status that will trigger a transfer of reward points from pending to earned. Points are transferred when the status changes between status items set to "Pending" and status items set to "Earned". Status items set to "Ignore" will have no effect on Order Status changes to it.', @cgi, '2', NULL, now(), 'UseRewardPointStateFunction' , 'SetRewardPointStateFunction(');

INSERT 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 , 'Reward Point Sunrise Period', 'REWARD_POINTS_SUNRISE_PERIOD', '0', 'The number of days after which points pending become points earned. Set to 0 for no sunrise period.', @cgi, '3', NULL, now(), NULL , NULL);

INSERT 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 , 'Reward Point Redeem Minimum', 'REWARD_POINTS_REDEEM_MINIMUM', '0', 'This is the minimum amount of earned points needed before they can be redeemed.', @cgi, '3', NULL, now(), NULL , NULL);

INSERT 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 , 'Reward Point Redeem Maximum', 'REWARD_POINTS_REDEEM_MAXIMUM', '0', 'This is the maximum amount of earned points that can be redeemed against a single order.<br /><i>Note: this can be a absolute value (eg 1000) or a percentage (20%).</i>', @cgi, '4', NULL, now(), NULL , NULL);

INSERT 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 , 'Reward Point Rounding', 'REWARD_POINTS_ROUNDING', '0.0', '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)', @cgi, '5', NULL, now(), NULL , NULL);

INSERT 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 , 'Max Transactions to Display in Customer Admin', 'REWARD_POINTS_MAX_TRANSACTIONS', '12', 'Select the maximum number of records to show on the Pending Reward Points table in Customer Reward Point administration.', @cgi, '6', NULL, now(), NULL , NULL);

INSERT 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 , 'Delete Old Reward Transactions Period', 'REWARD_POINTS_HOUSEKEEPING', '90', '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.', @cgi, '7', NULL, now(), NULL , NULL);

INSERT 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 , 'Adjust Reward Points for Sales/Specials', 'REWARD_POINTS_SPECIAL_ADJUST', '0', 'How to calculate Reward Points<br />0= Always use the base price.<br />1= Use price less Discounts and Specials.', @cgi, '7', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');

INSERT 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 Reward Points on Free Products', 'REWARD_POINTS_ALLOW_ON_FREE', '0', 'Set how points are rewarded for free products.<br />0= Free products give 0 Reward Points.<br />1= Allow Reward Points on free products.', @cgi, '8', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');

INSERT 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.', @cgi, '9', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');

INSERT 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 , 'Set Minimum Order Value to Redeem Points Against', 'REWARD_POINTS_MINIMUM_VALUE', '0', 'Set the minimum value that the order should be in order for it to qualify for reward point redeem.', @cgi, '10', NULL, now(), NULL , NULL);

INSERT 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 , 'Limit Maximum Customers on Listings', 'REWARD_POINTS_CUSTOMER_LIMIT', '50', 'Set the maximum number of records to appear on each page under Customer Reward Point administration page.', @cgi, '11', NULL, now(), NULL , NULL);

INSERT 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 , 'Display Products Reward Points When Zero', 'REWARD_POINTS_ALWAYS_DISPLAY', '1', 'Set whether a products reward points are displayed when zero.<br />0= Don\'t display 0 Reward Points.<br />1= Always display reward points even when zero.', @cgi, '12', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');

INSERT 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 , 'Set New Account Reward Points', 'REWARD_POINTS_NEW_ACCOUNT_REWARD', '0', 'Set the amount of points awarded to a customer when an account is created. The points can either be added to \'Earned\' which will allow the customer to redeem the points straight away; Or the points can be added to \'Pending\' in which case the customer will receive the points after their first successful order.', @cgi, '13', NULL, now(), 'UseRewardPointNewAccountAwardFunction' , 'SetRewardPointNewAccountAwardFunction(');

INSERT 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, 'Advanced Reward Point Calculation Rules', 'REWARD_POINTS_ADVANCED_CALCULATE_TABLE', '-ot_gv,-ot_coupon', 'Advanced configuration of Reward Point calculations. This will be the figure that total Reward Points are adjusted by. This also affects the maximum value that any points can be redeemed against.', @cgi, '14', NULL, now(), 'UseRewardPointAdvancedCalculateTableFunction', 'SetRewardPointAdvancedCalculateTableFunction(');

INSERT 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 , 'Show Reward Points on Product Info Display Page', 'SHOW_REWARD_POINTS_PRODUCT', '0', 'Display Reward Points on product info display page?<br />0= No<br />1= Yes', @cgi, '1', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');


/*
zencart 1.5 mods
*/

INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configRewardPoints','BOX_CONFIGURATION_REWARD_POINTS','FILENAME_CONFIGURATION',CONCAT('gID=',@cgi), 'configuration', 'Y', @cgi);  
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('GroupRewardRedeem', 'BOX_GROUP_REWARD_POINTS_REDEEM', 'FILENAME_ADMIN_GROUP_REWARD_POINTS_REDEEM', '', 'customers', 'Y', 35); 
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('RewardPoints', 'BOX_REWARD_POINTS', 'FILENAME_ADMIN_REWARD_POINTS', '', 'catalog', 'Y', 36); 
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('CustomerRewardPoints', 'BOX_CUSTOMER_REWARD_POINTS', 'FILENAME_ADMIN_CUSTOMER_REWARD_POINTS', '', 'customers', 'Y', 37); 


---

I am going to upload a new version for this.

Great!
That's for sure, this module needs to be updated.
I do remember having issues on module upgrade, I had to completely remove and then install.
But I have this working on the latest zc version with PHP 7.1.... or at least I think I have this working.
Tomorrow I'll test some more.

I am going to test this today. So far changed the MYSQL statements and those class functions to __construct.

A bug?

You cant enable both ot_reward_points and ot_reward_points_discount.

this line in ot_reward_points module:

PHP Code:

---

$ot_module=DIR_FS_CATALOG_MODULES.'order_total/'."ot_reward_points_discount.php";
        if(file_exists($ot_module))
        {
            include($ot_module);
            $module=new ot_reward_points_discount;
            $module->remove(); 


---

I think is wrong as it should be ot_reward_points correct?

Anyone have fix for One Page Checkout for this? Can someone explain why this code is needed? Since you can't enable both it seems on 1.5.5

PHP Code:

---

$ot_module=DIR_FS_CATALOG_MODULES.'order_total/'."ot_reward_points_discount.php";
        if(file_exists($ot_module))
        {
            include($ot_module);
            $module=new ot_reward_points_discount;
            $module->remove();
        }
    } 


---

have you try this:
#post1313855

I do remember that something is mentioned on the One page checkout support thread

No I didn't try that but here is what I was told but don't know what to do with it:

hanks I see that now; quick question it says to add this code in ot_reward_points.php after function collect_posts

PHP Code:

PHP Code:

PHP Code:

---

if (isset($_SESSION['redeem_flag']) && $_SESSION['redeem_flag']) 
            $_POST['redeem_flag'] = $_SESSION['redeem_flag']; 


---

Here is the code in that function. Do I need to replace this code with one above? instead of request it's supposed to be session?

PHP Code:

PHP Code:

---

function collect_posts()  
    { 
        if($_REQUEST['redeem_checkout_flag']) 
         if((isset($_REQUEST['redeem_flag']) && $_REQUEST['redeem_flag']) || (isset($_REQUEST['redeem_points']) && $_REQUEST['redeem_points']>0)) 
         { 
            $_SESSION['redeem_points']=$this->get_points_redeeming(); 
            $_SESSION['redeem_value']=$_SESSION['redeem_points']*GetRedeemRatio($_SESSION['customer_id']); 
         } 
         else 
          $this->clear_posts(); 
    } 


---

tmccaff what version of php are you testing this on? Should work on 7 as 1.5.5f is designed for 7 and PCI certified only on php7

@delia thanks for responding. PHP 7.1 to my understanding you need to change some of the code to work with one page but not sure how or where to change this.

Also I think there is a bug if you enable rewards_points or rewards_points_discounts not both can be enabled just one. Not sure if that's a bug or what.

so you are not on php 7. Rats. Other than that bug, you have it working in zc 1.5.5?

I am going through the code piece by piece I hope to tnt.

Quote:

---

Originally Posted by tmccaff

I am going to upload a new version for this.

---

I never got around to update the package since the fix from Sep 2016 page #202 for making it work on 1.5.5e
If you haven't already done so, Im going to load that minor updated package so people dont have to hack it to work.
I've named it 2.5f so perhaps your might be 2.5g to avoid confusion? I assume yours is with that the fix along with other updates I've notice you've been talking about. I haven't implemented any of that yet, as I do not use single page checkouts.

Also, I've tested my version of the Rewards Points 2.5f over PHP 5.6, PHP 7.1, MySQL 5.7.17, MariaDB 20.1.16, MariaDB 10.2.11. I've pretty much
migrated everything over to MariaDB since its like the party of OpenOffice to LibreOffice.


ChibiPaw

thanks!! Will test as soon as it becomes available.

Not certain if it's the install or the particular cart I'm working on but I thought I would share... Zen Cart 1.55f, Reward Point Full Suite 2.5f

After installing the newest rewards module 2.5f, running the SQL for a new install this particular sql update created a mismatch between the configuration menu and the actual configuration_group_id

The menu was posting gID=36 while the actual entry was set for configuration_group_id = 63

This prevented the entire admin -> configuration menu -> Reward Point Configuration from loading. No errors, no sign of what or why until I hovered over the menu link and noticed the ID error.

I sourced it back to this line of the SQL file:
/*
zencart 1.5 mods
*/

INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order ) VALUES ('configRewardPoints','BOX_CONFIGURATION_REWARD_POINTS','FILENAME_CONFIGURATION' ,CONCAT('gID=',@cgi), 'configuration', 'Y', @cgi);


Which also relates to this:
SELECT @groupid:=configuration_group_id FROM configuration_group
WHERE configuration_group_title= 'Reward Points';
DELETE FROM configuration WHERE configuration_group_id = @groupid AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @groupid AND configuration_group_id != 0;

INSERT INTO configuration_group VALUES (NULL , 'Reward Points', 'Reward Point Module Configuration', '50' , '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SELECT @cgi:=configuration_group_id FROM configuration_group WHERE configuration_group_title = 'Reward Points';


The problem:
It seems @cgi picked up the wrong ID then rolled with it.


The fix:
I changed the db entry in admin_pages -> page_key -> configRewardPoints -> page_params -> gID=36 to gID=63

All is well now!

Don't have that issue here. Might be just your installation.

Quote:

---

Originally Posted by chibipaw

Don't have that issue here. Might be just your installation.

---

I agree. There's a chance an old version was installed or that the SQL updates got interrupted causing the incorrect counter.

Hey everyone - I just noticed something that may be an easy fix, but I can't figure out why.

I thought that reward points were based on the Master Category ID of the product, and it would ignore anything else?

For example, I have a product that is in multiple categories. The Master Category is point eligible (set at 0.005).......but it also linked to a sub category that isn't point eligible. This is somehow overriding things and making it so that the product isn't eligible for points.

I thought the code used the main Master Category to determine the point status. If not, is there anyway around this? Perhaps finding a part of the code to only look at the Master ID and not any sub category?

Quote:

---

Originally Posted by coldfire0078

i'm use zencart 1.5.1 and installed Reward Points Full Suite v2.5.
When i test to pay with paypal standard (it's go paypal site and return). I can see the reward point in checkout page but after payment, no points pending or earned.
but if i test to pay with Western Union (it's not go the third part site). all works well, i can see points pending, then earned after delivery.
need kindly help! thanks you very much.

---

Known issue with PayPal. No known fix as far as I know.
But you might want to read the the older post about it on this thread.

Quote:

---

Originally Posted by Jeff_Mash

Hey everyone - I just noticed something that may be an easy fix, but I can't figure out why.

I thought that reward points were based on the Master Category ID of the product, and it would ignore anything else?

For example, I have a product that is in multiple categories. The Master Category is point eligible (set at 0.005).......but it also linked to a sub category that isn't point eligible. This is somehow overriding things and making it so that the product isn't eligible for points.

I thought the code used the main Master Category to determine the point status. If not, is there anyway around this? Perhaps finding a part of the code to only look at the Master ID and not any sub category?

---

Nevermind this question. I figured it out. :)

Quote:

---

Originally Posted by Jeff_Mash

Nevermind this question. I figured it out. :)

---

Care to share so others can benefit?

There is a scope for products. So you could set a single product to have different points than the master category

Hello and thank you for looking into updating this mod.

I've downloaded the latest version, and two things are not working, taxes and the manual Point Redeem Method. Whenever I set to redeem the points in manual mode the value of reward points which should display in checkout_confirmation disappears completely and no deduction is ever taking place.

Taxes are also not being calculated correctly. Taxes should be calculated after any discounts and deductions, but reward points are not eve considered for this calculation.

I have no clue where to begin to figure these two issues out. Any ideas?

At checkout page, before confirm order I can see that points are calculated without taking into account "Use price less Discounts and Specials" setting.

Do you all have this problem ?

ZC 1.5.5 + Reward Points Full Suite v2.5b

Hi All,

I am running with Zen v1.5.5f and Reward Points 2.5f.

I noticed a problem whilst running the sql. It appears it WONT work if you have a prefix (example zen_) and the "install sql" doesn't give a reason just an error has occurred please refresh your page.

I have sorted my error simply by removing the prefix as it wasn't needed anymore. If you do do this don't forget to amend config.php!!

P.s. Thanks for the plugin, it has worked fine for me since v1.5.1 and is time for updates again.

Regards

Is there any known way to hack this mod, i mean for customers without earned points to somehow get discount using reward point? I have an order placed by guest customer and reward points were applied to the order, the problem is i can not find that customer in the database by searching the orders using the customer information.

Another question, what information used by zen cart to lookup if this customer has reward points earned when the customer is a guest?

Quote:

---

Originally Posted by TamyA

Is there any known way to hack this mod, i mean for customers without earned points to somehow get discount using reward point? I have an order placed by guest customer and reward points were applied to the order, the problem is i can not find that customer in the database by searching the orders using the customer information.

Another question, what information used by zen cart to lookup if this customer has reward points earned when the customer is a guest?

---

There are several things that come to mind, but I'd be mostly guessing without the answers to the posting tips. Your version, PHP version, and a link are needed. If an upgrade was done recently, how? Auto-updaters can be a part of the problem. What are your session settings in the admin?

Quote:

---

Originally Posted by dbltoe

There are several things that come to mind, but I'd be mostly guessing without the answers to the posting tips. Your version, PHP version, and a link are needed. If an upgrade was done recently, how? Auto-updaters can be a part of the problem. What are your session settings in the admin?

---

Sorry for the delay in responding to your questions, and here it goes.

Sessions

Title	Value
Session Directory	/home/acctname/public_html/cache
Cookie Domain	True
Force Cookie Use	True
Check SSL Session ID	False
Check User Agent	False
Check IP Address	False
Prevent Spider Sessions	False
Recreate Session	False
IP to Host Conversion Status	true
Use root path for cookie path	False
Add period prefix to cookie domain	True

PHP Version 7.1.21


This was installed over a fresh Zen Cart v1.5.5f

One last thing that does not make since is the following:
https://www.discounthomeoffice.com/b...ixel_trans.gif

Sub-Total:	$759.05
Free Shipping:	$0.00
Sales Tax :	$0.00
Value of Redeemed Reward Points:	$34.34
Total:	$724.71
Reward Points earned:	$0.00

this customer never ordered from us before and the redeemed point is calculated wrong based on 0.01 for each point and should be

Reward Points

Title	Value
Reward Point Mode	1
Reward Point Sidebox Display	2
Show Reward Points on Product Info Display Page	1
Reward Point Status Track	Pend: [Pending, Processing, Update, Canceled, Charged, Partial Shipment, Back Order, PO Shipped, PO PAID, PO Accepted, Google New, Google Processing, Google Digital Processed, Google Shipped, Google Refunded, Google Shipped and Refunded, Google Canceled, Collection and Reporting] Earn: [Shipped]
Reward Point Sunrise Period	6
Reward Point Redeem Minimum	2
Reward Point Redeem Maximum	0
Reward Point Rounding	0.0
Max Transactions to Display in Customer Admin	12
Delete Old Reward Transactions Period	120
Adjust Reward Points for Sales/Specials	1
Allow Reward Points on Free Products	0
Allow Redeem of Reward Points on Order Total or Subtotal	1
Set Minimum Order Value to Redeem Points Against	0
Limit Maximum Customers on Listings	50
Display Products Reward Points When Zero	0
Set New Account Reward Points	No points awarded for new accounts
Advanced Reward Point Calculation Rules	Advanced Rules Enabled

URL: https://bit.ly/2O7Nv3h

Submitted to the plugins - Reward Points 2.5g for Zen Cart 1.55f

- This version simply updates the core overwrite files to Zen Cart 1.55f while including the Reward Points code.
- And I cleaned up the version inconsistencies in the instructions.

[The previous Reward Point Full Suite v2.5f runs Zen Cart 1.54 core files.]



Help is here! - Future updates will be released as we trace the known issues listed in the forum because...

...Reward Points are headed for Twitch Wholesale integration :flex::clap:

I'm installing the latest download version of this module and I'm somewhat confused as to the references in in admin/orders.php to TABLE_HEADING_WHOLESALE_CUSTOMERS on line 835, o.customers_wholesale, line 842
There is nothing in the installer that adds this non standard field to the database, and doing a quick search of the module files, I can find no other reference to this field.

Is it an unintentional code block from another Twitch mod?

If it is an error in the module files, can I get a clean copy of the module files anywhere?

Quote:

---

Originally Posted by strelitzia

I'm installing the latest download version of this module and I'm somewhat confused as to the references in in admin/orders.php to TABLE_HEADING_WHOLESALE_CUSTOMERS on line 835, o.customers_wholesale, line 842
There is nothing in the installer that adds this non standard field to the database, and doing a quick search of the module files, I can find no other reference to this field.

Is it an unintentional code block from another Twitch mod?

If it is an error in the module files, can I get a clean copy of the module files anywhere?

---

My apologies!

I've submitted a 'cleaner' copy without the Twitch Wholesale code - double checked against a vanilla 1.55f (b) fileset.


strelitzia - You're welcome to email me directly and I'll send a copy immediately.

Quote:

---

Originally Posted by twitchtoo

strelitzia - You're welcome to email me directly and I'll send a copy immediately.

---

Email sent. Thanks

Quote:

---

Originally Posted by strelitzia

Email sent. Thanks

---

Check your snail mail :smile:

Reward Points Full Suite 2.5h for 1.55f has been submitted for approval

v2.5h - 01/07/2019 Updated By Twitch:

• Strelitza - Bug Reported - Twitch Wholesale code found in YOUR_ADMIN/orders.php:
• https://www.zen-cart.com/showthread....00#post1353100
• Reward Points 2.5h - Twitch Updated:
• Bugfix - Reset YOUR_ADMIN/orders.php in new install + upgrade fileset to 1.55f stock
• Version change updated in the installation instructions
• File naming standards enforced on directory names.

I've come across an issue with this module.
As the number of entries in reward_status_track table increases, loading the admin page takes longer and longer.
A site I just fixed had around 9700 entries, and admin was crashing every time I tried to load customers_reward_points.php
TTFB was in excess of 2 minutes!
I resolved this issue by applying an index to the database table like

ALTER TABLE `reward_status_track` ADD INDEX(`customers_id`);

Admin now loads instantly.
Please update your installer to include this index on the database table

Quote:

---

Originally Posted by strelitzia

I've come across an issue with this module.
As the number of entries in reward_status_track table increases, loading the admin page takes longer and longer.
A site I just fixed had around 9700 entries, and admin was crashing every time I tried to load customers_reward_points.php
TTFB was in excess of 2 minutes!
I resolved this issue by applying an index to the database table like

ALTER TABLE `reward_status_track` ADD INDEX(`customers_id`);

Admin now loads instantly.
Please update your installer to include this index on the database table

---

:bigups: got to check this

Is anyone working on updating for 1.5.6? Or has anyone tried this in 1.5.6?

Quote:

---

Originally Posted by jeking

Is anyone working on updating for 1.5.6? Or has anyone tried this in 1.5.6?

---

I've installed it to a 1.5.6a site. It's currently with the client for testing prior to go live. I haven't had any reports of issues with it so far

Quote:

---

Originally Posted by strelitzia

I've installed it to a 1.5.6a site. It's currently with the client for testing prior to go live. I haven't had any reports of issues with it so far

---

Good to know, thank you.

I have used this since a 1.5.6a upgrade and I had an issue similar to those in the past where the reward points were not being applied to the order total.

The fix contained in post 202 of this thread contains a fix and it has worked just fine for me.

Quote:

---

Originally Posted by strelitzia

I've come across an issue with this module.
As the number of entries in reward_status_track table increases, loading the admin page takes longer and longer.
A site I just fixed had around 9700 entries, and admin was crashing every time I tried to load customers_reward_points.php
TTFB was in excess of 2 minutes!
I resolved this issue by applying an index to the database table like

ALTER TABLE `reward_status_track` ADD INDEX(`customers_id`);

Admin now loads instantly.
Please update your installer to include this index on the database table

---

Where exactly do we do this? Should I use the Admin->Install SQL Patches or can I copy and past this into the Installation SQL in this area:

Code:

---

CREATE TABLE reward_status_track (
rewards_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
customers_id INT( 11 ) NOT NULL ,
orders_id INT( 11 ) NOT NULL ,
date DATETIME NOT NULL ,
reward_points DOUBLE( 15, 4 ) NOT NULL ,
status TINYINT( 1 ) NOT NULL,
UNIQUE (orders_id));
ALTER TABLE `reward_status_track` ADD INDEX(`customers_id`);

---

before I complete the installation or can I just stick it anywhere at the bottom of the page? Also, if I am to add it to the Installation SQL would I write it like this

Code:

---

ALTER TABLE reward_status_track ( ADD INDEX(customers_id));

---

or exactly as it is written above?

You just have to do it one time.
For example in phpmyadmin.
But I guess it can be done with Install SQL Patches also.

Perhaps someone will update the module to add this index upon installation.