Reward Points Module for ZC v13x

[willie bee]

Noted and added to the todo list for v1.50

honey do's. DO IT!

[willie bee]

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.

[willie bee]

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.

[bumba000]

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

[bumba000]

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

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

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

[bumba000]

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.

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

[nolsowski]

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!

[Athens Collectibles]

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.

[nolsowski]

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!

[nolsowski]

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!