Printable View
Quote:
Originally Posted by hem
Database: MySQL 5.0.45-community-log
I was trying to set up the Standard IPN first, but after discovering the Paypal problem with the IPN i switched to Express Checkout.
And im afraid that maybe the Reward Points Module is causing this SQL-error when clicking the button without being logged in.
So i just want to make sure, is this mod working when using Paypal Express Checkout?
Strange- it should work fine- let me have a look at it in the morning and I'll get back to you then.Quote:
Originally Posted by user2345
Actuallly- now I've had a good look at your original message I can see where the problem is- I'll code in an adjustment and add it to the mod.Quote:
Originally Posted by hem
Hi there -
First of all thanks for this mod! It sounds awesome and I can't wait to dig in.
That being said... after I installed the mod and went to the Admin>Customer>Group rewards redeem, I get the following error:
Warning: require(../../includes/application_top.php) [function.require]: failed to open stream: No such file or directory in /home/eurocoop/public_html/botanikanaturals/admin/group_reward_points.php on line 23
Fatal error: require() [function.require]: Failed opening required '../../includes/application_top.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/eurocoop/public_html/botanikanaturals/admin/group_reward_points.php on line 23
Now, I don't know that much about PHP at all, so I'm kinda lost here. Can anyone give me a hint what could be causing this or how to fix it? I would be eternally in your debt and will add you to my list of ZC Heroes :D
It looks like you haven't copied the files across correctly- You need to make sure that they go into the corresponding folders on your website.Quote:
Originally Posted by crashley1784
OK, I'll double check that. I thought I was relentless in making sure I did everything correctly, but maybe I made a mistake. Any hint what application_top.php is though? I searched the reward point module folder and did not find that file...
Ok, I checked and all my files are in the correct places. Any other ideas?
Question about the mod -
Is it possible to only offer reward points to a specific group? I don't want every customer to be able to earn points, only my club members - earning points is one of the perks of membership.
Thanks :)
It's a ZenCart core file. Your error message is telling you that application_top.php could not find one of the reward point modules.Quote:
Originally Posted by crashley1784
Yes- just set your global redeem to 0 and set up a Group Redeem Points for your club members.Quote:
Originally Posted by crashley1784
If global redeem is set to zero will non-club members still be able to see the reward points listed per item or no?Quote:
Originally Posted by hem
Hello,
Hem, I seem to be experiencing problems redeeming points when using Maestro.
I have Fast and Easy Checkout installed and One Page checkout enabled. No problems when using Visa, Solo, MasterCard as the points are deducted correctly.
For some reason, it won't deduct when using Maestro? Have you tried it with this card? Do you think the 3D Secure is causing it?
Thx
No- they will just see 0 reward points per productQuote:
Originally Posted by MeltDown
It should return via the same path as the rest of the cards so there should not be any problems.Quote:
Originally Posted by Berserker
Unfortunately, that wasn't the case for Maestro. Had a customer buy something and then used their reward points. The rewards points was used but did not deduct on the total value of purchase.Quote:
Originally Posted by hem
Hi Hem
When I go to redeem the reward points earned they have no value and cannot be redeemed how do I fix this?
Thanks
Hello
I installed Store Credits and Rewards Points Module
IN the admin , customer, store credit , the following error appear:
1146 Table 'pillownp_zc1.zen_sc_customers' doesn't exist
in:
[select count(*) as total from zen_customers c left join zen_sc_customers sc on c.customers_id= sc.customers_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.
And on checkout a similiar error:
1146 Table 'pillownp_zc1.zen_sc_customers' doesn't exist
in:
[select amount from zen_sc_customers where customers_id = 5]
Please advise
thank you
Hello , this is update on above
After installed Reward point Full suit, got following error on checkout:
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;]
Please advise
thank you
Any idea which module it's not able to find? I've quadruple checked that all my files are in the correct places (at least according to the file structure included with the rewards suite download). If I knew which module it was looking for I could probably solve the problem.Quote:
Originally Posted by hem
Thanks!
Hi,Quote:
Originally Posted by Rasyr
I've tried this procedure and I still get the same error when I try to uninstall this (even my backup files aren't overriding this). How can I get rid of it?
Thanks!
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
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
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.
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.
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.
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.Quote:
Originally Posted by Mike_DeanOk.. I clearly have a gremiln.. I have not touched or installed anything and now I have this issue again. (Rapidly removing hair..!!!)Quote:
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.
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 ?
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.
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$.Quote:
Originally Posted by hem
No- they will just see 0 reward points per productQuote:
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?
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
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
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.
I did try the reuploading, etc all without luck.
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;");
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:Quote:
Originally Posted by Mineralicious
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.
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
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
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.Quote:
Originally Posted by nev
Thanks.
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.Quote:
Originally Posted by dscott1966
Thank you for the quick reply, once again great mod i will wait.
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
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
I haven't had a chance to look at Google CheckoutQuote:
Originally Posted by kenwahl
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.phpQuote:
Originally Posted by kenwahl
Thanks for that, that was some debug code left over from when I was trying to solved the PayPal IPN issue.Quote:
Originally Posted by kenwahl
I have posted a fixed version to contribs (v1.12b).
Nicolas- if you PM me your URL I'll take a look at it.Quote:
Originally Posted by nicholas84
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
2) 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
3) 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
4) 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
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 looks like you are missing the admin/includes/functions/extra_functions/reward_points_functions.php fileQuote:
Originally Posted by dscott1966
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).Quote:
Originally Posted by Mineralicious
Try the attached version instead.
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 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.
Thank you for all of your help Andrew. I am getting this message now when running the quick update version:Quote:
Originally Posted by hem
Quote:
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.
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/showth...445#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
HemQuote:
Originally Posted by kenwahl
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
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.
I think I've got a handle on what's causing it- I'll code up a new version in the morning.Quote:
Originally Posted by kenwahl
Yep- they are on the wishlist.Quote:
Originally Posted by nev
That one's on the next update.Quote:
Originally Posted by nev
It should be easy enough to do- It could be added to the Group Redeem- We could set up special groups with membership criteria.Quote:
Originally Posted by nev
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.Quote:
Originally Posted by 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.
Let's try that again...Quote:
Originally Posted by hem
Thanks Hem this version of ot_reward_points.php works great.Quote:
Originally Posted by hem
Ken
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.
Thanks HemQuote:
Originally Posted by 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.
http://www.paws4deals.com/gc.jpg
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.Quote:
Originally Posted by kenwahl
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.
Did you copy over all the latest files as per my PM???Quote:
Originally Posted by dscott1966
This (and reward points for referrals) will be in the next version which I will start working on once all the issues with the current version have been resolved.Quote:
Originally Posted by dscott1966
Here's a quick hack of the googlecheckout.php which adds the reward_points_display module to Google Checkouts list of Order Total mods to ignore. Unfortunately is list is hard coded rather than databased hence the code change.Quote:
Originally Posted by hem
Just extract the php file to includes/modules/payment/
Thanks HemQuote:
Originally Posted by hem
This change works great. It no longer shows the Rewards points line in Google checkout like before.
I don't know how familiar you are with Google Checkout but it works different than most payment modules. Once the customer goes to Google Checkout (they don't log into zencart) they don't come back to the site. Thus, checkout success page isn't hit. Zen cart gets a notification via responsehandler.php that a purchase was made and passes all the info on the order to zencart. It doesn't seem that something is getting triggered to award them there points when their order is created after notification from the responsehandler. Though it does show how many points were awarded on their invoice.
I have Reward Point Status Track set to:
Pend: [Pending, Processing, Google New, Google Processing] Earn: [Shipped, Google Shipped]
I have both Pending & Processing set because I had a problem with it changing from Pending to Processing so fast that it was like it was never in Pending status and didn't award points.
Thanks
Ken
Ken, I've checked it out and it's because the responsehandler does not call any of the ZenCart notifiers. As the "store points awarded" code is hooked to NOTIFY_CHECKOUT_PROCESS_AFTER_ORDER_CREATE_ADD_PRODUCTS this is never called and therefore no points get stored. I'm afraid that it's something the Google Checkout team will need to address.Quote:
Originally Posted by kenwahl
Thanks HemQuote:
Originally Posted by hem
Thats what I was afraid would be the case.
Just one more question on Google Checkout. Do you think it would be possible in some way to pass the info to Reward Points via Google Checkouts AddThirdPartyTracking in googlecheckout/library/googlecart.php (around line 389)? I know that is what JROX affiliate module has to do. an example line for JROX is:
$cart->AddThirdPartyTracking("www.YOURDOMAIN.com/JAMINSTALLATION/sale.php?",array('trans_id','amount' => 'order-total'));
Thanks
Ken
hello .. thx for the great work .. i've installed a modified payment module and have a problem when anybody want to buy anything above 1000 it gives me this error" Please make sure you entered the correct card information or contact your Card issuing Bank, then try again."
can you help me please. thanx
Which payment module is it??? Also have you got the latest Reward Point mod (v1.12c)???Quote:
Originally Posted by qtiger
yes i have the latest reward system .. and the payment module is not available anywhere.. it's inhouse made. but i just want to know if the reward system has anything to do with this error?Quote:
Originally Posted by hem
thx for ur prompt help :)
Okay- check that your bespoke code is not handling the reward point lines and somehow this is screwing up your bottom line when calling the CC authentication.Quote:
Originally Posted by qtiger
thx .. i really appreciate it. i'll check with my developers .. thxQuote:
Originally Posted by hem
Hi, my hosting provider uses the following version of the mySQL database : "MySQL 4.0.26-standard" (as reported by Zen).
Is this compatible with the Reward Points module?
Many thanks in advance.
EDIT: I have just checked and I have the option of also using MySQL V5 with my provider. Will that work ok and do you think it will cause any issues with Zen if I migrate the current database from V4 to V5 (there is only test data in there at the moment).
Sorry it needs MySQL v4.2 minimal. However there should not be any problems using v5- Migration should be trivial too.Quote:
Originally Posted by snowy2008
Andrew,
Did the ver1.12c solve the paypal PIN problem?
Thanks :smile:
I'm hoping PayPal sorted the IPN problem.Quote:
Originally Posted by fiji
Is there a way to have the reward points based on the net figure after previously awarded points have bewen deducted from the gross rather than always have the points awarded on the gross purchase?
Jim
Is there a fix yet for it not calculating correctly at review order stage?
Sub-Total:$125.00
Postage: $9.00 ( 6 - Incl $5.00 P&H. ):
Tax: $12.50GST:
-$10.00Gift Certificates:
-$105.50Value of Redeemed Reward Points:
$155.00Total:
By my calculations it should be $115.50 credit from the reward points and the gift certificate taken away from the sub total.
So it should be
Sub-Total: $125.00
Postage: $9.00
Tax: $12.50
-$10.00 gift voucher
-$105.50 value of rewards
$31.00
Appreciate any help. Thanks
I am still having the same issues with Paypal. If the transaction type is "web_accept", it works fine. However, if the transaction type is "unique", no Reward Points are awarded as Pending, and I have to go back and add them by hand.Quote:
Originally Posted by hem
The problem only seems to happen when your using a coupon/gift certificate.
I just did another test with out redeeming one and it seems to work.
So is there something I need to change for the GV/Rewards system to both be usable at check out stage?
hi,
May i know if any body have problem on the product attributes?
as i found that the script don't work very well for the product which as attributes.
e.g. product base price = USD100, one option +USD50
it will count the credit MORE Than USD50.
it seems it will add up all the product attributes price.
i use the 1.3.8a default store data to test.
any idea?
I am setting up a store where products are purchased ONLY with member rewards points.
Whenever a certain event occurs (away from the store), members receive points which they can spend at the store.
I need a way to easily give members their points, have the program add the points to their previous points, and use the points to purchase.
Is this possible with Zen Cart? Is this module what I'm looking for?
I appreciate the help.
Hi Andrew,
Fantastic mod by the way !
I was wonering if you could add an extra function.
In the configuration under Reward Point Status Track where you can specify under advanced which status's trigger a pending or earned status, can you add in an extra column for remove points. so if an order is cancelled and not deleted the reward points are removed automatically when status is set to cancelled.
Thanks
Shane
Ok, Just installed this module, had previous version installed and working. Now getting this error. Anyone have a clue?
Fatal error: Cannot redeclare class RewardPoints in includes/classes/observers/class.reward_points.php on line 58
I installed reward points, but I notices at google checkout cart , the reward points are mistakenly added to the cart total, how do i fix this. ? Please advise
thank you
Checkout comment 262 a couple pages back. It will remove all reference of reward points in Google Checkout. Be advised that points are not automatically awarded via Google checkout. You will need to do that manually. Their invoice will show what they are awarded but you have to do it manually.Quote:
Originally Posted by zafer
Ken
Check in includes/classes/observers/ you probably have 2 files for reward_points. delete the class.reward_points.php and leave the other one. They are declaring the same things and only one of them is needed. It will work with either but not with both.Quote:
Originally Posted by Crzipilot
Ken
Sorry I read the problem wrong. Look at comment/post 240 and it should fix your problem.Quote:
Originally Posted by kenwahl
yep Ken nailed that one. One of the recent changes renamed class.reward_points.php to class.core_reward_points.php to be more compatible with the ZenCart naming process. You will probably find both these files in includes/classes/observers. In this case delete class.reward_points.php and you should be okay.Quote:
Originally Posted by kenwahl
Anyway, I'm back again after another RL session which wiped out all my free time. I have a sabbatical coming up shortly so I would like to know from all the people who are using the mod what are the most important upgrades required for the next release. Be aware that I'm already looking at alternative ways to handle the Reward Point pend to handle mods that don't follow the order_process route so that Google Checkout and Paypal IPN should work without having to manually handle the reward points.
Thanks for the response, I knew of that change, found out it was two hands not knowing what the other was doing. Had to go back and pull out all the files for whatever version we started with, and put in the new files for the latest version and then everything worked.
thanks
Another quick question. Release 1.11 says it Added Configuration item to set minimum order value to redeem points against.
Added Configuration item to allow redeem of RP against Subtotal or Total (inc. shipping)
After I got everything working I'm not really sure if I have this under the config menu.
If I read it correctly, the option of putting a mininum order amount before they can use reward points should be in there? Such as they can order stuff and gain reward points. But they can not redeem them on any orders under 100.00. If this is already in there, I guess I need to go back and change some things.
Thanks for all your work on this mod. I don't know if it will make any difference or not but Google Checkout can be configured to return to checkout_success which is actually the default since 1.4.1beta and up.
The setting is in Module - Payments - GoogleCheckout towards the bottom.
Will someone with knowlege of both please explain the difference between this mod and http://www.zen-cart.com/forum/showth...+points+module
Thanks!
Well I know that version did use some of my core code to start with but has diverged a lot from then.Quote:
Originally Posted by BlessIsaacola
I installed latest reward points , with updated update.sql file
still error after loading sql:
Fatal error: Call to a member function add() on a non-object in /home/pillownp/public_html/admin/sqlpatch.php on line 211
Please help
To the best of my knowledge that setting just tells Google Checkout where to return if and only if once the customer finishes checking out they click on a link on Google checkout page to return to the site. They would then return to the page you spcified there. From my experience most of my customers don't do that they just finish the checkout and don't return to the site.Quote:
Originally Posted by BlessIsaacola
Ken
Also my checkout is now blank screen. When I debug the error is:
PHP Fatal error: Cannot redeclare class ot_reward_points in /home/pillownp/public_html/includes/modules/order_total/ot_reward_points.php on line 23
Thank you for your help
Thanks for pointing that out. I completely forgot that requires a customer action.Quote:
Originally Posted by kenwahl
It still would be helpful for those of you that know the difference between the two mods to please post. I am looking for information to make an informed decision. I like the feature of store credit versus reward points as an added feature.Quote:
Originally Posted by hem
Thanks!
Those items should be the last 2 items listed under Configuration - Reward Points.Quote:
Originally Posted by Crzipilot
Allow Redeem of Reward Points on Order Total or Subtotal
Set Minimum Order Value to Redeem Points Against
Ken
I looked at that one and from what I remember.... It didn't play well with Google Checkout or items with attributes. It also was set up to only work with a global point structure by a percentage of the sale( All items get same points). It also displays in Dollars not points so if a product gets 10 points with this mod that one may display $.05 for that one depending what they are worth. I personally like it to show points rather that what they are worth on the product page. That mod has a lot less options as to how points are awarded and how they are used.Quote:
Originally Posted by BlessIsaacola
Hope this helps a little
Ken