Reward Points Module for ZC v13x

[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

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

[hem]

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

[ChrisR]

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

[hem]

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.

[ChrisR]

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

[hem]

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.

[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

[hem]

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.

[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!

[ChrisR]

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