[Skip to main content](#vessel-content) # VAT problem ## - **[mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile")** - [![mohairbears's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/916-mohairbears "View mohairbears's Profile") Topic Author - [ Offline](/forum/user/916-mohairbears) Less More - Posts: 610 - Thank you received: 13 - 13 years 7 months ago [\#96613](#96613) by [mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile") *[VAT problem](/forum/2-general-talk-about-hikashop/79756-vat-problem#96613 "Hi, I need to now include VAT. Is it possible to leave my current product prices (including VAT) and display the VAT total in checkout? i.e. product price 5.00 including VAT checkout to display 4.17 in Order Total, and .83 in VAT @ 20%, Final Total 5.00 If this cannot be done what is the best way for me to proceed to set up VAT considering I have 1000's of products with prices that include the forthcoming VAT (April 1st)? thanks in advance")* was created by *[mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile")* Hi, I need to now include VAT. Is it possible to leave my current product prices (including VAT) and display the VAT total in checkout? i.e. product price 5.00 including VAT checkout to display 4.17 in Order Total, and .83 in VAT @ 20%, Final Total 5.00 If this cannot be done what is the best way for me to proceed to set up VAT considering I have 1000's of products with prices that include the forthcoming VAT (April 1st)? thanks in advance Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NzU2LXZhdC1wcm9ibGVtP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 13 years 7 months ago [\#96620](#96620) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[VAT problem](/forum/2-general-talk-about-hikashop/79756-vat-problem#96620 "Hi, I need to now include VAT. Is it possible to leave my current product prices (including VAT) and display the VAT total in checkout? i.e. product price 5.00 including VAT checkout to display 4.17 in Order Total, and .83 in VAT @ 20%, Final Total 5.00 If this cannot be done what is the best way for me to proceed to set up VAT considering I have 1000's of products with prices that include the forthcoming VAT (April 1st)? thanks in advance")* Hi, I think that the best way to do that would be to add a tax rate to your "default tax category", then this tax should be applied to all your products. Hope this will help you a little. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NzU2LXZhdC1wcm9ibGVtP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile")** - [![mohairbears's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/916-mohairbears "View mohairbears's Profile") Topic Author - [ Offline](/forum/user/916-mohairbears) Less More - Posts: 610 - Thank you received: 13 - 13 years 7 months ago [\#96621](#96621) by [mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile") Replied by *[mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile")* on topic *[VAT problem](/forum/2-general-talk-about-hikashop/79756-vat-problem#96621 "Hi, I need to now include VAT. Is it possible to leave my current product prices (including VAT) and display the VAT total in checkout? i.e. product price 5.00 including VAT checkout to display 4.17 in Order Total, and .83 in VAT @ 20%, Final Total 5.00 If this cannot be done what is the best way for me to proceed to set up VAT considering I have 1000's of products with prices that include the forthcoming VAT (April 1st)? thanks in advance")* Sorry but this is not what I want to do as explained, by doing that it will add a further 20% to the already set prices. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NzU2LXZhdC1wcm9ibGVtP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 13 years 7 months ago [\#96628](#96628) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[VAT problem](/forum/2-general-talk-about-hikashop/79756-vat-problem#96628 "Hi, I need to now include VAT. Is it possible to leave my current product prices (including VAT) and display the VAT total in checkout? i.e. product price 5.00 including VAT checkout to display 4.17 in Order Total, and .83 in VAT @ 20%, Final Total 5.00 If this cannot be done what is the best way for me to proceed to set up VAT considering I have 1000's of products with prices that include the forthcoming VAT (April 1st)? thanks in advance")* Ok, so can you explain your problem with more detail, through some screenshots for example ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NzU2LXZhdC1wcm9ibGVtP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile")** - [![mohairbears's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/916-mohairbears "View mohairbears's Profile") Topic Author - [ Offline](/forum/user/916-mohairbears) Less More - Posts: 610 - Thank you received: 13 - 13 years 7 months ago [\#96632](#96632) by [mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile") Replied by *[mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile")* on topic *[VAT problem](/forum/2-general-talk-about-hikashop/79756-vat-problem#96632 "Hi, I need to now include VAT. Is it possible to leave my current product prices (including VAT) and display the VAT total in checkout? i.e. product price 5.00 including VAT checkout to display 4.17 in Order Total, and .83 in VAT @ 20%, Final Total 5.00 If this cannot be done what is the best way for me to proceed to set up VAT considering I have 1000's of products with prices that include the forthcoming VAT (April 1st)? thanks in advance")* Ok I'll try. I have been using Hikashop for quite a few years and did not pay VAT as we have been below the threshold. Our current product prices would need to stay the same (to remain competitive) therefore we have prices shown as including VAT, BUT! Is it possible to show the 20% part of the total as VAT in Checkout as below. Order Total £100 VAT @ 20% £20 Shipping £7 Final Total £107 The only way I can see to do this is to reduce our prices by 20% and as there are 1,000's then this is going to be a very time consuming job so we are looking for a quicker solution if there is one. thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NzU2LXZhdC1wcm9ibGVtP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 13 years 7 months ago [\#96641](#96641) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[VAT problem](/forum/2-general-talk-about-hikashop/79756-vat-problem#96641 "Hi, I need to now include VAT. Is it possible to leave my current product prices (including VAT) and display the VAT total in checkout? i.e. product price 5.00 including VAT checkout to display 4.17 in Order Total, and .83 in VAT @ 20%, Final Total 5.00 If this cannot be done what is the best way for me to proceed to set up VAT considering I have 1000's of products with prices that include the forthcoming VAT (April 1st)? thanks in advance")* Sure, you'll just have to : - Go to "*Hikashop->System->Configuration->'Main'->'Taxes'*" - Set the "Show taxed prices" to **no tax** Then your product will display without any tax through the product page and the checkout, but you'll have a "VAT" line trough the checkout like you wanted to. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NzU2LXZhdC1wcm9ibGVtP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile")** - [![mohairbears's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/916-mohairbears "View mohairbears's Profile") Topic Author - [ Offline](/forum/user/916-mohairbears) Less More - Posts: 610 - Thank you received: 13 - 13 years 7 months ago [\#96748](#96748) by [mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile") Replied by *[mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile")* on topic *[VAT problem](/forum/2-general-talk-about-hikashop/79756-vat-problem#96748 "Hi, I need to now include VAT. Is it possible to leave my current product prices (including VAT) and display the VAT total in checkout? i.e. product price 5.00 including VAT checkout to display 4.17 in Order Total, and .83 in VAT @ 20%, Final Total 5.00 If this cannot be done what is the best way for me to proceed to set up VAT considering I have 1000's of products with prices that include the forthcoming VAT (April 1st)? thanks in advance")* Hi, this does work as you say BUT the VAT is added in the Final Total, I do not want it added to the final total as it already has been added? thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NzU2LXZhdC1wcm9ibGVtP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 13 years 7 months ago [\#96784](#96784) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[VAT problem](/forum/2-general-talk-about-hikashop/79756-vat-problem#96784 "Hi, I need to now include VAT. Is it possible to leave my current product prices (including VAT) and display the VAT total in checkout? i.e. product price 5.00 including VAT checkout to display 4.17 in Order Total, and .83 in VAT @ 20%, Final Total 5.00 If this cannot be done what is the best way for me to proceed to set up VAT considering I have 1000's of products with prices that include the forthcoming VAT (April 1st)? thanks in advance")* Ok, So if you want to change the way your cart is displaid, you'll have to do it through "*Hikashop->Display->Views*" by editing the code of your **cart** file of your **checkout** view of your **front-end template**. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NzU2LXZhdC1wcm9ibGVtP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile")** - [![mohairbears's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/916-mohairbears "View mohairbears's Profile") Topic Author - [ Offline](/forum/user/916-mohairbears) Less More - Posts: 610 - Thank you received: 13 - 13 years 7 months ago [\#96818](#96818) by [mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile") Replied by *[mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile")* on topic *[VAT problem](/forum/2-general-talk-about-hikashop/79756-vat-problem#96818 "Hi, I need to now include VAT. Is it possible to leave my current product prices (including VAT) and display the VAT total in checkout? i.e. product price 5.00 including VAT checkout to display 4.17 in Order Total, and .83 in VAT @ 20%, Final Total 5.00 If this cannot be done what is the best way for me to proceed to set up VAT considering I have 1000's of products with prices that include the forthcoming VAT (April 1st)? thanks in advance")* Ok so which part of the code needs changing? as this is dragging on can you please ask Nik as he will advise. All I want is the HIKASHOP_FINAL_TOTAL to NOT include the VAT in it's calculation, I want the VAT total displayed though. thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NzU2LXZhdC1wcm9ibGVtP3RtcGw9bWFya2Rvd24=) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 13 years 7 months ago [\#96913](#96913) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[VAT problem](/forum/2-general-talk-about-hikashop/79756-vat-problem#96913 "Hi, I need to now include VAT. Is it possible to leave my current product prices (including VAT) and display the VAT total in checkout? i.e. product price 5.00 including VAT checkout to display 4.17 in Order Total, and .83 in VAT @ 20%, Final Total 5.00 If this cannot be done what is the best way for me to proceed to set up VAT considering I have 1000's of products with prices that include the forthcoming VAT (April 1st)? thanks in advance")* You cannot have the VAT calculated from the taxed price. VAT is always calculated from the untaxed price. So your calculations are wrong. If the total taxed is 100£ and that the tax is 20%, the tax amount is not 20£ but 16.67£ and the untaxed price is not 80£ but 83.33£ So you need to have the untaxed price in all your products and then set the tax rules to add the 20% VAT to get back your normal product prices. Fortunately, changing all the prices at once is quite easy with a SQL query. Simply run the query below in your phpmyadmin to remove the VAT from your product prices: UPDATE #__hikashop_price SET price_value=price_value/1.2 (make sure that you replace #__ by your table prefix) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NzU2LXZhdC1wcm9ibGVtP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile")** - [![mohairbears's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/916-mohairbears "View mohairbears's Profile") Topic Author - [ Offline](/forum/user/916-mohairbears) Less More - Posts: 610 - Thank you received: 13 - 13 years 7 months ago [\#96919](#96919) by [mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile") Replied by *[mohairbears](/forum/user/916-mohairbears "View mohairbears's Profile")* on topic *[VAT problem](/forum/2-general-talk-about-hikashop/79756-vat-problem#96919 "Hi, I need to now include VAT. Is it possible to leave my current product prices (including VAT) and display the VAT total in checkout? i.e. product price 5.00 including VAT checkout to display 4.17 in Order Total, and .83 in VAT @ 20%, Final Total 5.00 If this cannot be done what is the best way for me to proceed to set up VAT considering I have 1000's of products with prices that include the forthcoming VAT (April 1st)? thanks in advance")* Wicked I knew you would give me the solution. thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NzU2LXZhdC1wcm9ibGVtP3RtcGw9bWFya2Rvd24=) 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.099 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)