ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Using ProductCart
  New Posts New Posts RSS Feed - Accruing Reward Points For ALL Orders
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Accruing Reward Points For ALL Orders

 Post Reply Post Reply
Author
Message
toyjam View Drop Down
Newbie
Newbie


Joined: 27-January-2007
Location: United States
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote toyjam Quote  Post ReplyReply Direct Link To This Post Topic: Accruing Reward Points For ALL Orders
    Posted: 30-May-2008 at 3:10pm

The current functionality of the Reward Points program allows retails customers to accrue points on new purchases.  But when they use their points on subsequent orders, they do not accrue any points for those order which points are applied.

Is there a way to always allow the user to accrue points on orders on which points were applied?  This is a discount my customers really like.
Back to Top
Hamish View Drop Down
Admin Group
Admin Group


Joined: 12-October-2006
Location: United Kingdom
Status: Offline
Points: 56
Post Options Post Options   Thanks (0) Thanks(0)   Quote Hamish Quote  Post ReplyReply Direct Link To This Post Posted: 01-June-2008 at 7:03pm
Hi,
  Having looked into this on the surface it looks like a small change is required.

Before I get into the code change required I'd just like to clarify -
Is it OK for the whole value of the current purchase to accrue points - even though the  purchase is then discounted by existing points?
In this scenario - If someone has accrued enough points to purchase, say, a $20 item purely with reward points they will get new points on the full $20 purchase  even though the actual cost to them is zero.
Back to Top
Hamish View Drop Down
Admin Group
Admin Group


Joined: 12-October-2006
Location: United Kingdom
Status: Offline
Points: 56
Post Options Post Options   Thanks (0) Thanks(0)   Quote Hamish Quote  Post ReplyReply Direct Link To This Post Posted: 02-June-2008 at 12:32pm
Hi,
  Just a quick follow up on this.
I did a quick calculation on this. If, for example you set the reward points to 5%  then  the ACTUAL points in the scenario above (points on all purchases) are a more generous 5.26%. This is due to points being accrued on points purchases.
On the other hand, with the existing system the reward points can work out at actually slightly less than the full 5% - By how much depends on what percentage of the purchase is covered by the existing reward points, as they accrue no reward points for the balance of the purchase.

The ideal  would be, IMHO, to accrue reward points on purchases, ignoring any part of the purchase covered by  reward points.  It's certainly possible to do that, but will require more code changes to achieve.  

  


Edited by Hamish - 02-June-2008 at 12:56pm
Back to Top
toyjam View Drop Down
Newbie
Newbie


Joined: 27-January-2007
Location: United States
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote toyjam Quote  Post ReplyReply Direct Link To This Post Posted: 07-June-2008 at 1:48am
Your ideal situation makes the best sense - accrue reward points while ignoring the part of the purchase covered by the points.  So if someone got something free, they would not get any points, but if someone purchased an item for $20 and their points covered $5, then they could still get some points for the $15 of real money they spent.
Back to Top
caughlan View Drop Down
Groupie
Groupie
Avatar

Joined: 25-September-2006
Location: Canada
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote caughlan Quote  Post ReplyReply Direct Link To This Post Posted: 11-August-2008 at 8:10pm
Lets say I didn't care if the system gave full points on a purchase where points were redeemed... is this where I'd change something to make that happen?
iRewardPointsAccrued = rstemp("iRewardPointsAccrued")
iRewardPointsUsed = rstemp("iRewardPointsUsed")
if iRewardPointsAccrued="" then
    iRewardPointsAccrued=0
end if
if iRewardPointsUsed="" then
    iRewardPointsUsed=0
end if
iBalance = INT(iRewardPointsAccrued) - Int(iRewardPointsUsed)
if iBalance=0 then
    iDollarValue =0
else
    iDollarValue = iBalance * (RewardsPercent / 100)
end if
iRewardPointsHistory=iRewardPointsAccrued
rstemp.Close
Stacelynn (who's always workin' hard to make logic out of code!)
Back to Top
macleather View Drop Down
Newbie
Newbie


Joined: 23-June-2008
Location: Los Angeles
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote macleather Quote  Post ReplyReply Direct Link To This Post Posted: 12-August-2008 at 1:03pm
Hi,

I would be interested in Hamish's "ideal" situation as well. I think that makes the most sense.

Alan
Back to Top
Hamish View Drop Down
Admin Group
Admin Group


Joined: 12-October-2006
Location: United Kingdom
Status: Offline
Points: 56
Post Options Post Options   Thanks (0) Thanks(0)   Quote Hamish Quote  Post ReplyReply Direct Link To This Post Posted: 12-August-2008 at 1:17pm
Hi Stacelynn,
  Blimey, I'd forgotten about this one. I'm just getting ready to go on Hols for a week, so I haven't got time to look at code today - but it certainly looks like a/the right spot. Be careful in case there are other places which carry out related calculations - not that it's likely to invalidate any change you make, just that you may not cover all the bases. A quick scan for iRewardPointsUsed shows 7 references in /admin and 7 in /pc.

Don't forget - backup the unmodified version of the code to give yourself a "get out of jail free" card & TEST as thoroughly as you feel is necessary.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.063 seconds.