Reward Points Module for ZC v13x

Sailman:

I need all Reward Points to be posted automatically as Earned, without having order status changes, etc.
We will redeem the points off-line in a different manner. Using the Advanced/Order Status in the Admin doesn't change anything. All points still go to Pending and I must manually change them to Earned in Admin/Customers/Reward Points.

I have messed with some of the functions, but only succeeded in crashing it. Is there a place where a few lines of code will put all points in the cart automatically to Earned?

If you set the Sunrise Period to 0 this should do it.

The sunrise period is set to 0 and all selections in Admin/Advanced Order Status are set to "Earned", but I still must either change the order status or manually change them to Earned in Customers/Reward Points.

I was hoping there was a change to a couple of lines in one of the PHP pages that might write them all to Earned in the db.

Thanks for the response, and Happy New Year!

Sailman:

The sunrise period is set to 0 and all selections in Admin/Advanced Order Status are set to "Earned", but I still must either change the order status or manually change them to Earned in Customers/Reward Points.

I was hoping there was a change to a couple of lines in one of the PHP pages that might write them all to Earned in the db.

Thanks for the response, and Happy New Year!

if you go to "Your Admin->Configuration->Reward Points->Reward Point Status Track" set this to Advanced mode and set all dots to earned.
this will fix your problem.

Sailman:

The sunrise period is set to 0 and all selections in Admin/Advanced Order Status are set to "Earned", but I still must either change the order status or manually change them to Earned in Customers/Reward Points.

I was hoping there was a change to a couple of lines in one of the PHP pages that might write them all to Earned in the db.

Thanks for the response, and Happy New Year!

There should be no lines to change as that functionality is already built in. What version of the mod are you using?

Hem:

I am using RW Version 1.40. The sunrise period is set to 0 and all the radio buttons in Status Track are set to Earned. It is probably a conflict with the Super Orders mod. But in my case, we don't want to use "Pending" for any reason, and all redeeming and subtraction of points from accounts will be done manually thru the Admin. The ability to redeed points on-line is disabled, and no money values are shown for the points. Points are points and can only be redeemed for one certain category, whose prices are modified "free" items. When a Reward Item is added to the cart, we will check the point values and redeem and subtract from the total in the customer account if he has enough points.

Everything works fine, but the accumulated points are set to the DB as "Pending" and I have to go in and either change the order status to anything or move them in the Customers/Reward Points in the Admin. All I would ask is that the points are written to Earned automatically when the order is placed, like the 100 points we give for New Accounts. That works fine. I have tried repeatedly to mimic that function, but only succeeded in crashing it.

Sailman:

Hem:

I am using RW Version 1.40. The sunrise period is set to 0 and all the radio buttons in Status Track are set to Earned. It is probably a conflict with the Super Orders mod. But in my case, we don't want to use "Pending" for any reason, and all redeeming and subtraction of points from accounts will be done manually thru the Admin. The ability to redeed points on-line is disabled, and no money values are shown for the points. Points are points and can only be redeemed for one certain category, whose prices are modified "free" items. When a Reward Item is added to the cart, we will check the point values and redeem and subtract from the total in the customer account if he has enough points.

Everything works fine, but the accumulated points are set to the DB as "Pending" and I have to go in and either change the order status to anything or move them in the Customers/Reward Points in the Admin. All I would ask is that the points are written to Earned automatically when the order is placed, like the 100 points we give for New Accounts. That works fine. I have tried repeatedly to mimic that function, but only succeeded in crashing it.

Ah, that makes sense. There is a new version of Super Orders being released that should sort this out.

For a quick fix- try this:

Edit includes/classes/observers/class.reward_points.php:

On line 94, add the following:

$status=STATUS_PROCESSED;

This should do what you are looking for. The other options will work but require someone to log into Admin before they are transferred.

hem:

For a quick fix- try this:

Edit includes/classes/observers/class.reward_points.php:

On line 94, add the following:

$status=STATUS_PROCESSED;

> 
> This should do what you are looking for. The other options will work but require someone to log into Admin before they are transferred.
Andrew:

I hate to be a particular pain, but I have tried this: (line 94 is a blank line in Notepad++)

	  if(REWARD_POINTS_ALLOW_TOTAL=='0')
	   $status=($order->info['subtotal']>0?STATUS_PENDING:STATUS_PROCESSED);
	  else
	   $status=($order->info['total']>0?STATUS_PENDING:STATUS_PROCESSED);
                   $status=STATUS_PROCESSED;  
	  if($status==STATUS_PENDING) // Place reward points into pending if awaiting payment/status change
	   $sql="INSERT INTO ".TABLE_REWARD_CUSTOMER_POINTS." SET customers_id='".$customer_id."', pending_points='".$reward_points."' ON DUPLICATE KEY UPDATE pending_points=pending_points+".$reward_points.";";
	  else // Reward points and or coupons have covered the price of the purchase- place into processed
	   $sql="INSERT INTO ".TABLE_REWARD_CUSTOMER_POINTS." SET customers_id='".$customer_id."', reward_points='".$reward_points."' ON DUPLICATE KEY UPDATE reward_points=reward_points+".$reward_points.";";
	  $db->Execute($sql);

It still puts the points into Pending. I tried a few permutations of the surrounding code to try to get it to write the points as Earned in the db no matter whether they were Pending or Earned, but it either didn't do anything different or crashed. Possible line numbering difference between our editors......  So close to success, but no cigar......

Is there a known conflict between Rewards Points and Gift Certificates?

When a customer uses a Gift Certificate to pay a part of the total and then applies Reward Points for the balance the reward points are entered as a wrong number

example...
total due is $55.17
pay with Gift Cert $51.00
pay with Reward Points $4.17

The balance should be zero but this is what happens on step 3 of checkout....

Sub-Total: $42.00
FedEx Ground (FedEx Ground® ):$9.70
CA TAX 8.25%: $3.47

Gift Certificates: -$51.00
Value of Redeemed Reward Points: -$-46.83

Total: $51.00

Reward Points earned: 48

..
When the customer realized this was not correct he went ahead and paid the wrong amount with his credit card to complete the purchase. BUT the credit card was not actually charged and the order came through as if it were paid.

How can I fix this? I'm using zc138a and rp140a
Thanks

hi all

i want to know whether it is possible to redeem reward points for a particular category??

thanks

Hello there,

Just installed this mod and it works quite nicely, but I'm trying to accomplish something particular for one of my stores and quite frankly I have no clue how to do it.

I want to offer reward points for a certain group. I sell a membership which offers them a certain discount and along with the discount I want this particular group to enjoy the reward points program. My problem is I don't want the regular customer who haven't purchase this membership to see the rewards points anywhere, nor enjoy of the reward points at all, is this possible with this mod? and if so, how can I accomplish hiding the points earned from non members?

Thanks in advance!

mvstudio:

Hello there,

Just installed this mod and it works quite nicely, but I'm trying to accomplish something particular for one of my stores and quite frankly I have no clue how to do it.

I want to offer reward points for a certain group. I sell a membership which offers them a certain discount and along with the discount I want this particular group to enjoy the reward points program. My problem is I don't want the regular customer who haven't purchase this membership to see the rewards points anywhere, nor enjoy of the reward points at all, is this possible with this mod? and if so, how can I accomplish hiding the points earned from non members?

Thanks in advance!

you might be able to do it with something like the dual pricing and hidden wholesale mods.

the hidden mod wraps this around code to hide it:

if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0') { 

// Here's where your module code goes

} 

so only wholesale customers can see it.

Kezza

I've had this module installed for quite a while, months actually, and the only thing that doesn't seem to work for me is the automatic moving off reward points from "pending" to "earned".

I'm sorry if a fix has been mentioned before. :(

I've basically given up on trying to get it to work and currently have it set where I have to change the order status to move it to the "earned". I thought I'd give it a shot and see if anyone has a bit more info on maybe getting that to work.

Kezza:

if you go to "Your Admin->Configuration->Reward Points->Reward Point Status Track" set this to Advanced mode and set all dots to earned.
this will fix your problem.

Isn't it wrong to set all of them to earned? I ask because what if, as in my case, you have a "Order Cancelled/Refunded" status. By selecting earned in that instance it would mean that the person would still be earning the points, which in my opinion is wrong. The points should then be ignored.

You also have statuses like PayPal where some pay using their checking account via PayPal and therefore you need to wait for payment. In this instance it would be wrong to award those points as well seeing that you haven't even gotten paid for what was originally bought and ultimately you therefore are giving away points that could be used to purchased something else. In this instance the points should be "Pending" until PayPal releases the funds.

In one instance PayPal auto changes the status to the correct one once the funds have been released. On the other you have to change the status yourself. Regardless, the reward points system should then follow the statuses as you've set them to either release the reward points to "Earn", "Ignore" or place them into "Pending" based on your selection.

Hello Hem..

Wanna make sure Super Orders plays nice with Rewards Points.. Apparently there are a few outstanding issues to address.. (I gathered some of the posts I found here) Since Edit Orders 3.03 (which includes your fix to the Rewards Points issue:clap:) will adress the outstanding issue with Rewards Points and Edit Orders, I'd like to make sure Super Orders plays nice too..

May I contact you under separate cover about this??:smile:

hem:

hmmmmm- looks like something that Super Order is bringing to the table- It must assume all values in the order are cash values.

fiji:

I found a problem.
If use "Super Orders" to change order status, the pending points won't add to earn point.

beadfaery:

I've just installed the Super Orders mod and have been having a play with it. The only problem I can see is that if I want to edit an order, it changes the Reward Points to a $ value intead of points value. eg; if the customer received 50 points....when I edit the order it changes it to $50.00 :wacko:

I've searched this thread to see if an answer was already here, but didn't find anything.
Is there something I need to do to fix this problem??

Thanks in advance :smile:

Still loving this mod hem :clap: Thanks heaps....you really need to sort something so we can all shout you a guiness or a cuppa :D

retched:

I'm having similar problems between Super Orders and Edit Orders what generally happens is that any number entered where total points are are converted to a $0.00 like entry (example, I enter 400, the number is converted to $400).

The only way for this to be fixed is to take apart the edit order mod and determine how it gets values then add in custom coding so that when you modify the value of the points, it doesn't change on you.

Another, less practical, way of fixing this would be to go into your MySQL DB with a tool like phpMyAdmin and have it at that way. But again, this is NOT ideal for beginner's.

Kezza:

you might be able to do it with something like the dual pricing and hidden wholesale mods.

the hidden mod wraps this around code to hide it:

if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0') {

// Here's where your module code goes

}

> so only wholesale customers can see it.
> 
> Kezza

Thanks Kezza for your reply, I managed to make it work more or less to my needs but still have a few things that I want to modify. your suggestion though wouldn't work in my case.
The store has both retail and wholesale. Wholesale of course has no benefits but a large discount, no discounts, no coupons, no gift certificates, obviously no reward points either. For the retail I offer a purchased membership with an annual 10% discount on everything in the store for members only, and I want to add the reward points to this membership. I'm using discount group for this membership to work, so reward points would have to work only with discount groups and not with the regular retail.

Also the way I have it set up, the reward points don't show on product listing instead only the total of reward points earned is shown during checkout, so what I'm really trying to accomplish is show reward points only for this particular discount group, and not the rest of regular clients, does it make any sense? I'm thinking with an if statement on the checkout pages I might be able to make it work, but I'm still working on that.

Thanks for any help :smile:

I want my site to reward customers for sharing a lnkto me on Facebook or sending e-mail referrals (after their referral makes a purchase). I see two rewards modules, this one and one by nemicus I think. It is ok for my customers to get points for purchases but that is not my focus. I want a button that says "share on facebook" or share through e-mail that then pops up with a unique referral link for that customer and keeps track when the referral makes a purchase. Is this or another rewards module customizable for that or is their another app that does this? Thank you.

mvstudio:

Thanks Kezza for your reply, I managed to make it work more or less to my needs but still have a few things that I want to modify. your suggestion though wouldn't work in my case.
The store has both retail and wholesale. Wholesale of course has no benefits but a large discount, no discounts, no coupons, no gift certificates, obviously no reward points either. For the retail I offer a purchased membership with an annual 10% discount on everything in the store for members only, and I want to add the reward points to this membership. I'm using discount group for this membership to work, so reward points would have to work only with discount groups and not with the regular retail.

Also the way I have it set up, the reward points don't show on product listing instead only the total of reward points earned is shown during checkout, so what I'm really trying to accomplish is show reward points only for this particular discount group, and not the rest of regular clients, does it make any sense? I'm thinking with an if statement on the checkout pages I might be able to make it work, but I'm still working on that.

Thanks for any help :smile:

why not try changing the statement to something like this:

if ($_SESSION['customers_group_pricing'] && $_SESSION['customers_group_pricing'] != '1') { 

// Here's where your module code goes

}

then add a RAW SQL query for customers->customers_group_pricing

Kezza

in that last statment it should be 0 not 1, so should read:

['customers_group_pricing'] != '0')

leilanddale:

I've had this module installed for quite a while, months actually, and the only thing that doesn't seem to work for me is the automatic moving off reward points from "pending" to "earned".

I'm sorry if a fix has been mentioned before. :(

I've basically given up on trying to get it to work and currently have it set where I have to change the order status to move it to the "earned". I thought I'd give it a shot and see if anyone has a bit more info on maybe getting that to work.

Any feedback on this?