Reward Points Module for ZC v13x

Rasyr:

Looks like you found your own answer to the question.

If you go to the Group Rewards Redeem, you can set a Redeem ratio for the entire store (i.e. you can set it to zero.

You can also set the redeem ration for special groups as well.

I don't think that there is any way to turn off the award of points to everybody, but you can set it so that they cannot redeem them for anything unless they are part of a group.

Hi - thanks for your response. So everyone sees the points accumulate but (if the settings are such) they can't participate unless they join, correct? That might be an option. I wonder, however, if it would be an enticement or an annoyance.

To be sure I understand, using the Group Reward Points Redeem it would be possible to offer a group that gets a discounted price across the board (using the existing Zen discount mod) Plus a Redeem ratio that is better than the rest of the store, correct?

If I am understanding what your saying, then the answer is yes (I think).

(I am not sure if the Group Reward Redeem groups are related to Group Pricing that is standard in Zen Cart or not).

I have exhausted my abilities to correct this, so far i have only found it on my log in page. I don't have many contributions installed.

Here is the error I am getting.

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_pricin' 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;]

For now I am going to uninstall this contribution... I really want to use it as I have quite a few return customer's.

Thanks in advance. Michelle

hi, andrew

Today I installed a new 138a zen-cart and your rewards add on.
Here is my experience:

1. install is easy and no error found.

2. if using bank or check payment to check out, well done. No error found.

3. if using paypal to check out, bug found.
   a) Customer pay via paypal without using reward point, the order is going well. Customer received order confirm email, just NO pending point in his account. I have to add point to his account manually.

b) After I manually add 100 point to his account. The customer place a new order, use the 100 point to check out via paypal. the order is going well, but both the customer and admin can not receive the order confirm email. Still no pending point.

Conclusion:
using paypal to check out, no pending points.
using paypal and points to check out, no pending points and no order confirm Email.

I have two paypal accounts, so I can test it myself.
If someone have the same paypal problem, please post here.

I hope these infomation is helpful and thanks for your work.:smile:

I also had a customer spend Reward Points (paying via Paypal - Transaction Type = unique) along with using a coupon and using a Gift Certificate.

Paypal returned him to our store
He received no confirmation email
He did not receive any Reward Points for the purchase.
His Gift Certificate Account was NOT updated to relfect the GC that he used.

Note: If the customer has a transaction type of "web_accept", things seem to work properly.

We went live with the rewards program last night and have had 2 orders placed using PayPal, and both have gone through smoothly.. (Fingers crossed this continues....)

Will see what happens when the same customer uses their reward points on a new order..

Mike_Dean:

We went live with the rewards program last night and have had 2 orders placed using PayPal, and both have gone through smoothly.. (Fingers crossed this continues....)

Will see what happens when the same customer uses their reward points on a new order..

Ok.. False alarm..

Edit.. The emails went through with confirmations etc, but the points did not get allocated and they are not showing as earned or pending ?

And in Admin the points are not showing either.. I have to manually allocate them

Mike_Dean:

Ok.. False alarm..

Edit.. The emails went through with confirmations etc, but the points did not get allocated and they are not showing as earned or pending ?

And in Admin the points are not showing either.. I have to manually allocate them

customer will receive the order confirmation Email in the first time, because they didn't use the points. (They don't have the points to use)
In the second order (admin add pointd to his account), if they use the point to check out via paypal, they won't receive the confirmation Email.

Hi

Had similar and it turned out to be an SQL DB problem. Delete all the tables related to the rewards program. Leave all the other files in place. Rerun the sql script. Fixed it for us

Hope this helps

grannysantiques:

I have exhausted my abilities to correct this, so far i have only found it on my log in page. I don't have many contributions installed.

Here is the error I am getting.

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_pricin' 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;]

For now I am going to uninstall this contribution... I really want to use it as I have quite a few return customer's.

Thanks in advance. Michelle

In Admin-->Catalog-->Reward Points, how do I set the Bonus? AlsoHow can I create a multiplier? for example, I decide to be totally generous today and points are worth 10x thier value

Mike_Dean:

We went live with the rewards program last night and have had 2 orders placed using PayPal, and both have gone through smoothly.. (Fingers crossed this continues....)

Will see what happens when the same customer uses their reward points on a new order..

Can you check the order and see what the transaction type is? Is either "unique" or are both "web_accept"?

melm81:

In Admin-->Catalog-->Reward Points, how do I set the Bonus? AlsoHow can I create a multiplier? for example, I decide to be totally generous today and points are worth 10x thier value

Under Admin|Catalog|Reward Points you can set the number of points that the customer receives for each dollar (or base monetary unit that you use) spent. This can be done on a Global basis or by product Category or by Individual Product.

For example, on my store, customers receive 2 points for every dollar spent on everything except Gift Certificates and one category of books. The Gift Certificate gives zero points, and the one category of books gives 6 RP per dollar spent.

To set what the Reward Points are redeemed at, go to Admin|Customers|Group Reward Redeem and set the value in the box on the right.

For example, my store is set to redeem 1 Reward Point for a value of 1 penny off the price of an item.

I hope that this answers your questions...

but nothing shows in the "Bonus" column. Am I missing something?

Rasyr:

Can you check the order and see what the transaction type is? Is either "unique" or are both "web_accept"?

Both are unique.

Are people still having an issues with RP when paid via PayPal ?

melm81:

but nothing shows in the "Bonus" column. Am I missing something?

I think that the Bonus column (on the page under Admin|Catalog|Reward Points) is for a future enhancement. Right now there is nothing that touches that. All you need to worry about is your Ratio column.

Mike_Dean:

Both are unique.

Are people still having an issues with RP when paid via PayPal ?

Yes, and it seems to happen when the Transaction Type is "unique". Paypal purchases with a transaction type of "web_accept" seem to work ok.

Andrew IS working on this issue. In the meantime, you just need to manually enter points (which is what I do).

Rasyr:

I think that the Bonus column (on the page under Admin|Catalog|Reward Points) is for a future enhancement. Right now there is nothing that touches that. All you need to worry about is your Ratio column.

That is correct.

melm81:

In Admin-->Catalog-->Reward Points, how do I set the Bonus? AlsoHow can I create a multiplier? for example, I decide to be totally generous today and points are worth 10x thier value

Sorry- you will have to do it manually. There is a Campaign addon on the wishlist which will allow this.

Sorry- I haven't been ignoring you lot- The other side of my job kicked in and I've been out on travels but I'm back now.

Top priority is to get to the bottom of the PayPal issue. I don't understand why the transaction type would affect how PayPal IPN redirects back to checkout_process.php. It's also interesting that GVs are also affected. I'm guessing that what ever the problem is it is affecting all the credit mods- I should have a better read this afternoon- I have just completed setting up my test rig with PayPal's Sandbox...

Watch this space.

Hi,

Tried to install the reward points module today, but when I turned the sideboxes on, all my website pages went blank below the logo/header section. Everything comes back again when I turn both sideboxes off again. Also, on Configuration > Reward Points I get the following warning:

Warning: call_user_func(UseRewardPointStateFunction) [function.call-user-func]: First argument is expected to be a valid callback in .......store/admin/includes/functions/general.php on line 1544

Please help!!!!!!!!!!!!!!!

MoonCow
https://www.cardcarousel.co.uk/store