Reward Points Module for ZC v13x

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:

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.

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

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:

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/showpost.php?p=605598&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

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

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:

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/attachment.php?attachmentid=4531&d=1221258768

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

Einstin:

Andrew,
Tried the new class files posted at http://www.zen-cart.com/forum/showpost.php?p=605598&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

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

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.

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.