cart calculation strangeness

Running
OC 3.0.3.3,
default theme,
no extensions,
currency factor set to 1.0
I'm getting results in my cart I don't understand.

Product (stock) price = 500.00, 16% VAT = 80.00
Case A: set to display price w/o vat

Case B: set to display prices with vat

In your totals Tax should be before Total.

ADD Creative wrote: ↑

Sat Jun 13, 2020 4:07 am

In your totals Tax should be before Total.

You meant I should do it like that?


Well, this way button total and listed total don't differ anymore,
but the subtotal is still wrong.
On the store front the Mac is listed with 580.00
I bought one Mac, thus the subtotal has to be 580.00, not 500.00
Displaying 80.00 tax is correct, but it must not be part of the calculation here, since I had chosen to display prices with VAT included

Unfortunately that's just the way OpenCart has always worked. When you select display prices with tax. It only shows the product prices with tax. Totals are always shown excluding tax.

You would need to make some modifications to display how you want it to. You could always check the marketplace to see if there is an extension the does what you want.

ADD Creative wrote: ↑

Sat Jun 13, 2020 9:28 pm

Unfortunately that's just the way OpenCart has always worked. When you select display prices with tax. It only shows the product prices with tax. Totals are always shown excluding tax.

You would need to make some modifications to display how you want it to. You could always check the marketplace to see if there is an extension the does what you want.

Thank you very much for that information - I didn't know that.
But honestly I see no good reason to install an extension - just in order to sum up 1 + 1 correctly?

If my product is listed with 580.00 on the store front,
and the same item is listed once with 580.00 in the cart
the Sub-Total has to be 580.00. Anything else is simply a bug.
So hopefully there's a chance we got that fixed with the upcoming 3.0.3.4 release.

derzet wrote: ↑

Sun Jun 14, 2020 12:34 am

ADD Creative wrote: ↑

Sat Jun 13, 2020 9:28 pm

Unfortunately that's just the way OpenCart has always worked. When you select display prices with tax. It only shows the product prices with tax. Totals are always shown excluding tax.

You would need to make some modifications to display how you want it to. You could always check the marketplace to see if there is an extension the does what you want.

Thank you very much for that information - I didn't know that.
But honestly I see no good reason to install an extension - just in order to sum up 1 + 1 correctly?

If my product is listed with 580.00 on the store front,
and the same item is listed once with 580.00 in the cart
the Sub-Total has to be 580.00. Anything else is simply a bug.
So hopefully there's a chance we got that fixed with the upcoming 3.0.3.4 release.

The sub-total should display the price before tax. When enabling tax from your admin systems settings page, the total price should then display the tax price, not before.

straightlight wrote: ↑

Sun Jun 14, 2020 3:23 am

derzet wrote: ↑

Sun Jun 14, 2020 12:34 am

If my product is listed with 580.00 on the store front,
and the same item is listed once with 580.00 in the cart
the Sub-Total has to be 580.00. Anything else is simply a bug.

The sub-total should display the price before tax. When enabling tax from your admin systems settings page, the total price should then display the tax price, not before.

Okay, I think I'm beginning to understand ... and yes, then it's wrong from the basic concept.
There's a clear mathematical definition of what a sub-total should do, and that's: calculating the sum of WHATEVER values, up to a certain line.
In other words, if I had an invoice like
1 trash item $50.00
1 gold item $50.00
-------
running a sub-total at this stage HAS to display exactly these two values
2 (items) and $100.00
regardless of anything hidden that may have been already included somewhere

The sub-total only calculates the total before tax despite how many active products may originate from any active categories. Then, the total either includes taxes or VATs depending on their settings and regions and which extensions might also be used additionally.

In your case, if you're looking for a specific extension where the sub-total should be regrouped by category count to display those totals on the invoice, then an extension might be required for that. You could either look on the Marketplace for such solutions. If you cannot find any that may suit your specific needs, you could always create a new service request in the Commercial Support section of the forum or by contacting a reliable Opencart Partner from the Resources link at the top of the site to get this done as a custom job.

straightlight wrote: ↑

Mon Jun 15, 2020 8:26 am

The sub-total only calculates the total before tax ...
In your case, if you're looking for a specific extension where the sub-total should be regrouped by category count to display those totals on the invoice ....

Straightlight,
I'm not looking for a specific extension, I'm simply expecting transparency in my invoices and a DEFAULT form an average talented guy of my tax office will be able to follow. Name your currently available module "opencard-sub-total-special" ... whatever ... but it's not a sub-total in the usual sense.

A comprehensible invoice should be in line with the math of a spreadsheet,
and if I put a sub-total formular like SUM(B1:B10) in B11, it has to sum up the values of B1 to B10 - no matter where these values came from or what may be already in or excluded.

derzet wrote: ↑

Tue Jun 16, 2020 5:38 am

straightlight wrote: ↑

Mon Jun 15, 2020 8:26 am

The sub-total only calculates the total before tax ...
In your case, if you're looking for a specific extension where the sub-total should be regrouped by category count to display those totals on the invoice ....

Straightlight,
I'm not looking for a specific extension, I'm simply expecting transparency in my invoices and a DEFAULT form an average talented guy of my tax office will be able to follow. Name your currently available module "opencard-sub-total-special" ... whatever ... but it's not a sub-total in the usual sense.

A comprehensible invoice should be in line with the math of a spreadsheet,
and if I put a sub-total formular like SUM(B1:B10) in B11, it has to sum up the values of B1 to B10 - no matter where these values came from or what may be already in or excluded.

While you may simply be looking for specific requirements for the order totals, the order totals from the core do work as intended. If you'd like to use specific extensions, I would suggest to look on the Marketplace for more advanced solutions.