imagesgroup Posted May 22, 2012 Share Posted May 22, 2012 Being new to Prestashop I'm used to other shopping carts such as Cubecart and the like. In those you simply setup your Tax zone per Country and it was added when the visitor went to the checkout. Am I right in thinking that in Prestashop you have Tax Rules setup which have to be assigned on each and every product? E.g. UK 20% needs to be selected on every product? If so is there a way to do this via the back-office or must I use a SQL command like in this example. How to apply same tax rule on all products quickly Link to comment Share on other sites More sharing options...
imagesgroup Posted May 22, 2012 Author Share Posted May 22, 2012 In the end I've just run a SQL command to apply my desired TAX Rule to all products. If anyone else would like to do this first take a full backup of your database and then using phpMyAdmin run the command: UPDATE ps_product SET id_tax_rules_group =1 WHERE id_tax_rules_group =0 This finds all products with a tax rule value of '0' and assigns the tax rule with the id '1' I had two tax rules in my Prestashop: id name 1 UK Standard Rate (20%) 2 UK Reduced Rate (5%) It's a bit confusing having a Tax rules table and then having to go through and assign that rule to each product - something I would have liked to have know prior to doing my csv import as I've since tweaked a lot. This thread is now solved but I'd still like to know if this is the correct way to setup VAT using Prestashop. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now