Accruing Reward Points For ALL Orders

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.

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

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

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.