Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Uk Vat


dohnut2004

Recommended Posts

hi

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

 

but

 

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

 

dohnut

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.

 

Ken

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

Archived

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

×
×
  • Create New...