[Skip to main content](#vessel-content) # wrong total price exclusice tax in admin email ## - **[michael\_steiner](/forum/user/2674-michael-steiner "View michael_steiner's Profile")** - [![michael_steiner's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2674-michael-steiner "View michael_steiner's Profile") Topic Author - [ Offline](/forum/user/2674-michael-steiner) Less More - Posts: 11 - Thank you received: 0 - - - - [](http://www.octa-it.at) - 15 years 2 months ago [\#24492](#24492) by [michael\_steiner](/forum/user/2674-michael-steiner "View michael_steiner's Profile") *[wrong total price exclusice tax in admin email](/forum/3-bug-report/24492-wrong-total-price-exclusice-tax-in-admin-email#24492 "Hi, when order is finished 2 emails are sent: one to the client one to the admin the corresponding views are not modified by me (original version) the views seems for me to access the same data the total value in client email is correct calculated. the total value in admin email is wrong. the difference comes by wrong tax calculation of the shipping price in some other place of HS. (Liefermethode: price 9,48 is incl. tax)")* was created by *[michael\_steiner](/forum/user/2674-michael-steiner "View michael_steiner's Profile")* Hi, when order is finished 2 emails are sent: one to the client one to the admin the corresponding views are not modified by me (original version) the views seems for me to access the same data the total value in client email is correct calculated. the total value in admin email is wrong. the difference comes by wrong tax calculation of the shipping price in some other place of HS. (Liefermethode: price 9,48 is incl. tax) image missing http://www.hikashop.com/media/kunena/attachments/legacy/images/admin.PNG --- brgds Michael - [ ![admin.PNG](/forum/attachment/1693) ](/forum/attachment/1693 "admin.PNG") [ ](/forum/attachment/1693?download=1 "admin.PNG") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNDQ5Mi13cm9uZy10b3RhbC1wcmljZS1leGNsdXNpY2UtdGF4LWluLWFkbWluLWVtYWlsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[michael\_steiner](/forum/user/2674-michael-steiner "View michael_steiner's Profile")** - [![michael_steiner's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2674-michael-steiner "View michael_steiner's Profile") Topic Author - [ Offline](/forum/user/2674-michael-steiner) Less More - Posts: 11 - Thank you received: 0 - - - - [](http://www.octa-it.at) - 15 years 2 months ago [\#24493](#24493) by [michael\_steiner](/forum/user/2674-michael-steiner "View michael_steiner's Profile") Replied by *[michael\_steiner](/forum/user/2674-michael-steiner "View michael_steiner's Profile")* on topic *[Re: wrong total price exclusice tax in admin email](/forum/3-bug-report/24492-wrong-total-price-exclusice-tax-in-admin-email#24493 "Hi, when order is finished 2 emails are sent: one to the client one to the admin the corresponding views are not modified by me (original version) the views seems for me to access the same data the total value in client email is correct calculated. the total value in admin email is wrong. the difference comes by wrong tax calculation of the shipping price in some other place of HS. (Liefermethode: price 9,48 is incl. tax)")* here is the client email image missing http://www.hikashop.com/media/kunena/attachments/legacy/images/client.PNG --- brgds Michael - [ ![client.PNG](/forum/attachment/1694) ](/forum/attachment/1694 "client.PNG") [ ](/forum/attachment/1694?download=1 "client.PNG") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNDQ5Mi13cm9uZy10b3RhbC1wcmljZS1leGNsdXNpY2UtdGF4LWluLWFkbWluLWVtYWlsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[michael\_steiner](/forum/user/2674-michael-steiner "View michael_steiner's Profile")** - [![michael_steiner's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2674-michael-steiner "View michael_steiner's Profile") Topic Author - [ Offline](/forum/user/2674-michael-steiner) Less More - Posts: 11 - Thank you received: 0 - - - - [](http://www.octa-it.at) - 15 years 2 months ago [\#24495](#24495) by [michael\_steiner](/forum/user/2674-michael-steiner "View michael_steiner's Profile") Replied by *[michael\_steiner](/forum/user/2674-michael-steiner "View michael_steiner's Profile")* on topic *[Re: wrong total price exclusice tax in admin email](/forum/3-bug-report/24492-wrong-total-price-exclusice-tax-in-admin-email#24495 "Hi, when order is finished 2 emails are sent: one to the client one to the admin the corresponding views are not modified by me (original version) the views seems for me to access the same data the total value in client email is correct calculated. the total value in admin email is wrong. the difference comes by wrong tax calculation of the shipping price in some other place of HS. (Liefermethode: price 9,48 is incl. tax)")* Hi, just for curiosity. the admin email was sent 09:00:47 with wrong total_price_without_tax the client email was sent 09:00:48 with correct total_price_without_tax could it be that some calculations were not finished and the admin email process has seen other values from the database, than the client email process? I don't know if there is record locking forseen in the software. --- brgds Michael Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNDQ5Mi13cm9uZy10b3RhbC1wcmljZS1leGNsdXNpY2UtdGF4LWluLWFkbWluLWVtYWlsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14279 - - 15 years 2 months ago [\#24514](#24514) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: wrong total price exclusice tax in admin email](/forum/3-bug-report/24492-wrong-total-price-exclusice-tax-in-admin-email#24514 "Hi, when order is finished 2 emails are sent: one to the client one to the admin the corresponding views are not modified by me (original version) the views seems for me to access the same data the total value in client email is correct calculated. the total value in admin email is wrong. the difference comes by wrong tax calculation of the shipping price in some other place of HS. (Liefermethode: price 9,48 is incl. tax)")* Hi, That's indeed something we found out recently and already fixed on our end. You can correct the problem by changing the file media/com_hikashop/mail/order_admin_notification.html.php by the one in the archive enclosed. #### *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNDQ5Mi13cm9uZy10b3RhbC1wcmljZS1leGNsdXNpY2UtdGF4LWluLWFkbWluLWVtYWlsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[michael\_steiner](/forum/user/2674-michael-steiner "View michael_steiner's Profile")** - [![michael_steiner's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2674-michael-steiner "View michael_steiner's Profile") Topic Author - [ Offline](/forum/user/2674-michael-steiner) Less More - Posts: 11 - Thank you received: 0 - - - - [](http://www.octa-it.at) - 15 years 2 months ago [\#24524](#24524) by [michael\_steiner](/forum/user/2674-michael-steiner "View michael_steiner's Profile") Replied by *[michael\_steiner](/forum/user/2674-michael-steiner "View michael_steiner's Profile")* on topic *[Re: wrong total price exclusice tax in admin email](/forum/3-bug-report/24492-wrong-total-price-exclusice-tax-in-admin-email#24524 "Hi, when order is finished 2 emails are sent: one to the client one to the admin the corresponding views are not modified by me (original version) the views seems for me to access the same data the total value in client email is correct calculated. the total value in admin email is wrong. the difference comes by wrong tax calculation of the shipping price in some other place of HS. (Liefermethode: price 9,48 is incl. tax)")* Hi Nicolas! Thank you for the prompt answer, but this would have been to easy. I wrote it has nothing to do with the view of the emails. Maybe I didn't explain it clearly. Name Einzelpreis Menge Summe Bluetooth Transmitter 238,80 € 1 238,80 € inkl. VAT correct Liefermethode : 9,48 € inkl. VAT correct Gesamtsumme exkl. MwSt.: 208,48 € exkl. VAT WRONG Gesamtsumme inkl. MwSt.: 248,28 € inkl. VAT correct All taxes are 20% The failure is in : Gesamtsumme exkl. MwSt.: 208,48 € 248,28 divided by 6 times 5 is 206,90 Liefermethode : 9,48 € is the shipment price inclusive tax price without tax is 7,90 difference is 1,58 this is exact the amount your calculation is wrong. This failure is done not in the email views, it has to do with one of your controllers or helper functions. As I explained earlier the admin email is sent first getting wrong data from the system (database, variables what ever), with wrong calculation. Next is sent the client email with correct calculation. Somewhere in your system you take for the shipment instead of the excl. price the inkl. price to calculate the "Gesamtsumme exkl. MwSt.: 208,48 €". I hope I explained it more clearly now. best regards Michael --- brgds Michael Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNDQ5Mi13cm9uZy10b3RhbC1wcmljZS1leGNsdXNpY2UtdGF4LWluLWFkbWluLWVtYWlsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14279 - - 15 years 2 months ago [\#24544](#24544) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: wrong total price exclusice tax in admin email](/forum/3-bug-report/24492-wrong-total-price-exclusice-tax-in-admin-email#24544 "Hi, when order is finished 2 emails are sent: one to the client one to the admin the corresponding views are not modified by me (original version) the views seems for me to access the same data the total value in client email is correct calculated. the total value in admin email is wrong. the difference comes by wrong tax calculation of the shipping price in some other place of HS. (Liefermethode: price 9,48 is incl. tax)")* Please try to replace the line $tax = $data->cart->order_subtotal - $data->cart->order_subtotal_no_vat; by $tax = $data->cart->order_subtotal - $data->cart->order_subtotal_no_vat + $data->order_discount_tax + $data->order_shipping_tax; in that file. The shipping and discount taxes are apparently not taken into account in the display of the price without tax in the admin email. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNDQ5Mi13cm9uZy10b3RhbC1wcmljZS1leGNsdXNpY2UtdGF4LWluLWFkbWluLWVtYWlsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[michael\_steiner](/forum/user/2674-michael-steiner "View michael_steiner's Profile")** - [![michael_steiner's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2674-michael-steiner "View michael_steiner's Profile") Topic Author - [ Offline](/forum/user/2674-michael-steiner) Less More - Posts: 11 - Thank you received: 0 - - - - [](http://www.octa-it.at) - 15 years 2 months ago [\#24563](#24563) by [michael\_steiner](/forum/user/2674-michael-steiner "View michael_steiner's Profile") Replied by *[michael\_steiner](/forum/user/2674-michael-steiner "View michael_steiner's Profile")* on topic *[Re: wrong total price exclusice tax in admin email](/forum/3-bug-report/24492-wrong-total-price-exclusice-tax-in-admin-email#24563 "Hi, when order is finished 2 emails are sent: one to the client one to the admin the corresponding views are not modified by me (original version) the views seems for me to access the same data the total value in client email is correct calculated. the total value in admin email is wrong. the difference comes by wrong tax calculation of the shipping price in some other place of HS. (Liefermethode: price 9,48 is incl. tax)")* Hi Nicolas! Thank you very much for your support. Now it works correct. --- brgds Michael Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNDQ5Mi13cm9uZy10b3RhbC1wcmljZS1leGNsdXNpY2UtdGF4LWluLWFkbWluLWVtYWlsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[tfrangi](/forum/user/2588-tfrangi "View tfrangi's Profile")** - [![tfrangi's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2588-tfrangi "View tfrangi's Profile") - [ Offline](/forum/user/2588-tfrangi) - web master beginner Less More - Posts: 15 - Thank you received: 0 - - - - 15 years 4 weeks ago [\#26702](#26702) by [tfrangi](/forum/user/2588-tfrangi "View tfrangi's Profile") Replied by *[tfrangi](/forum/user/2588-tfrangi "View tfrangi's Profile")* on topic *[Re: wrong tax amount in client mail](/forum/3-bug-report/24492-wrong-total-price-exclusice-tax-in-admin-email#26702 "Hi, when order is finished 2 emails are sent: one to the client one to the admin the corresponding views are not modified by me (original version) the views seems for me to access the same data the total value in client email is correct calculated. the total value in admin email is wrong. the difference comes by wrong tax calculation of the shipping price in some other place of HS. (Liefermethode: price 9,48 is incl. tax)")* hi, sorry to open again this topic, but I find a quite important mistake which is a little bit different than michael_steiner's one : at the end of order, after paiement, two mails are send : - one for the admin with (first amount of items without VAT, amount of VAT only and last line is the total amount) - a second mail is sent to the client for a recap and the same information should appear, but that's my prob, amount of items is ok, total amount is ok, but, the amount of the VAT only in wrong ! here's a sreenshot of an email sent to a client : image missing http://www.hikashop.com/media/kunena/attachments/legacy/images/Capture_dcran_2011_10_05__13.png corrects informations should appears (which are rights on the mail admin receive) : - total for each items without VAT : 16,72 € ok - shipping (never VAT on that) 5 € ok - total without VAT 38,44 euro (it appears with 40€ more) - total amount with tax and shipping : 45€ ok what is weird is that total general is correct ! and the mail sent to admin is all ok... thanks a lot if you can spend a minute to help me... - [ ![Capture_dcran_2011_10_05__13.png](/forum/attachment/1819) ](/forum/attachment/1819 "..._10_05__13.png") [ ](/forum/attachment/1819?download=1 "..._10_05__13.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNDQ5Mi13cm9uZy10b3RhbC1wcmljZS1leGNsdXNpY2UtdGF4LWluLWFkbWluLWVtYWlsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14279 - - 15 years 4 weeks ago [\#26771](#26771) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: wrong tax amount in client mail](/forum/3-bug-report/24492-wrong-total-price-exclusice-tax-in-admin-email#26771 "Hi, when order is finished 2 emails are sent: one to the client one to the admin the corresponding views are not modified by me (original version) the views seems for me to access the same data the total value in client email is correct calculated. the total value in admin email is wrong. the difference comes by wrong tax calculation of the shipping price in some other place of HS. (Liefermethode: price 9,48 is incl. tax)")* Please download the new version on our website and update your website. That should correct the problem. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNDQ5Mi13cm9uZy10b3RhbC1wcmljZS1leGNsdXNpY2UtdGF4LWluLWFkbWluLWVtYWlsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.359 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)