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 221 to 240 of 2,476
This thread is locked. New replies are disabled.
29 May 2008, 3:59 AM
#221
superprg avatar

superprg

Totally Zenned

Join Date:
Feb 2006
Location:
Chicago
Posts:
1,349
Plugin Contributions:
0

Reward Points Module for ZC v13x

Hi
I already have "Reward Points Module"
http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=911
Can I go ahead with " Reward Point Full Suite"?
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_60&products_id=1002

Please let me know if there would be any problems

29 May 2008, 4:17 AM
#222
superprg avatar

superprg

Totally Zenned

Join Date:
Feb 2006
Location:
Chicago
Posts:
1,349
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

Please ignore prev message, I cant edit

Hi
I already have this "Store Credits and Rewards Points Module" installed
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_48&products_id=501
Store Credits and Rewards Points Module

Can I go ahead with " Reward Point Full Suite"?
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_60&products_id=1002

Please let me know if there would be any problems

29 May 2008, 7:40 AM
#223
seamstobesew avatar

seamstobesew

Zen Follower

Join Date:
Nov 2005
Location:
Germany
Posts:
110
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

So even tho mod installed properly, it won't run on mysql less than version 4.2...

My host won't upgrade to 4.2, they use to offer mysql 5 servers but are now out of space with them, so consequently because my version is Database: MySQL 4.1.21, I am out of luck getting the mod to work properly with the problem:

Current Reward Points:
1150 points earned

Value of Redeemed Reward Points:
$0.00

Redeem Reward Points:

(not checked yet)

on the cart redeem.

Is it possible to leave this installed so people can at least earn there points until I can figure out how to get host to upgrade mysql to higher versions.. (I'm sure I'm out of luck, I've used this host for well over two years with no problems, I'm not about to change hosts for an addon), so possibly I can be hopeful they will someday offer mysql 5 again.

29 May 2008, 7:43 AM
#224
seamstobesew avatar

seamstobesew

Zen Follower

Join Date:
Nov 2005
Location:
Germany
Posts:
110
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

As a tip, possibly you should note that on the downloads page as I would have checked my database version before installing this mod. As it is, I can't find anywhere that it says that even in the instructions.

29 May 2008, 8:59 AM
#225
nev avatar

nev

New Zenner

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

Re: Reward Points Module for ZC v13x

First Andrew let me say thanks you for this contribution. I was desperately looking for it in November and there was nothing.

It installed without any problems, on a cart with quite a few mods already on it. The only little problem was the missing <?php tag at the beginning of the admin/includes/languages/english/extra_definitions/reward_points_definitions.php, that was preventing the display of proper titles in admin.

I’ve run it through quite a bit of combinations, options and tests to see how it works. And I have a few things to report.

Bug(s):

Sorry found one. :blush:

I think I know why there have been a few post about the value of the points showing 0$
And why Mike Dean seems to have this resetting itself.

Originally Posted by Mike_Dean> Originally Posted by hem

Your redeem ratio was set to 0- re-installing the mod just reset the ratio back to the default (0.01). And yes the points will be removed from the earned as you had ticked the box.
Ok.. I clearly have a gremiln.. I have not touched or installed anything and now I have this issue again. (Rapidly removing hair..!!!)

I checked the ot_rewards_points and nothing seems to be amiss.

I even copied the original across and no change..

Where do I set (re-set) the ratio ?

When you go to admin/Catalog/Reward points and change the Set Global Reward Point ratio (in either fields), or even just press 'Update' it ERASES the value set in Customers/Group Reward Points Redeem - Enter global points ratio. It does NOT erase the Group points ratio if you have any groups set up just the Global.

As soon as you enter a value into “Enter global points ratio” it resets the Set Global Reward Point ratio to the default 1.000. So you have a circular problem.

(I was trying to test a promo option of double points on purchases on a particular date so I was fiddling with the Global Reward Point ratio in the Catalog.)

I have no idea why this I happening just that it is. And it could explain why some people were reporting the point values being reset to 0$.

**Check out problem **

Using the points on with Virtual Merchant doest completely work.
So I had 20$ worth of points in the account. I purchased a 10$ GV so no tax no shipping, a straight out 10$ transaction. It would not let me check out without providing a CC number.

Now it did set the total amount of the transaction to 0$

My VM processing log shows that the Cart did make a request for approval of 0$ and received an approval (authorization code) for 0$. If you are paying a .25$ .30$ transaction fee .. that will cost you. But more than that the customer doesn’t want to have to enter a CC number when the transaction is free.

I can put you in touch with Todd who has been working on the VM payment module so maybe you guys can figure out why it’s this is happening. PM me for this.

Issue(s)

First one was raised in this post.

Originally Posted by hem

Originally Posted by MeltDown
If global redeem is set to zero will non-club members still be able to see the reward points listed per item or no?

No- they will just see 0 reward points per product

This is not correct. If global redeem is set to zero non-club members WILL still be able to see the reward points listed per item. They WILL get points assigned to them. The WILL show in My Account / Reward Points Summary (unless you manualy delete them) they WILL show in the check out Step 2 Screen they will just show a Value of Redeemed Reward Points: as 0$.

So the way the mod is set up now it’s “all or nothing” i.e. either all your customers are part of the program or you run a risk of a some very p*ssed off people.

You know how it goes. It will be: “But I saw/see the points. I was sure I subscribed/applied whatever to the rewards program.” So you are either willing to let them be mad or you are willing to say .. Ok Sir/Madam I will “activate” your rewards program and the points you have accumulated.

It would be nice to have an option to activate an Opt in for the points same as the Newsletter (it can be mentioned in the Welcome e-mail as an offer) that way you give people an option. This gives an illusion of exclusivity to the program; you can have a separate Newsletter for Reward members and so on. Gives a feeling of “I’m special” I get a better deal because I’m a “member”

I said an option (in admin to activate) Opt in since I see from some posts that some people are happy with all the customers being awarded points. And that is what suits their needs. The marketing strategy on this is highly dependent on the type of store and product and service you offer.

Issue 2:

Would it be possible to move the Rewards Point Summary from ‘View or change my account information’ to its own link in the My Accounts. The GV notification is on the Main page of ‘My Account’, so you have an expectation of at least some reference to the Rewards Program on the same page – like a link. My first reaction was ‘Ohh they are not here’ then some clicking in the attempt to find them. None of the links seemed like the right place to go. So I know the customers will look too.

Not on the main page like the GV. If you have a few orders in history it becomes too long/messy. I wish the GV information was on its own page.

Anyway, this is my novela for the night.:blush:

And thank you again for all the work on this great mod, it very much appreciated.

nev

29 May 2008, 9:22 AM
#226
nicholas84 avatar

nicholas84

New Zenner

Join Date:
May 2008
Posts:
5
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

Hello
I've just installed this module, the system is working fine but the sideboxes are just not cooperating
When i switch on the reward sideboxes it will blank my whole right side bar
Pls advice

29 May 2008, 8:13 PM
#227
tbaquatics avatar

tbaquatics

New Zenner

Join Date:
Jan 2008
Posts:
72
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

I am getting the following under customer reward points:

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 'SELECT SUM(rp.reward_points) FROM zen_reward_status_track rp WHERE cp.customers_' at line 1
in:
[UPDATE zen_reward_customer_points cp, zen_reward_status_track rp SET cp.reward_points=cp.reward_points+IFNULL(SELECT SUM(rp.reward_points) FROM zen_reward_status_track rp WHERE cp.customers_id=rp.customers_id AND rp.status=0 AND rp.dateIf 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 am running version 5 of mysql.

30 May 2008, 1:22 AM
#228
tbaquatics avatar

tbaquatics

New Zenner

Join Date:
Jan 2008
Posts:
72
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

I did try the reuploading, etc all without luck.

30 May 2008, 4:03 AM
#229
tbaquatics avatar

tbaquatics

New Zenner

Join Date:
Jan 2008
Posts:
72
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

Did a little debugging. The issue is with the following code:

//if($db->Execute("UPDATE ".TABLE_REWARD_CUSTOMER_POINTS." cp, ".TABLE_REWARD_STATUS_TRACK." rp SET cp.reward_points=cp.reward_points+IFNULL(SELECT SUM(rp.reward_points) FROM ".TABLE_REWARD_STATUS_TRACK." rp WHERE cp.customers_id=rp.customers_id AND rp.status=".STATUS_PENDING." AND rp.date<NOW()-INTERVAL ".REWARD_POINTS_SUNRISE_PERIOD." DAY),0) WHERE cp.customers_id=rp.customers_id;"))
// $db->Execute("UPDATE ".TABLE_REWARD_STATUS_TRACK." SET status=".STATUS_PROCESSED." WHERE status=".STATUS_PENDING." AND date<NOW()-INTERVAL ".REWARD_POINTS_SUNRISE_PERIOD." DAY;");

1 Jun 2008, 11:31 PM
#230
mineralicious avatar

mineralicious

New Zenner

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

Re: Reward Points Module for ZC v13x

I installed this and have an issue with the sidebox not showing. It doesn't appear in the Layout Boxes Controller. I am very new to Zen Cart (well customizing it anyway) and cannot figure out how to fix this. Please help? I'm all :blink: trying to figure this out. Thanks in advance!

2 Jun 2008, 12:33 AM
#231
mineralicious avatar

mineralicious

New Zenner

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

Re: Reward Points Module for ZC v13x

Mineralicious:

I installed this and have an issue with the sidebox not showing. It doesn't appear in the Layout Boxes Controller. I am very new to Zen Cart (well customizing it anyway) and cannot figure out how to fix this. Please help? I'm all :blink: trying to figure this out. Thanks in advance!

:oops:

Ok, nevermind LOL As for help and ye shall figure it out yourself :D Now I just need to figure out how to set up the rest of it.

3 Jun 2008, 11:18 PM
#232
kenwahl avatar

kenwahl

New Zenner

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

Re: Reward Points Module for ZC v13x

Hem

Any status change on releasing the fix for attributes with different pricing than the base item? I think you said the fix was coded a few weeks ago but was waiting on the Paypal fix to release. I don't use Paypal but I am having the attribute problem. There are probably several others with the same problem.

Thanks
Ken

4 Jun 2008, 10:45 AM
#233
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

Sorry I've been out f touch guys- A big part of my job (non web related) kicked in and I spent the last 2 weeks hanging off the side of buildings installing very expensive GNSS (GPS) receivers.

But I'm back now and starting to go through all the posts. I have a new version of the mod ready which clears some of the bugs reported and has the attribute issue solved. I didn't update before going into the field because I knew I would not be anywhere near an internet connection and therefore would not be able to offer any help if things went pear-shaped. I'll post it to contribs this afternoon. If anyone has had problems since my last post can they please try out the new version and let me know if the fault persists- Hopefully that will make life a little easier on me clearing out the backlog...

Thanks

4 Jun 2008, 12:00 PM
#234
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:

When you go to admin/Catalog/Reward points and change the Set Global Reward Point ratio (in either fields), or even just press 'Update' it ERASES the value set in Customers/Group Reward Points Redeem - Enter global points ratio. It does NOT erase the Group points ratio if you have any groups set up just the Global.

As soon as you enter a value into “Enter global points ratio” it resets the Set Global Reward Point ratio to the default 1.000. So you have a circular problem.

(I was trying to test a promo option of double points on purchases on a particular date so I was fiddling with the Global Reward Point ratio in the Catalog.)

I have no idea why this I happening just that it is. And it could explain why some people were reporting the point values being reset to 0$.

Okay, got that problem- Turns out I was using a REPLACE INTO when I should have been using an INSERT ON DUPLICATE KEY. I've corrected it and it's in v1.12a which I've just uploaded to the contributions.

Thanks.

4 Jun 2008, 6:24 PM
#235
dscott1966 avatar

dscott1966

Zen Follower

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

Re: Reward Points Module for ZC v13x

I was just testing out the module, it everything seems just great so far, but for one thing. Im using Price updater which interns work with attributes pricing so that when a customer chooses a attribute with a price it upates the main price.

Now the problem is and i do not know if it is suppose to do this, but when the price changes when you select a attribute with a additional charge, for example: graphics card, Base price 300.00 you have two attributes one for model and memory.

Now there is a additional charge for upgrading the model to premium 100.00
and a additional charge for upgrading the memory lets say 16mb 70.00

you have just upgraded 170.00 to be added to the base price of 300.00 you have 470.00 in your cart. Should the rewards points be updated to show that instead of just going of the base price.

if it should do that how do i get it to work, and if it doesnt is there away to get the two to work together so that it does. if i was a customer i would want the points for the upgrades i just made. The only thing i can see happending on my end is to manually update there reward points from the admin, but that would be time consuming if you have a lot of orders. Im not a coder im trying to learning this php and zencart thing. Can this be done and if so how or can someone take a look into it.

Thank you for a great mod.

4 Jun 2008, 7:46 PM
#236
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:

I was just testing out the module, it everything seems just great so far, but for one thing. Im using Price updater which interns work with attributes pricing so that when a customer chooses a attribute with a price it upates the main price.

Now the problem is and i do not know if it is suppose to do this, but when the price changes when you select a attribute with a additional charge, for example: graphics card, Base price 300.00 you have two attributes one for model and memory.

Now there is a additional charge for upgrading the model to premium 100.00
and a additional charge for upgrading the memory lets say 16mb 70.00

you have just upgraded 170.00 to be added to the base price of 300.00 you have 470.00 in your cart. Should the rewards points be updated to show that instead of just going of the base price.

if it should do that how do i get it to work, and if it doesnt is there away to get the two to work together so that it does. if i was a customer i would want the points for the upgrades i just made. The only thing i can see happending on my end is to manually update there reward points from the admin, but that would be time consuming if you have a lot of orders. Im not a coder im trying to learning this php and zencart thing. Can this be done and if so how or can someone take a look into it.

Thank you for a great mod.

Scott- Attribute Reward Points is in v1.12a- I have posted it in the contributions but it's yet to make an appearance.

4 Jun 2008, 11:40 PM
#237
dscott1966 avatar

dscott1966

Zen Follower

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

Re: Reward Points Module for ZC v13x

Thank you for the quick reply, once again great mod i will wait.

5 Jun 2008, 12:26 AM
#238
nicholas84 avatar

nicholas84

New Zenner

Join Date:
May 2008
Posts:
5
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

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

5 Jun 2008, 6:00 AM
#239
kenwahl avatar

kenwahl

New Zenner

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

Re: Reward Points Module for ZC v13x

I updated to the new version 1-12a and found the following:

  • attribute fix seems to work fine

  • Google Checkout still broke

  • unneeded file included which makes zen cart blowup

    includes/auto_loaders/config.reward_points.core.php

    complains it cant be defined twice (deleted file)

  • comments left in file cause login to display error

    includes/classes/observers/class.reward_points.php

    removed comments:

    echo 'Reward Points notifier called!!!<br>'; (line 18)
    echo echo 'NOTIFY_CHECKOUT_PROCESS_AFTER_SEND_ORDER_EMAIL called!!!<br>'; (line 25)

Otherwise seems to work fine

Thanks
Ken

5 Jun 2008, 8:32 AM
#240
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 updated to the new version 1-12a and found the following:

  • attribute fix seems to work fine

  • Google Checkout still broke

I haven't had a chance to look at Google Checkout

kenwahl:

  • unneeded file included which makes zen cart blowup

    includes/auto_loaders/config.reward_points.core.php

    complains it cant be defined twice (deleted file)

The config.reward_points.core.php is the same file but has been renamed to fit in with the ZenCart schema. Delete (or rename) config.reward_points.php

kenwahl:

  • comments left in file cause login to display error

    includes/classes/observers/class.reward_points.php

    removed comments:

    echo 'Reward Points notifier called!!!<br>'; (line 18)
    echo echo 'NOTIFY_CHECKOUT_PROCESS_AFTER_SEND_ORDER_EMAIL called!!!<br>'; (line 25)

Thanks for that, that was some debug code left over from when I was trying to solved the PayPal IPN issue.

I have posted a fixed version to contribs (v1.12b).