Reward Points Module for ZC v13x

[superprg]

Hi
I already have "Reward Points Module"
http://www.zen-cart.com/index.php?ma...roducts_id=911
Can I go ahead with " Reward Point Full Suite"?
http://www.zen-cart.com/index.php?ma...oducts_id=1002

Please let me know if there would be any problems

[superprg]

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?ma...roducts_id=501
Store Credits and Rewards Points Module

Can I go ahead with " Reward Point Full Suite"?
http://www.zen-cart.com/index.php?ma...oducts_id=1002

Please let me know if there would be any problems

[Seamstobesew]

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.

[Seamstobesew]

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.

[nev]

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.

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.

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

nev

[nicholas84]

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

[tbaquatics]

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.

[tbaquatics]

I did try the reuploading, etc all without luck.

[tbaquatics]

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;");

[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 trying to figure this out. Thanks in advance!