Reward Points Module for ZC v13x

Thank you. I am sorry I changed where it was calculating by subtotal but missed the part where it calculated individually or by order total/subtotal.

Error on the Customer Reward Points Admin page:


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 'REWARD_POINTS_CUSTOMER_LIMIT' at line 1
in:
[select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_group_pricing, r.pending_points, r.reward_points, gp.group_name, rm.redeem_ratio from zen_customers as c LEFT JOIN (zen_reward_customer_points as r) ON (r.customers_id=c.customers_id) LEFT JOIN(zen_group_pricing as gp) ON (gp.group_id=c.customers_group_pricing) LEFT JOIN(zen_reward_master as rm) ON ((c.customers_group_pricing!=0 AND rm.scope=3 AND rm.scope_id=c.customers_group_pricing) OR (c.customers_group_pricing=0 AND rm.scope=0 AND rm.scope_id=0)) ORDER BY c.customers_id, c.customers_lastname LIMIT REWARD_POINTS_CUSTOMER_LIMIT;]
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.



I have reward_point_full_suite_1-26a

I want to uninstall the entire thing and reinstall. Will that fix my problem? When I uninstall it doesn't get rid of everything on my db.

Hello,

I am using the most current version of this module and the most current version of Zen Cart.

I need to put the reward points earned, reward points pending, and current order reward points on a section in my header.

I am new to php, can someone help me find the exact pieces of code I would have to isolate in order to achieve this?

Thanks,

Jordin

Quote:

---

Originally Posted by Jordin

Hello,

I am using the most current version of this module and the most current version of Zen Cart.

I need to put the reward points earned, reward points pending, and current order reward points on a section in my header.

I am new to php, can someone help me find the exact pieces of code I would have to isolate in order to achieve this?

Thanks,

Jordin

---

Whereabouts in your header- In the top "banner" of your page or one of the bars beneath it?

The install of this mod on 1.3.8a is easy to follow. When I do the sql patch thru the admin section - I get a sql error and no admin. I have installed many mods without problems. The error seems to indicate there is an error in the sql patch. I have redone several times - same error. I have a zen_ prefix in my database - don' know why I did that ages ago. Anyway, help please. Thanks

Quote:

---

Originally Posted by 2004g35

The install of this mod on 1.3.8a is easy to follow. When I do the sql patch thru the admin section - I get a sql error and no admin. I have installed many mods without problems. The error seems to indicate there is an error in the sql patch. I have redone several times - same error. I have a zen_ prefix in my database - don' know why I did that ages ago. Anyway, help please. Thanks

---

You need to extract the sqlpatch.zip file that comes with the mod. The sqlpatch.zip fixes a bug in the sqlpatch.php file. It is added as a zip because I don't like overwriting core files and the bug is minimal. The bug is reported here: http://www.zen-cart.com/forum/showthread.php?t=123631

I'm interested in offering reward points and would like to offer the customer more points (say 2p in the pound rather than 1p in the pound) when the sub-total is over a certain amount (say £25.00).

Is this possible/or advisable? Has anyone tried this? :unsure:

If so, could anyone point me in the right direction for the relevant sub-total functions that would need an amend.

Any help appreciated, and thanks in advance. :hug:

Quote:

---

Originally Posted by tvsupport

I'm interested in offering reward points and would like to offer the customer more points (say 2p in the pound rather than 1p in the pound) when the sub-total is over a certain amount (say £25.00).

Is this possible/or advisable? Has anyone tried this? :unsure:

If so, could anyone point me in the right direction for the relevant sub-total functions that would need an amend.

Any help appreciated, and thanks in advance. :hug:

---

Under Config->Reward Points set "Set Minimum Order Value to Redeem Points Against" to 25. Then under Customers->Group Rewards Redeem set "global points ratio" to 0.02

Quote:

---

Originally Posted by hem

Under Config->Reward Points set "Set Minimum Order Value to Redeem Points Against" to 25. Then under Customers->Group Rewards Redeem set "global points ratio" to 0.02

---

Thanks for the quick reply. I would still like to reward points under 25 pounds but less points eg 1 point per pound up to 25 pounds and 2 points thereafter. Sorry for any confusion.
Posted via Mobile Device

Just in case I caused confusion, ideally I would like to credit:

10 points for every pound if sub-total less than £25
20 points for every pound if sub-total is £25 or more

All points redeemed worth 0.01 pound.

(Idea being customers enticed to spend above £25 to gain double points per pound.)

:lookaroun

I did as you instructed - replaced the sqlpatch.php and re-loaded all again. Still getting an error and then can not get back into my admin section - the store still works though.
This is the error that I am getting --

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 `orders_id` FROM zen_orders) LIMIT 1' at line 1
in:
[SELECT * FROM zen_reward_status_track rs WHERE rs.`orders_id` NOT IN (SELECT `orders_id` FROM zen_orders) LIMIT 1;]
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

Thanks in advance for your help

i have the module installed but...

where is the rewards point order total which i can set each point = 1 cent ?

i have 3 module in order total, but non of them has this setting.

Quote:

---

Originally Posted by tvsupport

Just in case I caused confusion, ideally I would like to credit:

10 points for every pound if sub-total less than £25
20 points for every pound if sub-total is £25 or more

All points redeemed worth 0.01 pound.

(Idea being customers enticed to spend above £25 to gain double points per pound.)

:lookaroun

---

You would need to change the process function in includes/modules/order_total/ot_reward_points.php

Quote:

---

Originally Posted by 2004g35

I did as you instructed - replaced the sqlpatch.php and re-loaded all again. Still getting an error and then can not get back into my admin section - the store still works though.
This is the error that I am getting --

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 `orders_id` FROM zen_orders) LIMIT 1' at line 1
in:
[SELECT * FROM zen_reward_status_track rs WHERE rs.`orders_id` NOT IN (SELECT `orders_id` FROM zen_orders) LIMIT 1;]
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

Thanks in advance for your help

---

What version of MySQL are you running?

Quote:

---

Originally Posted by weber

i have the module installed but...

where is the rewards point order total which i can set each point = 1 cent ?

i have 3 module in order total, but non of them has this setting.

---

Under Customer->Group Reward Points. Just enter 0.03 for the Global Redeem.

my php is version 5.2.11 and mysql is ver 4.0.27
Thanks for looking at this for me

Hi everyone,

I was wondering if it was possible to make a purchase with Reward Points only and not by credit card/paypal?

I have installed ZC v1.3.8 and the Rewards Points FS v1.2.6
and everything seems fine so far in terms of configruation.

Im testing at the moment and I made the reward points worth one dollar and gave 200 points to one of the test users to purchase an item worth 70 points.

I have input !00% as the maximum points allowed to redeem, too.

On checkout it asked me for credit card details to proceed, is there something I have missed?

Cheers
Adam

Quote:

---

Originally Posted by 2004g35

my php is version 5.2.11 and mysql is ver 4.0.27
Thanks for looking at this for me

---

Your problem is that this mod requires v4.2 of MySQL minimum. You will need to get your host to upgrade it.

Quote:

---

Originally Posted by kellan4459

I have upgraded to version 1.26 but when I install and try to modify the Discount Table I can't add or delete the entries. I am searching the thread and I don't see anything on this yet so again I apologize if this has been discussed before.

---

I'm also having this issue where I can't delete/add the various percentages in the Discount Table.

Any assistance appreciated.

I'm running Zen Cart 1.3.8a.

Mick

Hi I installed this but when i went to Admin->Tools->Layout Box Controller nothing shows up for it any help would be awesome
Thanks

Quote:

---

Originally Posted by angelstubes

Hi I installed this but when i went to Admin->Tools->Layout Box Controller nothing shows up for it any help would be awesome
Thanks

---

The Reward Point boxes appear under Admin->Modules->Order Total

Quote:

---

Originally Posted by marmi01

I'm also having this issue where I can't delete/add the various percentages in the Discount Table.

Any assistance appreciated.

I'm running Zen Cart 1.3.8a.

Mick

---

Download the latest version from here: http://www.omnicia.com/Zencart%20Rew...s%20Module.zip

Thanks - i'll give that a go.

I got the reward points module working with the latest version but am still on unable to change the associated percentages - I get a browser error when I try to click the little red x.

I'm using the latest firefox and also have the same issue with IE8.

At present all I can use are the default percentages.

I have installed it all good BUT one thing
If a customer has enough points and nothing is owning at the end of check out its still going to paypal with the value of 0.00 how can i set it that it dont go to paypal please
MY customers are not happy

Quote:

---

Originally Posted by marmi01

I got the reward points module working with the latest version but am still on unable to change the associated percentages - I get a browser error when I try to click the little red x.

I'm using the latest firefox and also have the same issue with IE8.

At present all I can use are the default percentages.

---

Can you check that you have the following file installed:

admin/includes/javascript/reward_points.js

It should be 5818 bytes long.

Quote:

---

Originally Posted by angelstubes

I have installed it all good BUT one thing
If a customer has enough points and nothing is owning at the end of check out its still going to paypal with the value of 0.00 how can i set it that it dont go to paypal please
MY customers are not happy

---

This appears to be an issue with the PayPal mod- It should check to see if there is any amount owing on the order before requesting payment.

Quote:

---

Originally Posted by hem

This appears to be an issue with the PayPal mod- It should check to see if there is any amount owing on the order before requesting payment.

---

thanks But any idea how I fix it lol

Quote:

---

Originally Posted by hem

Can you check that you have the following file installed:

admin/includes/javascript/reward_points.js

It should be 5818 bytes long.

---

O have the same issue and yep admin/includes/javascript/reward_points.js has been installed

Quote:

---

Originally Posted by angelstubes

O have the same issue and yep admin/includes/javascript/reward_points.js has been installed

---

What error are you getting?

no error it just dont do anything!

Quote:

---

Originally Posted by angelstubes

thanks But any idea how I fix it lol

---

I not sure- My guess would be to code into the function pre_confirmation_check() so that the order total is checked and if it is zero then don't prompt for paypal details.

Quote:

---

Originally Posted by angelstubes

no error it just dont do anything!

---

Do you have a URL that I can check out?

http://resaletubes.com

Hi guys

I have recently installed RP 1.26a onto Zen Cart 1.3.8 and everything appears ok except for one thing.

The reward points values aren't showing on any of the products (Underneath the product description and price).

The points values are displayed on the Shopping cart and Reward Points sections in the right column just fine as well as on checkout, but not when you click on the product. (I'm using a custom template too if that helps).

If anyone can point me in the right direction or show me a previous thread/tutorial on this that would be great.

Cheers

hello, in my admin - customers - reward points, when i check the points of customers, it shows Value of Earned: 5%, but i want it showing Value of Earned: $10, what do i change the percent value to a fix value? :dontgetit

i use rp 1.26a

it works now, i forgot installing the rp module in admin :P

but i get another problem, tax culculation

if i click to redeem the collected points, it's applied to the total, the total is correct, but the tax doesn't change,

for example:
total $100, tax: 100*10%= $10
if redeem value of points $20, then tax should been (100-20)*10%=$8
but now tax is still $10.

what do i fix it? :dontgetit

Is there a way to show a link on the main account page for the customer? Right now the link on the account page is hidden in "view or change my account information". It would be awesome if it had it's own link for Reward points.

Quote:

---

Originally Posted by swamyg1

Is there a way to show a link on the main account page for the customer? Right now the link on the account page is hidden in "view or change my account information". It would be awesome if it had it's own link for Reward points.

---

If you look in the "Read Me" file, you will see:

4. Switch on the 'Shopping Cart with Rewards' sidebox using Admin->Tools->Layout Box Controller

4.1. There is also a "Reward Points" sidebox which displays points in cart and points earned (if logged in)

Quote:

---

Originally Posted by MrsQ

If you look in the "Read Me" file, you will see:

4. Switch on the 'Shopping Cart with Rewards' sidebox using Admin->Tools->Layout Box Controller

4.1. There is also a "Reward Points" sidebox which displays points in cart and points earned (if logged in)

---

I'm aware of both of those sideboxes, I'm just wondering if there's a way to show the link when the customer is inside their account.

I guess I could change the link to say "Change account info / View reward points"

HI All
I have installed a test for the latest point system. Its seems to be a great add on feature and I really want to get it live on my site. While I was testing I have come across an issue. i have ver 1.38 and I am using a discount table for when people buy quantities. If you purchse more than 2 items the price is cheaper, but the points do not reflect this they remain on the base price. I have switched on the include specials and discounts but it seems not to use the tabel rates. Can anyone help.
Thanks

Also forgot to add in last post I also have the tax issue. It does not reduce the tax after taking off the dicount
Thanks

Quote:

---

Originally Posted by hem

It would appear that your custom folder is not called "custom". Have you tried running the RPD (details in the readme). It will show you what your custom folder is called and let you know if you have copied the files to the right location.

---

Quote:

---

Originally Posted by Centec2b

Please can I ask for guidance on a problem that I do not understand

I am running a test system on Ubuntu Linux with Lamp. I a running the latest edition of Zen and have installed this contribution without known problems

When I go to TOOLS / LAYOUT BOXES CONTROLLER and look for the relevant files (ie includes/modules/sideboxes/custom/ reward_points.php and shopping_cart_with_rewards.php) they dont show.

If I move the files up one directory ie includes/modules/sideboxes/ they show

However after invoking them reward_points.php does not show in the sideboxes and shopping_cart_with_rewards.php causes the sidebox column to blank it and the ensuing items (if that makes sense)

What is also missing is the changes to the products where I believe you will see the points value. To my knowledge the relevant areas of the admin are turned on

The administration area shows up the relevant parts of the contribution fine and a test purchase also grants and saves the "points"

Phew - sorry a bit long winded but I would be grateful for any suggestions as to where to start looking. After 48 hours I dont have much hair left!

Thank you Centec2b

---

Hello,

I'm having an identical problem, I've run the RPD, it tells me that my custom folder is: DIR_WS_TEMPLATE (which I cannot find while using Filezilla to surf my domain)

But, /includes/modules/sideboxes/custom has both reward_points.php and shopping_cart_with_rewards.php.

Any advice?

Dennis

Hi There

This module works great for me but I have a bit of a situation I am struggling to solve. I currently use reward points per product and it works great!! We sell tickets for musical shows, so now my client wants to give "complimentary" tickets, so I created a discount code of 100%. The reward module still gives full reward points if the product is discounted.

So I thought I'd try the TOTAL/SUBTOTAL reward ear/redeem feature, but now it calculates reward points on shipping and handling...

Any ideas how to get past this issue?

The idea is that even if the product is complimentary, they should still pay handling and postage, but not earn reward points

Quote:

---

Originally Posted by cliffvt

Hi There

This module works great for me but I have a bit of a situation I am struggling to solve. I currently use reward points per product and it works great!! We sell tickets for musical shows, so now my client wants to give "complimentary" tickets, so I created a discount code of 100%. The reward module still gives full reward points if the product is discounted.

So I thought I'd try the TOTAL/SUBTOTAL reward ear/redeem feature, but now it calculates reward points on shipping and handling...

Any ideas how to get past this issue?

The idea is that even if the product is complimentary, they should still pay handling and postage, but not earn reward points

---

I'm currently working on this- Right now the RP mod either gives points calculated off of the products purchased or the subtotal of the sale or the total of the sale. If does not take into account any discounts, coupons or other promotional items.

Quote:

---

Originally Posted by thepollywog

Hello,

I'm having an identical problem, I've run the RPD, it tells me that my custom folder is: DIR_WS_TEMPLATE (which I cannot find while using Filezilla to surf my domain)

But, /includes/modules/sideboxes/custom has both reward_points.php and shopping_cart_with_rewards.php.

Any advice?

Dennis

---

DIR_WS_TEMPLATE is defined in includes/configure.php

Quote:

---

Originally Posted by hem

DIR_WS_TEMPLATE is defined in includes/configure.php

---

Found it: define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/');

What should I change it to? templates/custom/ ?

Does it matter that RPD says my custom folder is in:

DIR_WS_TEMPLATE

Whereas in configure.php it is written in the plural form (with an S at the very end)?

Appreciate the help!

Dennis

Quote:

---

Originally Posted by thepollywog

Found it: define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/');

What should I change it to? templates/custom/ ?

Does it matter that RPD says my custom folder is in:

DIR_WS_TEMPLATE

Whereas in configure.php it is written in the plural form (with an S at the very end)?

Appreciate the help!

Dennis

---

Apologies- it should be includes/init_includes/init_templates.php (line 40)

Quote:

---

Originally Posted by hem

Apologies- it should be includes/init_includes/init_templates.php (line 40)

---

Thanks again, I trust you mean this line:

define('DIR_WS_TEMPLATE', DIR_WS_TEMPLATES . $template_dir . '/');

?

What should I change it to? This:

define('DIR_WS_TEMPLATE', DIR_WS_TEMPLATES . $template_dir . 'includes/templates/custom');

?

Dennis

Hi all
can someone tell me how to set the earned points to pending and not automatically to earned ?
Thank you in advance

Quote:

---

Originally Posted by cla74

Hi all
can someone tell me how to set the earned points to pending and not automatically to earned ?
Thank you in advance

---

It's in the Admin->Configuration->Reward Points. What you are looking to set is Reward Point Status Track

v1.27a now available for beta testing.

New features include:

1. The ability to "fine tune" the order total to handle discounts, coupons, low order fees etc
2. Cash Discount added to Reward Point Discount order module.
3. Percentages are now handled in the Reward Point Configuration (Max Redeem in particular)

Download from here:

http://www.omnicia.com/Zencart%20Rew...s%20Module.zip

Quote:

---

Originally Posted by thepollywog

Thanks again, I trust you mean this line:

define('DIR_WS_TEMPLATE', DIR_WS_TEMPLATES . $template_dir . '/');

?

What should I change it to? This:

define('DIR_WS_TEMPLATE', DIR_WS_TEMPLATES . $template_dir . 'includes/templates/custom');

?

Dennis

---

Hi,

I made the change suggested above and it has had no effect. Is it possible that I need to restart the store for these changes to take effect, or that I need to try something else?

Dennis

Quote:

---

Originally Posted by hem

It's in the Admin->Configuration->Reward Points. What you are looking to set is Reward Point Status Track

---

My Reward Point Status Track is set to simple mode,but earned points going to earned status

Quote:

---

Originally Posted by thepollywog

Hi,

I made the change suggested above and it has had no effect. Is it possible that I need to restart the store for these changes to take effect, or that I need to try something else?

Dennis

---

It's more fundamental than that. One of the core files of ZenCart is not being called. Is there any chance you are running with a heavy modded template???

Quote:

---

Originally Posted by cla74

My Reward Point Status Track is set to simple mode,but earned points going to earned status

---

Could it be that you've set your store to automatically mark new orders as "Processed" rather than "Pending"

Quote:

---

Originally Posted by hem

Could it be that you've set your store to automatically mark new orders as "Processed" rather than "Pending"

---

Yes,it's sets to processed!!
isnt there a way to make it works anyway?

Quote:

---

Originally Posted by cla74

Yes,it's sets to processed!!
isnt there a way to make it works anyway?

---

Sorry,
i've made a mistake.
The order status is sets to pending after a customer place an order

Quote:

---

Originally Posted by cla74

Sorry,
i've made a mistake.
The order status is sets to pending after a customer place an order

---

If it's set to Pending then the reward points should go to Pending rather than Earned.

I have installed the new version. I was hopeing that the Tax would be working now but it si not. If someone has $10 worth of points and the buy something for $10 and the shipping is $5 then they should only pay the $5. At the moment they have to pay the $5 and the Base Tax applicable to the product they bought. I have tried all day to fix it but do not have a clue really. Is there a quick way to get the tax working as well.

I also see that when you select "allow redeem on total " in the admin section my order value somehow changes and it sayd that you cannot redeem your points below $50 as I have this as a setting.

Everything is great for the rest it seems I just really need the tax sorted. Am I missing a setting somehere. Thanks

Quote:

---

Originally Posted by hem

v1.27a now available for beta testing.




New features include:

1. The ability to "fine tune" the order total to handle discounts, coupons, low order fees etc
2. Cash Discount added to Reward Point Discount order module.
3. Percentages are now handled in the Reward Point Configuration (Max Redeem in particular)

Download from here:

http://www.omnicia.com/Zencart%20Rew...s%20Module.zip

---

Quote:

---

Originally Posted by ChrisR

I have installed the new version. I was hopeing that the Tax would be working now but it si not. If someone has $10 worth of points and the buy something for $10 and the shipping is $5 then they should only pay the $5. At the moment they have to pay the $5 and the Base Tax applicable to the product they bought. I have tried all day to fix it but do not have a clue really. Is there a quick way to get the tax working as well.

I also see that when you select "allow redeem on total " in the admin section my order value somehow changes and it sayd that you cannot redeem your points below $50 as I have this as a setting.

Everything is great for the rest it seems I just really need the tax sorted. Am I missing a setting somehere. Thanks

---

Use the new Advanced Reward Point Calculation Rules config setting and add ot_tax as a rule

Quote:

---

Originally Posted by hem

It's more fundamental than that. One of the core files of ZenCart is not being called. Is there any chance you are running with a heavy modded template???

---

Nope, fresh install of Zenn Cart, and a fresh install of the module.

I'd be off to the races if I could just clear this one hurdle, really appreciate any help you could provide...

Dennis

Quote:

---

Originally Posted by thepollywog

Nope, fresh install of Zenn Cart, and a fresh install of the module.

I'd be off to the races if I could just clear this one hurdle, really appreciate any help you could provide...

Dennis

---

Do you have a URL?

Quote:

---

Originally Posted by hem

Do you have a URL?

---

Have sent it privately.

Quote:

---

Originally Posted by thepollywog

Have sent it privately.

---

Well my main advice would be to change your hosts. Each page takes so long to load (around 30 seconds) that in its current state your site is unworkable. The latency could also be the reason for some of your other problems too.

Sorry for being blind, but where do I find this "Advanced points reward calculation rules" Perhaps I have not installed correctly.

Also I had the previous version installed. Do I need to update the dtata base as well using the new SQL or has this new version got no additions to the data base?

Will using this advanced piece fix the TAX?
Thanks

Quote:

---

Originally Posted by hem

Use the new Advanced Reward Point Calculation Rules config setting and add ot_tax as a rule

---

Quote:

---

Originally Posted by ChrisR

Sorry for being blind, but where do I find this "Advanced points reward calculation rules" Perhaps I have not installed correctly.

Also I had the previous version installed. Do I need to update the dtata base as well using the new SQL or has this new version got no additions to the data base?

Will using this advanced piece fix the TAX?
Thanks

---

It has a change to the Reward Points config so you'll have to run the update.sql

Quote:

---

Originally Posted by hem

It has a change to the Reward Points config so you'll have to run the update.sql

---

Hello again
I have now updated the database and found the advanced reward system you are talking about. How ever the tax still does not work. I will try to explain the issue.

Reward point mode: = 1
In the Order Totals Module-Reward points earned 102
- Reward points 105
Now the points earned are directlay after Sub Total
Advanced module has nothing set and then the points are great as they are based on the subtotal value of the order so now my points equaled the points in the basket.
If you changed the sort order back to 900 then the points changed and were incorrect. So up till here all is fine.

How ever lets say the order was the following:
Sub-Total: €185.50
Reward Points earned: 93 (half sub total)
Value of redeemed reward points: €130.00
Tax: (This is the issue) €35.25 it should be €10.55 as 185-130=55 and 19% vat is 10.55 not 35.25.
So now the customer pays an extra 24.70 for this order due to the VAT not being correct.

In your advanced option when i add things here it only affects the points not the VAT.

Also if you used the same order above leaving the points set to order 900 then you still cannot get it to be correct as you can add the VAT but not the subtracted points from the order.
I gues you would then want to use points set to induvidual items Reward point mode: = 1 but then I cannot get it to work correctly as I am using tables to add discount to quantites bought and it does not take this into consideration.

So as it is now it can be used except the VAT does not compute and I do not know where to add this to the calculations so that the $order = the $order - Redeemed reward points.

Hopefully this explains in a bit more detail.


Thanks

Chris

Quote:

---

Originally Posted by ChrisR

Hello again
I have now updated the database and found the advanced reward system you are talking about. How ever the tax still does not work. I will try to explain the issue.

Reward point mode: = 1
In the Order Totals Module-Reward points earned 102
- Reward points 105
Now the points earned are directlay after Sub Total
Advanced module has nothing set and then the points are great as they are based on the subtotal value of the order so now my points equaled the points in the basket.
If you changed the sort order back to 900 then the points changed and were incorrect. So up till here all is fine.

How ever lets say the order was the following:
Sub-Total: €185.50
Reward Points earned: 93 (half sub total)
Value of redeemed reward points: €130.00
Tax: (This is the issue) €35.25 it should be €10.55 as 185-130=55 and 19% vat is 10.55 not 35.25.
So now the customer pays an extra 24.70 for this order due to the VAT not being correct.

In your advanced option when i add things here it only affects the points not the VAT.

Also if you used the same order above leaving the points set to order 900 then you still cannot get it to be correct as you can add the VAT but not the subtracted points from the order.
I gues you would then want to use points set to induvidual items Reward point mode: = 1 but then I cannot get it to work correctly as I am using tables to add discount to quantites bought and it does not take this into consideration.

So as it is now it can be used except the VAT does not compute and I do not know where to add this to the calculations so that the $order = the $order - Redeemed reward points.

Hopefully this explains in a bit more detail.


Thanks

Chris

---

I understand it- It's just when I add ot_tax to my advanced rules (Action 'Add') the checkout works fine for me.

I have now made a clean install and tried again but I still cannot get the tax to work corectly. the pints are fine but tax keeps calculating on the normal tax rate.
I have Modules installed. Reward Points and Reward points earned. Reward points tiered is not installed and cannot be installed either if reward points is installed (hopefully that is correct)

Do yo perhaps have some other module installed that could be affecting the tax issue?

Not sure what else to try Is it possible to tell me the settings you have used in your modules?

Thanks
Chris

Hey! I am running this on my site and have only had one customization problem.

ot_reward_point_discount

I cant seem to edit the values of the rewards. I want to change from percentage % to dollar value $. And it also wont let me edit the value to redeem the rewards.

It is set at the default of 5000 5%, 10000 10%, and so on.

I dont want the rewards set so high, since most of my products are $2-25. I know I can adjust the points earned per dollar, but it just looks outrageous.

Is there a back end page that I can edit and FTP over to the server?

I dont have time to read through 117 pages, and i tried searching for previous posts with no luck, so sorry if this has been addressed before.

Not sure if my site url will be of any help, but visitors are always welcome!

www. moonbeamsoycandles .com/shop/ index.php

Quote:

---

Originally Posted by moonbeamsoycandles

Hey! I am running this on my site and have only had one customization problem.

ot_reward_point_discount

I cant seem to edit the values of the rewards. I want to change from percentage % to dollar value $. And it also wont let me edit the value to redeem the rewards.

It is set at the default of 5000 5%, 10000 10%, and so on.

I dont want the rewards set so high, since most of my products are $2-25. I know I can adjust the points earned per dollar, but it just looks outrageous.

Is there a back end page that I can edit and FTP over to the server?

I dont have time to read through 117 pages, and i tried searching for previous posts with no luck, so sorry if this has been addressed before.

Not sure if my site url will be of any help, but visitors are always welcome!

www. moonbeamsoycandles .com/shop/ index.php

---

Are you running the latest version? (see post http://www.zen-cart.com/forum/showpo...postcount=1152) for details.

Ok, just installed the new version. It pretty muched fixed my problem.

Thanks so much! and Thanks for this Mod! It is going to do wonders for everyone! I know you have spent a lot of time and effort on this. It is much apprecitated.

Quote:

---

Originally Posted by ChrisR

How ever lets say the order was the following:
Sub-Total: €185.50
Reward Points earned: 93 (half sub total)
Value of redeemed reward points: €130.00
Tax: (This is the issue) €35.25 it should be €10.55 as 185-130=55 and 19% vat is 10.55 not 35.25.
So now the customer pays an extra 24.70 for this order due to the VAT not being correct.

In your advanced option when i add things here it only affects the points not the VAT.
Chris

---

Chris- Think the issue is that the Redeemed Reward Points have also a VAT component too- The €130 is redeemed off of the total so whatever is left is the remainder including a 19% VAT. However this may not being recalculated in the Tax display. I'll look into this.

Unfortuantely I am a total novice with PHP so not really able to help here.
What I have been trying to find is where the order total is calculated for the final time and the TAX is calculated for the final time. If at this stage the final order amout must be chnaged to final order amount - points redeemed value the the tax should work as normal as the points redeemed value has already bee deducted before the tax is calculated and then it should work fine. I just have no idea where this is done.
Thanks chris

Quote:

---

Originally Posted by hem

Well my main advice would be to change your hosts. Each page takes so long to load (around 30 seconds) that in its current state your site is unworkable. The latency could also be the reason for some of your other problems too.

---

[Andrew] I've freshly installed Zencart on a new host, and installed RPM 1.26a. Exactly same problem (layout box controls are not appearing), so I suspect I'm not completing the install correctly.

RPD turns out different results than the last webhost though:

Reward Point Module Diagnostic
Site Settings
Zencart version: Zen Cart v1.3.8a
PHP version: 5.2.2
MySQL version: 5.0.77-log
Zencart Settings
Zencart Custom Folder: includes/templates/classic/
Zencart Custom Template: classic
Zencart MySQL Prefix: zen_
Folder/File Check
MySQL Database Check

The only steps in your installation readme that I have not completed are #2 (I presume it does not apply on a fresh install), and (because I don't know how or if it applies):

3.2.1 If you use table prefixes in ZenCart you will need to manually rename 2 Reward Point Mod tables:

3.2.1.1 Rename 'yourprefix_reward_product_points' to 'yourprefix_reward_master'

3.2.1.2 Rename 'yourprefix_reward_point_history' to 'yourprefix_reward_status_track'

Could you walk me through these steps or whatever you think is appropriate -- I haven't been able to find anything in this forum?

Dennis

Nevermind my last post! I think I figured it out! Had to dig back to the 8th page of this thread.

Just to make sure I haven't in some way made something worse, I just want to make sure I have, now, correctly followed Step #2 of the installation readme for RPM.

From the reward points diagnostic module I know that my custom folders are named "classic", so where ever I have found a folder actually named "custom" I have copied its contents into the folder named "classic" which exists at the same level in the tree.

Is that the correct method? I have only had to do this in 3 places, I am running a fresh Zen Cart install, with RPM being the only mod. After doing this, the sideboxes appeared in layout control as expected.

Dennis

Quote:

---

Originally Posted by thepollywog

Nevermind my last post! I think I figured it out! Had to dig back to the 8th page of this thread.

Just to make sure I haven't in some way made something worse, I just want to make sure I have, now, correctly followed Step #2 of the installation readme for RPM.

From the reward points diagnostic module I know that my custom folders are named "classic", so where ever I have found a folder actually named "custom" I have copied its contents into the folder named "classic" which exists at the same level in the tree.

Is that the correct method? I have only had to do this in 3 places, I am running a fresh Zen Cart install, with RPM being the only mod. After doing this, the sideboxes appeared in layout control as expected.

Dennis

---

Yep- sounds like you have done everything correctly.

Quote:

---

Originally Posted by ChrisR

Unfortuantely I am a total novice with PHP so not really able to help here.
What I have been trying to find is where the order total is calculated for the final time and the TAX is calculated for the final time. If at this stage the final order amout must be chnaged to final order amount - points redeemed value the the tax should work as normal as the points redeemed value has already bee deducted before the tax is calculated and then it should work fine. I just have no idea where this is done.
Thanks chris

---

I'll have a look at it when I get back to the office on Friday- Could be we only need a forced recalculation of the Tax module.

Hi,

Thanks for the update! Would like to ask is the point redeem system is available yet on 1.27a? I mean like customers may choose how many points they would like to redeem for. Thank you!

I have already install the latest one (v 1.27a)
but I still don't know how to change the discount table.
I want to change the reward point discount, i.e
3% - 5000point
etc.

are there any advice?
thx a lot
:blink:

Can anyone please let me how to fix this message?

Warning: Cannot modify header information - headers already sent by (output started at G:\wwwroot\xampp\htdocs\premiersalon.com.au\ws\admin\includes\languages\english\ extra_definitions\reward_points_definitions.php:39) in G:\wwwroot\xampp\htdocs\premiersalon.com.au\ws\admin\includes\init_includes\init _templates.php on line 36

Warning: Cannot modify header information - headers already sent by (output started at G:\wwwroot\xampp\htdocs\premiersalon.com.au\ws\admin\includes\languages\english\ extra_definitions\reward_points_definitions.php:39) in G:\wwwroot\xampp\htdocs\premiersalon.com.au\ws\admin\includes\functions\general. php on line 21

Quote:

---

Originally Posted by daxchoki

I have already install the latest one (v 1.27a)
but I still don't know how to change the discount table.
I want to change the reward point discount, i.e
3% - 5000point
etc.

are there any advice?
thx a lot
:blink:

---

You need to uninstall and install the module again for it to work.

Quote:

---

Originally Posted by oavs

Can anyone please let me how to fix this message?

Warning: Cannot modify header information - headers already sent by (output started at G:\wwwroot\xampp\htdocs\premiersalon.com.au\ws\admin\includes\languages\english\ extra_definitions\reward_points_definitions.php:39) in G:\wwwroot\xampp\htdocs\premiersalon.com.au\ws\admin\includes\init_includes\init _templates.php on line 36

Warning: Cannot modify header information - headers already sent by (output started at G:\wwwroot\xampp\htdocs\premiersalon.com.au\ws\admin\includes\languages\english\ extra_definitions\reward_points_definitions.php:39) in G:\wwwroot\xampp\htdocs\premiersalon.com.au\ws\admin\includes\functions\general. php on line 21

---

Have you edited any of the php files recently?

Quote:

---

Originally Posted by M a C

Hi,

Thanks for the update! Would like to ask is the point redeem system is available yet on 1.27a? I mean like customers may choose how many points they would like to redeem for. Thank you!

---

Hi,

I guess you missed out my question :blink:

Quote:

---

Originally Posted by M a C

Hi,

I guess you missed out my question :blink:

---

Sorry- No, the manual redeem didn't make it into this version. I got some way into it but it turned out to be a little more complicated than I had envisioned; hopefully it will make it into the next version.

Quote:

---

Originally Posted by hem

You need to uninstall and install the module again for it to work.

---

to uninstall the module, just run the uninstall sql right?
but I got this :

1146 Table 'cftlcom_zc1.configuration' doesn't exist
in:
[DELETE IGNORE FROM configuration WHERE configuration_group_id=@group_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.

:dontgetit

I find that someone has same problem with me, and you told about diagnostic.
http://www.omnicia.com/rpd.zip

I've downloaded it, what should I do next..
thx a lot...

Quote:

---

Originally Posted by daxchoki

to uninstall the module, just run the uninstall sql right?
but I got this :

1146 Table 'cftlcom_zc1.configuration' doesn't exist
in:
[DELETE IGNORE FROM configuration WHERE configuration_group_id=@group_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.

:dontgetit

---

No- just go to the Modules->Order Total, select the RP mod and click on Remove. Then click on Install to reinstall.

Quote:

---

Originally Posted by hem

No- just go to the Modules->Order Total, select the RP mod and click on Remove. Then click on Install to reinstall.

---

thx a lot
I've fixed the problem... :clap:

Hi, hem

Thanks for the nice add-on.
But recently I get a really weird issue on reward point add-on. Sometimes it does credit my customers' account the right reward points they earned after the status of their orders changed to 'Delivered' but sometimes it doesn't work but only deletes the reward points under pending. :(
This is my setting:
Reward Point Status Track Pend: [Pending, Processing] Earn: [Delivered]

Thanks in advance,
Best regards,

Quote:

---

Originally Posted by ShoesBuyOnline

Hi, hem

Thanks for the nice add-on.
But recently I get a really weird issue on reward point add-on. Sometimes it does credit my customers' account the right reward points they earned after the status of their orders changed to 'Delivered' but sometimes it doesn't work but only deletes the reward points under pending. :(
This is my setting:
Reward Point Status Track Pend: [Pending, Processing] Earn: [Delivered]

Thanks in advance,
Best regards,

---

Let me check that out- One question- do you have any other mods that might affect how an order is processed?

Quote:

---

Originally Posted by hem

I'll have a look at it when I get back to the office on Friday- Could be we only need a forced recalculation of the Tax module.

---

had any luck in resolving this issue? I have been unable to resoleve it myself.
Thanks
Chris

Quote:

---

Originally Posted by hem

Let me check that out- One question- do you have any other mods that might affect how an order is processed?

---

Hi, hem

Thanks for your reply.

I have Edit Orders, Improved Attributes Controller, Cross Sell and some other but not relative add-ons installed on my site. It looks weird that my new customers would not get pending reward points after they placed orders on my sites not to mention earned reward points. But when I used a test account(registered before) and made an order, it works.

Below is my settings for reward points:
Reward Point Mode 1
Reward Point Sidebox Display 0
Reward Point Status Track Pend: [Pending, Processing] Earn: [Delivered]
Reward Point Sunrise Period 0
Reward Point Redeem Minimum 200
Reward Point Redeem Maximum 400
Reward Point Rounding 0.01
Max Transactions to Display in Customer Admin 12
Delete Old Reward Transactions Period 366
Adjust Reward Points for Sales/Specials 1
Allow Reward Points on Free Products 0
Allow Redeem of Reward Points on Order Total or Subtotal 1
Set Minimum Order Value to Redeem Points Against 0
Limit Maximum Customers on Listings 50
Display Products Reward Points When Zero 1
Set New Account Reward Points No points awarded for new accounts

Thanks for your help,

Best regards,

Quote:

---

Originally Posted by cliffvt

Hi There

This module works great for me but I have a bit of a situation I am struggling to solve. I currently use reward points per product and it works great!! We sell tickets for musical shows, so now my client wants to give "complimentary" tickets, so I created a discount code of 100%. The reward module still gives full reward points if the product is discounted.

So I thought I'd try the TOTAL/SUBTOTAL reward ear/redeem feature, but now it calculates reward points on shipping and handling...

Any ideas how to get past this issue?

The idea is that even if the product is complimentary, they should still pay handling and postage, but not earn reward points

---

Was this fixed yet? I am having the same issue. And also having an issue with the module calculating points on orders someone is redeeming point on. Can this be fixed easily? Like stated before if I calculate points on the order total then it calculates points on the tax and shipping. While I can deal with the tax part I can't deal with the shipping part. If it has not been fixed is there an easy work around I can do?

Rich

Hi hem,

First off, great adds-on!! Thanks so much for your contribution.

It works great for me so far, there's only 1 thing that bugged me. My site use Singapore Dollar as the default currency, and the symbol I used is S$. And the reward points box didn't show up properly during checkout

http://farm5.static.flickr.com/4054/...572ecb88fc.jpg

When I changed the symbol to $, the "&nbsp" was replaced with a space, which was a great. But for any other symbol, it would be like the picture above. I really need to use S$ or SGD as a symbol to avoid confusion with US dollar.

Please show me how to fix this? I use zen cart version 1.3.8, and the reward point mod version 1.26

Quote:

---

Originally Posted by hem

Let me check that out- One question- do you have any other mods that might affect how an order is processed?

---

I tried several times to get point.

However, results show that the points on admin page and main page are not match.

For example, I bought a product whch is $50.49, and then I got reward 455.


Orders pages shwos that Reward Points earned is 455.

However, Main pages shows that Reward Points is "491 points pending"

I installed both 1.26a and 1.27a.. but same situation~~~

What is wrong?

Please check this linked images. If you see this image, you understand what I am saing...

http://www.doremihouse.com/reward.jpg

Quote:

---

Originally Posted by hem

On the same page on the top right hand side there is a box which allows you to set the Global Redeem Ratio

---

This should be moved to a more normal place. I probably looked for an hour for this. :)

I have just installed RP Mod, but I have no RP Order Total Module. Am I missing something? I also have a custom template, but I simply cannot get the reward sideboxes to show. Am I missing something?

Hi,
I have just installed this add on but I have one small problem, the redeem points box does not show up during checkout, has anyone got any ideas why not?