ProductCart Shopping Cart Software Forums : Accruing Reward Points For ALL Orders https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 06:18:38 +0000 Tue, 12 Aug 2008 13:17:30 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=1675 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Accruing Reward Points For ALL Orders : Hi Stacelynn, Blimey, I&#039;d...]]> https://forum.productcart.com/accruing-reward-points-for-all-orders_topic1675_post6368.html#6368 Author: Hamish
Subject: 1675
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.
]]> Tue, 12 Aug 2008 13:17:30 +0000 https://forum.productcart.com/accruing-reward-points-for-all-orders_topic1675_post6368.html#6368 <![CDATA[Accruing Reward Points For ALL Orders : Hi,I would be interested in Hamish&#039;s...]]> https://forum.productcart.com/accruing-reward-points-for-all-orders_topic1675_post6366.html#6366 Author: macleather
Subject: 1675
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
]]> Tue, 12 Aug 2008 13:03:05 +0000 https://forum.productcart.com/accruing-reward-points-for-all-orders_topic1675_post6366.html#6366 <![CDATA[Accruing Reward Points For ALL Orders : Lets say I didn&#039;t care if...]]> https://forum.productcart.com/accruing-reward-points-for-all-orders_topic1675_post6357.html#6357 Author: caughlan
Subject: 1675
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!)
]]> Mon, 11 Aug 2008 20:10:26 +0000 https://forum.productcart.com/accruing-reward-points-for-all-orders_topic1675_post6357.html#6357 <![CDATA[Accruing Reward Points For ALL Orders : Your ideal situation makes the...]]> https://forum.productcart.com/accruing-reward-points-for-all-orders_topic1675_post5437.html#5437 Author: toyjam
Subject: 1675
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.]]> Sat, 07 Jun 2008 01:48:07 +0000 https://forum.productcart.com/accruing-reward-points-for-all-orders_topic1675_post5437.html#5437 <![CDATA[Accruing Reward Points For ALL Orders : Hi, Just a quick follow up on...]]> https://forum.productcart.com/accruing-reward-points-for-all-orders_topic1675_post5330.html#5330 Author: Hamish
Subject: 1675
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]]> Mon, 02 Jun 2008 12:32:43 +0000 https://forum.productcart.com/accruing-reward-points-for-all-orders_topic1675_post5330.html#5330 <![CDATA[Accruing Reward Points For ALL Orders : Hi, Having looked into this on...]]> https://forum.productcart.com/accruing-reward-points-for-all-orders_topic1675_post5323.html#5323 Author: Hamish
Subject: 1675
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.
]]> Sun, 01 Jun 2008 19:03:40 +0000 https://forum.productcart.com/accruing-reward-points-for-all-orders_topic1675_post5323.html#5323 <![CDATA[Accruing Reward Points For ALL Orders : The current functionality of the...]]> https://forum.productcart.com/accruing-reward-points-for-all-orders_topic1675_post5289.html#5289 Author: toyjam
Subject: 1675
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.
]]> Fri, 30 May 2008 15:10:41 +0000 https://forum.productcart.com/accruing-reward-points-for-all-orders_topic1675_post5289.html#5289