VAT problem

  • Posts: 517
  • Thank you received: 8
  • Hikashop Business
11 years 9 months ago #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

Please Log in or Create an account to join the conversation.

  • Posts: 12953
  • Thank you received: 1778
11 years 9 months ago #96620

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 or Create an account to join the conversation.

  • Posts: 517
  • Thank you received: 8
  • Hikashop Business
11 years 9 months ago #96621

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 or Create an account to join the conversation.

  • Posts: 12953
  • Thank you received: 1778
11 years 9 months ago #96628

Ok, so can you explain your problem with more detail, through some screenshots for example ?

Please Log in or Create an account to join the conversation.

  • Posts: 517
  • Thank you received: 8
  • Hikashop Business
11 years 9 months ago #96632

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 or Create an account to join the conversation.

  • Posts: 12953
  • Thank you received: 1778
11 years 9 months ago #96641

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 or Create an account to join the conversation.

  • Posts: 517
  • Thank you received: 8
  • Hikashop Business
11 years 9 months ago #96748

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 or Create an account to join the conversation.

  • Posts: 12953
  • Thank you received: 1778
11 years 8 months ago #96784

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 or Create an account to join the conversation.

  • Posts: 517
  • Thank you received: 8
  • Hikashop Business
11 years 8 months ago #96818

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 or Create an account to join the conversation.

  • Posts: 83041
  • Thank you received: 13405
  • MODERATOR
11 years 8 months ago #96913

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 or Create an account to join the conversation.

  • Posts: 517
  • Thank you received: 8
  • Hikashop Business
11 years 8 months ago #96919

Wicked I knew you would give me the solution.

thanks

Please Log in or Create an account to join the conversation.

Time to create page: 0.098 seconds
Powered by Kunena Forum