Reward Points Module for ZC v13x

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

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

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?

hem:

Do you have a URL?

Have sent it privately.

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

hem:

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

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

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

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

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/showpost.php?p=807585&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.

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

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

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.

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!