Tax Calculation Based On Prices Which Includes Tax

Hi there,

I have a question regarding the calculation of the tax or the total price. I'm selling my products to clients living in Germany. So therefore I have to sell all my products with tax. And all my prices I want to show the clients in the shop are with tax.
So, what did I? I set the VAT Tax for Germany to 19%. And I set the checkbox for "Show prices including VAT".
The next step was to set the price values for my products to the price without VAT and I checked "Taxable".

Then everything seems good. But the calculation of the total price has rounding errors because it is based on the price without tax.
An example. I want to sell 5 photos each 3.90 euro (incl. TAX). Should be 19.50 euro in summary.

Summary is calculated on the price of 3.28 euro (3.90 - 19% tax) and is finally 19.52 euro.

A possible solution could be a more precise price without tax (in this case 3,2773109 euro) or better the calculation based on the price with tax.
Or is there an option I did not see?

Greetings from Germany,
Wolfgang

Edited by

If you send me an email, I can send you some code to run through PHPMyAdmin in your hosting control panel that will give you more decimal points for your prices.

Edited by

Hi - I need this too Tim.

I'm selling products for £3.50 inc VAT

So the base price I have entered is £2.92 - so the inc VAT price is £3.504. This should be rounded down at this point ideally, or the base price can be made more accurate if necessary to achieve the desired final exact price.

When I have two of these products in the cart, then the total ( £7.008 ) gets rounded up - so I'm selling two items for £7.01, rather than £7.00

And the cart page shows the anomaly - the products have the correct prices and the total shown at the bottom is wrong. I'm getting the same issue with other prices and shopping carts as well...

I wish we had the ability to have the base prices including VAT, and just show the VAT portion in the invoice - I modified photocart to do this as it was easier than calculating the pre tax price. In the UK most B2C pricing is quoted and displayed including VAT - though you still have to show the VAT portion on the invoices.

Edited by

Another anomaly seems to be the display of carts in the admin section. If you look at incomplete carts (? is that the right term) then they're displayed without VAT - see image. This is very confusing as you don't see the real value of the order.

Edited by

I'm having this problem too. Eg, my product costs $60 so I enter 54.5454 in the price box (sales tax is 10%) but the total is coming up as $60.01. It's not a big deal but it's a bit messy and is happening on several packages. If I could have the code too it would be great.

Edited Wed Feb 21, 18 5:56 PM by Sarah MacKenzie

If the prices are not saving the 4 decimal points in the price after saving, click Settings in the main menu of your Sytist admin.

Then underneath the left menu click MySQL query.

Copy the following and paste it in the query box and click run:

ALTER TABLE `ms_cart` CHANGE `cart_price` `cart_price` DECIMAL( 10, 4 ) NOT NULL DEFAULT '0.00';
ALTER TABLE `ms_photo_products` CHANGE `pp_price` `pp_price` DECIMAL( 10, 4 ) NOT NULL DEFAULT '0.00';
ALTER TABLE `ms_photo_products_connect` CHANGE `pc_price` `pc_price` DECIMAL( 10, 4 ) NOT NULL DEFAULT '0.00';
ALTER TABLE `ms_packages` CHANGE `package_price` `package_price` DECIMAL( 10, 4 ) NOT NULL DEFAULT '0.00';


If you need 6 decimals, you can use this:


ALTER TABLE `ms_cart` CHANGE `cart_price` `cart_price` DECIMAL( 10, 6 ) NOT NULL DEFAULT '0.00';
ALTER TABLE `ms_photo_products` CHANGE `pp_price` `pp_price` DECIMAL( 10, 6 ) NOT NULL DEFAULT '0.00';
ALTER TABLE `ms_photo_products_connect` CHANGE `pc_price` `pc_price` DECIMAL( 10, 6 ) NOT NULL DEFAULT '0.00';
ALTER TABLE `ms_packages` CHANGE `package_price` `package_price` DECIMAL( 10, 6 ) NOT NULL DEFAULT '0.00';

Edited Fri Feb 23, 18 6:22 AM by Tim - PicturesPro.com

Thanks Tim!
I can't find MySQL query.
I should be looking in my domain hosting settings (I couldn't find it on the sytist admin settings -it only had checkout, emails tax etc etc.)? I have MySQL databases, MySQL Database Wizard and Remote MySQL.

Edited by

Click Settings in the main menu of your Sytist admin.

Then underneath the left menu click MySQL query.

Edited by

Got it!! I was looking in the menu. Sorry for being obtuse!!!

Edited by

Hi Tim,
Could I please have the code that will do this for Buy Alls. Thanks! Sarah

Edited by

See this page under more decimals. I have added some code for the buy alls to it

https://www.picturespro.com/sytist-manual/settings/tax/

Edited by

Can decimals be added to shop and booking items too?

Edited by

Click Settings in the main menu of your Sytist admin

Underneath the left menu click MySQL query.

Copy the following lines of code and paste it in the query area and click run. This will give you 4 decimal places

ALTER TABLE `ms_calendar` CHANGE `prod_price` `prod_price` DECIMAL( 10, 4 ) NOT NULL DEFAULT '0.00';
ALTER TABLE `ms_calendar` CHANGE `prod_sale_price` `prod_sale_price` DECIMAL( 10, 4 ) NOT NULL DEFAULT '0.00';
ALTER TABLE `ms_calendar` CHANGE `book_deposit_flat` `book_deposit_flat` DECIMAL( 10, 4 ) NOT NULL DEFAULT '0.00';

Edited by

Has the MySQL Query link been removed?

I can not find it and need to fix the rounding up/down issues to 4 decimal places.
Thank you

Edited by

The MySQL query is not available in Sytist Hosted, but I have just now run that code for you.

Edited by