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

@gigi3, may I suggest that you open a new thread (Reward Points+Edit Orders, or another title to your choosing) so we don't hijack this support thread discussing possibilities?

It will "help" to know your Zen Cart, Edit Orders and Reward Points version in formulating any change-suggestion.

Thank you. I have done so. See: https://www.zen-cart.com/showthread.php?220257-Reward-Points-Edit-Orders-Admin-New-Order

My client does not update order status so we needed to find a way to award points when orders are placed. I set the completed order status of each payment module to Completed (renamed from Shipping of orders_status_id=3). The Reward Point Sunrise Period is set to zero.

I expected this would award the points as orders are placed. The order status for orders is showing up as 'Completed' but the their points as still Pending.

What did I misunderstand so I can get the desired result?

Hi
Is this working on zc155 ?
I've made a new intalation and a upgrade to the database from the reward previous version.
I've already put the site online since I had no log reports about this but:

The points are added and subtratect from the customer account, but on checkout, they have no effect on the total order.
And also, in the Set New Account Reward Points , I have them config to add to pending. But after a customer makes a purchase, they don't go anyware.

In the reward points configuration I have this jscritp error :
configuration.php?gID=41&cID=816&action=edit:415 Uncaught TypeError: Cannot read property 'length' of undefined

And in the advanced rules, sometimes I have e t_total.php (? didn't had this in v151) with a action to add....
There also the ot_shipping that I can't set ... I click update, but nothing.
So I have this options:

<select rel="dropdown" name="moduleField">
<option value="ot_cod_fee">ot_cod_fee</option>
<option value="ot_coupon">ot_coupon</option>
<option value="ot_group_pricing">ot_group_pricing</option>
<option value="ot_gv">ot_gv</option>
<option value="ot_loworderfee">ot_loworderfee</option>
<option value="ot_shipping">ot_shipping</option>
<option value="ot_tax">ot_tax</option>
</select>

Why that t_total.php cames up....or when, I still didn't get it....

....the ot_total should be here, right ?

Thanks

About the configuration.php?gID=41&cID=816&action=edit:415 Uncaught TypeError: Cannot read property 'length' of undefined
Forget about this, I got this all over the place, and it's from a js that it's counting the chars in the metatag description, but should only run in there.

Checking the GetRewardPointAdvancedCalculateTable and the SetRewardPointAdvancedCalculateTableFunction , something is wrong here

If I choose the ot_shipping I guess it's related to the ot_total (?) , since when I click update ( with subtract) , it add the ot_total (but with the action add ) ....

But as you can see in the SetRewardPointAdvancedCalculateTableFunction it's setting a t_total.php .... maybe this is the issue ?
But related to what ? jscript ?
Still didn't find out

GetRewardPointAdvancedCalculateTable
Array
(
[0] => ot_total.php
)

SetRewardPointAdvancedCalculateTableFunction
Array
(
[0] => Array
(
[module] => t_total.php
[action] => Add
)

)

Well, after some digging I reach no were.

I've already uninstall the sql, and install it again, since I've done a upgrade...nothing.

The t_total -> Probably the list explode is not wright, but the ot_total is on the ignore list...so not sure why is here.

Changing the redem_points from manual to automatic, makes no difference, it simple doesn't do nothing to the total or sub_total amounts.

I'm not sure if this [redeem_checkout_flag] => should be set to 1 after the checkout_payment , but on checkout_confirmation it's empty

Array
(
[securityToken] => 3906a7a995203c0f60ddcbe065940b6c
[action] => submit
[dc_redeem_code] =>
[redeem_points] => 365
[redeem_checkout_flag] =>
[payment] => eustandardtransfer
[comments] =>
)

But I can find no errors here :

 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',true);
			  else
			   $prompt =zen_draw_input_field('redeem_points',$_SESSION['redeem_points']).' '.zen_draw_hidden_field('redeem_checkout_flag',true);

The customer loses his points and earns new ones on checkout... but it doesn't reflect on the total ....
Must disable this until I find something, or I get into troubles.

A last clue :

in a zc151 :
($_REQUEST)
Array (
[main_page] => checkout_confirmation
[securityToken] => 332bc18f56cb21482a0c5bb28243620f
[action] => submit
[dc_redeem_code] =>
[redeem_points] => 100
[redeem_checkout_flag] => 1
[payment] => eustandardtransfer
[comments] => )

In zc155 :
Array
(
[main_page] => checkout_confirmation
[securityToken] => 3906a7a995203c0f60ddcbe065940b6c
[action] => submit
[dc_redeem_code] =>
[redeem_points] => 100
[redeem_checkout_flag] =>
[payment] => eustandardtransfer
[comments] =>
)

And in the SESSION values :
zc151:
[REWARD_POINTS_EARNED] => 75
[comments] =>
[redeem_points] => 100
[redeem_value] => 1

zc155:
[REWARD_POINTS_EARNED] => 134
[comments] =>

...so I getting closer.

In zc155 ( at least I'm the only one complaining until now ( could be a karma thing) )
I can get this to work if I change in modules/order_total/ot_reward_points.php this:

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',true);
			  else
			   $prompt=zen_draw_input_field('redeem_points',$_SESSION['redeem_points']).' '.zen_draw_hidden_field('redeem_checkout_flag',true);

To this :

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',true);
			  else
$prompt=zen_draw_input_field('redeem_points',isset($_SESSION['redeem_points'])).' '.zen_draw_hidden_field('redeem_checkout_flag',true);

Even so, only setting the zen_draw_hidden_field('redeem_checkout_flag',1) I get the [redeem_checkout_flag] => 1

So, now it's making the calculations, etc..

About the Advanced Reward Point Calculation Rules, still didn't find a solution...but for this case, or my case, it's not a priority

jeking:

My client does not update order status so we needed to find a way to award points when orders are placed. I set the completed order status of each payment module to Completed (renamed from Shipping of orders_status_id=3). The Reward Point Sunrise Period is set to zero.

I expected this would award the points as orders are placed. The order status for orders is showing up as 'Completed' but the their points as still Pending.

What did I misunderstand so I can get the desired result?

Well, I don't have this working either but in a different situation: the reward points given to the customer on registration do not pass to earn after the first purchase.

But in your case, have your try to change Reward Point Status Track from simple to advanced, and applied the earning at the pending state ?

mesnitu:

Well, I don't have this working either but in a different situation: the reward points given to the customer on registration do not pass to earn after the first purchase.

But in your case, have your try to change Reward Point Status Track from simple to advanced, and applied the earning at the pending state ?

Thanks for the suggestion. I had tried that without success. This is a 1.5.4 store, FYI. I ended up modifying the plugin code to get the points 'earned'.

jeking:

Thanks for the suggestion. I had tried that without success. This is a 1.5.4 store, FYI. I ended up modifying the plugin code to get the points 'earned'.

Cool !
I end up changing the code also to transfer the points added on new account on the first purchase...since it was not processing this stuff....
Haven't check the sunrise period, but anyway I'm not using that either.
So on rewards admin extra functions I've changed this function... not sure if it's the best way, the smarter way, or if the script does this, but I can't find that piece of code anywere:

This is not entirely tested, got to go and watch the game against Croatia, but perhaps someone has a better idea...or something.

About the javascript in zc155, there are places where nothing works, others were it's ok.

function TransferCustomerPointsFromPending($order_id)
{
    global $messageStack, $db;

    if(($record=GetLastRewardPointHistoryRecord($order_id)) && $record->fields['status']==STATUS_PENDING)
    {
         
        $customer_id=$record->fields['customers_id'];
        $reward_points=$record->fields['reward_points'];
        $pending_points=-$reward_points;
        
        UpdateCustomerRewardPoints($customer_id,$reward_points,$pending_points);
        UpdateRewardPointHistoryRecord($customer_id,$order_id,$reward_points,STATUS_PROCESSED);
        
        $customer_pending_points = GetCustomersPendingPoints($customer_id);

        if ( ($customer_pending_points) == abs(REWARD_POINTS_NEW_ACCOUNT_REWARD) ) {
        
          $sql=$db->Execute("SELECT * FROM ".TABLE_REWARD_STATUS_TRACK." WHERE customers_id=".(int)$customer_id." and status =1");
          if ($sql->RecordCount() >= 1 ) {
              $updpoints = $reward_points + $customer_pending_points;
              $sql=$db->Execute("UPDATE ".TABLE_REWARD_CUSTOMER_POINTS." SET pending_points=0 ,reward_points=".$updpoints." WHERE customers_id=".(int)$customer_id." ");
             
          }
        }     
    }
    else
     if(!$record)
      $messageStack->add_session(WARNING_MISSING_RECORD.' '.$order_id, 'warning');
}

I must be the first one to use this Reward Points Full Suite v2.5 with ZC 1.5.5.a ? I don't find in any forums where anyone else is having this problem. When I change the screen to mobile mode, the Reward Points box which is normally set to be displayed in left-hand column stretches across the top of the entire screen, rather than disappearing as the other sideboxes do. I think I understand the problem ... the responsive_default.css controls displaying the sideboxes:

/* side-boxes /
/ ADD { display:none;visibility:hidden; } to Hide Side-Box /
/ LEAVE BLANK { } to Show Side-Box */
div#documentcategories {display:none;visibility:hidden;}
div#categories {display:none;visibility:hidden;}
div#whatsnew {display:none;visibility:hidden;}
div#manufacturers {display:none;visibility:hidden;}
div#reviews {display:none;visibility:hidden;}
div#featured {display:none;visibility:hidden;}
div#information {display:none;visibility:hidden;}
div#moreinformation {display:none;visibility:hidden;}

Since reward points box is a plug-in, the standard css file doesn't handle it. So I figured all I had to do was add the equivalent statement for the Reward Points box. But here is where I am puzzled ... I did a search for moreinformation in the entire structure of my installation and no where do I find the term moreinformation. So I don't understand how this works, and of course I don't know what term to add to the css file for the Reward Points box. Can someone help me ? Thanks.

wonged:

I must be the first one to use this Reward Points Full Suite v2.5 with ZC 1.5.5.a ? I don't find in any forums where anyone else is having this problem. When I change the screen to mobile mode, the Reward Points box which is normally set to be displayed in left-hand column stretches across the top of the entire screen, rather than disappearing as the other sideboxes do. I think I understand the problem ... the responsive_default.css controls displaying the sideboxes:

/* side-boxes /
/ ADD { display:none;visibility:hidden; } to Hide Side-Box /
/ LEAVE BLANK { } to Show Side-Box */
div#documentcategories {display:none;visibility:hidden;}
div#categories {display:none;visibility:hidden;}
div#whatsnew {display:none;visibility:hidden;}
div#manufacturers {display:none;visibility:hidden;}
div#reviews {display:none;visibility:hidden;}
div#featured {display:none;visibility:hidden;}
div#information {display:none;visibility:hidden;}
div#moreinformation {display:none;visibility:hidden;}

Since reward points box is a plug-in, the standard css file doesn't handle it. So I figured all I had to do was add the equivalent statement for the Reward Points box. But here is where I am puzzled ... I did a search for moreinformation in the entire structure of my installation and no where do I find the term moreinformation. So I don't understand how this works, and of course I don't know what term to add to the css file for the Reward Points box. Can someone help me ? Thanks.

I have this on two 1.5.5 carts, but not sure if we have the sidebox enabled. Can you share your site url?

jeking:

I have this on two 1.5.5 carts, but not sure if we have the sidebox enabled. Can you share your site url?

Here is the link for the test site I am working on.
http://www.gottahaveitnwi.com/shop_155/
When there, if you click the link to view in Mobile mode, or just shrink the width of the browser window, you will see the Reward Points box spread across the upper part of the window.

Under Tools>Layout Box Controller
what do you have for Single Column Status for the rewards points box?

My guess is ON. Try setting it to OFF.

jeking:

Under Tools>Layout Box Controller
what do you have for Single Column Status for the rewards points box?

My guess is ON. Try setting it to OFF.
Sorry to disappoint but that was too obvious :P
Here is how the Reward Points box is set:
Box Details:
Box Name: reward_points.php
Left/Right Column Status: ON
Location: (Single Column ignores this setting) LEFT
Left/Right Column Sort Order: 75
Single Column Sort Order: 0
Single Column Status: OFF

wonged:

Sorry to disappoint but that was too obvious :P
Here is how the Reward Points box is set:
Box Details:
Box Name: reward_points.php
Left/Right Column Status: ON
Location: (Single Column ignores this setting) LEFT
Left/Right Column Sort Order: 75
Single Column Sort Order: 0
Single Column Status: OFF

I always start with the most obvious things. But had I read your first post closer, I would known the answer right way.

add:
div#rewardpointsHeading {display:none;visibility:hidden;}
right below
div#moreinformation {display:none;visibility:hidden;}

in your responsive_default.css mentioned above.

jeking:

I always start with the most obvious things. But had I read your first post closer, I would known the answer right way.

add:
div#rewardpointsHeading {display:none;visibility:hidden;}
right below
div#moreinformation {display:none;visibility:hidden;}

in your responsive_default.css mentioned above.
Well, that didn't change anything, but since the other sideboxes didn't have **Heading **after them, I tried
div#**rewardpoints **{display:none;visibility:hidden;}
and that worked for when I shrink the browser window, but still see it when I click for mobile mode.
Also if I log-in, my shopping cart with reward points shows-up in the center now. Looks like I have to play more with the three responsive_xxx.css files. Seems like the trick is knowing what term to use for those two "custom" boxes :huh:

wonged:

Well, that didn't change anything, but since the other sideboxes didn't have **Heading **after them, I tried
div#**rewardpoints **{display:none;visibility:hidden;}
and that worked for when I shrink the browser window, but still see it when I click for mobile mode.
Also if I log-in, my shopping cart with reward points shows-up in the center now. Looks like I have to play more with the three responsive_xxx.css files. Seems like the trick is knowing what term to use for those two "custom" boxes :huh:

Yes, div#rewardpoints. You will need to follow the lead of the other sideboxes for your template when it comes to the responsive display as this box is not part of the default installation.