Jump to content
Latest News: (loading..)
deep-silver

### POINTS AND REWARDS MODULE V1.00 ###

Recommended Posts

This is how mine is set-up

 

Sub-Total: £1,640.65

Per Item (Best Way): £3.78

UK VAT 15%: £245.54

Points Redeemed: -£10.00

Total: £1,879.97

 

At first look the VAT is wrong because 15% of £1640.65 = 246.10. But the tax is not being calculated on £1640.65 instead it is being calculated on £1636.93 which is my Sub-Total minus those items that have no VAT added to them - in this case the VAT is correct. I suggest everyone keep their order totals as originally advised when adding this contribution, make sure Points deduction is after sub total and shipping, tax but before total.

 

It makes more financial sense to deduct Points at the end, for example, your customer buys an item for £100 and pays £10 for shipping and £15 VAT and uses £20.00 worth of Points at checkout, meaning you get payment of £105. If you do it your way the customer would pay £80 for the item as they would redeem £20.00 worth of Points and then pay £10 for shipping and then pay £12 VAT, meaning you get a payment of £102.

 

I seem to recall the order total for Points was set to 6 because it was supposed to be applied after tax so there is not a ready made solution to this issue, not one that I can recall.

Edited by chooch

Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back!

 

Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you?

 

There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere.

 

CHOOCH

Share this post


Link to post
Share on other sites
This is how mine is set-up

 

Sub-Total: £1,640.65

Per Item (Best Way): £3.78

UK VAT 15%: £245.54

Points Redeemed: -£10.00

Total: £1,879.97

 

At first look the VAT is wrong because 15% of £1640.65 = 246.10. But the tax is not being calculated on £1640.65 instead it is being calculated on £1636.93 which is my Sub-Total minus those items that have no VAT added to them - in this case the VAT is correct. I suggest everyone keep their order totals as originally advised when adding this contribution, make sure Points deduction is after sub total and shipping, tax but before total.

 

It makes more financial sense to deduct Points at the end, for example, your customer buys an item for £100 and pays £10 for shipping and £15 VAT and uses £20.00 worth of Points at checkout, meaning you get payment of £105. If you do it your way the customer would pay £80 for the item as they would redeem £20.00 worth of Points and then pay £10 for shipping and then pay £12 VAT, meaning you get a payment of £102.

 

I seem to recall the order total for Points was set to 6 because it was supposed to be applied after tax so there is not a ready made solution to this issue, not one that I can recall.

 

The payment I receive is not the issue, the total is also correct (I have my shop set up to show prices including Tax), the issue is the VAT amount not being correct (also on the invoice).

The problem is that in my store people can alsobuy points and may deduct the VAT amount from that transaction for TAX reasons.

When they buy a product and the VAT is calculated of the Sub-total amount (instead of sub-total minus points amount), customers can deduct VAT thice and that is for obvious reasons not allowed.

 

So my Total looks like this :

 

Sub-Total: 50,00EUR

Points red.: - 25,00EUR

 

Total: 25,00EUR

 

(VAT amount 19%: 7,98EUR) <- should in my case be 3,99 calculated on sub-total minus points

 

 

Is it in any way possible to deduct points before the sub-total is generated, the I put "points redeemed" all the way on the top or to deduct the amount of points in the amount the VAT is calculated over?

 

I hope someone can help.

 

regards,Tom

Edited by TomH73

Share this post


Link to post
Share on other sites

I have install this great contribution. I have a issue about shipping cost tax.

 

Sub-Total: $30.00

United States Postal Service (1 x 8lbs) (Parcel Post): $9.56

TX TAX 8.25%: $3.26

Points Redeemed: -$42.04 (30.00 * 8.25% + 9.56) <<< I expect (30.00 + 9.56)* 8.25% >>>>

Total: $0.78

 

 

The points redeemed doesn't include shipping cost tax.

 

Could any one give a help?

 

Thanks,

Share this post


Link to post
Share on other sites

I tried to install this contribution to my living server. I got the following message:

 

Warning: Cannot modify header information - headers already sent by (output started at /home/ufashio1/public_html/catalog/point_reward_db_installer.php:31) in /home/ufashio1/public_html/catalog/point_reward_db_installer.php on line 242

 

Please help.

 

Thanks,

Share this post


Link to post
Share on other sites

Firstly what a fantastic contrib.

I have one error and that is with order total unless i have points to redeem i only get sub total and total showing. when redeeming points i get the following

Sub-Total:£98.33Points Redeemed:-£0.75Total:£109.96Taxes and shipping have been calculated and are corrrect sort orders are as follows

1 sub total

2 shipping

3 tax

4 Redeem

5 Discount coupon

6 Total.

Ive changed the order around but no success, can some one please point me in the right direction.

 

Thanks

Share this post


Link to post
Share on other sites

Hi

 

Not sure if you can or want to help on this as I have an older version which I am happy with. I have V1.6 because it works & I didn't need the add ons since, however I have noticed one problem that I'm hoping you may point me in the right direction to solve. :)

 

Points are NOT given on sale items, but they are being given if on a mixed order, so I have to manually adjust the figures before confirming them instead of just using the tick button in the order page. sale only & they don't get points. The problem arises when they have both sale & non-sale.

 

Which file & what code is controlling this please?

 

I realise this is a big ask, so if it can't be answered I'll just have to keep on manually doing it. :(

 

Thanks for any help.

Julie

Share this post


Link to post
Share on other sites
Posted 06 October 2008 - 02:29 AM

Bug found.

In a very rare case where full amount is covered by point and shipping tax and regular items tax are separated

the order total is not rounded correctly and you will be returned to payment page asking you to choose payment method.

to fix it

open catalog/includes/languages/english/modules/order_total/ot_redemptions.php

find this at line no.37

 

$order->info['total'] = $order->info['total'] - tep_calc_shopping_pvalue($customer_shopping_points_spending);

 

 

and replace with this.

 

$order->info['total'] = number_format($order->info['total'] - tep_calc_shopping_pvalue($customer_shopping_points_spending), 4);

 

 

in a normal cases you won't see any different.

 

post by DeepSilver

 

Posted 16 September 2009 - 10:50 PM

View Postsashaben, on Sep 16 2009, 09:39 PM, said:

I also had the same problem, I believe this will fix it

 

includes/modules/order_total/ot_redemption.php

Find

 

$order->info['total'] = number_format($order->info['total'] - tep_calc_shopping_pvalue($customer_shopping_points_spending), 4);

 

 

Replace With

 

$order->info['total'] -= tep_calc_shopping_pvalue($customer_shopping_points_spending);

 

 

 

Can someone confirm?

 

I can definitely confirm that your code does in fact fix the total addup issue when an order is in the 4 digits. Thank you so much!

 

I'm not proficient at PHP, but the way it was explained to me, you've reverted back to the original code and undone what the author intended to do??? I had a friend look at this as I was having the same problem. He came up with this.

Replace:

$order->info['total'] = number_format($order->info['total'] - tep_calc_shopping_pvalue($customer_shopping_points_spending), 4);

With this:

$order->info['total'] = number_format($order->info['total'] - tep_calc_shopping_pvalue($customer_shopping_points_spending), 4, '.', '');

 

It worked for me, and will still keep the original fix intact.

 

Michael

Share this post


Link to post
Share on other sites

I'm not proficient at PHP, but the way it was explained to me, you've reverted back to the original code and undone what the author intended to do??? I had a friend look at this as I was having the same problem. He came up with this.

Replace:

$order->info['total'] = number_format($order->info['total'] - tep_calc_shopping_pvalue($customer_shopping_points_spending), 4);

With this:

$order->info['total'] = number_format($order->info['total'] - tep_calc_shopping_pvalue($customer_shopping_points_spending), 4, '.', '');

 

It worked for me, and will still keep the original fix intact.

 

Michael

 

Thanks, that works! =)

Share this post


Link to post
Share on other sites

Hi,

 

I was wondering if anyone else is having this problem or knows how to fix it.

 

When I go to "Customers Points" and delete points, I check the box next to "Queue customers points table?" and "Notify Customer".

 

However, once I confirm that I want to delete points, it does not update the customers points table or send an email out even though it says it is successful at the top left of the screen when I am done.

 

When I check the "Queue customers points table?" box when I am adding points to a customer's account, it works fine.

 

Does anyone possibly know how to fix this?

 

Thank you very much.

Share this post


Link to post
Share on other sites

For Deep-Silver.

 

I have installed your wonderful contribution in my store and eventhough I think -along with everyone else- this is one of the best contributions ever I've also noticed that some of us have had the same problem with PayPal -IPN and/or Standard- in regards that when a customer uses points either to pay part or the full order, points don't get deducted of the total to be pay. As well as the fact that if customer changes his mind and go a back, their current points get lost.

 

When I first faced this problems, I went through the entire forum looking for a solution as I was sure someone with the same problem may have already came up with a solution but, after reading lots and lots of posts and tried every single "solution" even that most of them refer to PayPal IPN (I use PayPal Standard)and found that none of them really work I wrote the post below hoping someone could've help me.

 

I'm aware you don't use and even like PayPal as you said way back a while ago in some post when you started to be asked about this but if you check the forum, since you released Points/RewardsV2.1rc2a many of us still have this problems and unfortunately we can't simply give up PayPal due in our countries our customers want to pay us through them.

 

I know you haven't been around the forum for quite a while, but if you get to read this, I really hope you can help us all out with a solution not because we want you to solve our problems (as you said once) but because no one knows this contribution the way you do and this a very recurrent issue at the forum.

 

Wishing you the very best, receive my regards.

 

 

***** PayPal Standard*****

 

Hi all,I'm using PayPal Standard along with this great contribution (Points/RewardsV2.1rc2a) but unfortunately I can't get points to be deducted from my customer's order, in checkout_confirmation.php I get this:

 

Subtotal: $350.00

Shipping:$80.00

Points Redeemed:$-16.67

Total:$413.33

 

But once I'm forward to PayPal website I get:

 

Subtotal: $350.00

Shipping: $80.00

Total: $430.00

 

I've looked over the forum for days but it seems NO ONE has had this problem except with PayPal IPN -wich apparently has already been solved months ago- but applying the same code doesn't work as well as PuffDandEd's contribution (http://addons.oscommerce.com/info/3220).

 

Also, I have gone trough my installation step by step to see if I missed something but nothing's wrong.

 

Does ANYBODY out there has a figured out a solution for this?

 

PLEASE HELP!!!

Share this post


Link to post
Share on other sites

After searching this Forum for hours and days for a solution to my PayPal IPN issue with the points and rewards module I have not got any further and cannot find any answers!

 

I have worked out the following:

 

1. That PayPal IPN does not at present accept negative values, such as discount coupons or redeemed points in this module

 

2. That the only solution (that I can think of) is for any available person with the skills required to change any code that would see the Points Redeemed taken before the SUB TOTAL

 

 

CURRENT PROBLEM:

 

Products x 2: £7.60

 

Sub-Total: £7.60 <- This is the TOTAL sent to PayPal

Points Redeemed: -£5.00

Flat Rate (Best Way): £1.00

Total: £3.60 <-- This total is not sent by PayPal IPN

 

CHANGED TO:

 

Products x 2: £7.60

Points Redeemed: -£5.00

Sub-Total: £2.60 <- So the sub total price is inclusive of the points redeemed total

Flat Rate (Best Way): £1.00

Total: £3.60 <- Paypal will calculate this same amount with shipping cost and form this total

 

 

I know that probably didnt make any sense, but if anyone who is more competent in this sort of work can provide the code to subtract the redeemed points from the subtotal this could possibly resolve many of the issues surrounding the problems faced with using PayPal IPN.

 

However, I must agree with previous posts. This is really an amazing contribution and once this has been rectified will provide an amazing facility for my customers.

 

Regards

 

Dickie

Share this post


Link to post
Share on other sites

Hi Everybody,

 

Just like a lot of us, I had the same problem with Paypal IPN.

 

I'm still working on it, but I think I have somme elements to begin.

 

Of course, Paypal IPN must be set on "aggregate".

 

In ot_redemption.php, find :

 

$order->info['total'] = number_format($order->info['total'] - tep_calc_shopping_pvalue($customer_shopping_points_spending), 4);
$order->info['payment_method'] = ( $order->info['subtotal'] > 0) ? $order->info['payment_method'] . '+' . str_replace(':', '', TEXT_POINTS) : str_replace(':', '', TEXT_POINTS);

 

Just BEFORE, add :

$order->info['subtotal'] = number_format($order->info['subtotal'] - tep_calc_shopping_pvalue($customer_shopping_points_spending), 4);

 

Now, in your admin->modules->order total, set the order of the module BEFORE the sub-total.

 

Here it is ! For me, that works...

Share this post


Link to post
Share on other sites

Hi,

 

I was wondering if anyone else is having this problem or knows how to fix it.

 

When I go to "Customers Points" and delete points, I check the box next to "Queue customers points table?" and "Notify Customer".

 

However, once I confirm that I want to delete points, it does not update the customers points table or send an email out even though it says it is successful at the top left of the screen when I am done.

 

When I check the "Queue customers points table?" box when I am adding points to a customer's account, it works fine.

 

Does anyone possibly know how to fix this?

 

Thank you very much.

 

I had the same issue for the emailing of clients their point totals when they are confirmed out of the "pending" points table.

 

What I did was to change the SQL call on line 41 of customers_pending_points.php to include pulling the customers email from customers table. I'm not sure why the creator of this wants to rely (apparently) on POST data to send out the email. You are pulling from the customers table other information anyway.....

 

That being said, I have been pretty busy and haven't had time to evaluate where the issue in the script is. The points seem to transfer just fine from pending to the points available table for me.

 

If you need more information on how to do this change, let me know and I will post a step-by-step guide for you.

Share this post


Link to post
Share on other sites

Does anyone has a solution for this and know what to change in the code?

The order itself doesn't matter.

 

The payment I receive is not the issue, the total is also correct (I have my shop set up to show prices including Tax), the issue is the VAT amount not being correct (also on the invoice).

The problem is that in my store people can alsobuy points and may deduct the VAT amount from that transaction for TAX reasons.

When they buy a product and the VAT is calculated of the Sub-total amount (instead of sub-total minus points amount), customers can deduct VAT thice and that is for obvious reasons not allowed.

 

So my Total looks like this :

 

Sub-Total: 50,00EUR

Points red.: - 25,00EUR

 

Total: 25,00EUR

 

(VAT amount 19%: 7,98EUR) <- should in my case be 3,99 calculated on sub-total minus points

 

 

Is it in any way possible to deduct points before the sub-total is generated, the I put "points redeemed" all the way on the top or to deduct the amount of points in the amount the VAT is calculated over?

Share this post


Link to post
Share on other sites

I didn't see this in the configuration file but I don't think it should be happening. Customers are able to pay for shipping and tax using their points. If this is a default feature of the contribution how do I turn it off? If it's not why are customers able to do this? Does it have to do with the sort order? Right now the only thing they don't pay for is if they opt for shipping insurance.


Samuel Mateo, Jr.

osC 2.2 MS2

Installed Mods:

WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket

Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE

Share this post


Link to post
Share on other sites

To Avoid the shipping cost being redeemed with points you need to set up your order of your modules

Admin Area---->Modules--->Order Total

 

Here is the order below that I have mine. Keep in mind that there are no shipping costs on my site

 

Modules Sort Order

 

Points Redeemptions 4

Shipping 2

Sub-Total 1

Tax 3

Total 5

 

I would think that your order would be different. Just set the order that you want the points to be redeemed. For example your Points Redemtion should come before the shipping module.

 

Hope that helps!

I setup my sort order as follows and points are still able to be redeemed for shipping and tax.

 

Points Redemptions

Discount Coupon

Gift Card

USPS Shipping

USPS Insurance

Sub-Total

Tax

Total

 

The only thing being charged is USPS Insurance. See here: http://clip2net.com/clip/m7120/1257883015-clip-20kb.jpg

 

Customers should always pay for shipping and tax. Why is this not working?


Samuel Mateo, Jr.

osC 2.2 MS2

Installed Mods:

WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket

Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE

Share this post


Link to post
Share on other sites

Hi

 

I can't find the answer for this (have searched)

 

Even though "Award points for Specials" is set to false. It still does. :(

Is there a code change I need? Or is this not working for all versions? I have 1.6

 

How do I exempt products for points? If I enable points restriction I would expect to have to state which ones,but it asks "If restriction enabled set model allowed" ?

"Or set product ID allowed"

"Or set category ID allowed"

 

Could you explain please? :)

 

I would expect to set to true & have to put in the category ID which doesn't have points.

 

Also does this work as the special exception doesn't?

 

Thanks :)

Julie

Share this post


Link to post
Share on other sites

im having an issue with the referral system, i had enabled it in the admin section, but the email box when creating an account isnt showing. I read in one of the pages that someone commented out a couple lines, however i dont know exactly where that strip of code is, http://forums.oscommerce.com/topic/152746-points-and-rewards-module-v100/page__view__findpost__p__1372907

Share this post


Link to post
Share on other sites

Hello.

When clients redeem theis Points, the discount is not calculated in the shopping cart and i am not noticed, so i never know when they want to redeem their points unless i go check in the administration site and the client never know the correct total that he has to pay.

Can you help me please? Everything else seems to be working fine.

Share this post


Link to post
Share on other sites

Hello all,

 

Just installed the latest version (V2.1rc2a_1) and like it a lot - but there is a bug that I have not been able to find answer to in this forum.

 

It is occuring when a customer should check out an order and load the checkout_payment.php. This page does NOT fully load.

 

It happens only when a customer has reached the number of points so that he can redeem.

 

Any help is very greatful!

Edited by hanler

Share this post


Link to post
Share on other sites

Hi all,

 

Just want to know, can a customer who is buying a product, use the awarded points at once. So it will already, before paying, reduces the price with the awarded point/money?

 

Thank you,

Regards,

Rob

Share this post


Link to post
Share on other sites

Hello, im using CCGV and points&rewards, and i have huge problems to make points & rewards work together with ccgv.

Please help me to resolve this issue. CCGV works very well when only gift vouchers or coupon code are used, and points&rewards work very well only when points are used. when used together dont works very good.

 

when i use both contibs in the same order i get an error like i have not enough points, and ask me to select another payment. :(

 

Thank you very much

Share this post


Link to post
Share on other sites

Hello, im using CCGV and points&rewards, and i have huge problems to make points & rewards work together with ccgv.

Please help me to resolve this issue. CCGV works very well when only gift vouchers or coupon code are used, and points&rewards work very well only when points are used. when used together dont works very good.

 

when i use both contibs in the same order i get an error like i have not enough points, and ask me to select another payment. :(

 

Thank you very much

 

 

i think that here is where i need to play

 

if ((USE_POINTS_SYSTEM == 'true') && (USE_REDEEM_SYSTEM == 'true')) {

if (isset($_POST['customer_shopping_points_spending']) && is_numeric($_POST['customer_shopping_points_spending']) && ($_POST['customer_shopping_points_spending'] > 0)) {

$customer_shopping_points_spending = false;

if (tep_calc_shopping_pvalue($_POST['customer_shopping_points_spending']) < $order->info['total'] && !is_object($$payment)) {

$customer_shopping_points_spending = false;

tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(REDEEM_SYSTEM_ERROR_POINTS_NOT), 'SSL'));

} else {

$customer_shopping_points_spending = $_POST['customer_shopping_points_spending'];

if (!tep_session_is_registered('customer_shopping_points_spending')) tep_session_register('customer_shopping_points_spending');

}

}

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×