- Posts: 20
- Thank you received: 0
Price and calculating problems
11 years 2 months ago #210519
by crudi
Price and calculating problems was created by crudi
-- url of the page with the problem -- :
erlebnismanager.info/mieten/kategorie
-- HikaShop version -- : 2.5.0
-- Joomla version -- : 3.4.3
Hi,
at first I've got a display problem with prices. Without changing anything hikshop shows the retail price. In the setting it is set to price per unit. Is there any other main option where this could be set? Major and subs are set correctly...
The other thing is a calculating issue in checkout. The problem is, that total is not the sum of the single product prices - the tax is calculate new, so you get a rounding difference in price with tax.
Regards
Chris
-- HikaShop version -- : 2.5.0
-- Joomla version -- : 3.4.3
Hi,
at first I've got a display problem with prices. Without changing anything hikshop shows the retail price. In the setting it is set to price per unit. Is there any other main option where this could be set? Major and subs are set correctly...
The other thing is a calculating issue in checkout. The problem is, that total is not the sum of the single product prices - the tax is calculate new, so you get a rounding difference in price with tax.
Regards
Chris
Please Log in or Create an account to join the conversation.
11 years 2 months ago #210529
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Replied by Jerome on topic Price and calculating problems
Hi,
Are you sure that you didn't set a "retail price" for your products ?
www.hikashop.com/support/documentation/i...uct-form.html#prices
About the checkout issue ; please provide a screenshot as example.
Regards,
Are you sure that you didn't set a "retail price" for your products ?
www.hikashop.com/support/documentation/i...uct-form.html#prices
About the checkout issue ; please provide a screenshot as example.
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Please Log in or Create an account to join the conversation.
11 years 2 months ago #210623
by crudi
Replied by crudi on topic Price and calculating problems
So it shows the retail price if it is set in the product? I thought there prices need to be set to "show all"...
Attached a picture where you can see the wrong total incl. tax
Attached a picture where you can see the wrong total incl. tax
Please Log in or Create an account to join the conversation.
11 years 2 months ago #210629
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Replied by Jerome on topic Price and calculating problems
Hi,
I'm sorry but your total is absolutely fine ; there is nothing wrong in it.
Maybe you want to round the prices during the calculations ; in order to not have prices with more than 2 decimal.
At this moment you need to activate the corresponding setting "round prices during calculations" :
www.hikashop.com/support/support/documen...nfig.html#main_taxes
Regards,
I'm sorry but your total is absolutely fine ; there is nothing wrong in it.
Maybe you want to round the prices during the calculations ; in order to not have prices with more than 2 decimal.
At this moment you need to activate the corresponding setting "round prices during calculations" :
www.hikashop.com/support/support/documen...nfig.html#main_taxes
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Please Log in or Create an account to join the conversation.
11 years 2 months ago #210696
by crudi
Replied by crudi on topic Price and calculating problems
Sorry but the total is wrong. There is a difference from 1ct caused of a rounding problem.
The rows are correct because they need to be round down. The total without tax also is right but the total with tax isnt. Thats not the total thats again calculated the tax and there it need to be round up and therefore you get 1ct difference
The rows are correct because they need to be round down. The total without tax also is right but the total with tax isnt. Thats not the total thats again calculated the tax and there it need to be round up and therefore you get 1ct difference
Please Log in or Create an account to join the conversation.
11 years 2 months ago #210708
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Replied by Jerome on topic Price and calculating problems
Hi,
Like I wrote, the total is correct.
If you just read one single line, like the first product.
His unit price with tax is "0.33" but for a 40 quantity it's "13.33" (And 0.33 * 40 = 13.20)
You can't tell me that only the final total is incorrect when you have there proof that the price have more decimal that you do not see.
So it is not possible to just add the prices of the last column to get the final total, otherwise you're in contradiction for the unit price and final price.
Now if you take a look at the final total without tax, which is 160.66 and you add the 19% ; you got a " 191.1854 " total ; which is " 191.19 " once rounded.
Now, if you still have an issue with the total ; please explain it clearly.
Otherwise, just take a look at my previous message and activate the setting I'm suggesting you.
Regards,
Like I wrote, the total is correct.
If you just read one single line, like the first product.
His unit price with tax is "0.33" but for a 40 quantity it's "13.33" (And 0.33 * 40 = 13.20)
You can't tell me that only the final total is incorrect when you have there proof that the price have more decimal that you do not see.
So it is not possible to just add the prices of the last column to get the final total, otherwise you're in contradiction for the unit price and final price.
Now if you take a look at the final total without tax, which is 160.66 and you add the 19% ; you got a " 191.1854 " total ; which is " 191.19 " once rounded.
Now, if you still have an issue with the total ; please explain it clearly.
Otherwise, just take a look at my previous message and activate the setting I'm suggesting you.
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Please Log in or Create an account to join the conversation.
11 years 2 months ago #210750
by crudi
Replied by crudi on topic Price and calculating problems
Simple thing. The shown prices are:
13,33
5,83
13,92
158,10
Total = 191,18 €
The shown total is 191,19 €
Again the problem. Every single price is correct. The problem is that the total is not the sum of the single prices. You take the price without tax as a sum and then you caculate the total with tax. So if you look at the single prices again
11,20 * 1,19 = 13,328 so 13,33 is correct
4,90 * 1,19 = 5,831 so 5,83 is correct
11,70 * 1,19 = 13,923 so 13,92 is correct
132,86 * 1,19 = 158,1034 so 158,10 is correct
also 160,66 * 1,19 = 191,1854 so if you caculate that way 191,19 € is correct
BUT thats not the total of 13,33+5,83+13,92+158,10...
Attached the tax settings.
13,33
5,83
13,92
158,10
Total = 191,18 €
The shown total is 191,19 €
Again the problem. Every single price is correct. The problem is that the total is not the sum of the single prices. You take the price without tax as a sum and then you caculate the total with tax. So if you look at the single prices again
11,20 * 1,19 = 13,328 so 13,33 is correct
4,90 * 1,19 = 5,831 so 5,83 is correct
11,70 * 1,19 = 13,923 so 13,92 is correct
132,86 * 1,19 = 158,1034 so 158,10 is correct
also 160,66 * 1,19 = 191,1854 so if you caculate that way 191,19 € is correct
BUT thats not the total of 13,33+5,83+13,92+158,10...
Attached the tax settings.
Please Log in or Create an account to join the conversation.
11 years 2 months ago #210780
by nicolas
Replied by nicolas on topic Price and calculating problems
Well, that's normal.
That's the way it should be.
Most supermarkets calculate your bill like that.
They don't round prices during calculations and round the prices when they display them on the bill.
So if you sum the total of the lines of your supermarket bills you often find such discrepancies because they actually aren't. If you take the not rounded total of each row, sum them up and then round the result, you get the same amount as you see as total, like in HikaShop when you have the "round prices during calculations" setting turned off.
If you turn on that option, then the prices will be rounded at each step of the calculations and it will match when you sum the total of each row and compare it to the total calculated by HikaShop, as Jerome already told you.
So based on what you said you want, you want to turn on that option.
That's the way it should be.
Most supermarkets calculate your bill like that.
They don't round prices during calculations and round the prices when they display them on the bill.
So if you sum the total of the lines of your supermarket bills you often find such discrepancies because they actually aren't. If you take the not rounded total of each row, sum them up and then round the result, you get the same amount as you see as total, like in HikaShop when you have the "round prices during calculations" setting turned off.
If you turn on that option, then the prices will be rounded at each step of the calculations and it will match when you sum the total of each row and compare it to the total calculated by HikaShop, as Jerome already told you.
So based on what you said you want, you want to turn on that option.
Please Log in or Create an account to join the conversation.
11 years 2 months ago #210851
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Replied by Jerome on topic Price and calculating problems
Hi,
Just for the clarification :
13,328 + 5,831 + 13,923 + 158,1034 = 191,1854
Like I wrote before ; you can't made the addition on the rounded prices on one side and not on the other.
So if the unit prices are not rounded to calculate the total product prices ; it's the same for the total product prices when you calculate the order total price.
Regards,
Just for the clarification :
13,328 + 5,831 + 13,923 + 158,1034 = 191,1854
Like I wrote before ; you can't made the addition on the rounded prices on one side and not on the other.
So if the unit prices are not rounded to calculate the total product prices ; it's the same for the total product prices when you calculate the order total price.
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Please Log in or Create an account to join the conversation.
11 years 2 months ago #210869
by crudi
Replied by crudi on topic Price and calculating problems
The supermarkets in germany don't work like that because theay only use prices with tax
but that doesnt matter.
So far I see actually the shop rounds each line, also that option isnt turned on... is this, because € is set with 2 after comma?
So far I see actually the shop rounds each line, also that option isnt turned on... is this, because € is set with 2 after comma?
Please Log in or Create an account to join the conversation.
11 years 2 months ago #210880
by nicolas
Replied by nicolas on topic Price and calculating problems
Hi,
You're mixing up two things here.
Prices are always displayed rounded on the website, based on the number of decimals configured in the currency.
That has nothing to do with the "round prices during calculations" setting which will do such rounding at each step of the calculations if activated.
You're mixing up two things here.
Prices are always displayed rounded on the website, based on the number of decimals configured in the currency.
That has nothing to do with the "round prices during calculations" setting which will do such rounding at each step of the calculations if activated.
Please Log in or Create an account to join the conversation.
Time to create page: 0.277 seconds