Jump to content

rounding down of prices in order


Recommended Posts

The total $ amount of my orders appears to be rounding down improperly.

 

Product A: 419.95 retail, has a 10% price discount for a price of $377.96

Product B: 34.95 retail, has a 10% price discount for a price of $31.46

 

When both are purchased together,

prestashop adds it together as $409.40 when is should be $409.42.

 

Even if I added the 2 retail prices together I would get

$454.90

with a 10% discount

the price is $409.41

 

Yes prestashop shows the final total as $409.40

how do I fix that.

Link to comment
Share on other sites

Hi barry,

I had to break out the calculator, but it turns out that this is just the way that PrestaShop rounds numbers. A 10% discount on a product retailing for $419.95 removes $41.995 from the price for a sale price of $377.95. However, before applying any discount, PrestaShop rounds the discount itself, so instead of $41.995, it applies a discount of $42.00 after rounding to the second decimal.

 

The same thing goes for the product at $34.95. The $3.495 discount is rounded to $3.50.

 

If you add those together, you get a total discount of $45.50 after rounding. Take that away from the combined retail price of $454.90, and you get a total of $409.40.

 

I hope this helps explain how our rounding system works.

 

-Mike

Link to comment
Share on other sites

The products I am selling are bound by a minimum price agreement.

 

For the $419.95 I am supposed to charged $377.96.

Which 90% of 419.95 is 377.955, which rounded up is 377.96

 

and for the 34.95 product, I am supposed to charge 31.46

which 90% of is 31.455 which rounded up is 31.46

 

if I add

377.96

and

31.46

I should get

409.42

 

if I change the type of round to superior or inferior

will that give me the result I am looking for

 

also is the rounding taking place on the total order

or on individual products

Link to comment
Share on other sites

Hi Barry,

The rounding takes place on the individual products at the discount in your situation. To see this for yourself, rather than taking 90% of your retail price, take 10% of it, round result there and subtract that from the retail price. That is how our rounding system is set up.

 

-Mike

Link to comment
Share on other sites

Mike,

 

I tried out superior and inferior round methods,

and then went back to classical.

 

now my 419.95 retail products

show as 377.95

they previously showed as 377.96

 

but when showing as other products in the same category

they show as 377.96

while now on the product detail page they show as 377.95

 

look at

http://www.homeschool-shelf.com/en/5-subject-sets/10-sos-3rd-grade-5-subject-set-2011-9780740323188.html

Link to comment
Share on other sites

Hi Barry,

You should check out the individual price settings for each product in the back office to try to find any discrepancies in the set-up.

 

Originally, I'll admit to being a little confused about the significance of a one cent rounding difference, but no more. You can't sell math software if we can't get it right ourselves! :P

 

-Mike

Link to comment
Share on other sites

Thanks Mike,

I appreciate that...

 

if possible there are two other weird things going on with my shop

 

1. After customer logs in as guest or registered customer, they can no longer select carrier options

at check out. The round selection dots are no longer selectable

 

2. The Tag block always shows the same tags...it never updates for the tags I enter for each product...

Link to comment
Share on other sites

Thanks Mike,

I appreciate that...

 

if possible there are two other weird things going on with my shop

 

1. After customer logs in as guest or registered customer, they can no longer select carrier options

at check out. The round selection dots are no longer selectable

 

2. The Tag block always shows the same tags...it never updates for the tags I enter for each product...

 

Would you mind posting your URL so that I can investigate this for you?

 

-Mike

Link to comment
Share on other sites

  • 3 weeks later...
×
×
  • Create New...