Reward Points Module for ZC v13x

Thanks for this, everything is working great accept for 1 thing. I have "Adjust Reward Points for Sales/Specials" set up so that you will earn points based on whatever the sale price is, not the regular price. This is confirmed when you click on an item. For example, if a product is on sale for $17.00, marked down from $20.00 it shows in red text that you will earn 170 points. This part is working correctly. However, on Step 2 of the check-out page it shows that you will earn 200 points. I also have "Allow Redeem of Reward Points on Order Total or Subtotal" set to subtotal, so that you won't earn points on S$H fees.

Am I missing another setting that needs to be fixed?

I have set a up a group called Wholesale and these customers will always receive a 10% discount. I also want them to earn rewards along with everyone else.. but when I am logged in as a Wholesale customer and try a test purchase I am earning the rewards points correctly but my 10% discount is nowhere to be seen. Is it not possible to get the discount and earn points at the same time?

Quote:

---

Originally Posted by lilshopofsecrets

I have set a up a group called Wholesale and these customers will always receive a 10% discount. I also want them to earn rewards along with everyone else.. but when I am logged in as a Wholesale customer and try a test purchase I am earning the rewards points correctly but my 10% discount is nowhere to be seen. Is it not possible to get the discount and earn points at the same time?

---

When you've tested it, have you gone all the way through the process (ie completed checkout)?:smile:

Quote:

---

Originally Posted by beadfaery

When you've tested it, have you gone all the way through the process (ie completed checkout)?:smile:

---

Yes I have gone all the way through. I have tried it both redeeming points and not redeeming points and both ways my 10% discount never showed up. It seems as though this mod just cancels out the group discounts.

Is there a way to prevent orders being paid with a gift certificate to receive points? I know that I can prevent the purchase of the gift certificate from receiving points, but I would rather the person who buys the certificate be rewarded than the person who is receiving the gift. Also, can I prevent points from being used to purchase gift certificates? I'm sorry if these questions have already been answered, but I have read through the posts and nothing came up in my searches.

Quote:

---

Originally Posted by lilshopofsecrets

Yes I have gone all the way through. I have tried it both redeeming points and not redeeming points and both ways my 10% discount never showed up. It seems as though this mod just cancels out the group discounts.

---

Hmmmmmm? I tested it with mine as soon as I saw your question and it worked fine for me??
Sorry....no help, but at least we've established it's not the mod.
I'm sure when Andrew's here, he'll be able to solve it :smile:

Quote:

---

Originally Posted by hem

Yes, that's the issue. Regular Paypal works. Paypal IPN (like Google Checkout) however does not use the same 'path' as any of the other payment methods and so the reward point mod never gets called.

I've tried various ideas to affect a workaround but none of them have been satisfactory. At this stage I think the only way around it is to modify the core code for the Paypal IPN (and Google Checkout) payment modules.

---

I have a updated reward point notify class which hopefully resolves the IPN issue. Is there anyone who would like to take it for a test drive???

Quote:

---

Originally Posted by 0be1

I had a problem with it the first time installing and then I realized it was my fault (due to a mysql version). Do you know how I can make this work with zc 1.3.7.1, mysql 4.0.26, and php 4.4.4.

tia...

0be1

---

The mod will not work with any version of MySQL lower than v4.2. But as v5 is the current standard and v6 is in the pipeline maybe you should go and talk to your ISP about them upgrading.

Quote:

---

Originally Posted by lilshopofsecrets

Yes I have gone all the way through. I have tried it both redeeming points and not redeeming points and both ways my 10% discount never showed up. It seems as though this mod just cancels out the group discounts.

---

The mod does not change any of the pricing in an order so I'm afraid your discount issue lies elsewhere.

Quote:

---

Originally Posted by Boogy

Thanks for this, everything is working great accept for 1 thing. I have "Adjust Reward Points for Sales/Specials" set up so that you will earn points based on whatever the sale price is, not the regular price. This is confirmed when you click on an item. For example, if a product is on sale for $17.00, marked down from $20.00 it shows in red text that you will earn 170 points. This part is working correctly. However, on Step 2 of the check-out page it shows that you will earn 200 points. I also have "Allow Redeem of Reward Points on Order Total or Subtotal" set to subtotal, so that you won't earn points on S$H fees.

Am I missing another setting that needs to be fixed?

---

I'll double check this- it sounds like you are set up correctly.

Quote:

---

Originally Posted by hem

I have a updated reward point notify class which hopefully resolves the IPN issue. Is there anyone who would like to take it for a test drive???

---

Can you provide a link? I would love to not have to manually update the points for the paypal orders we have...

Quote:

---

Originally Posted by hem

I'll double check this- it sounds like you are set up correctly.

---

I just checked with mine and it's working properly.

I have however noticed that with the 'Quantity Discounts' ...if someone purchases, say 10 of something (giving them a discount) they still get the points that they would have received for full price.

Quote:

---

Originally Posted by Rasyr

Can you provide a link? I would love to not have to manually update the points for the paypal orders we have...

---

See attachment here- Unzip to includes/classes/observers (overwrite the one there). Let me know how you get on.

Quote:

---

Originally Posted by beadfaery

I just checked with mine and it's working properly.

I have however noticed that with the 'Quantity Discounts' ...if someone purchases, say 10 of something (giving them a discount) they still get the points that they would have received for full price.

---

Likewise, I can't reproduce this.

Quote:

---

Originally Posted by lilshopofsecrets

Yes I have gone all the way through. I have tried it both redeeming points and not redeeming points and both ways my 10% discount never showed up. It seems as though this mod just cancels out the group discounts.

---

This issue has been fixed, it was an error on my part (duh!). But, now that I have my discount showing up the points are not adding up correctly. Customers who are getting the 10% discount are getting too many points because the points are being calculated by the sub-total minus points being redeemed. It needs to go one step deeper and remove the 10% discount prior to awarding points. I have not tested tax, coupons, gift certificates, etc yet. I have tried changing the sort order of the order total modules but it doesn't make a difference. Here is an example:

Sub-Total: $32.81
Group Discount: -$3.28
Value of Redeemed Reward Points: -$2.00
United Parcel Service (Ground): $9.27
Total: $36.80
Reward Points earned: 31

I have it set to calculate from the sub-total and the points rounding 0.5 (default) so this customer should be earning 28 points rather than 31. It is only a few points difference but over time or on large orders this can really add up. Any suggestions? Thanks a bunch!

I currently have my rewards points set up so that for every 1,000 points that my customers accumulate, they can redeem it for $10. However, when they accumulate more than 1,000 (say, 1500), they are able to redeem it for $15, which is not what I want.

My question is, how can I change it so that they can only redeem for $10 at a time? If they have 1500 points, could I possibly move 500 points to pending, so that they can redeem the 1,000 and then move the 500 back into earned points?

Also, will I be notified if the customers redeem their credit?

Quote:

---

Originally Posted by hem

I have a updated reward point notify class which hopefully resolves the IPN issue. Is there anyone who would like to take it for a test drive???

---

Hem

Before installing does this update resolve Google Checkout issues also?

Thanks
Ken

Paws4Deals

Quote:

---

Originally Posted by kenwahl

Hem

Before installing does this update resolve Google Checkout issues also?

Thanks
Ken

Paws4Deals

---

Not yet Ken, though I will have an updated Google Checkout/RP mod tomorrow if you want to give it a test drive. Google Checkout does not use notifiers which RP hangs on to do the point reward so it means an addition to the Google Checkout core code- I did try other methods (which worked badly) and I have posted a request on the Google Checkout mod site for the developers to add notifiers.

Quote:

---

Originally Posted by fairylite

I currently have my rewards points set up so that for every 1,000 points that my customers accumulate, they can redeem it for $10. However, when they accumulate more than 1,000 (say, 1500), they are able to redeem it for $15, which is not what I want.

My question is, how can I change it so that they can only redeem for $10 at a time? If they have 1500 points, could I possibly move 500 points to pending, so that they can redeem the 1,000 and then move the 500 back into earned points?

Also, will I be notified if the customers redeem their credit?

---

Can't do it right now but I will add it to the wishlist.

Quote:

---

Originally Posted by lilshopofsecrets

This issue has been fixed, it was an error on my part (duh!). But, now that I have my discount showing up the points are not adding up correctly. Customers who are getting the 10% discount are getting too many points because the points are being calculated by the sub-total minus points being redeemed. It needs to go one step deeper and remove the 10% discount prior to awarding points. I have not tested tax, coupons, gift certificates, etc yet. I have tried changing the sort order of the order total modules but it doesn't make a difference. Here is an example:

Sub-Total: $32.81
Group Discount: -$3.28
Value of Redeemed Reward Points: -$2.00
United Parcel Service (Ground): $9.27
Total: $36.80
Reward Points earned: 31

I have it set to calculate from the sub-total and the points rounding 0.5 (default) so this customer should be earning 28 points rather than 31. It is only a few points difference but over time or on large orders this can really add up. Any suggestions? Thanks a bunch!

---

Right now the mod just handles the subtotal (or total) and negates the redeemed points- no other discounts are considered (or GV for that matter). The short term workaround here would be to drop the number of points rewarded by that group by 10%- This should give you the result you are looking for.

Hi Andy
is the version in the downloads section current? or do we need the new file you have posted to sort out the paypal issue as well?

thanks

Andy

Quote:

---

Originally Posted by andy

Hi Andy
is the version in the downloads section current? or do we need the new file you have posted to sort out the paypal issue as well?

thanks

Andy

---

Andy, the new file is just a beta at the moment and has not been added to the official contribution in the downloads section.

Quote:

---

Originally Posted by hem

Andy, the new file is just a beta at the moment and has not been added to the official contribution in the downloads section.

---

Thanks, I will install both later tonight, and see how it works

thanks

Andy

All installed and working, except i get a 500 intrnal server error when i click on Admin>Customers>Reward Points

Any idea's what might be wrong? i dont have access to the server log to find out

I have checked twice that all the files are in place/uploaded from the latest version in th downloads section.

thanks

Andy

managed to access my log file, and this is the message

ModSecurity: Output filter: Response body too large (over limit of 2621440, total not specified)

Any idea what this means? is this the reward module not sending information, or the security on the server stopping it?

thanks

Andy

Quote:

---

Originally Posted by andy

managed to access my log file, and this is the message

ModSecurity: Output filter: Response body too large (over limit of 2621440, total not specified)

Any idea what this means? is this the reward module not sending information, or the security on the server stopping it?

thanks

Andy

---

My guess is you have an extremely large customer database. I'm currently working on a better customer record interface. In the meantime unzip the attachment to your admin/ folder.

Hi Andy
we have close to 5000 customers in the DB, is this a lot for the module?

thanks for the mod, will try it in a bit

Andy

Hi Andy
thanks for the file, it hs fixed the problem, just need to finish testing it

thanks again

Andy

I think this is a brilliant module. I will send a few pints to you soon, and I encourage other users to do the same.

I had a question. I wondered if there is a way to extract a customers reward point total, for it to show up in a newsletter for that respective person.

Regards,

Heathenmagic:smile:

Quote:

---

Originally Posted by hem

Not yet Ken, though I will have an updated Google Checkout/RP mod tomorrow if you want to give it a test drive. Google Checkout does not use notifiers which RP hangs on to do the point reward so it means an addition to the Google Checkout core code- I did try other methods (which worked badly) and I have posted a request on the Google Checkout mod site for the developers to add notifiers.

---

Thanks

I'll test it as soon as the update is posted.

Ken
Paws4Deals

I've grabbed the rewards class and installed it as well. Should find out shortly if it will post the pending points to the customer account or not.

I also grabbed the updated version of the customer_reward_points.php to try as well. Would it take too much to add page navigation to this?

Also, congrats on a GREAT mod! :clap:
cheers!

Andrew,
Tried the new class files posted at http://www.zen-cart.com/forum/showpo...&postcount=413 and had an order come in last night using PayPal IPN and was an instant payment transaction type unique. No points were added to the customers pending balance. No errors were shown or logged anywhere that I could find. Had to add the points manually for the customer this morning.

ZC Version 1.3.7
PHP Version 4.3.9
MySQL Version 4.1.20
Apache 2.0.52

I recently installed this module and when I view the following admin pages:

Customer Reward Points Admin

Quote:

---

1146 Table 'nos0825310485094.zen_reward_customer_points' doesn't exist
in:
[select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_group_pricing, r.pending_points, r.reward_points, gp.group_name, rm.redeem_ratio from zen_customers as c LEFT JOIN (zen_reward_customer_points as r) ON (r.customers_id=c.customers_id) LEFT JOIN(zen_group_pricing as gp) ON (gp.group_id=c.customers_group_pricing) LEFT JOIN(zen_reward_master as rm) ON ((c.customers_group_pricing!=0 AND rm.scope=3 AND rm.scope_id=c.customers_group_pricing) OR (c.customers_group_pricing=0 AND rm.scope=0 AND rm.scope_id=0)) ORDER BY c.customers_lastname;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

---

Reward Points - Top

Quote:

---

1146 Table 'nos0825310485094.zen_reward_master' doesn't exist
in:
[SELECT * FROM zen_reward_master WHERE scope='0' AND scope_id='0';]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

---

I must have done something wrong when I installed the mod.:frusty:

Quote:

---

Originally Posted by Boogy

Thanks for this, everything is working great accept for 1 thing. I have "Adjust Reward Points for Sales/Specials" set up so that you will earn points based on whatever the sale price is, not the regular price. This is confirmed when you click on an item. For example, if a product is on sale for $17.00, marked down from $20.00 it shows in red text that you will earn 170 points. This part is working correctly. However, on Step 2 of the check-out page it shows that you will earn 200 points. I also have "Allow Redeem of Reward Points on Order Total or Subtotal" set to subtotal, so that you won't earn points on S$H fees.

Am I missing another setting that needs to be fixed?

---

Any updates?

Here's a Reward Point Diagnostic. Unzip the attached zip file to the root of your zencart folder and then fire up your browser and enter the following address: [your site URL]/rpd.php.

This will check that all the files, folders, tables and records are correct for RP to run. Look for any items highlighted in red. You can delete rpd.php and rpd.xml once everything is running correctly.

http://www.zen-cart.com/forum/attach...1&d=1221258768

Quote:

---

Originally Posted by HeathenMagic

I think this is a brilliant module. I will send a few pints to you soon, and I encourage other users to do the same.

I had a question. I wondered if there is a way to extract a customers reward point total, for it to show up in a newsletter for that respective person.

Regards,

Heathenmagic:smile:

---

IT should be possible. I will check to see how I can make it easier to call within the email

Quote:

---

Originally Posted by Einstin

Andrew,
Tried the new class files posted at http://www.zen-cart.com/forum/showpo...&postcount=413 and had an order come in last night using PayPal IPN and was an instant payment transaction type unique. No points were added to the customers pending balance. No errors were shown or logged anywhere that I could find. Had to add the points manually for the customer this morning.

ZC Version 1.3.7
PHP Version 4.3.9
MySQL Version 4.1.20
Apache 2.0.52

---

Looks like I'm going to smack the IPN module with a big stick

Quote:

---

Originally Posted by hem

See attachment here- Unzip to includes/classes/observers (overwrite the one there). Let me know how you get on.

---

Okay, first, I tried to update to the latest version and royally screwed something up and broke my whole store.

Once I had it restored (made sure to backup before attempting to upgrade the RP module -- the sql is where it went wacky on me.. hehe), I tried just adding this class file.

No luck, still no IPN joy..... :dontgetit

Quote:

---

Originally Posted by hem

Looks like I'm going to smack the IPN module with a big stick

---

I don't think it uses any of the observer/notifiers so you might have to manually add something into the IPN handler file. You might be able to hook into the orders class but that is also a bit short on notifiers. May well have to be a core file change to really nail it down.

Regards,
Christian.

Quote:

---

Originally Posted by CJPinder

I don't think it uses any of the observer/notifiers so you might have to manually add something into the IPN handler file. You might be able to hook into the orders class but that is also a bit short on notifiers. May well have to be a core file change to really nail it down.

Regards,
Christian.

---

The IPN mod does use notifiers though (Google Checkout doesn't). All I can think is that the mod does not call any user created classes. The problem is that debugging IPN is close to impossible.

I think you're right though, it's looking like there's no choice but to hack the core code.

Quote:

---

Originally Posted by hem

The IPN mod does use notifiers though (Google Checkout doesn't). All I can think is that the mod does not call any user created classes. The problem is that debugging IPN is close to impossible.

---

IIRC in ZC1.3.7 the PayPal IPN Handler uses its own application_top.php file which does not load any of the auto loaders so user defined notifiers and classes will not get loaded. ZC1.3.8 uses the standard application_top so autoloaders should get loaded. I don't recall ipn_main_handler.php triggering any notifiers at the point of order creation or status update though.

The last time I had to hook into the order creation process I ended up just changing the includes/classes/order.php file. It meant changing a core file but it ensured that all orders were caught and everything was simpler.

Regards,
Christian.

Quote:

---

Originally Posted by Einstin

Andrew,
Tried the new class files posted at http://www.zen-cart.com/forum/showpo...&postcount=413 and had an order come in last night using PayPal IPN and was an instant payment transaction type unique. No points were added to the customers pending balance. No errors were shown or logged anywhere that I could find. Had to add the points manually for the customer this morning.

---

Same here although only happened on one sale as the otherts just sat in pending.

Quote:

---

Originally Posted by CJPinder

The last time I had to hook into the order creation process I ended up just changing the includes/classes/order.php file. It meant changing a core file but it ensured that all orders were caught and everything was simpler.

Regards,
Christian.

---

I really don't want to hack the core orders.php file as this could have severe implications for anyone using ZenCart, not only those who are using PayPal IPN

Okay, I've had a long hard look at the IPN code and followed through the logic. I nearly wrote a test environment which would simulate a valid IPN session but then sanity kicked in.

I think I may have been wrongly assuming that my observer class never got called. It looks like now that the class is being called but IPN is not passing the customer_id via a $_SESSION variable.

So, I've done two things. I've changed the hook (again) and also told the mod to look for the customer_id in other places.

Fingers crossed that this works. At this stage I've spent more time trying to debug IPN than it took me to write the mod in the first place.

Okay, I have installed this latest observer class. Will let you know as soon as I have a IPN customer and let you know whether or not it works

Quote:

---

Originally Posted by hem

Okay, I've had a long hard look at the IPN code and followed through the logic. I nearly wrote a test environment which would simulate a valid IPN session but then sanity kicked in.

I think I may have been wrongly assuming that my observer class never got called. It looks like now that the class is being called but IPN is not passing the customer_id via a $_SESSION variable.

So, I've done two things. I've changed the hook (again) and also told the mod to look for the customer_id in other places.

Fingers crossed that this works. At this stage I've spent more time trying to debug IPN than it took me to write the mod in the first place.

---

:clap:

Hem

This new class.reward_points.php fixed the Google Checkout problem! It now awards points with Google Checkout. Outstanding job! Thanks for all the hard work I know it was a pain and time consuming to fix. Hopefully it also fixed the Paypal IPN issue (I don't use Paypal and can't test it).

Thanks
Ken

Paws4Deals

Cheers for the update and all your hard work, I have installed the new class and will report back if it works when someone next uses paypal on my site.

Quote:

---

Originally Posted by kenwahl

:clap:

Hem

This new class.reward_points.php fixed the Google Checkout problem! It now awards points with Google Checkout. Outstanding job! Thanks for all the hard work I know it was a pain and time consuming to fix. Hopefully it also fixed the Paypal IPN issue (I don't use Paypal and can't test it).

Thanks
Ken

Paws4Deals

---

I just came here to post that the new version should also fix the Google Checkout problem too. You beat me to it. :P

Okay, presuming Paypal IPN and Google Checkout are now working (fingers crossed) I can now devote so time into adding further features. I have on the wishlist:

1. A better Customer Reward Point admin interface
2. The ability to display earned and pending points in a customer email/newsletter
3. Round points on quantity*price rather than just price.

The 3rd item is where 0 points are being awarded for an item priced say 0.5 even when 20 of them are purchased. Just out of interest how would people expect to see the Reward Points displayed for this item??? Have something like "buy 2 and get 1 reward point"???

Anyone any other items I should add to the wishlist???

Quote:

---

Originally Posted by Rasyr

Okay, I have installed this latest observer class. Will let you know as soon as I have a IPN customer and let you know whether or not it works

---

Sorry, but no points were awarded (pending) to the Paypal customer who made a purchase last night...

Quote:

---

Originally Posted by Rasyr

Sorry, but no points were awarded (pending) to the Paypal customer who made a purchase last night...

---

What version of ZenCart are you running?

Here's a newer version with a minor refinement.

Quote:

---

Originally Posted by hem

Okay, presuming Paypal IPN and Google Checkout are now working (fingers crossed) I can now devote so time into adding further features. I have on the wishlist:

1. A better Customer Reward Point admin interface
2. The ability to display earned and pending points in a customer email/newsletter
3. Round points on quantity*price rather than just price.

The 3rd item is where 0 points are being awarded for an item priced say 0.5 even when 20 of them are purchased. Just out of interest how would people expect to see the Reward Points displayed for this item??? Have something like "buy 2 and get 1 reward point"???

Anyone any other items I should add to the wishlist???

---

I would love to see the calculation of points work around group pricing, discount coupons, etc so that the points awarded are accurate. I'm sure it's a huge job but it would be so wonderful!

Quote:

---

Originally Posted by hem

What version of ZenCart are you running?

---

I am running the latest version of Zen Cart -- 1.3.8a

Quote:

---

Originally Posted by hem

The 3rd item is where 0 points are being awarded for an item priced say 0.5 even when 20 of them are purchased. Just out of interest how would people expect to see the Reward Points displayed for this item??? Have something like "buy 2 and get 1 reward point"???

Anyone any other items I should add to the wishlist???

---

Hmmmm? good point.....maybe have it as '.5 points' ?? or what you suggested would be good :) I'll just be happy if the points are awarded.

Quote:

---

Originally Posted by hem

Here's a newer version with a minor refinement.

---

What is the 'minor refinement' ? Is it worth applying this upgrade, or better to wait until there's more? :smile:

Oh and....I'm not very knowledgable with this kind of thing....where do I put this update?

Quote:

---

Originally Posted by beadfaery

What is the 'minor refinement' ? Is it worth applying this upgrade, or better to wait until there's more? :smile:

Oh and....I'm not very knowledgable with this kind of thing....where do I put this update?

---

would it go in /includes/classes/observers?

Quote:

---

Originally Posted by lilshopofsecrets

I would love to see the calculation of points work around group pricing, discount coupons, etc so that the points awarded are accurate. I'm sure it's a huge job but it would be so wonderful!

---

I second this :smile:

one thing I would like to see on the wishlist and would be good & useful if its possible is to allow 100% claim (zero cost) for paypal as normally anything totalling zero goes through the freecharge card payment module rather than paypal, but with this, it is still passed through to paypal as zero charge which can not be handled by them.

I hope that makes sense ? :)

Quote:

---

Originally Posted by hem

Here's a newer version with a minor refinement.

---

Hem

I don't know if it fixed Paypal IPN, but the tweak didn't break Google Checkout. It still works with the change.

Ken

Paws4Deals

This looks like a great mod and I think it is what I'm looking for - wonder if someone could confirm it will work for me as follows:

I'm putting up a store which will allow people to redeem points they have earned from my resellers elsewhere. I need it to work as follows:

For resellers:
Reseller purchases points in blocks of 100 from one area of the store.
The reseller can then award points to a customer or customers, up to the amount in the resellers account (maybe by logging on using Admin Profiles mod ). For example - a reseller with only 500 points cannot award 600 points.

Customers log in, see how many points they have been allocated, and may spend them on anything in the store.
Customers NEVER receive points from any purchases or points redemptions.

It would be nice if customers could make up the difference on an item they want by using cash but I can implement that later once the PayPal problem gets sorted.

Can anyone confirm that this will work?

Thanks

Well we are still having problem with the points being redeemed correctly off the subtotals, etc...

not taking the points off before it calculates tax, and the subtotal doesn't add up right..

50 x AAA Widgets 001 $500.00 -$9.80
Value of Redeemed Reward Points: $9.80



Sub-Total:500.00

Table Rate (Best Way): 20.00


FL TAX 7.0%: 35.00


Total: 542.20


Reward Points earned: 490.2

Quote:

---

Originally Posted by hem

Here's a newer version with a minor refinement.

---

still no joy..... :(

still not working with paypal :( I'm afraid

Quote:

---

Originally Posted by median

This looks like a great mod and I think it is what I'm looking for - wonder if someone could confirm it will work for me as follows:

I'm putting up a store which will allow people to redeem points they have earned from my resellers elsewhere. I need it to work as follows:

For resellers:
Reseller purchases points in blocks of 100 from one area of the store.
The reseller can then award points to a customer or customers, up to the amount in the resellers account (maybe by logging on using Admin Profiles mod ). For example - a reseller with only 500 points cannot award 600 points.

Customers log in, see how many points they have been allocated, and may spend them on anything in the store.
Customers NEVER receive points from any purchases or points redemptions.

It would be nice if customers could make up the difference on an item they want by using cash but I can implement that later once the PayPal problem gets sorted.

Can anyone confirm that this will work?

Thanks

---

It's possible but it would mean you coding some extra template pages. How do your resellers interact with your site currently?

Quote:

---

Originally Posted by Crzipilot

Well we are still having problem with the points being redeemed correctly off the subtotals, etc...

not taking the points off before it calculates tax, and the subtotal doesn't add up right..

50 x AAA Widgets 001 $500.00 -$9.80
Value of Redeemed Reward Points: $9.80



Sub-Total:500.00

Table Rate (Best Way): 20.00


FL TAX 7.0%: 35.00


Total: 542.20


Reward Points earned: 490.2

---

Set the Sort Order for the Reward Point mod so it is lower than the Tax module. Should do the trick.

Quote:

---

Originally Posted by Rasyr

still no joy..... :(

---

Bugger- back to the drawing board then :frusty:

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

Quote:

---

Originally Posted by 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

---

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

Hi there,

This mod looks like it's something I can use for my client's new Zen Cart. We're using ZC for their organization to take online payments from members for annual dues, advertising costs and training classes and workshops. They are offering CEUs (Continuing Education Units) to the participants for the training courses they take and they want to know if there's a way to track this, and be able to report on earned CEUs. I thought your mod might do the trick. Do you know of anyone doing something similar? Does this sound feasible?

Thanks!
Tracey

i installed this mod and during check out got this error:

1146 Table 'southbe2_zc03.sc_customers' doesn't exist
in:
[select amount from sc_customers where customers_id = 5]

Can anybody tell me specifically what this is and how to fix it? i am completely illiterate when it comes to all this stuff--i can only follow directions.

Quote:

---

Originally Posted by rlskreftie

i installed this mod and during check out got this error:

1146 Table 'southbe2_zc03.sc_customers' doesn't exist
in:
[select amount from sc_customers where customers_id = 5]

Can anybody tell me specifically what this is and how to fix it? i am completely illiterate when it comes to all this stuff--i can only follow directions.

---

That's rather serious. The RP mod does not alter the customers table (it's a core ZenCart table). It sounds like you need to do a restore from your last backup.

Quote:

---

Originally Posted by rlskreftie

i installed this mod and during check out got this error:

1146 Table 'southbe2_zc03.sc_customers' doesn't exist
in:
[select amount from sc_customers where customers_id = 5]

Can anybody tell me specifically what this is and how to fix it? i am completely illiterate when it comes to all this stuff--i can only follow directions.

---

sc.customers is from the Store Credit module I think. Delete those tables maybe if you are using Reward points instead (I reckon it clashes)

Quote:

---

Originally Posted by HeathenMagic

sc.customers is from the Store Credit module I think. Delete those tables maybe if you are using Reward points instead (I reckon it clashes)

---

Nice catch!

I have a problem i do not know if this can be fixed or not hoping it can be. I'm using the mod price updater. The problem is some of my attributes have different prices, the reward points are not updating to reflect the price change. But it is reflecting the price change in the checkout is there away to get it to reflect the price change on the product info page?

Can be seen Here: http://dealz-r-us.com/index.php?main...&products_id=9

Thank you

I just have a quick question. First of all I love this add on! The question I have is with the earned points showing up during checkout with google. I have been testing in the sandbox to try and work out a couple of other bugs and noticed that the rewards points earned are always 0. Is that simply because I am in sandbox mode, or have I misconfigured something.

I think I should maybe be a little more specific in my question about the Reward Points Module and Google Checkout.

I need to find a way to have google checkout show the reward points earned when customers are completeing checkout. Currently if using the built in cart the rewards work great. When using Google checkout it shows, Rewards earned as 0. When Google Checkout is used there is also no points passed on to admin or anything.

I really need some urgent help with this to see if it can be corrected because I really like the module and hate to remove it.

Thanks for any help you can give me.:lamo:

Quote:

---

Originally Posted by urbdistrib

I think I should maybe be a little more specific in my question about the Reward Points Module and Google Checkout.

I need to find a way to have google checkout show the reward points earned when customers are completeing checkout. Currently if using the built in cart the rewards work great. When using Google checkout it shows, Rewards earned as 0. When Google Checkout is used there is also no points passed on to admin or anything.

I really need some urgent help with this to see if it can be corrected because I really like the module and hate to remove it.

Thanks for any help you can give me.:lamo:

---

There is a zip file a page or so back which now enables Google Checkout for Reward Points (but sadly not PayPal IPN). It will be added to the full contribution the moment I get PayPal working.

Thanks for the quick reply.
I have just downloaded the class zip as suggested. Just one question, where should I place it.

Thanks, :blush:

It goes in includes/classes/observers

Quote:

---

Originally Posted by dscott1966

I have a problem i do not know if this can be fixed or not hoping it can be. I'm using the mod price updater. The problem is some of my attributes have different prices, the reward points are not updating to reflect the price change. But it is reflecting the price change in the checkout is there away to get it to reflect the price change on the product info page?

Can be seen Here: http://dealz-r-us.com/index.php?main...&products_id=9

Thank you

---

Can iget some help with this Question? Has anyone run into this problem.

Quote:

---

Originally Posted by dscott1966

Can iget some help with this Question? Has anyone run into this problem.

---

I'm sorry, I cannot guarantee that the RP mod will work with any other mod that does price changing.

Hi Andy
do you have a time scale for looking at the PayPal part of this module?

thanks

Andy

I too am having problems with this mod not correctly calculating point values.

I want it to calculate based on the subtotal. Good enough and understood how to do that.

The problem comes in when I adjust the "Point Reward Rounding" field in the admin.

If I set it to "0" (no adding before rounding) then the system consistently mis-calculates the reward point total UNDER the amount it should be. This is more evident with larger orders. The larger the order the larger the discrepancy.

Without a doubt this looks to be a problem with the way the Rewards points Rounds numbers to determine how many points to reward.

Is there way in the code to simply look at the SUBTOTAL of the order and drop the decimals then generate points from that?

For example, if the subtotal is $330.00 then the reward points (if 1 point per dollar spent) should be 330.

Currently my system is calculating that at 336 points? Even with no other options (no shipping, no discounts) being used?

I know why it is doing what it is now.

Let me see if I can explain. It DOES have to do with the way the system Loops through the "rounding" portion of the rewards points.

Currently (and in my previous example posted) the system loops PER PRODUCT in the cart.

The problem is that it also loops through and adds the "rounding" portion to each product. What the rounding portion should do is simply round 1 time based on the final order total (either up or down.)

Right?

Let me go back to my previous example and it may seem clearer:

In that example I had 24 products in my cart for a total of $330 (excluding shipping, discounts etc...)

I had the rounding factor (in the admin) set to ".25".

Instead of receiving "330 points" based on the subtotal I got "336" points awarded. This came about because I determined that the system took 24 products and multiplied EACH ONE times "rewards rounding" of .25.

Doing the math you find that 24 x .25 = 6.

Add those 6 points to the 330 subtotal and you get 336. (6 more points than should be awarded).

When I set the rounding factor to "0" or anything less than .25 the system is off in the other direction by that same amount.

It's a calculation problem in the mod apparently.

Does that sound right or am I missing something?

I figured it out.

The problem was that there was a missing parameter in the super_orders_funtctions.php file.

Around lines 409 - 412 you'll find:

PHP Code:

---

  $db->Execute("UPDATE " . TABLE_ORDERS . " SET
                orders_status = '" . $new_status . "'
                WHERE orders_id = '" . (int)$oID . "'");
} 


---

Change that to:

PHP Code:

---

  $db->Execute("UPDATE " . TABLE_ORDERS . " SET
                orders_status = '" . $new_status . "', last_modified = now()
                WHERE orders_id = '" . (int)$oID . "'");
} 


---

And you are all set. This must have been altered in an update release somewhere because it was working in previous versions I had.

Quote:

---

Originally Posted by econcepts

I figured it out.

The problem was that there was a missing parameter in the super_orders_funtctions.php file.

Around lines 409 - 412 you'll find:

PHP Code:

---

  $db->Execute("UPDATE " . TABLE_ORDERS . " SET
                orders_status = '" . $new_status . "'
                WHERE orders_id = '" . (int)$oID . "'");
} 


---

Change that to:

PHP Code:

---

  $db->Execute("UPDATE " . TABLE_ORDERS . " SET
                orders_status = '" . $new_status . "', last_modified = now()
                WHERE orders_id = '" . (int)$oID . "'");
} 


---

And you are all set. This must have been altered in an update release somewhere because it was working in previous versions I had.

---

Forget this post it was supposed to go to the Super Orders thread.

It has nothing to do with this thread.

Quote:

---

Originally Posted by andy

Hi Andy
do you have a time scale for looking at the PayPal part of this module?

thanks

Andy

---

I'll have another go at it in the next couple of days.

Quote:

---

Originally Posted by econcepts

I too am having problems with this mod not correctly calculating point values.

I want it to calculate based on the subtotal. Good enough and understood how to do that.

The problem comes in when I adjust the "Point Reward Rounding" field in the admin.

If I set it to "0" (no adding before rounding) then the system consistently mis-calculates the reward point total UNDER the amount it should be. This is more evident with larger orders. The larger the order the larger the discrepancy.

Without a doubt this looks to be a problem with the way the Rewards points Rounds numbers to determine how many points to reward.

Is there way in the code to simply look at the SUBTOTAL of the order and drop the decimals then generate points from that?

For example, if the subtotal is $330.00 then the reward points (if 1 point per dollar spent) should be 330.

Currently my system is calculating that at 336 points? Even with no other options (no shipping, no discounts) being used?

---

It's on the wishlist (http://www.zen-cart.com/forum/showpo...&postcount=449)

Quote:

---

Originally Posted by hem

It's on the wishlist (http://www.zen-cart.com/forum/showpo...&postcount=449)

---

Thanks Andrew.

I developed a work around using the "round()" function in place of the (int). This built in PHP function automatically rounds my figures for me based on the final order total (other items I setup) and eliminates the need for me to use the "point rounding" factor in the admin config.

This solved my problem and both the rounding and points are right on the mark.

I sent you a PM with more detail.

Quote:

---

Originally Posted by econcepts

Thanks Andrew.

I developed a work around using the "round()" function in place of the (int). This built in PHP function automatically rounds my figures for me based on the final order total (other items I setup) and eliminates the need for me to use the "point rounding" factor in the admin config.

This solved my problem and both the rounding and points are right on the mark.

I sent you a PM with more detail.

---

Replied to PM. Just to clarify for everyone else here:

The issue as I see it is that there looks to be two methods of awarding RP. One is as a fixed number of points per unit of product (which is as the mod stands now). The other is as a number of points based on the total (or subtotal) spend (which is the direction Eric is going).

With this in mind the next release of the RP mod will have a configuration item which will allow users to select their method of reward- Either by Product Unit or by Order Total. The Order Total method will also be able take into account any discounts (and hopefully cover other price changing mods). However it will mean that user will lose the ability to display Reward Points against each product (as it will not be fixed) and also it looks like any Product Group redeems will be lost too (the whole calculation will need to be done on the Global Reward Point Ratio).

That sounds great for me, Hem.
I'm in the same boat as econcepts and most of my customers are getting more points than they should
I'd say this would also fix my problem with the cheap items (less than $0.50) not getting any points :smile:
If I could just award points on the subtotal, after discounts, it would be great. :smile:

v1.20a has been released and uploaded to Contributions.

1.20a:

• Added new Reward Point Mode configuration item to select how points are rewarded.
• Added Reward Point Mode to decide whether points are rewarded by product or by order (sub)total.
• Refreshed screenshots.
• Created global GetRewardPoints function
• Order/Cart handlers added (fixed Google Checkout)
• Fixed Customer Reward Admin not displaying for large number of customers (temporary Fixed)

Arrg.. i just installed version 1.13a this morning :D

Anyway, a question.

At Customers->Group Reward Redeem , there is a way to set the redeem ratio for a group. But is there a way to change the default global redeem ratio ? (instead of using the default 0.01 for everyone)





Using Zen Cart 1.3.8a


Thanks.

Quote:

---

Originally Posted by yonghs

Arrg.. i just installed version 1.13a this morning :D

Anyway, a question.

At Customers->Group Reward Redeem , there is a way to set the redeem ratio for a group. But is there a way to change the default global redeem ratio ? (instead of using the default 0.01 for everyone)





Using Zen Cart 1.3.8a


Thanks.

---

On the same page on the top right hand side there is a box which allows you to set the Global Redeem Ratio

Doesn't seem to be available yet..

Quote:

---

Originally Posted by hem

v1.20a has been released and uploaded to Contributions.

1.20a:

• Added new Reward Point Mode configuration item to select how points are rewarded.
• Added Reward Point Mode to decide whether points are rewarded by product or by order (sub)total.
• Refreshed screenshots.
• Created global GetRewardPoints function
• Order/Cart handlers added (fixed Google Checkout)
• Fixed Customer Reward Admin not displaying for large number of customers (temporary Fixed)

---

Quote:

---

Originally Posted by Asgoroth

Doesn't seem to be available yet..

---

Yeah, I haven't had a "Upload Available" yet. If it's not there by morning I'll post it up on my site.

Quote:

---

Originally Posted by hem

On the same page on the top right hand side there is a box which allows you to set the Global Redeem Ratio

---

:shocking: How did I miss that? .... Thanks. This is the best mod ever!

Quote:

---

Originally Posted by hem

Yeah, I haven't had a "Upload Available" yet. If it's not there by morning I'll post it up on my site.

---

Okay, it's still not up. You can load it from here:

ZenCart Reward Points Mod

I'll remove it once the contribution is official posted.

Just updated to your latest version and had a very quick play and it seems good :clap: It even rewards points for my cheapy items, where it wasn't before.
Thanks AGAIN for the work you've put into this, Andrew! It was already a great mod IMO and now it's even better :bigups: