-
Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
This is for Zen Cart v1.5.x
This is the NEW thread for the latest version Reward Points Full Suite v2.5 for Zen Cart v1.5.x.
v2.5 - 11/10/2014
- Added admin on/off switches to control if you want to show Reward Points on the product info page.. This way folks don't have to do code edits.
- Fixed now shows Reward Points when viewing details of an order.
- Fixed a bug with Reward Points and Edit Orders not playing nicely together.
- Added a readme _docs folder on how to install and upgrade Reward Points.
If you are using Zen Cart v1.3.x:
Please DO NOT post questions regarding the v1.3.x versions of this add-on in this support thread.
Questions regarding the v1.3.x versions of this add-on should be directed to this support thread HERE:zen-cart.com/showthread.php?95021-Reward-Points-Module-for-ZC-v13x
When posting bugs/issues about Reward Points v2.5, it's more helpful to resolve them if you post details. Just saying "it's broken" or "doesn't work" does not provide nearly enough information to help YOU resolve YOUR issue.
Reward Points is in the plugins area here: http://www.zen-cart.com/downloads.php?do=file&id=704
-
Re: Reward Points Full Suite v2.5 Support Thread
Could anyone help with 1.5.3
I have removed reward points as it is just not been used in the 3 years I have used it .
I have removed all the files and folders have checked 3 times in case i missed something + have used the zencarts toolkit to find rewards ,run both un install sql and remove config items
But am left with this on 1st stage checkout ( 2 yellow bars )
WARNING: Could not locate language file: includes/languages/english/modules/order_total/ot_reward_points.php
WARNING: Could not locate language file: includes/languages/english/modules/order_total/ot_reward_points_display.php
I have had to replace the 3 order total files so this error goes away
website site is pewterworld .co .uk
thanks
-
Re: Reward Points Full Suite v2.5 Support Thread
Quote:
Originally Posted by
Andy-C27
Could anyone help with 1.5.3
I have removed reward points as it is just not been used in the 3 years I have used it .
I have removed all the files and folders have checked 3 times in case i missed something + have used the zencarts toolkit to find rewards ,run both un install sql and remove config items
But am left with this on 1st stage checkout ( 2 yellow bars )
WARNING: Could not locate language file: includes/languages/english/modules/order_total/ot_reward_points.php
WARNING: Could not locate language file: includes/languages/english/modules/order_total/ot_reward_points_display.php
I have had to replace the 3 order total files so this error goes away
website site is pewterworld .co .uk
thanks
Did you remove the ot_reward_points_display, ot_reward_points_discount, ot_reward_points modules in admin/modules/order total before uninstalling reward points. If you didn't that is probably why you are getting the warnings.
WARNING: Could not locate language file: includes/languages/english/modules/order_total/ot_reward_points.php
WARNING: Could not locate language file: includes/languages/english/modules/order_total/ot_reward_points_display.php
-
Re: Reward Points Full Suite v2.5 Support Thread
Hi ,yes I removed them first to see if there would be any issues (just didn't check there) with my website then I ran the sql
-
Re: Reward Points Full Suite v2.5 Support Thread
Quote:
Originally Posted by
Andy-C27
Could anyone help with 1.5.3
I have removed reward points as it is just not been used in the 3 years I have used it .
I have removed all the files and folders have checked 3 times in case i missed something + have used the zencarts toolkit to find rewards ,run both un install sql and remove config items
But am left with this on 1st stage checkout ( 2 yellow bars )
WARNING: Could not locate language file: includes/languages/english/modules/order_total/ot_reward_points.php
WARNING: Could not locate language file: includes/languages/english/modules/order_total/ot_reward_points_display.php
I have had to replace the 3 order total files so this error goes away
website site is pewterworld .co .uk
thanks
I uninstalled Reward Points on my zen cart version 1.5.3 test site to see if I could reproduce the error.
It does not show any errors when checking out. Not sure why you are getting them.
-
Re: Reward Points Full Suite v2.5 Support Thread
Good evening. I recently downloaded this addon and installed it. (Like, the day before you updated to v2.5, lol). I downloaded and installed version 2.1b.
Anyway, I'm not super savvy but I'm decent enough to follow instructions, so I apologize if this is a silly question.
The instructions have directions for a fresh install, or upgrading from 1.33A to 2.5. How do I update 2.1b to 2.5?
-
Re: Reward Points Full Suite v2.5 Support Thread
Quote:
Originally Posted by
Kcin
Good evening. I recently downloaded this addon and installed it. (Like, the day before you updated to v2.5, lol). I downloaded and installed version 2.1b.
Anyway, I'm not super savvy but I'm decent enough to follow instructions, so I apologize if this is a silly question.
The instructions have directions for a fresh install, or upgrading from 1.33A to 2.5. How do I update 2.1b to 2.5?
Open the Upgrade-1-33A_to_2-5 folder and copy all files to your server. After that paste the 1-5-3_Upgrade.sql In your admin panel, open Tools -> Install SQL Patches. Copy the query from 1-5-3_Upgrade.sql into the text box and hit 'send'.
This will upgrade anything from v1.33A to v2.5
-
Re: Reward Points Full Suite v2.5 Support Thread
Quote:
This will upgrade anything from v1.33A to v2.5
Hi
I'm using 2.1b for a while, and already have customers with and using reward points.
I have the same question... how do I update from 2.1b to 2.5 ? Do I loose the configs, and the customers points, etc ? I read you earlier reply but I didn't get it....
Thanks
-
Re: Reward Points Full Suite v2.5 Support Thread
Quote:
Originally Posted by
mesnitu
Hi
I'm using 2.1b for a while, and already have customers with and using reward points.
I have the same question... how do I update from 2.1b to 2.5 ? Do I loose the configs, and the customers points, etc ? I read you earlier reply but I didn't get it....
Thanks
No customer points will be loss. Just upload the admin folder inside the upgrade folder and copy and paste the 1-5-3_Upgrade.sql in admin.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
I have updated the _docs folder how to upgrade Reward Points so no one else will have any problems. It will be in the downloads soon. Sorry for all the confusion.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
countrycharm
I have updated the _docs folder how to upgrade Reward Points so no one else will have any problems. It will be in the downloads soon. Sorry for all the confusion.
This has now been updated.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
-
Re: Reward Points Full Suite v2.5 Support Thread
Quote:
Originally Posted by
countrycharm
Open the Upgrade-1-33A_to_2-5 folder and copy all files to your server. After that paste the 1-5-3_Upgrade.sql In your admin panel, open Tools -> Install SQL Patches. Copy the query from 1-5-3_Upgrade.sql into the text box and hit 'send'.
This will upgrade anything from v1.33A to v2.5
Thanks for the clarification, much appreciated!
-
Re: Reward Points Full Suite v2.5 Support Thread
Ugh, I hate being the squeaky wheel. I apologize. I would have just stuck with the previous version, but your new update included a feature I needed, which was the ability to turn off the points display on the product info page. Since I'm using the auto update plugin for the price, I wanted to remove the reward points since they aren't updating. Unfortunately, changing that value in the admin control panel had no effect, it continues to display either way.
-
Re: Reward Points Full Suite v2.5 Support Thread
Quote:
Originally Posted by
Kcin
Ugh, I hate being the squeaky wheel. I apologize. I would have just stuck with the previous version, but your new update included a feature I needed, which was the ability to turn off the points display on the product info page. Since I'm using the auto update plugin for the price, I wanted to remove the reward points since they aren't updating. Unfortunately, changing that value in the admin control panel had no effect, it continues to display either way.
I'm not following you. What not working Reward Points or another plugin?
-
Re: Reward Points Full Suite v2.5 Support Thread
Quote:
Originally Posted by
countrycharm
I'm not following you. What not working Reward Points or another plugin?
Sorry, bulk of unnecessary information, so let me rephrase that. The setting that turns off/on the reward points on the product info page is not working. Mine is always on regardless of setting.
-
Re: Reward Points Full Suite v2.5 Support Thread
Quote:
Originally Posted by
Kcin
Sorry, bulk of unnecessary information, so let me rephrase that. The setting that turns off/on the reward points on the product info page is not working. Mine is always on regardless of setting.
You are absolutely right. I left out the tpl_product_info_display.php file. I have now added the includes/templates/YOUR_TEMPLATE/templates/tpl_product_info_display.php folders to the Upgrade-From-v2.1b-or-Less-to-v2.5 folder.
Sorry about that.
You can download the reward_point_full_suite_2.5a.zip here until it get in the Plugins and Addons Directory.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Hi,
I have a problem with the reward points on the product info page. I have zen cart 1.5.0 and I just upgraded to reward points v2.5. So this I s my problem:
I have my products priced by attributes so I see the reward points in red on the product page but when I change the attribute for this product the reward points are not changing. Example:
cards price - attribute 1 -$15 rewards points -15
cards price - attribute 2 - $18 rewards points 15
cards price - attribute 3- $24ewards points 15
cards price - attribute 4- $30ewards points 15
cards price - attribute 5- $35ewards points 15
It is just not updating after I change the attributes.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
cargo1223
Hi,
I have a problem with the reward points on the product info page. I have zen cart 1.5.0 and I just upgraded to reward points v2.5. So this I s my problem:
I have my products priced by attributes so I see the reward points in red on the product page but when I change the attribute for this product the reward points are not changing. Example:
cards price - attribute 1 -$15 rewards points -15
cards price - attribute 2 - $18 rewards points 15
cards price - attribute 3- $24ewards points 15
cards price - attribute 4- $30ewards points 15
cards price - attribute 5- $35ewards points 15
It is just not updating after I change the attributes.
I don't get this problem on a stock zen cart v1.5.3.
Please give us a link to you site if you need help.
Selecting attributes will not show the reward points until you add them to the shopping cart.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
when I add them to the shopping cart everything is fine but before you add them to the shopping cart is the problem.
And I am sure that before i installed the edit orders it was working but then started showing only the lowest attribute and if i change the attributes doesn't matter it still shows the lowest attribute price. After edit orders there was a problem in the admin site i was not able to delete costumers but then i found that a function is missing so that was fixed but the current problem is still present.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
cargo1223
when I add them to the shopping cart everything is fine but before you add them to the shopping cart is the problem. ...
Quote:
Originally Posted by
countrycharm
...Selecting attributes will not show the reward points until you add them to the shopping cart.
As stated by countrycharm when a customer changes an attribute on a product page (which alters the product price) the "reward points" are not dynamically updated on the product page. The customer will not see the total amount of "reward points" based on product + attribute price until they visit the shopping cart page (with the product + attributes added to their cart).
One could craft additional Javascript to provide the functionality cargo1223 is requesting, but the functionality is not part of the current version of "Reward Points Full Suite".
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
lhungil
As stated by countrycharm when a customer changes an attribute on a product page (which alters the product price) the "reward points" are not dynamically updated on the product page. The customer will not see the total amount of "reward points" based on product + attribute price until they visit the shopping cart page (with the product + attributes added to their cart).
One could craft additional Javascript to provide the functionality cargo1223 is requesting, but the functionality is not part of the current version of "Reward Points Full Suite".
lhungil is right it can be crafted with additional Javascript to provide the functionality you are asking for. lhungil that is a good idea I may add that function later on. Don't know when that will be. If you need now you will have to hire someone to do it for you.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Thank you for the fast answers for now i will just turn it off of the product page so it will show only in the shopping cart.
Thank you.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Hi, is it possible to restrict redeem of points on Specials, or other individual products?
i.e. customers are allowed to earn points on a special offer, but should not be able to redeem points against an already discounted offer.
Thanks
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
enlightened
Hi, is it possible to restrict redeem of points on Specials, or other individual products?
i.e. customers are allowed to earn points on a special offer, but should not be able to redeem points against an already discounted offer.
Thanks
Not without some custom coding I'm afraid.
-
1 Attachment(s)
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
"Sorry, I posted this on the wrong thread."
Hi I was wondering if some one can help with an issue I am having
Have install mod & works great except issue I am having with redeeming points.
Issue is this: customer purchases product & gets 100 points for product purchased. On same transaction uses points earned ($ value $10) which I am findinding deducts of the purchase price so they end up only earning 90 points EG: see attached file
Attachment 14868
As we claim on the site (test site at moment) that they always get full $value on their purchases this doesn't work. Having no issues with the mod at all except for this issue
I would appreciate it if anyone would advise if they have had a similar problem and how they resolved it.
I have tried a suggestion that was advised, but still having the same issue
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
Winchees
"Sorry, I posted this on the wrong thread."
Hi I was wondering if some one can help with an issue I am having
Have install mod & works great except issue I am having with redeeming points.
Issue is this: customer purchases product & gets 100 points for product purchased. On same transaction uses points earned ($ value $10) which I am findinding deducts of the purchase price so they end up only earning 90 points EG: see attached file
Attachment 14868
As we claim on the site (test site at moment) that they always get full $value on their purchases this doesn't work. Having no issues with the mod at all except for this issue
I would appreciate it if anyone would advise if they have had a similar problem and how they resolved it.
I have tried a suggestion that was advised, but still having the same issue
As stated in the other reward points thread. Go to admin/configuration, scroll down to reward point configuration.
Select: Reward Point Redeem Maximum
This is the maximum amount of earned points that can be redeemed against a single order.
Note: this can be a absolute value (eg 1000) or a percentage (20%).
This will keep your customers from redeeming all of there point on a single order. If you are having problems go back and check your installation making sure all files uploaded correctly. I have this running on a stock zen cart 1.5.4 with not problems at all.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
countrycharm
As stated in the other reward points thread. Go to admin/configuration, scroll down to reward point configuration.
Select: Reward Point Redeem Maximum
This is the maximum amount of earned points that can be redeemed against a single order.
Note: this can be a absolute value (eg 1000) or a percentage (20%).
This will keep your customers from redeeming all of there point on a single order. If you are having problems go back and check your installation making sure all files uploaded correctly. I have this running on a stock zen cart 1.5.4 with not problems at all.
I don't think this is the issue Winchees is reporting.. It doesn't appear that his issue is with the maximum amount of points that can be redeemed against a single order..
Quote:
Originally Posted by
Winchees
Issue is this:
customer purchases product & gets 100 points for product purchased.
On same transaction uses points earned ($ value $10) which I am findinding deducts of the purchase price so they end up only earning 90 points EG: see attached file
Attachment 14868
As we claim on the site (test site at moment) that they always get full $value on their purchases this doesn't work. Having no issues with the mod at all except for this issue
While Winchees hasn't fully explained the issue, I am GUESSING (based on the information provided) that the issue here is that the reduction of points against the order total reduces the order total, and therefore reduces the total points earned for this order.. I further assume he is expecting that the points earned on this order should be 100 and not the 90 you see in his screenprint..
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
DivaVocals
I don't think this is the issue Winchees is reporting.. It doesn't appear that his issue is with the maximum amount of points that can be redeemed against a single order..
While Winchees hasn't fully explained the issue, I am GUESSING (based on the information provided) that the issue here is that the reduction of points against the order total reduces the order total, and therefore reduces the total points earned for this order.. I further assume he is expecting that the points earned on this order should be 100 and not the 90 you see in his screenprint..
Hi Diva,
This is correct - thanks for explaining better
As I stated -so far all working well with mod except for this annoying issue.
Can anyone advise work around??
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Swinging in the dark here, as it's been a long time since I installed this module or played with its settings.....but can't this issue be resolve by changing the sort order on the order total module for the reward points and moving it farther down so it uses the correct amount to determine the points to give on the order?
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
barco57
Swinging in the dark here, as it's been a long time since I installed this module or played with its settings.....but can't this issue be resolve by changing the sort order on the order total module for the reward points and moving it farther down so it uses the correct amount to determine the points to give on the order?
and I'm getting ready to install it for the 1st time, so I've got no great insight either, but what you suggest would be my guess as well..
-
2 Attachment(s)
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
DivaVocals
and I'm getting ready to install it for the 1st time, so I've got no great insight either, but what you suggest would be my guess as well..
Cool, thanks for the suggestion worked a treat, but now brings up another issue:
When the order is confirmed & process it is not processing the correct points - still deducting the points of the points earned (weird number as well) - shows on inv as below & only allocates the incorrect number to pending points
Attachment 14870
Really driving me insane this - mod is great except for this issue - Anyone HELP!!
For your guys information my setup is as follows:
Zen Cart: V1.5.4
PHP: V5.6.2
MySQL: V5.1.61
Have the following Templates & Mods installed:
Template: Carlisle Fresh Responsive
Mods: CSS/JS Loader, Carousel Featured Products x 2 (2nd one is for new arrivals), Fast & Easy Checkout, Zipship, Direct Bank Deposit-NZ, Google Analytics & Magic Toolbox(Magic Thumb)
Setting wise: I have left it as basic as possible screen shot below except for the "Global Reward Point ratio:" which is set at 1.1500 to account for our GST figures - I have duplicated the issue on my local test system as well. Copy of settings:
Attachment 14871
Any help from some one would be most appreciated - this is the only major problem we are having on the site - rest of the install & set up has gone really well - just have to sort out minor formatting & layout issues now
Any Help PLEASE
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Oops, forgot to mention also have "Ask a Question" & "Mailchimp Intergration" mods installed
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Think I may have worked out now.
One last thing, can someone tell me how to charge this "Total Reward Discount Amount: (1000%)" to this: "Total Reward Discount Amount:"
I wish to remove the percentage figure that is coming up and only show the $ value
Would appreciate some help
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
Winchees
Think I may have worked out now.
One last thing, can someone tell me how to charge this "Total Reward Discount Amount: (1000%)" to this: "Total Reward Discount Amount:"
I wish to remove the percentage figure that is coming up and only show the $ value
Would appreciate some help
Can you share how you worked out your original issue??? "I may have worked out now" is great, but it would be REALLY nice if you could tell us HOW.. It helps OTHER community members who may be searching the forum for a solution to the SAME issue when folks post and SHARE their solutions..
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
DivaVocals
Can you share how you worked out your original issue??? "I may have worked out now" is great, but it would be REALLY nice if you could tell us HOW.. It helps OTHER community members who may be searching the forum for a solution to the SAME issue when folks post and SHARE their solutions..
Hi DivaVocals,
I thought I had resolved, but it was more a case of my stupidity in not working through how mod works.
Anyway, have had another issue come up that is really irritating:
1st one is the request I posted earlier:
"can someone tell me how to charge this "Total Reward Discount Amount: (1000%)" to this: "Total Reward Discount Amount:"
I wish to remove the percentage figure that is coming up and only show the $ value"
2nd one is:
Product Price inc tax: $115
Freight and Packaging: $7.48
Tax content 15%: $15.98
Total Reward Discount Amount: (2000%): -$20
Total: $101.50
Winchee Points earned: 92
Issue I have is with items in red:
Tax is wrong - should be $13.24
Points earned are incorrect - should be 95
I have tried moving the discount field up above the tax, but still no joy - tax display still incorrect & points still stay at 92
These figures also show on invoice
Anyone got any ideas - help would be appreciated
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
Winchees
I thought I had resolved, but it was more a case of my stupidity in not working through how mod works.
Uhhh okay.. I figured it was a settings issue, but it stills helps others if you share what you did to make it work correctly.. but okay..
The rest of your totals issues really don't sound like they are related to THIS module as much as they are how to configure your tax and totals to calculate correctly..
The on-screen "Total Reward Discount Amount" text is likely in a language file.. Use the Developers Toolkit under the Tools menu in the admin to search for this text to see which language file it's in..
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
DivaVocals
Uhhh okay.. I figured it was a settings issue, but it stills helps others if you share what you did to make it work correctly.. but okay..
The rest of your totals issues really don't sound like they are related to THIS module as much as they are how to configure your tax and totals to calculate correctly..
The on-screen "Total Reward Discount Amount" text is likely in a language file.. Use the Developers Toolkit under the Tools menu in the admin to search for this text to see which language file it's in..
Thanks, very new to this - very much a case of knowing enough to be very dangerous & stuff things up
I had found the text & then did a shearch on the define statement & found this:
$this->output[] = array('title' => MODULE_ORDER_TOTAL_REWARD_POINTS_DISCOUNT_VALUE.' ('.zen_round($redeem_discount*100, 2).'%)',
'text' => '-'.$currencies->format($order_discount),
'value' => $order_discount);
in the "ot_reward_points_discount.php" file.
I have played around with it & all I can get it to do is totally take all the staments out, but other than that end up crashing the site.
Any suggestions someone
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
Winchees
Thanks, very new to this - very much a case of knowing enough to be very dangerous & stuff things up
I had found the text & then did a shearch on the define statement & found this:
$this->output[] = array('title' => MODULE_ORDER_TOTAL_REWARD_POINTS_DISCOUNT_VALUE.' ('.zen_round($redeem_discount*100, 2).'%)',
'text' => '-'.$currencies->format($order_discount),
'value' => $order_discount);
in the "ot_reward_points_discount.php" file.
I have played around with it & all I can get it to do is totally take all the staments out, but other than that end up crashing the site.
Any suggestions someone
Yes search AGAIN.. find the LANGUAGE file that contains the actual language definition.. You don't edit the file that USES the definition (as it it appears you are trying to do), you edit the language file that contains the text you want to replace..
Looks something like..
define, 'Total Reward Discount Amount';
REPLACE the text you DON'T want with the text you DO WANT..
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
DivaVocals
Yes search AGAIN.. find the LANGUAGE file that contains the actual language definition.. You don't edit the file that USES the definition (as it it appears you are trying to do), you edit the language file that contains the text you want to replace..
Looks something like..
define, 'Total Reward Discount Amount';
REPLACE the text you DON'T want with the text you DO WANT..
Thanks, I will keep searching till I find correct one
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Reinstalling this as part of a v1.5.4 upgrade for a client.. Can someone explain WHY the upgrade SQL contains the admin page delete statements only to RE-INSERT the same entries again later in the script??
Code:
/*
zencart 1.5 mods
*/
DELETE FROM admin_pages WHERE page_key='configRewardPoints';
DELETE FROM admin_pages WHERE page_key='GroupRewardRedeem';
DELETE FROM admin_pages WHERE page_key='RewardPoints';
DELETE FROM admin_pages WHERE page_key='CustomerRewardPoints';
SELECT @cgi:=configuration_group_id FROM configuration_group WHERE configuration_group_title = 'Reward Points';
INSERT INTO configuration
(configuration_id ,configuration_title ,configuration_key ,configuration_value ,configuration_description ,configuration_group_id ,sort_order ,last_modified ,date_added ,use_function ,set_function)
VALUES (NULL , 'Show Reward Points on Product Info Display Page', 'SHOW_REWARD_POINTS_PRODUCT', '0', 'Display Reward Points on product info display page?<br />0= No<br />1= Yes', @cgi, '1', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');
INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configRewardPoints','BOX_CONFIGURATION_REWARD_POINTS','FILENAME_CONFIGURATION',CONCAT('gID=',@cgi), 'configuration', 'Y', @cgi);
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('GroupRewardRedeem', 'BOX_GROUP_REWARD_POINTS_REDEEM', 'FILENAME_ADMIN_GROUP_REWARD_POINTS_REDEEM', '', 'customers', 'Y', 35);
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('RewardPoints', 'BOX_REWARD_POINTS', 'FILENAME_ADMIN_REWARD_POINTS', '', 'catalog', 'Y', 36);
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('CustomerRewardPoints', 'BOX_CUSTOMER_REWARD_POINTS', 'FILENAME_ADMIN_CUSTOMER_REWARD_POINTS', '', 'customers', 'Y', 37);
As far as I can see the only REAL "upgrade/change" is the addition of one more configuration option.. Am I missing something here?????
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
more upgrade questions..
regarding the admin/orders.php file
on line 607 I see this change:
Code:
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
the default code is this:
Code:
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $currencies->format($order->totals[$i]['value'], false) . '</td>' . "\n" .
Is this a Rewards points change?? (there are no code comments to help clarify this if it is) If it is a Rewards Points modification, I need some clarification as to what EXACTLY this change does???
Also because the orders.php file bundled in the Rewards Points module is from the last v1.5.4RC version and NOT the final release, it is MISSING a language file change that went into the last release v1.5.4RC version and eventually into the final release code.
line 978 reads:
Code:
$contents[] = array('text' => 'Products Ordered: ' . sizeof($order->products) );
It should be:
Code:
$contents[] = array('text' => TABLE_HEADING_PRODUCTS . ': ' . sizeof($order->products) );
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
I believe the change is to show the "text" field from the order_total database table directly instead of reading from the "value" and displaying based upon currency rules.
It has been a long time since I have looked at this module, But If I remeber correctly the order total module for reward points uses the "text" field to display the "points" and leaves the value at 0 for earned (and a monetary value if redeemed).
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
lhungil
I believe the change is to show the "text" field from the order_total database table directly instead of reading from the "value" and displaying based upon currency rules.
Okay that makes sense.. I get the WHAT it does.. Now the question is WHY.. I am starting to suspect that this is some legacy thing that is still in this code.. because I left this change out and cannot see it making any difference.. Now I am have NEVER used this module before, so it could be I am just not getting it here, but I cannot see how this change is needed..
Quote:
Originally Posted by
lhungil
It has been a long time since I have looked at this module, But If I remeber correctly the order total module for reward points uses the "text" field to display the "points" and leaves the value at 0 for earned (and a monetary value if redeemed).
so is the change to the admin/orders.php required for this to work??
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Regarding my previous post..
Quote:
Originally Posted by
DivaVocals
Quote:
Originally Posted by
DivaVocals
more upgrade questions..
regarding the admin/orders.php file
on line 607 I see this change:
Code:
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
the default code is this:
Code:
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $currencies->format($order->totals[$i]['value'], false) . '</td>' . "\n" .
Is this a Rewards points change?? (there are no code comments to help clarify this if it is) If it is a Rewards Points modification, I need some clarification as to what EXACTLY this change does???
Also because the orders.php file bundled in the Rewards Points module is from the last v1.5.4RC version and NOT the final release, it is MISSING a language file change that went into the last release v1.5.4RC version and eventually into the final release code.
line 978 reads:
Code:
$contents[] = array('text' => 'Products Ordered: ' . sizeof($order->products) );
It should be:
Code:
$contents[] = array('text' => TABLE_HEADING_PRODUCTS . ': ' . sizeof($order->products) );
Quote:
Originally Posted by
lhungil
I believe the change is to show the "text" field from the order_total database table directly instead of reading from the "value" and displaying based upon currency rules.
It has been a long time since I have looked at this module, But If I remeber correctly the order total module for reward points uses the "text" field to display the "points" and leaves the value at 0 for earned (and a monetary value if redeemed).
Now I see what happened and when this code was introduced into the base module.. Thanks to a little birdie, I found these posts from the old support thread:
Quote:
Quote:
Originally Posted by
izar74
Hi again,
hard work bring issues as long as solutions ;-)
First the issue: I found that when i was going to the details of an order the Rewards point shown were always 0, but if you go on the invoice module the Rewards point magically appeared. Simply in the order details the point were not shown.
it seems that the problem could be with this line in /admin/order.php around line 666
PHP Code:
<td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $currencies->format($order->totals[$i]['value'], false) . '</td>' . "\n" .
If replaced with:
PHP Code:
<td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
all seems fine. Someone else got this error?
Zencart 1.51
Reward Point 2.1b
Quote:
Originally Posted by
lhungil
Order Total Modules were designed to show prices added or subtracted from an order... While the changes mentioned earlier "may" work... They may also break pricing calculation for stores accepting more than one currency... The stock Zen Cart "/admin/order.php" uses the database entry for "value" (with any currency conversion and formatting) instead of "text".
Instead of removing the currency calculations from EVERY order total module, one should probably add a modification to "/admin/order.php" specifically targeting the "Reward Points display" order total module (and using "text" when this module is encountered)... If going this route, one would also need to add an exemption to cause "Edit Orders" to NOT load the "Reward Points display" module (so it does not edit this line)... Or add "special" handling to address the non-standard use of the "value" and "text" but the "Reward Points display" order total module.
The alternative is to stop using (and remove) the "Reward Points Display" order total module and add the reward points earned information directly to the various templates / pages involved. This avoids the issues caused by using the "orders_total" database table in a way not expected by the Zen Cart core code.
Quote:
Originally Posted by
lhungil
Alright, dug into this the subject a little deeper today. Looks like Zen Cart 1.5.x out of box does not allow one to view orders in the admin with a currency other than the store default... I remember a discussion of this somewhere on the forums in the past, but do not remember what was decided...
So your change should not make a difference for the majority of users of Zen Cart 1.5.x (only those who may have for some reason wanted to see localized pricing for a different country in the admin and made changes)... I still believe it would be even better to at least add some conditional code to check which "order total" module (in "/admin/orders.php") is being displayed and ONLY skip the format function on the "Reward Points display" order total module... Or replace the "Reward Points display" order total module completely.
I currently have many other ongoing projects, so will not be able to spend any time on this project. Just was browsing this thread (have poked in here from time to time since it crossed my path) and decided to share some thoughts.
Now at the risk of offending anyone, IMHO this code should have NEVER found it's way into the base module.. I am not a fan of modules which include incomplete solutions which IMHO this code change is.. I think lhungil was on the right track on what the RIGHT solution SHOULD be. Perhaps the change to the orders.php file would have been better served as an instruction included in the readme as opposed to being made part of the code base. This way for those who are okay with this solution knowing the pros and cons of it can implement if they wish.. Or make this "bandaid" solution an admin on/off option..
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
DivaVocals
more upgrade questions..
regarding the
admin/orders.php file
on line 607 I see this change:
Code:
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
the default code is this:
Code:
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $currencies->format($order->totals[$i]['value'], false) . '</td>' . "\n" .
Is this a Rewards points change?? (there are no code comments to help clarify this if it is) If it is a Rewards Points modification, I need some clarification as to what EXACTLY this change does???
Also because the
orders.php file bundled in the Rewards Points module is from the last v1.5.4RC version and NOT the final release, it is MISSING a language file change that went into the last release v1.5.4RC version and eventually into the final release code.
line 978 reads:
Code:
$contents[] = array('text' => 'Products Ordered: ' . sizeof($order->products) );
It should be:
Code:
$contents[] = array('text' => TABLE_HEADING_PRODUCTS . ': ' . sizeof($order->products) );
Okay so after thinking about this I think I know what solution I would prefer to implement to achieve the objective of showing the actual points earned (the results of the order_total table's "text" column) on the order detail page..
Been messing around with stuff, and I think what would work while still keeping the currency support is the following:
Show ALL order totals from the order_total table where the class is not = to "ot_reward_points_display" display the "title" and the "value" columns
Quote:
<?php
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
echo ' <tr>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $currencies->format($order->totals[$i]['value'], false) . '</td>' . "\n" .
' </tr>' . "\n";
}
?>
BUT...
If there are order totals from the order_total table where the class is = to "ot_reward_points_display", show those totals JUST below the other orders totals, but display the values in the "title" and the "text" columns.
Code:
<?php
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
echo ' <tr>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
' </tr>' . "\n";
}
?>
Now I've been messing around but I'm not sure how to do this..
I tried this:
Code:
<?php
if ($order->totals['class'] !== 'ot_reward_points_display') {
code for showing default order totals code which supports currencies goes here. Will exclude Reward Points
}
if ($order->totals['class'] == 'ot_reward_points_display') {
code for showing default order totals code which supports currencies goes here. Will include Reward Points
}
?>
No dice..
I tried this:
Code:
<?php
if ($order->totals['class'] !== 'ot_reward_points_display') {
code for showing order totals code which supports currencies goes here. Will exclude Reward Points
}
?>
<?php
if ($order->totals['class'] == 'ot_reward_points_display') {
code for showing default order totals code which supports currencies goes here. Will include Reward Points
}
?>
Again no dice..
Hoping a kind community member will jump in here..
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Hi Diva you can redo and submit any changes you see fix. Was just trying to keep things simple from all the it you want to do this replace this with this. Want hurt my felling at all.....:smile:
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
countrycharm
Hi Diva you can redo and submit any changes you see fix. Was just trying to keep things simple from all the it you want to do this replace this with this. Want hurt my felling at all.....:smile:
No worries my friend.. was mostly thinking out loud here.. :smile: If I come up with a solution that keeps the currency support intact, I will post here, and (with your blessings) update the module..:smile:
-
3 Attachment(s)
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
I am having an issue with the Rewards Points Full Suite that is driving me nuts:
Basically it has to do with Redeeming the points.
Situation is this:
When I a customer redeems points on their purchase to things happen;
1/ the points on their purchase is always incorrect
2/ the tax figure showing is incorrect not updating
The attached images will give you an idea what I mean
Attachment 14911
The points earned on this order should be 153 (not 150)
GST (tax) content of the order should be $19.89 (not $22.50)
I have worked out the the missing 3 points relates to the GST figure not updating collectly
If points aren't redeemed all works well as per attached:
Attachment 14912
I'm setting up on my test site which I have configured for NZ Tax's (GST) of 15% & have stripped all other Discount Modules of the site in case there was a conflict with them.
At the present time the development site which will become the live site has been set up with no tax's & it works with no problem at all EG
Attachment 14913
The Rewards Module is set up out of the box so to speak, but I have set the "Global Reward Point ratio:" at 1.1500 to account for the tax rate that we need to charge on Goods & Services & I quickly figured out that the points are calculated on the Net Product Price (ex tax)
Is there something that I need to do on the mod or is it a tax related issue that I should explore on the tax thread??
I would appreciate any help in sorting this out - Driving me insane - all works well except this issue.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
I just installed and points are NOT being added to the customers account. My site is live on my server but not "live" to the public as of yet. I had 2 different testers try using both payment options and it didn't work :( My site is www.bellaornamenti.com Thank you
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
So doing some testing and found myself having to explain this to my client:
Quote:
Advanced mode: Set the order status items that will trigger a transfer of the reward points between pending and earned. Points are transfered when the status changes between the "Pending" and "Earned". Status items set to "Ignore" will have no effect if the Order Status changes to it.
Honestly this is truly as clear as mud.. I changed it on my client's shop to read:
Quote:
Advanced mode: Allows you to select the order status that will trigger a transfer of reward points from pending to earned. Points are transferred when the status changes between status items set to "Pending" and status items set to "Earned". Status items set to "Ignore" will have no effect on Order Status changes to it.
Wanted to share in case someone wants to make a similar change.. (or understand better what this means..:smile:)
-
Does anyone know how to add pagination to "Customer Reward Points Admin" page??
There's no pagination on this page, and at the bottom of the page there's this text:
"No Customer (or invalid customer) selected. No action performed!"
Not sure what triggers that warning/error.. but there is no pagination or even sorting.. Yes I can search for the customer I am looking for, but some pagination and the ability to sort by first or last name would be a nice navigational touch..
Has anyone done this and if so would ya be willing to share what ya did..
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
samisoaps
I just installed and points are NOT being added to the customers account. My site is live on my server but not "live" to the public as of yet. I had 2 different testers try using both payment options and it didn't work :( My site is
www.bellaornamenti.com Thank you
Points are added when the order status changes..
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
DivaVocals
Points are added when the order status changes..
I've changed the order status and it still didn't update the customers account. I've disabled it for now since I need to get a soft launch on the site this week.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
samisoaps
I've changed the order status and it still didn't update the customers account. I've disabled it for now since I need to get a soft launch on the site this week.
You are going to need to post ALL of your settings to get the RIGHT answer..
-
Re: Does anyone know how to add pagination to "Customer Reward Points Admin" page??
Quote:
Originally Posted by
DivaVocals
There's no pagination on this page, and at the bottom of the page there's this text:
"No Customer (or invalid customer) selected. No action performed!"
Not sure what triggers that warning/error.. but there is no pagination or even sorting.. Yes I can search for the customer I am looking for, but some pagination and the ability to sort by first or last name would be a nice navigational touch..
Has anyone done this and if so would ya be willing to share what ya did..
Diva put up a image of what you are seeing under customers/reward points. There should see a index across the top where you can search by A to Z
-
Re: Does anyone know how to add pagination to "Customer Reward Points Admin" page??
Quote:
Originally Posted by
countrycharm
Diva put up a image of what you are seeing under customers/reward points. There should see a index across the top where you can search by A to Z
and I DO see that.. But clicking on any letter doesn't show the full results for the letter clicked.. For example I clicked "J" to look for Johnson, and the list is truncated before I can even get to that part of the J's.. This is is where pagination would help, and so would sorting since what I would expect to see is the names arranged first by last name, and then by first name.. It truly is NOT a good user experience, and I'm surprised no one's grumbled about this before..
-
Re: Does anyone know how to add pagination to "Customer Reward Points Admin" page??
Quote:
Originally Posted by
DivaVocals
and I DO see that.. But clicking on any letter doesn't show the full results for the letter clicked.. For example I clicked "J" to look for Johnson, and the list is truncated before I can even get to that part of the J's.. This is is where pagination would help, and so would sorting since what I would expect to see is the names arranged first by last name, and then by first name.. It truly is NOT a good user experience, and I'm surprised no one's grumbled about this before..
I will look into getting this done. You have a good suggestion in how it should work, and I totally agree with you.
I will post back in a few days.
-
Re: Does anyone know how to add pagination to "Customer Reward Points Admin" page??
Hi,
Thank you for the great Mod.
I have just updated my ZC 1.3.9.h to 1.5.4 and the reward points are working fine. Except I have errors in my store/logs/ and wondered if anybody had any insight or have received similar errors?
[25-Feb-2015 16:45:03 America/New_York] PHP Fatal error: 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=p.products_id AND prp.scope='2')
OR (p.products_i' at line 3 :: SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute
FROM reward_master prp, products p, products_to_categories p2c
WHERE p.products_id='-1''
AND p2c.products_id='-1''
AND ((prp.scope_id=p.products_id AND prp.scope='2')
OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='1')
OR (prp.scope='0'))
ORDER BY prp.scope DESC LIMIT 1; ==> (as called by) /home/xx/xx/store/includes/functions/extra_functions/reward_points_functions.php on line 62 <== in /home/xx/xx/store/includes/classes/db/mysql/query_factory.php on line 155
Any help would be much appreciated.
-
Re: Does anyone know how to add pagination to "Customer Reward Points Admin" page??
Looks like it is the DPU Dynamic Price Updater mod causing my issue and there fixing next release.. :)
-
Edit orders and Rewards point
Hi CountryCharm,
i'm using this add on with edit order, old habits i know... :D, i've found an error while updating an edited orders, even if You don't touch the reward point it will put the symbols of the currencies in the text field.
Diva point out that there was a solution but i wasn't able to find it so I'm trying to solve it, but If You have any advice please tell.
Thanks
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
DivaVocals
Okay so after thinking about this I think I know what solution I would prefer to implement to achieve the objective of showing the actual points earned (the results of the order_total table's "text" column) on the order detail page..
Been messing around with stuff, and I think what would work while still keeping the currency support is the following:
Show ALL order totals from the order_total table where the class is not = to "ot_reward_points_display" display the "title" and the "value" columns
BUT...
If there are order totals from the order_total table where the class is = to "ot_reward_points_display", show those totals JUST below the other orders totals, but display the values in the "title" and the "text" columns.
.....
Dunno if this could help, i'm still trying to figure it out, but Diva's mumbling made me mumble a lot :P.. so i found this kind of solution...
I modified the code:
PHP Code:
<?php
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
echo ' <tr>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $currencies->format($order->totals[$i]['value'], false) . '</td>' . "\n" .
' </tr>' . "\n";
}
?>
With:
PHP Code:
<?php
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
if ($order_total['class'] = "ot_reward_points_display") {
echo ' <tr>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
' </tr>' . "\n";
} else {
echo ' <tr>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $currencies->format($order->totals[$i]['value'], false) . '</td>' . "\n" .
' </tr>' . "\n";
}
}
?>
It seem to work... still testing
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
izar74
Dunno if this could help, i'm still trying to figure it out, but Diva's mumbling made me mumble a lot :P.. so i found this kind of solution...
I modified the code:
PHP Code:
<?php
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
echo ' <tr>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $currencies->format($order->totals[$i]['value'], false) . '</td>' . "\n" .
' </tr>' . "\n";
}
?>
With:
PHP Code:
<?php
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
if ($order_total['class'] = "ot_reward_points_display") {
echo ' <tr>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
' </tr>' . "\n";
} else {
echo ' <tr>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $currencies->format($order->totals[$i]['value'], false) . '</td>' . "\n" .
' </tr>' . "\n";
}
}
?>
It seem to work... still testing
Ahhhh at last!! Something which appears to be the RIGHT solution.. as opposed to the bandaid solution that the current code contains.. and yes.. I'll admit that I was indeed grumbling about this.. :laugh: The "solution" that made it's way into the current Reward Points code IMHO should NEVER have been implemented as it solves one issue, while creating another..
So does this now show the Rewards Points WITHOUT a currency symbol while showing all other order totals WITH the currency symbol still in place??
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
DivaVocals
So does this now show the Rewards Points WITHOUT a currency symbol while showing all other order totals WITH the currency symbol still in place??
I've not tested it very much but till now for all the order i've made Yes. It show all the total with currencies except the last line (in my case the Reward point module ot_reward_points_display has a sort order of 1000 so it's the last one) with the reward points.
Maybe this time is the right one :laugh:
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
izar74
I've not tested it very much but till now for all the order i've made Yes. It show all the total with currencies except the last line (in my case the Reward point module ot_reward_points_display has a sort order of 1000 so it's the last one) with the reward points.
Maybe this time is the right one :laugh:
If it preserves the currency symbol for actual currency values, while displaying points as whole numbers.. then YEP.. this is the one.. Thanks for sharing.. Now THIS is the solution that should be included in the core of this module!!
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
DivaVocals
If it preserves the currency symbol for actual currency values, while displaying points as whole numbers.. then YEP.. this is the one.. Thanks for sharing.. Now THIS is the solution that should be included in the core of this module!!
izar74
You can add this to the package or I will add it later this coming week sometime.
I have not tested it. I'm going on by what you said about it. I know it is a better way than before thank you
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Hi countrycharm,
add it to the next release please :-), till now the modification works great, no error or problem so far. I'm glad to be of any help :P
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Hi, I have what I hope is a simple question. I had this module previously and it worked great. Upgraded my store and had it reinstalled and it is basically working, but I can't get it to transfer points from pending to earned. i'm having to go in daily and manually transfer them. I'm sure it's some little box I don't have checked, but I can't figure out what it is. I've tried various configurations of where I think it needs changed, but it never works. Other than that, it is accumulating and redeeming just fine, but I'm tired of having to manually move them over.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
loaner
Hi, I have what I hope is a simple question. I had this module previously and it worked great. Upgraded my store and had it reinstalled and it is basically working, but I can't get it to transfer points from pending to earned. i'm having to go in daily and manually transfer them. I'm sure it's some little box I don't have checked, but I can't figure out what it is. I've tried various configurations of where I think it needs changed, but it never works. Other than that, it is accumulating and redeeming just fine, but I'm tired of having to manually move them over.
Try going to admin/configurations/Reward Points Config/ Reward Point Status Track. Change the simple to advance mode and set status items that will trigger a transfer of the reward points between pending and earned.
-
1 Attachment(s)
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
So right now I have them marked like this
Attachment 15190
and it isn't working. Should I have them marked in the other column? I think I've tried both and it didn't work for either one.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
bumping this to see if I can get some help. It is still not working for me? See post above.
-
1 Attachment(s)
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
loaner
So right now I have them marked like this
Attachment 15190
and it isn't working. Should I have them marked in the other column? I think I've tried both and it didn't work for either one.
On a stock zen cart 1.5.4 with reward points installed. This is how I have the reward points configuration setup.
Attachment 15202
The points transfer just fine from pending to earned when changing order status from processing or Delivered. Go back check your installation all I can tell you.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
K, I changed to match yours. I'll see if that works. If not, I'll try installing it again myself and see if maybe he missed a file. Do you have any idea which file controls that so I can maybe just check that one?
-
1 Attachment(s)
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Still not transferring for me. I downloaded the module again and checked all of the files that were installed back in February and it appears they are all there where they are supposed to be. I did notice this though. Do you think the one that is highlighted in blue may be causing a conflict? Can I delete it?
Attachment 15214
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Hi again,
I've got this error:
HTML Code:
[25-May-2015 15:22:01] PHP Fatal error: 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 '2')
OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id A' at line 3 :: SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute
FROM reward_master prp, products p, products_to_categories p2c
WHERE p.products_id='101'"'
AND p2c.products_id='101'"'
AND ((prp.scope_id=p.products_id AND prp.scope='2')
OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='1')
OR (prp.scope='0'))
ORDER BY prp.scope DESC LIMIT 1; ==> (as called by) /var/www/vhosts/.../httpdocs/includes/functions/extra_functions/reward_points_functions.php on line 62 <== in /var/www/vhosts/.../httpdocs/includes/classes/db/mysql/query_factory.php on line 155
Check the file but it seem all fine... the line 51 to 62 of reward_points_functions.php look like this:
PHP Code:
if(zen_get_products_price_is_free($products_id)==false || REWARD_POINTS_ALLOW_ON_FREE=='1') // Allow RP on free items (Admin settable)
{
$sql = "SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute
FROM ".TABLE_REWARD_MASTER." prp, ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_TO_CATEGORIES." p2c
WHERE p.products_id='" . $products_id . "'
AND p2c.products_id='" . $products_id . "'
AND ((prp.scope_id=p.products_id AND prp.scope='".SCOPE_PRODUCT."')
OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='".SCOPE_CATEGORY."')
OR (prp.scope='".SCOPE_GLOBAL."'))
ORDER BY prp.scope DESC LIMIT 1;";
$result=$db->Execute($sql);
The specific of the server are:
Database: MySQL 5.1.73
Versione PHP: 5.3.3 (Zend: 2.3.0) PHP Memory Limit: 128M
I'm a little bit unsure of what that error could be... any guess would be helpful :smile:
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
I'm not sure if I'm blind but I cant find the installation directions for this mod. I love the mod and cant wait to install it.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
I have reinstalled and made sure my screen matches yours on advanced and it is still not working. I'm still having to transfer points manually.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
OK,
Tell me where i am going wrong here
Clean install of zen 1.5.4 with database imported from 1.39h which had reward points installed on it
Should i use the upgrade or the full version for this.
Because i looked in the upgrade version and there are only about 7 files, whereas in the new install version there are loads of files, Now as my zencart files are all new, there will be no reward point files already there, BUT as my database is imported from 1.39h it will still have the reward points data in it, which i don't want to lose.
So should i upload all files from "New install" versions and then run the "Upgrade SQL" or am i missing something, as i have read the instructions but they seem to be for either a completely new install or for an in place upgrade of an installed reward points module where the cart hasn't been upgraded since said module was installed
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
nigelt74
OK,
Tell me where i am going wrong here
Clean install of zen 1.5.4 with database imported from 1.39h which had reward points installed on it
Should i use the upgrade or the full version for this.
Because i looked in the upgrade version and there are only about 7 files, whereas in the new install version there are loads of files, Now as my zencart files are all new, there will be no reward point files already there, BUT as my database is imported from 1.39h it will still have the reward points data in it, which i don't want to lose.
So should i upload all files from "New install" versions and then run the "Upgrade SQL" or am i missing something, as i have read the instructions but they seem to be for either a completely new install or for an in place upgrade of an installed reward points module where the cart hasn't been upgraded since said module was installed
Since you are not upgrading but doing a fresh install of all files and keeping your old database, use the New_Installation and use the Upgrade-to-2.5a.sql statement. That should be all you need to do.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
DivaVocals
So doing some testing and found myself having to explain this to my client:
Quote:
Advanced mode: Set the order status items that will trigger a transfer of the reward points between pending and earned. Points are transfered when the status changes between the "Pending" and "Earned". Status items set to "Ignore" will have no effect if the Order Status changes to it.
Honestly this is truly as clear as mud.. I changed it on my client's shop to read:
Quote:
Advanced mode: Allows you to select the order status that will trigger a transfer of reward points from pending to earned. Points are transferred when the status changes between status items set to "Pending" and status items set to "Earned". Status items set to "Ignore" will have no effect on Order Status changes to it.
Wanted to share in case someone wants to make a similar change.. (or understand better what this means..:smile:)
Diva if you don't mind I'm using your suggesting in changing the words for the Reward Point Status Track advance mode settings in the Reward_Points_Full_Install.sql.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
DivaVocals
Reinstalling this as part of a v1.5.4 upgrade for a client.. Can someone explain WHY the upgrade SQL contains the admin page delete statements only to RE-INSERT the same entries again later in the script??
Code:
/*
zencart 1.5 mods
*/
DELETE FROM admin_pages WHERE page_key='configRewardPoints';
DELETE FROM admin_pages WHERE page_key='GroupRewardRedeem';
DELETE FROM admin_pages WHERE page_key='RewardPoints';
DELETE FROM admin_pages WHERE page_key='CustomerRewardPoints';
SELECT @cgi:=configuration_group_id FROM configuration_group WHERE configuration_group_title = 'Reward Points';
INSERT INTO configuration
(configuration_id ,configuration_title ,configuration_key ,configuration_value ,configuration_description ,configuration_group_id ,sort_order ,last_modified ,date_added ,use_function ,set_function)
VALUES (NULL , 'Show Reward Points on Product Info Display Page', 'SHOW_REWARD_POINTS_PRODUCT', '0', 'Display Reward Points on product info display page?<br />0= No<br />1= Yes', @cgi, '1', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');
INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configRewardPoints','BOX_CONFIGURATION_REWARD_POINTS','FILENAME_CONFIGURATION',CONCAT('gID=',@cgi), 'configuration', 'Y', @cgi);
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('GroupRewardRedeem', 'BOX_GROUP_REWARD_POINTS_REDEEM', 'FILENAME_ADMIN_GROUP_REWARD_POINTS_REDEEM', '', 'customers', 'Y', 35);
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('RewardPoints', 'BOX_REWARD_POINTS', 'FILENAME_ADMIN_REWARD_POINTS', '', 'catalog', 'Y', 36);
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('CustomerRewardPoints', 'BOX_CUSTOMER_REWARD_POINTS', 'FILENAME_ADMIN_CUSTOMER_REWARD_POINTS', '', 'customers', 'Y', 37);
As far as I can see the only REAL "upgrade/change" is the addition of one more configuration option.. Am I missing something here?????
This has been updated in the next release.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
izar74
Dunno if this could help, i'm still trying to figure it out, but Diva's mumbling made me mumble a lot :P.. so i found this kind of solution...
I modified the code:
PHP Code:
<?php
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
echo ' <tr>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $currencies->format($order->totals[$i]['value'], false) . '</td>' . "\n" .
' </tr>' . "\n";
}
?>
With:
PHP Code:
<?php
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
if ($order_total['class'] = "ot_reward_points_display") {
echo ' <tr>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
' </tr>' . "\n";
} else {
echo ' <tr>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $currencies->format($order->totals[$i]['value'], false) . '</td>' . "\n" .
' </tr>' . "\n";
}
}
?>
It seem to work... still testing
This will be add in the next release. Thank you izar74
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
There will be a pagination on the Reward Points page too. It is not great but it will better than what came stock with reward points.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
countrycharm
There will be a pagination on the Reward Points page too. It is not great but it will better than what came stock with reward points.
Well it's a start :D
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Reward Point Full Suite - Version: 2.5c
Now available in the Plugins and Addons Directory
1.) Changes Added: Change the wording for Reward Point Status Track advance mode settings Admin->Configurations->Reward Points Configuration to better understand how to use the setting. Updated the Reward_Points_Full_Install.sql statement to reflect that change. ( Thanks to DivaVocals for suggestion this change. )
2.) Changes Added: Updated the Upgrade-to-2.5c.sql at the top because it deleted the Reward Points Admin page, only to RE-INSERT the same entries again later in the script. ( Thanks to DivaVocals for pointing this out. )
3.) Changes Added: Updated the admin/orders.php file to preserves the currency symbol for actual currency values, while displaying points as whole numbers. ( Thanks to izar74 for the code they suggested. )
4.) Changes Added: Added pagination on the Reward Points page. It is not great but it will better than what came stock with reward points.
5.) Files Added: ZC1.5.4 - Admin Plugin Backward Compatibility Plugin. We included this plugin created by lat9 into Reward Points to solve a compatibility issue once for all in zen cart v1.5.0, v1.5.1, v1.5.2, v1.5.3. ( Thanks to lat9. )
6.) Changes Added: Updated the _doc folder to reflect these changes.
7.) Changes Added: Updated the version number from 2.5b to 2.5c.
No major changes but would update the admin/orders.php file if you haven't already. It was really a bandaid solution to get Reward Point to show in admin/orders but now the right code has been implemented thanks to izar74.
If your Reward Points is working and you are happy live it as is..... :) If you have to upgrade your zen cart later on then look at using this version of Reward Points v2.5c.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
countrycharm
4.) Changes Added: Added pagination on the Reward Points page. It is not great but it will better than what came stock with reward points.
Does this resolve the issue of the Rewards Points page NOT showing all customers?? For example, I click on the "J" and the module currently will not bring in ALL the customers whose last name begins with "J".. I assume the pagination will now allow me to page through ALL the results??
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
DivaVocals
Does this resolve the issue of the Rewards Points page NOT showing all customers?? For example, I click on the "J" and the module currently will not bring in ALL the customers whose last name begins with "J".. I assume the pagination will now allow me to page through ALL the results??
Quote:
For example, I click on the "J" and the module currently will not bring in ALL the customers whose last name begins with "J
Yes it seems to. The only thing that need working on is looking up a last name or a first name from the search results. It still brings in last or first name results for whatever name you are looking for. I'll look into fixing that later.
The other little pet pea is how many Reward Points page customers to view per page results. You have to set it from by using Admin->Configuration->Maximum Values->Maximum Display of Customers on Customers Page. This is how it is done for now.
I know a bandaid solution but it does work for now.... :)
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
I have installed Rewards Points (v 2.5b) for a client running Zen Cart v 1.5.1. Just one odd issue I'm having in the Admin configuration. The "Select mode:" and "Award points for new accounts?" boxes both fail to update the configuration.
In the browser dev tools Console, the error message is "Uncaught TypeError: Cannot set property 'value' of undefined." This happens in Chrome and IE 11. I am able to update other configuration settings successfully.
No one else seems to have mentioned an issue like this. Any thoughts on what could be going on?
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
LAWebDev
I have installed Rewards Points (v 2.5b) for a client running Zen Cart v 1.5.1. Just one odd issue I'm having in the Admin configuration. The "Select mode:" and "Award points for new accounts?" boxes both fail to update the configuration.
In the browser dev tools Console, the error message is "Uncaught TypeError: Cannot set property 'value' of undefined." This happens in Chrome and IE 11. I am able to update other configuration settings successfully.
No one else seems to have mentioned an issue like this. Any thoughts on what could be going on?
I don't see that running a stock zen cart 1.5.4. Everything works correctly.
If I have time I will check it out on a clean version of 1.5.1.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
New version now available in the plugins' area Version: 25.d
1.) Bug in the pagination code in admin-->customers_reward_points.php file - Fixed reset button to properly go back to all customers.
Thanks to Ajeh
2.) Updated the _doc folder to reflect these changes.
3.) Updated the version number from 2.5c to 2.5d.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Small problem that I figured out but will drive folks crazy.
If you click on the edit button, the entire list of customers display but when you get back to the page the actual customer is on, it's open and editable. If you click on the line/customer name that doesn't happen.
In addition, the reward points page only shows the what's enabled in admin - changing the number of customers that are supposed to display does not work.
Thanks for you work on this!!
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Quote:
Originally Posted by
delia
Small problem that I figured out but will drive folks crazy.
If you click on the edit button, the entire list of customers display but when you get back to the page the actual customer is on, it's open and editable. If you click on the line/customer name that doesn't happen.
In addition, the reward points page only shows the what's enabled in admin - changing the number of customers that are supposed to display does not work.
Thanks for you work on this!!
Quote:
you click on the edit button, the entire list of customers display but when you get back to the page the actual customer is on, it's open and editable. If you click on the line/customer name that doesn't happen.
Not quite understanding what you are pointing out here.
Quote:
In addition, the reward points page only shows the what's enabled in admin - changing the number of customers that are supposed to display does not work.
Sure it does...
If you are talking about showing how many customers to view at one time on the reward points page You can set by using Admin->Configuration->Maximum Values->Maximum Display of Customers on Customers Page.
I tested it and it works....
If something is wrong with it, would you mind sharing so everybody else knows what going on and how to fix it, or send it to me and I will add it to the next release...
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
There are two ways to click on a customer on the rewards page. You can click on the customer's name or any of the text on that line or you can click on the green edit button. If you are on page 2 or more, clicking on the line instead of the green button works fine. If you click on the edit button, the screen refreshes and you go back to page one. When you go back to the page where the customer is, then you see the boxes open for that customer. So if the action is supposed to be the same - change the edit button to match the other.
button: customers_reward_points.php?id=80&action=edit
link: ustomers_reward_points.php?page=1&id=80&action=edit
in the configuration:
Limit Maximum Customers on Listings
Set the maximum number of records to appear on each page under Customer Reward Point admininstration page.
Changing that does not change anything so what you say makes sense - about the maximum numbers. Which means it needs removing?
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
From what I can tell on line 325 the code in RED is missing:
Code:
<?php echo '<a href="' . zen_href_link(FILENAME_ADMIN_CUSTOMER_REWARD_POINTS, zen_get_all_get_params(array('id', 'action')) . 'id=' . $customers->fields['customers_id'] . '&action=edit') . '">' . zen_image(DIR_WS_IMAGES . 'icon_edit.gif', ICON_EDIT) . '</a>'; ?>
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
thank ajeh! I knew it was simple. Just didn't take time to look at the code.
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
No problem ... glad you caught that as I did not even notice the issue ... :lookaroun
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
One other change is for the Update button on line 355:
Code:
$contents = array('form' => zen_draw_form('customer_reward_point_admin', FILENAME_ADMIN_CUSTOMER_REWARD_POINTS, zen_get_all_get_params(array('id', 'action')) . 'id='.$current_customer['customers_id'].'&action=update', 'post'));
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
Another change would be around line 229:
Code:
echo '<td class="dataTableRow" width="3%" align="center" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);" onclick="document.location.href=\''.zen_href_link(FILENAME_ADMIN_CUSTOMER_REWARD_POINTS, zen_get_all_get_params(array('customer_sort_index', 'action', 'id', 'page')) . 'customer_sort_index='.chr(65+$loop)).'\'">'.chr(65+$loop).'</td>';
-
Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread
I am having an issue with installing the sql patch for this mod. I am getting errors that state:
Cannot insert configuration_key "" because it already exists
This is happening on all of the "INSERT INTO configuration" statements. As of now, nothing appears on the "Configuration > Reward Point Configuration" page except the heading. I am running ZC 1.5.4. Any help will be greatly appreciated.