[Skip to main content](#vessel-content) # Not sure how to deal with tax calculation ## - **[gidgie](/forum/user/6893-gidgie "View gidgie's Profile")** - [![gidgie's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6893.jpg)](/forum/user/6893-gidgie "View gidgie's Profile") Topic Author - [ Offline](/forum/user/6893-gidgie) Less More - Posts: 70 - Thank you received: 4 - - 14 years 1 week ago [\#73508](#73508) by [gidgie](/forum/user/6893-gidgie "View gidgie's Profile") *[Not sure how to deal with tax calculation](/forum/2-general-talk-about-hikashop/73508-not-sure-how-to-deal-with-tax-calculation#73508 "HI, I have a live site running for a while now and we have noticed that tax is being calculated in a way that is not correct for us ( probably correct to Hikashop though) We have set Australia as a tax zone. Which means 10% GST on top of everything. However, all our product prices already include GST and we don't need to have that added. We know we can turn off that extra 10% off by removing tax zone, but it would be good to be able to display GST at the checkout. But instead of adding another 10% to the order before shipping, we would like the GST to be shown as a separate line of the sum that makes those 10% of the total order before shipping. OR at least the price without GST. We have quite a few products with several variants and many different price levels each, so it is not very practical for us to go back and adjust all prices. What is the best solution for us in this case? Thanks in advance.")* was created by *[gidgie](/forum/user/6893-gidgie "View gidgie's Profile")* HI, I have a live site running for a while now and we have noticed that tax is being calculated in a way that is not correct for us ( probably correct to Hikashop though) We have set Australia as a tax zone. Which means 10% GST on top of everything. However, all our product prices already include GST and we don't need to have that added. We know we can turn off that extra 10% off by removing tax zone, but it would be good to be able to display GST at the checkout. But instead of adding another 10% to the order before shipping, we would like the GST to be shown as a separate line of the sum that makes those 10% of the total order before shipping. OR at least the price without GST. We have quite a few products with several variants and many different price levels each, so it is not very practical for us to go back and adjust all prices. What is the best solution for us in this case? Thanks in advance. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczNTA4LW5vdC1zdXJlLWhvdy10by1kZWFsLXdpdGgtdGF4LWNhbGN1bGF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[rodfarrell](/forum/user/5859-rodfarrell "View rodfarrell's Profile")** - [![rodfarrell's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5859-rodfarrell "View rodfarrell's Profile") - [ Offline](/forum/user/5859-rodfarrell) Less More - Posts: 259 - Thank you received: 22 - - 14 years 1 week ago [\#73522](#73522) by [rodfarrell](/forum/user/5859-rodfarrell "View rodfarrell's Profile") Replied by *[rodfarrell](/forum/user/5859-rodfarrell "View rodfarrell's Profile")* on topic *[Re: Not sure how to deal with tax calculation](/forum/2-general-talk-about-hikashop/73508-not-sure-how-to-deal-with-tax-calculation#73522 "HI, I have a live site running for a while now and we have noticed that tax is being calculated in a way that is not correct for us ( probably correct to Hikashop though) We have set Australia as a tax zone. Which means 10% GST on top of everything. However, all our product prices already include GST and we don't need to have that added. We know we can turn off that extra 10% off by removing tax zone, but it would be good to be able to display GST at the checkout. But instead of adding another 10% to the order before shipping, we would like the GST to be shown as a separate line of the sum that makes those 10% of the total order before shipping. OR at least the price without GST. We have quite a few products with several variants and many different price levels each, so it is not very practical for us to go back and adjust all prices. What is the best solution for us in this case? Thanks in advance.")* Hi fellow Aussie. I would export your products to a csv file and change all of your prices to ex tax and reimport them. Its not as big a job as it sounds because you can insert a new column and add a formula to recalculate the price (=existing price/1.1) and past that as a special past (amount only) into the price column. Delete the calculation column then import. This means that if you decide to sell products to customers outside Australia the tax calc is taken care of automatically as is the display of tax on orders, invoices etc. You will find that accounting software etc will all work on ex prices so this is a good habit to get into. Make sure you back up your site first of course. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczNTA4LW5vdC1zdXJlLWhvdy10by1kZWFsLXdpdGgtdGF4LWNhbGN1bGF0aW9uP3RtcGw9bWFya2Rvd24=) 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: 86541 - Thank you received: 14304 - - 14 years 1 week ago [\#73720](#73720) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Not sure how to deal with tax calculation](/forum/2-general-talk-about-hikashop/73508-not-sure-how-to-deal-with-tax-calculation#73720 "HI, I have a live site running for a while now and we have noticed that tax is being calculated in a way that is not correct for us ( probably correct to Hikashop though) We have set Australia as a tax zone. Which means 10% GST on top of everything. However, all our product prices already include GST and we don't need to have that added. We know we can turn off that extra 10% off by removing tax zone, but it would be good to be able to display GST at the checkout. But instead of adding another 10% to the order before shipping, we would like the GST to be shown as a separate line of the sum that makes those 10% of the total order before shipping. OR at least the price without GST. We have quite a few products with several variants and many different price levels each, so it is not very practical for us to go back and adjust all prices. What is the best solution for us in this case? Thanks in advance.")* @rodfarrell Thanks. @gidgie You can simply run that query on your phpmyadmin: UPDATE #__hkashop_price SET price_value = price_value/1.1; Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczNTA4LW5vdC1zdXJlLWhvdy10by1kZWFsLXdpdGgtdGF4LWNhbGN1bGF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[rodfarrell](/forum/user/5859-rodfarrell "View rodfarrell's Profile")** - [![rodfarrell's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5859-rodfarrell "View rodfarrell's Profile") - [ Offline](/forum/user/5859-rodfarrell) Less More - Posts: 259 - Thank you received: 22 - - 14 years 1 week ago - 14 years 1 week ago [\#74063](#74063) by [rodfarrell](/forum/user/5859-rodfarrell "View rodfarrell's Profile") Replied by *[rodfarrell](/forum/user/5859-rodfarrell "View rodfarrell's Profile")* on topic *[Re: Not sure how to deal with tax calculation](/forum/2-general-talk-about-hikashop/73508-not-sure-how-to-deal-with-tax-calculation#74063 "HI, I have a live site running for a while now and we have noticed that tax is being calculated in a way that is not correct for us ( probably correct to Hikashop though) We have set Australia as a tax zone. Which means 10% GST on top of everything. However, all our product prices already include GST and we don't need to have that added. We know we can turn off that extra 10% off by removing tax zone, but it would be good to be able to display GST at the checkout. But instead of adding another 10% to the order before shipping, we would like the GST to be shown as a separate line of the sum that makes those 10% of the total order before shipping. OR at least the price without GST. We have quite a few products with several variants and many different price levels each, so it is not very practical for us to go back and adjust all prices. What is the best solution for us in this case? Thanks in advance.")* Yes you can. But I would never suggest anyone mess with their data via phpadmin unless I new their abilities. Either way, backup backup backup. Last edit: 14 years 1 week ago by [rodfarrell](/forum/user/5859-rodfarrell "View rodfarrell's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczNTA4LW5vdC1zdXJlLWhvdy10by1kZWFsLXdpdGgtdGF4LWNhbGN1bGF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[gidgie](/forum/user/6893-gidgie "View gidgie's Profile")** - [![gidgie's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6893.jpg)](/forum/user/6893-gidgie "View gidgie's Profile") Topic Author - [ Offline](/forum/user/6893-gidgie) Less More - Posts: 70 - Thank you received: 4 - - 14 years 1 week ago [\#74074](#74074) by [gidgie](/forum/user/6893-gidgie "View gidgie's Profile") Replied by *[gidgie](/forum/user/6893-gidgie "View gidgie's Profile")* on topic *[Re: Not sure how to deal with tax calculation](/forum/2-general-talk-about-hikashop/73508-not-sure-how-to-deal-with-tax-calculation#74074 "HI, I have a live site running for a while now and we have noticed that tax is being calculated in a way that is not correct for us ( probably correct to Hikashop though) We have set Australia as a tax zone. Which means 10% GST on top of everything. However, all our product prices already include GST and we don't need to have that added. We know we can turn off that extra 10% off by removing tax zone, but it would be good to be able to display GST at the checkout. But instead of adding another 10% to the order before shipping, we would like the GST to be shown as a separate line of the sum that makes those 10% of the total order before shipping. OR at least the price without GST. We have quite a few products with several variants and many different price levels each, so it is not very practical for us to go back and adjust all prices. What is the best solution for us in this case? Thanks in advance.")* Thanks everyone for the input. However, the client ( who as always has the last say) wants prices of the product to remain as they are - where tax is already included and is not specified. They just want different presentation of prices on the invoice... i have a bad feeling that I will have to hack hikashop yet again!! :laugh: :laugh: Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczNTA4LW5vdC1zdXJlLWhvdy10by1kZWFsLXdpdGgtdGF4LWNhbGN1bGF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[rodfarrell](/forum/user/5859-rodfarrell "View rodfarrell's Profile")** - [![rodfarrell's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5859-rodfarrell "View rodfarrell's Profile") - [ Offline](/forum/user/5859-rodfarrell) Less More - Posts: 259 - Thank you received: 22 - - 14 years 1 week ago [\#74107](#74107) by [rodfarrell](/forum/user/5859-rodfarrell "View rodfarrell's Profile") Replied by *[rodfarrell](/forum/user/5859-rodfarrell "View rodfarrell's Profile")* on topic *[Re: Not sure how to deal with tax calculation](/forum/2-general-talk-about-hikashop/73508-not-sure-how-to-deal-with-tax-calculation#74107 "HI, I have a live site running for a while now and we have noticed that tax is being calculated in a way that is not correct for us ( probably correct to Hikashop though) We have set Australia as a tax zone. Which means 10% GST on top of everything. However, all our product prices already include GST and we don't need to have that added. We know we can turn off that extra 10% off by removing tax zone, but it would be good to be able to display GST at the checkout. But instead of adding another 10% to the order before shipping, we would like the GST to be shown as a separate line of the sum that makes those 10% of the total order before shipping. OR at least the price without GST. We have quite a few products with several variants and many different price levels each, so it is not very practical for us to go back and adjust all prices. What is the best solution for us in this case? Thanks in advance.")* Changing the price to ex tax doesn't change the way it is presented on the site. The customer will still see the inc price if you choose that setting, its only the invoice that then shows the tax amount separately. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczNTA4LW5vdC1zdXJlLWhvdy10by1kZWFsLXdpdGgtdGF4LWNhbGN1bGF0aW9uP3RtcGw9bWFya2Rvd24=) 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: 86541 - Thank you received: 14304 - - 14 years 1 week ago [\#74176](#74176) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Not sure how to deal with tax calculation](/forum/2-general-talk-about-hikashop/73508-not-sure-how-to-deal-with-tax-calculation#74176 "HI, I have a live site running for a while now and we have noticed that tax is being calculated in a way that is not correct for us ( probably correct to Hikashop though) We have set Australia as a tax zone. Which means 10% GST on top of everything. However, all our product prices already include GST and we don't need to have that added. We know we can turn off that extra 10% off by removing tax zone, but it would be good to be able to display GST at the checkout. But instead of adding another 10% to the order before shipping, we would like the GST to be shown as a separate line of the sum that makes those 10% of the total order before shipping. OR at least the price without GST. We have quite a few products with several variants and many different price levels each, so it is not very practical for us to go back and adjust all prices. What is the best solution for us in this case? Thanks in advance.")* In each module/menu's hikashop options, you can select the option "show taxed prices" to "without taxes" and the prices displayed will be the prices without taxes. There is a similar option on the configuration for the product page. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczNTA4LW5vdC1zdXJlLWhvdy10by1kZWFsLXdpdGgtdGF4LWNhbGN1bGF0aW9uP3RtcGw9bWFya2Rvd24=) 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.101 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)