Price and calculating problems

  • Posts: 20
  • Thank you received: 0
10 years 1 month ago #210519

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

Please Log in or Create an account to join the conversation.

  • Posts: 26274
  • Thank you received: 4045
  • MODERATOR
10 years 1 month ago #210529

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,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 20
  • Thank you received: 0
10 years 1 month ago #210623

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

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 26274
  • Thank you received: 4045
  • MODERATOR
10 years 1 month ago #210629

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,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 20
  • Thank you received: 0
10 years 1 month ago #210696

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

Please Log in or Create an account to join the conversation.

  • Posts: 26274
  • Thank you received: 4045
  • MODERATOR
10 years 1 month ago #210708

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,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 20
  • Thank you received: 0
10 years 1 month ago #210750

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.

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 84305
  • Thank you received: 13700
  • MODERATOR
10 years 1 month ago #210780

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.

Please Log in or Create an account to join the conversation.

  • Posts: 26274
  • Thank you received: 4045
  • MODERATOR
10 years 1 month ago #210851

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,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 20
  • Thank you received: 0
10 years 1 month ago #210869

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?

Please Log in or Create an account to join the conversation.

  • Posts: 84305
  • Thank you received: 13700
  • MODERATOR
10 years 1 month ago #210880

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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.072 seconds
Powered by Kunena Forum