Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Uk Vat


Recommended Posts


wonder if someone can help me a bit i have reinstalled my site all put my backup sql file on




all 2700 items are saying they are not taxable goods instead of going throw them all 1 by 1 is they any way of changeing them all at once.so they all are taxable goods


thanks in advance



Link to comment
Share on other sites

If you know how to create/run a sql query, then it is simple thing to set all products to a certain tax class, ie, in you case UK VAT, in one signle update query. First find out the tax class ID for the UK VAT (Taxable Goods) in the tax_ class table, then set the products_tax_class_id for all products in the products table to that tax class ID, and that's all.



commercial support - unProtected channel, not to be confused with the forum with same name - open to everyone who need some professional help: either PM/email me, or go to my website (URL can be found in my profile).

over 20 years of computer programming experience.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...