Will this convert my whole store to show VAT inclusive pricing?

[DanJ]

Hi,

 

I am soon to be registering for VAT, and so will need to convert the tax code of all products within my store to reflect the VAT i must charge.

 

I think i know how to do this in one easy step, but could someone please confirm the following?

 

I have peeked at the database using phpadmin, and i think it may be possibly by running some sql to alter the 'products_tax_class_id' column in the product table, for all products. Can anyone confirm if this is correct, or whether any other tables will also need modifying??

 

If correct, would the following sql code work?

 

update products set products_tax_class_id = '1';

 

.....here assuming the tax code is entered in OSC, and stored as '1' in the tax_class table.

 

Thanks!

 

Dan.

[Historian]

This is how I set up VAT in my shop and it seems to be working! The only problem I have with VAT is on Postage. If anyone purchases all non-VATable goods in the EEC, I am still adding VAT to the postage! I didn't alter anything in the database!

My site shows tax until someone logs in from outside the EEC; then VAT "vanishes"!

 

Setting up Tax as follows should add the relevant VAT rate on EEC countries, but not add VAT to other countries. Add as follows in Admin Location/Taxes:

 

Tax Zones : "European Community" containing 27 EEC countries

“Non-EEC Countries” containing all other countries

 

Tax Classes: Defined 2 classes:

VAT - Standard Rate --- Normal UK tax rate

VAT - Zero Rated --- Applicable to Books, Maps

 

Tax Rates: Defined 3 Rates:

Non-EEC Rate --- Non-EEC rate --- 0.00 --- Non-EEC rate --- 2

VAT - Standard Rate --- European Community --- 17.50 --- UK Standard VAT Rate --- 1

VAT - Zero Rated --- European Community --- 0.00 --- UK Zero Rated --- 0

 

In Configuration > My Store

Country --- Set to "United Kingdom"

Zone --- "The zone my store is located in" --- This is blank

Display Prices with Tax --- Set to "true"

Tax will be added unless a customer logs in with an address outside the EEC

 

This also seems to work on Airmail Shipping rates (but I’m not sure why!) – Entering the Standard VAT rate in appears to add VAT to the European Zone, but not to Other Countries (Zone2).