Zen Cart Logo
Forums / All Other Contributions/Addons / Reward Points Module for ZC v13x

Reward Points Module for ZC v13x

Locked

Views: 470,646

Results 1,781 to 1,800 of 2,476
This thread is locked. New replies are disabled.
10 Apr 2011, 7:43 PM
#1781
picturemom avatar

picturemom

New Zenner

Join Date:
Feb 2011
Posts:
11
Plugin Contributions:
0

Reward Points Module for ZC v13x

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.

10 Apr 2011, 10:04 PM
#1782
retched avatar

retched

Totally Zenned

Join Date:
Jun 2007
Location:
Bronx, New York, United States
Posts:
943
Plugin Contributions:
3

Re: Reward Points Module for ZC v13x

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

21 Apr 2011, 10:37 PM
#1783
willie_bee avatar

willie_bee

Zen Follower

Join Date:
Mar 2011
Posts:
386
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

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?

22 Apr 2011, 12:15 AM
#1784
retched avatar

retched

Totally Zenned

Join Date:
Jun 2007
Location:
Bronx, New York, United States
Posts:
943
Plugin Contributions:
3

Re: Reward Points Module for ZC v13x

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

22 Apr 2011, 4:29 AM
#1785
willie_bee avatar

willie_bee

Zen Follower

Join Date:
Mar 2011
Posts:
386
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

retched:

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

You would think but no.

22 Apr 2011, 5:24 AM
#1786
athens_collectibles avatar

athens_collectibles

Zen Follower

Join Date:
May 2010
Location:
Athens, Greece
Posts:
293
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

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!

22 Apr 2011, 5:55 AM
#1787
willie_bee avatar

willie_bee

Zen Follower

Join Date:
Mar 2011
Posts:
386
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

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.

22 Apr 2011, 7:31 AM
#1788
athens_collectibles avatar

athens_collectibles

Zen Follower

Join Date:
May 2010
Location:
Athens, Greece
Posts:
293
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

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.

22 Apr 2011, 9:11 PM
#1789
hem avatar

hem

Totally Zenned

Join Date:
Sep 2007
Location:
Dublin, Ireland
Posts:
1,281
Plugin Contributions:
5

Re: Reward Points Module for ZC v13x

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

23 Apr 2011, 5:45 AM
#1790
athens_collectibles avatar

athens_collectibles

Zen Follower

Join Date:
May 2010
Location:
Athens, Greece
Posts:
293
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

Welcome back to the forums Andrew! :D

28 Apr 2011, 12:14 AM
#1791
willie_bee avatar

willie_bee

Zen Follower

Join Date:
Mar 2011
Posts:
386
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

hem:

Noted and added to the todo list for v1.50

honey do's. DO IT! :D

28 Apr 2011, 12:18 AM
#1792
willie_bee avatar

willie_bee

Zen Follower

Join Date:
Mar 2011
Posts:
386
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

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.

28 Apr 2011, 12:19 AM
#1793
willie_bee avatar

willie_bee

Zen Follower

Join Date:
Mar 2011
Posts:
386
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

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.

30 Apr 2011, 9:18 PM
#1794
bumba000 avatar

bumba000

Totally Zenned

Join Date:
Feb 2007
Location:
Pennsylvania
Posts:
856
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

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

30 Apr 2011, 10:27 PM
#1795
bumba000 avatar

bumba000

Totally Zenned

Join Date:
Feb 2007
Location:
Pennsylvania
Posts:
856
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

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. . . 
1 May 2011, 2:38 AM
#1796
bumba000 avatar

bumba000

Totally Zenned

Join Date:
Feb 2007
Location:
Pennsylvania
Posts:
856
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

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);}
        }}}
}
3 May 2011, 11:10 PM
#1797
nolsowski avatar

nolsowski

Inactive

Join Date:
Aug 2010
Posts:
324
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

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!

4 May 2011, 7:19 AM
#1798
athens_collectibles avatar

athens_collectibles

Zen Follower

Join Date:
May 2010
Location:
Athens, Greece
Posts:
293
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

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.

4 May 2011, 12:46 PM
#1799
nolsowski avatar

nolsowski

Inactive

Join Date:
Aug 2010
Posts:
324
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

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!

4 May 2011, 4:07 PM
#1800
nolsowski avatar

nolsowski

Inactive

Join Date:
Aug 2010
Posts:
324
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

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