Reward Points Module for ZC v13x

kenwahl:

I'm having a problem with this module that I haven't seen anyone post here. My site accepts both Authorize.net and Google Checkout. If they try to checkout via Google Checkout they are being billed for the rewards points they earn on that purchase. If they earn 10 rewards points for the purchase they are billed $10 that shows up in google checkout as a product. The module works fine via Authorize.net.

I've included a picture of it in google checkout.

Thanks
Ken

Somehow the Google Checkout mod is passing the "information line" regarding the Reward Points earned on the order- even though it does not affect the order total- I'll look into it- Thanks for the feedback.

hem:

I have coded in the Attributes function but was not going to go live with it until I resolved the PayPal problem...

One question to those who have been testing the mod with PayPal- Am I right in thinking that the problem only occurs with PayPal IPN? The other two PayPal methods should work okay.

Paypal IPN is all that we use, so I have no idea about the other methods.

Andrew,

I just use the Paypal IPN. :P

Hope you can fix the problem soon :D

hem:

Somehow the Google Checkout mod is passing the "information line" regarding the Reward Points earned on the order- even though it does not affect the order total- I'll look into it- Thanks for the feedback.

Thanks for your assistance. I'll look forward to the fix.

Ken

Well I've found the problem with the PayPal IPN module- It "breaks" the checkout_process function and therefore a number of notifiers are not called- Including the one I hook to which records the number of Reward Points earned. I'm going to post a message to the Code Errors forum and see if this is correct behavior- Otherwise I'm going to have to look for another notifier to hook to.

hem:

Well I've found the problem with the PayPal IPN module- It "breaks" the checkout_process function and therefore a number of notifiers are not called- Including the one I hook to which records the number of Reward Points earned. I'm going to post a message to the Code Errors forum and see if this is correct behavior- Otherwise I'm going to have to look for another notifier to hook to.

I guess thats half the probloem solved..? at least you now know what the problem is, next battle is solving it..!! :lookaroun Good Luck..!

the problem im having is that onthe product page rewards points is showing up twice. Can someone lead me in the right way to fix this.

Can be seen here: http://advecomsolution.com/index.php?main_page=product_info&cPath=1_2&products_id=5

Thank you

dscott1966:

the problem im having is that onthe product page rewards points is showing up twice. Can someone lead me in the right way to fix this.

Can be seen here: http://advecomsolution.com/index.php?main_page=product_info&cPath=1_2&products_id=5

Thank you

Strange- I only see it once here- in both Firefox and IE.

Im sorry i fixed it, i had it twice in the tpl_product_display file. Thank you for your response.

I have been having the same issue as KENWAHL , so while trying to trouble shoot on my "test" shop I decided to remove the mod from my "live" shop untill fixed. Here is where I have my NEW problem... I am unable to remove the mod with the uninstall sql
I get the following when trying to uninstall

1146 Table 'nitroshop_zc1.configuration' doesn't exist
in:
[DELETE IGNORE FROM configuration WHERE configuration_group_id=@group_id;]
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.

nitroshop_zc1 (not real name but is my sql db)

Hi there,

I just installed your Reward module. And when i goto order total mods, and choose reward points but there is no where to set the redeem ratio.

Any help at all?

What there is:

The module is installed :
TRUE

Sort order:
900

giftsbyevy:

Hi there,

I just installed your Reward module. And when i goto order total mods, and choose reward points but there is no where to set the redeem ratio.

Any help at all?

What there is:

The module is installed :
TRUE

Sort order:
900

As per the readme.txt:

8. You can set global and group Reward Point redeem ratios using Admin->Customer->Group Reward Redeem

just installed Reward Points and all works fine, BUT...
after setting up Paypal Express checkout i get the following error after clicking the Express button when not logged in:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ((prp.scope_id= AND prp.scope=4) OR (gp.group_id=c.customers_group_prici' at line 5
in:
[SELECT redeem_ratio FROM zen_reward_master prp, zen_customers as c LEFT JOIN(zen_group_pricing as gp) ON (gp.group_id=c.customers_group_pricing) WHERE c.customers_id= AND ((prp.scope_id= AND prp.scope=4) OR (gp.group_id=c.customers_group_pricing AND prp.scope_id=gp.group_id AND scope=3) OR (prp.scope=0)) ORDER BY prp.scope DESC LIMIT 1;]

is if there is a way to fix this problem...?

hem:

Well I've found the problem with the PayPal IPN module- It "breaks" the checkout_process function and therefore a number of notifiers are not called- Including the one I hook to which records the number of Reward Points earned. I'm going to post a message to the Code Errors forum and see if this is correct behavior- Otherwise I'm going to have to look for another notifier to hook to.

Hey Andrew,

Any luck with this yet ? Bit of a pain in the #$% having to go through and manually add points to customers who checkout via PayPal..

Thanks,
Mike

Hi there,

I just installed your Reward module. It's very nice mod, thank you.

I hope for the following content.
When the customer uses "Reward Points", the amount of money subtracted by the "Reward Points" wants to make it not added to "Reward Points".

Any help at all?
Sorry my poor english...:blush:

Just me again
I love the mod and it's working excellent now
Where do I set the value
When I go to redeem my points there value is $0.00 please help
Thanks
Emma

Mike, turns out the problem is at PayPals end. Check out:

http://www.theregister.co.uk/2008/05/17/paypal_ipn_meltdown/

The pain in the ###### is I spent over a week trying to debug the problem. So now I'm leaving it until PayPal sort their code out and if the problem persists then I will revisit.

user2345:

just installed Reward Points and all works fine, BUT...
after setting up Paypal Express checkout i get the following error after clicking the Express button when not logged in:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ((prp.scope_id= AND prp.scope=4) OR (gp.group_id=c.customers_group_prici' at line 5
in:
[SELECT redeem_ratio FROM zen_reward_master prp, zen_customers as c LEFT JOIN(zen_group_pricing as gp) ON (gp.group_id=c.customers_group_pricing) WHERE c.customers_id= AND ((prp.scope_id= AND prp.scope=4) OR (gp.group_id=c.customers_group_pricing AND prp.scope_id=gp.group_id AND scope=3) OR (prp.scope=0)) ORDER BY prp.scope DESC LIMIT 1;]

is if there is a way to fix this problem...?

What version of MySQL are you using???

Any ideas on the Google Checkout problem? I'm unable to use Google Checkout until it's fixed. Also, if your not going to be working the Paypal issue can you release the attribute fix?

Thanks

Ken

kenwahl:

Any ideas on the Google Checkout problem? I'm unable to use Google Checkout until it's fixed. Also, if your not going to be working the Paypal issue can you release the attribute fix?

Thanks

Ken

I'll move that one to the top of the pile :smile: