Zen Cart Logo
Forums / All Other Contributions/Addons / Reward Points Module for ZC v13x

Reward Points Module for ZC v13x

Locked

Views: 470,584

Results 241 to 260 of 2,476
This thread is locked. New replies are disabled.
5 Jun 2008, 8:35 AM
#241
hem avatar

hem

Totally Zenned

Join Date:
Sep 2007
Location:
Dublin, Ireland
Posts:
1,281
Plugin Contributions:
5

Reward Points Module for ZC v13x

nicholas84:

Hi Hem
could you help me solve my problem?
i've installed your mod
but once i switch on the sidebar it will disappear
when customer checkout, they do not have the point redemption line
but they could still faithfully collect points
pls assist
thanks

Nicolas- if you PM me your URL I'll take a look at it.

6 Jun 2008, 3:43 AM
#242
dscott1966 avatar

dscott1966

Zen Follower

Join Date:
Apr 2005
Posts:
298
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

Help is needed i just installed the new module and im getting errors in the admin

  1. First error under admin>configurations>reward points: The error that im getting is this:

Fatal error: Call to undefined function SetRewardPointStateFunction() in /home/dscott19/public_html/dealz-r-us/admin/configuration.php(192) : eval()'d code on line 1

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

  1. The second error under admin>catalog>reward points: The error that im getting is this:

Fatal error: Call to undefined function getrewardpointrecord() in /home/dscott19/public_html/dealz-r-us/admin/reward_points.php on line 125

  1. The third error under admin>customers>reward points: The error that im getting here is:

Fatal error: Call to undefined function cleanuprewardpointhistory() in /home/dscott19/public_html/dealz-r-us/admin/customers_reward_points.php on line 25

  1. The fourth error under admin>customers>group reward redeem: The error that im getting here is:

Fatal error: Call to undefined function getrewardpointrecord() in /home/dscott19/public_html/dealz-r-us/admin/group_reward_points.php on line 132

and the last thing is it should work with attributes to update if you have attributes with prices it does not do it.

Please help me to figure this out. thank you

6 Jun 2008, 6:35 AM
#243
mineralicious avatar

mineralicious

New Zenner

Join Date:
Jun 2008
Posts:
20
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

I am getting the following error messages when trying to run the SQL update

1062 Duplicate entry '0-0' for key 2
in:
[INSERT INTO zen_reward_master (rewards_products_id ,scope ,scope_id ,point_ratio ,bonus_points, redeem_ratio, redeem_points) VALUES (NULL , '0', '0', '1.0000', NULL, 0.01, NULL);]
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.

Can someone translate this into ZenNewbie please? :) TIA!

6 Jun 2008, 8:49 AM
#244
hem avatar

hem

Totally Zenned

Join Date:
Sep 2007
Location:
Dublin, Ireland
Posts:
1,281
Plugin Contributions:
5

Re: Reward Points Module for ZC v13x

dscott1966:

Help is needed i just installed the new module and im getting errors in the admin

  1. First error under admin>configurations>reward points: The error that im getting is this:

Fatal error: Call to undefined function SetRewardPointStateFunction() in /home/dscott19/public_html/dealz-r-us/admin/configuration.php(192) : eval()'d code on line 1

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

  1. The second error under admin>catalog>reward points: The error that im getting is this:

Fatal error: Call to undefined function getrewardpointrecord() in /home/dscott19/public_html/dealz-r-us/admin/reward_points.php on line 125

  1. The third error under admin>customers>reward points: The error that im getting here is:

Fatal error: Call to undefined function cleanuprewardpointhistory() in /home/dscott19/public_html/dealz-r-us/admin/customers_reward_points.php on line 25

  1. The fourth error under admin>customers>group reward redeem: The error that im getting here is:

Fatal error: Call to undefined function getrewardpointrecord() in /home/dscott19/public_html/dealz-r-us/admin/group_reward_points.php on line 132

and the last thing is it should work with attributes to update if you have attributes with prices it does not do it.

Please help me to figure this out. thank you

This looks like you are missing the admin/includes/functions/extra_functions/reward_points_functions.php file

6 Jun 2008, 8:57 AM
#245
hem avatar

hem

Totally Zenned

Join Date:
Sep 2007
Location:
Dublin, Ireland
Posts:
1,281
Plugin Contributions:
5

Re: Reward Points Module for ZC v13x

Mineralicious:

I am getting the following error messages when trying to run the SQL update

1062 Duplicate entry '0-0' for key 2
in:
[INSERT INTO zen_reward_master (rewards_products_id ,scope ,scope_id ,point_ratio ,bonus_points, redeem_ratio, redeem_points) VALUES (NULL , '0', '0', '1.0000', NULL, 0.01, NULL);]
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.

Can someone translate this into ZenNewbie please? :) TIA!

This is because ZenCart does not handle the MySQL directive "IGNORE" which tells MySQL to continue processing further commands even if there's an error (in this case trying to INSERT another 'Global' record).

Try the attached version instead.

6 Jun 2008, 3:19 PM
#246
kenwahl avatar

kenwahl

New Zenner

Join Date:
Feb 2008
Posts:
32
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

I have customers getting the following error when they try to checkout using their reward points.

Fatal error: Call to undefined function get_order_total() in
/home2/paw10000/public_html/includes/modules/order_total/ot_reward_points.php
on line 55

That function exists in ot_reward_points.php but errors off anyway.

Thanks
Ken

This is using the new version

6 Jun 2008, 6:04 PM
#247
dscott1966 avatar

dscott1966

Zen Follower

Join Date:
Apr 2005
Posts:
298
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

Hem,

I just went through the install all over again and it is the same thing as in post above i do have the reward_points_functions.php file there. Is there anything else i can try or look at.

I also noticed in admin>config>reward points that when i click on reward points status track i get this

Fatal error: Call to undefined function SetRewardPointStateFunction() in /home/dscott19/public_html/dealz-r-us/admin/configuration.php(192) : eval()'d code on line 1

Could that be causing the problem.

6 Jun 2008, 9:39 PM
#248
mineralicious avatar

mineralicious

New Zenner

Join Date:
Jun 2008
Posts:
20
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

hem:

This is because ZenCart does not handle the MySQL directive "IGNORE" which tells MySQL to continue processing further commands even if there's an error (in this case trying to INSERT another 'Global' record).

Try the attached version instead.

Thank you for all of your help Andrew. I am getting this message now when running the quick update version:

1146 Table 'min0815405174657.reward_master' doesn't exist
in:
[ALTER IGNORE TABLE reward_master ADD redeem_ratio DOUBLE( 15, 4 ) NULL;]
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.

6 Jun 2008, 11:54 PM
#249
nev avatar

nev

New Zenner

Join Date:
Nov 2007
Location:
Canada
Posts:
49
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

Hi Andrew it’s good to have you back. I figured you were busy so didn’t want to drop a whole bunch of stuff on you in one shot.

Thanks for fixing the loop with the points/redeem ratio fields.

Have you had a chance to give the two issues I raised in that post a thought?

http://www.zen-cart.com/forum/showthread.php?p=563445#post563445

the option for opt-in for the points program, if a store owner wants to enable it, and the point summary on the separate page in the my accounts. Any chance of this?

**Here is one more issue/question **

Would it be possible to program it so that transaction amount that was paid with the points doesn’t bring you any points? You only receive points on the part of the transaction (if there is any) that was actually paid for.

In a general situation (1$=1point - 1 point = .05$) it won’t bankrupt the store, but it’s just more what consumers are used to. It will bring you to about 0.52$ per point value when you include the points received by paying with points.

However if you plan on running any type of promotion it will end up costing.

Typical promotion would be example: Shop with us on June 29 and receive triple points on your purchase.

Such a promotion is geared to increase “real” sales. Giving the customer an incentive to shop on that day for a bonus.

Now you have a customer who collected 1000 points and they are worth 50$. He makes a 50$ purchase pays with points and collects 150 points (the value would be 7.5$ at your normal conversion of .05$ per point). Significantly increasing the conversion rate of his original points, without bringing any additional revenue to the store.

I collect/use points all the time. Granted mine are mostly all converted into one of 3 airline point programs, but it doesn’t matter. When I travel using the points then I don’t receive any on that trip.

Wish list

I like the groups, but at the moment if I want to create a tiered use of it it’s not really possible to implement.

So here is some thought for some additional options

Let say you want to create 3 classes of points /customers based on over the year total purchases.

So you create Premier $0 to $999, Elite $1,000 to $2,999 Platinum $3,000 and over (you can set up as many tiers as you think your business needs I figure 3 -4 is usually the max, more than that is confusing)

The figures are determined/set up by the store owner.

The idea here is that when a customer fulfills that requirement he/she jumps to the next tier, automatically. (a message to the admin would be nice so that the admin can use the opportunity to contact the customer and advise of the change of status, encouraging additional purchases)

Now ideally the difference between tiers would be in the amount of points collected. Premier would collect 1 point for 1$ (global setting) Elite 1.5 for 1$ (global x 1.5) and Platinum 2points for 1$ (global x2) (again determined by the admin) So the more you spend the more you get back.

Now in the groups as it is now it’s the redeem ratio that changes, so if you use increased redeem ratios to reward that would mean that if you earned the first 1000 points as a Premier client if you jump Tiers then those points already earned are worth more. Which is not bad in some situations, but not quite the idea here. i.e. a customer could earn 1000 points in a year.. jump tiers and now redeem them all at the higher redeem ratio without making additional purchases.

What you want in this situation is to have the redeem ratio stay the same. Just the opportunity for the customer to earn more points per $ spent. (and encourage him/her to reach the next level)

Now there are reasons to have both the earning per point tiers groups and the redeem ratio group. They can be combined for special members. They would get bumped up in tiers depending on spending but their points would always be worth more (on in some cases that I cant think of right now less) because if their special status.

The tier group setting could be set up like I put above on a multiplication of global. So tier one is global, tier 2 is global X 1.5 or what ever you want it to be for that tier increase. Not sure how complicated it is to build in the calculation of total purchases by customer for the previous year or 2 year period, so the customer can jump tiers automatically.

As i said wish list, but i think it would be a great addition and a nice incentive to customers. Any thoughts or questions? i'd like to hear what you think and if it's possible.

thanks
nev

7 Jun 2008, 12:47 AM
#250
kenwahl avatar

kenwahl

New Zenner

Join Date:
Feb 2008
Posts:
32
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

kenwahl:

I have customers getting the following error when they try to checkout using their reward points.

Fatal error: Call to undefined function get_order_total() in
/home2/paw10000/public_html/includes/modules/order_total/ot_reward_points.php
on line 55

That function exists in ot_reward_points.php but errors off anyway.

Thanks
Ken

This is using the new version

Hem

I replaced includes/modules/order_total/ot_reward_points.php with the one in version 11a and it works fine. So it has something to do with your changes to the file in version 12a.

Thanks
Ken

7 Jun 2008, 8:37 PM
#251
dscott1966 avatar

dscott1966

Zen Follower

Join Date:
Apr 2005
Posts:
298
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

As stated in post #242 there is something wrong. I did a clean install of zencart and this was the only mod that i have installed on it and im getting the same errors on it as stated in post #242.

How do i go about fixing those errors in the admin can someone give me a little insight on this.

8 Jun 2008, 9:49 PM
#252
hem avatar

hem

Totally Zenned

Join Date:
Sep 2007
Location:
Dublin, Ireland
Posts:
1,281
Plugin Contributions:
5

Re: Reward Points Module for ZC v13x

kenwahl:

I have customers getting the following error when they try to checkout using their reward points.

Fatal error: Call to undefined function get_order_total() in
/home2/paw10000/public_html/includes/modules/order_total/ot_reward_points.php
on line 55

That function exists in ot_reward_points.php but errors off anyway.

Thanks
Ken

This is using the new version

I think I've got a handle on what's causing it- I'll code up a new version in the morning.

8 Jun 2008, 9:56 PM
#253
hem avatar

hem

Totally Zenned

Join Date:
Sep 2007
Location:
Dublin, Ireland
Posts:
1,281
Plugin Contributions:
5

Re: Reward Points Module for ZC v13x

nev:

Hi Andrew it’s good to have you back. I figured you were busy so didn’t want to drop a whole bunch of stuff on you in one shot.

Thanks for fixing the loop with the points/redeem ratio fields.

Have you had a chance to give the two issues I raised in that post a thought?

http://www.zen-cart.com/forum/showthread.php?p=563445#post563445

the option for opt-in for the points program, if a store owner wants to enable it, and the point summary on the separate page in the my accounts. Any chance of this?

Yep- they are on the wishlist.

nev:

**Here is one more issue/question **

Would it be possible to program it so that transaction amount that was paid with the points doesn’t bring you any points? You only receive points on the part of the transaction (if there is any) that was actually paid for....

That one's on the next update.

nev:

Wish list

I like the groups, but at the moment if I want to create a tiered use of it it’s not really possible to implement...

It should be easy enough to do- It could be added to the Group Redeem- We could set up special groups with membership criteria.

9 Jun 2008, 9:28 AM
#254
hem avatar

hem

Totally Zenned

Join Date:
Sep 2007
Location:
Dublin, Ireland
Posts:
1,281
Plugin Contributions:
5

Re: Reward Points Module for ZC v13x

hem:

I think I've got a handle on what's causing it- I'll code up a new version in the morning.

Here's a new version of the ot_reward_points.php- copy it to includes\modules\order_total- It will be in the next mod.

9 Jun 2008, 10:11 AM
#255
hem avatar

hem

Totally Zenned

Join Date:
Sep 2007
Location:
Dublin, Ireland
Posts:
1,281
Plugin Contributions:
5

Re: Reward Points Module for ZC v13x

Here's a new version of the ot_reward_points_display.php- This should sort out the Google Checkout problem. Again copy it to includes\modules\order_total.

9 Jun 2008, 2:18 PM
#256
hem avatar

hem

Totally Zenned

Join Date:
Sep 2007
Location:
Dublin, Ireland
Posts:
1,281
Plugin Contributions:
5

Re: Reward Points Module for ZC v13x

hem:

Here's a new version of the ot_reward_points.php- copy it to includes\modules\order_total- It will be in the next mod.

Let's try that again...

10 Jun 2008, 1:49 AM
#257
kenwahl avatar

kenwahl

New Zenner

Join Date:
Feb 2008
Posts:
32
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

hem:

Let's try that again...

Thanks Hem this version of ot_reward_points.php works great.

Ken

10 Jun 2008, 1:57 AM
#258
dscott1966 avatar

dscott1966

Zen Follower

Join Date:
Apr 2005
Posts:
298
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

Hem,

everything is fine, except one thing when i do a test purchase and the points are pending, when i do the status change they just stay in pending it does not upate and send them to earned. i tried advance and simple.

how do i correct this?

Also is there away to give reward points for new sign up.

10 Jun 2008, 2:02 AM
#259
kenwahl avatar

kenwahl

New Zenner

Join Date:
Feb 2008
Posts:
32
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

hem:

Here's a new version of the ot_reward_points_display.php- This should sort out the Google Checkout problem. Again copy it to includes\modules\order_total.

Thanks Hem

This version of ot_reward_points_display.php greatly improves its working with Google checkout. Below is an image of Google checkout now using the new php.

It now calculates $0 for the points but doesn't show any earned. Also doesn't seem to award them any points (I have it set to award on Google New, Google Processing and Earned on Google Shipped) but shows correct amount earned on invoice in ZenCart. I can manually give them their points for now though.

Thanks
Ken

10 Jun 2008, 8:15 AM
#260
hem avatar

hem

Totally Zenned

Join Date:
Sep 2007
Location:
Dublin, Ireland
Posts:
1,281
Plugin Contributions:
5

Re: Reward Points Module for ZC v13x

kenwahl:

Thanks Hem

This version of ot_reward_points_display.php greatly improves its working with Google checkout. Below is an image of Google checkout now using the new php.

It now calculates $0 for the points but doesn't show any earned. Also doesn't seem to award them any points (I have it set to award on Google New, Google Processing and Earned on Google Shipped) but shows correct amount earned on invoice in ZenCart. I can manually give them their points for now though.

Thanks
Ken

Ken- that's as it should be. I've passed a 0 value to the reward_points_display. I'm going to talk to the author of the Google Checkout mod and see if we can't remove it from the actual checkout, but for now at least it is not coming up as a chargeable item.

As for the points not being awarded- As the points are calculated off of your order there should not be any difference. The reward_point_display mod is just that- a display mod and none of the values calculated are used anywhere else.