tank Posted September 1, 2011 Share Posted September 1, 2011 How to apply same tax rule on all products quickly? Is there a way to do this quickly, having to edit each product takes for ever. Link to comment Share on other sites More sharing options...
swally Posted September 4, 2011 Share Posted September 4, 2011 I have the same question. I just found that upgrading to v1.4.4.0 means I now have to add a tax rule on all products ... hundreds. What a poor system for computing taxes. Link to comment Share on other sites More sharing options...
Optim'Informatique Posted September 4, 2011 Share Posted September 4, 2011 If you know mysql, it is the field id_tax_rules_group in the ps_product table. Else you can use my module ExportCatalog ( available on the add ons : http://addons.prestashop.com/fr/export/2987-exportcatalogue.html ) : it exports product fields ( ID, name, reference, price, tax rule, manufacturer... ) in a CSV file so you can edit it in excel ( or another spreadsheet application ) and import your changes in Prestashop ( I wrote a documentation on import, it is includes in the module documentation). Link to comment Share on other sites More sharing options...
tank Posted September 21, 2011 Author Share Posted September 21, 2011 This problem forced me to learn sql...... I ended up doing it with an sql command. update ps_product set id_tax_rules_group = insert correct number here. Would be nice to have a global change in PrestaShop. Its crazy to have to update hundreds of products manually. 1 Link to comment Share on other sites More sharing options...
Luca S. Posted May 19, 2012 Share Posted May 19, 2012 hey guys, i have all products without taxes, now i want update the current price of each product "as taxed" and i would prestashop automatically add the price without vat too in the relative field based on the current... How to? Link to comment Share on other sites More sharing options...
helldog2004 Posted May 19, 2012 Share Posted May 19, 2012 If you use .csv to import products you can give it the "ID number" of the tax rule. like this: "product ID","Product name","price excl. tax","1" 1 --> The ID number of the tax rule.. Gives all products with a number 1 as Tax rule the percentage set as ID 1 in your BO! Cheers Helldog Link to comment Share on other sites More sharing options...
Luca S. Posted May 21, 2012 Share Posted May 21, 2012 My problem is this, i would mantein the current price i inserted in the field "price exc. vat" as price with VAT, so prestashop should calculate the price without VAT, how is possible? Thanks Link to comment Share on other sites More sharing options...
VNguyen Posted May 21, 2012 Share Posted May 21, 2012 The easiest way and simplest way to do that is migrate tax information from old system to new ones, keep the same id_tax, group, etc... Link to comment Share on other sites More sharing options...
Mr.Moon Posted January 10, 2013 Share Posted January 10, 2013 Well i found good solution. In phpmyadmin exec sql code: UPDATE ps_product SET id_tax_rules_group = 1 WHERE id_tax_rules_group = 0 Regards, 6 1 Link to comment Share on other sites More sharing options...
yvonig Posted January 13, 2013 Share Posted January 13, 2013 I tried that last solution... it works find in the BDD, but the price stay the same in the website and in the back office ! It is 5.3 prestashop... Is there any cache or something ? I've got only 1 taxe and 1 taxe rule ...?!!! any idea ? Link to comment Share on other sites More sharing options...
Jupiterr Posted January 15, 2013 Share Posted January 15, 2013 I tried that last solution... it works find in the BDD, but the price stay the same in the website and in the back office ! It is 5.3 prestashop... Is there any cache or something ? I've got only 1 taxe and 1 taxe rule ...?!!! any idea ? You should run the same query but also to the ps_product_shop table. UPDATE ps_product_shop SET id_tax_rules_group = 1 WHERE id_tax_rules_group = 0 Greetings. 6 Link to comment Share on other sites More sharing options...
Mr.Moon Posted January 15, 2013 Share Posted January 15, 2013 Well, i use PrestaShop™ 1.4.6.2. In my version isn`t table: ps_product_shop. All forks fine. Link to comment Share on other sites More sharing options...
turdi Posted March 28, 2013 Share Posted March 28, 2013 Is it posible to add quantity to all items via query? Can you post a command? Also would be nice a link to the tutorial how to execute this commands in phpmyadmin for newbies like me Thanks, Link to comment Share on other sites More sharing options...
Petya Posted July 4, 2013 Share Posted July 4, 2013 Thanks a lot, I was afraid that i will have to do the whole thing manually. Great post. Solution works with PS1.5.0.13 Link to comment Share on other sites More sharing options...
sigmaconcept Posted July 24, 2014 Share Posted July 24, 2014 Solution dont work on PS 1.6 Link to comment Share on other sites More sharing options...
lukas_jg Posted January 16, 2015 Share Posted January 16, 2015 My solution work on 1.6: update ps_product set id_tax_rules_group = '{tax_rule_id}'; update ps_product_shop set id_tax_rules_group = '{tax_rule_id}'; {tax_rule_id} = is id of TAX RULE This will change tax_rule in all products!! 4 Link to comment Share on other sites More sharing options...
dganeswaran Posted March 31, 2015 Share Posted March 31, 2015 lukas_jg solution worked on Prestashop 1.6. Thanks guys. Saved me a great deal of heartache. Link to comment Share on other sites More sharing options...
jodancer Posted April 29, 2015 Share Posted April 29, 2015 Hi, I have a client that has not selected a tax for any of the products (there are hundreds of them!) I tried the query and it works but my problem is that all the prices that they have put already include the tax and when I do the query it adds the tax onto this. Is there a way to update the tables in this situation? Thanks Link to comment Share on other sites More sharing options...
sigmaconcept Posted April 30, 2015 Share Posted April 30, 2015 See the solution here : https://www.prestashop.com/forums/topic/268630-changing-multiple-products/ Link to comment Share on other sites More sharing options...
jodancer Posted April 30, 2015 Share Posted April 30, 2015 Thanks sigmaconcept but this adds the tax on to the price that is already there and my problem is that the prices put in the products have been added with tax but no tax rate has been selected. We have a VAT rate here of 21 % so I don't know id it's possible to do a division query to divide the prices by 1.21 to get the pre VAT prices and then do the other query stated above. I'm pretty useless at SQL and don't know if this is possible? Link to comment Share on other sites More sharing options...
tuk66 Posted May 5, 2015 Share Posted May 5, 2015 Sure, UPDATE ... price = price/1.21 ... works, but you need to know what prices to change. Usually there is more than one price in more than one table. Link to comment Share on other sites More sharing options...
jodancer Posted May 5, 2015 Share Posted May 5, 2015 Thanks tuk66, I think I am going to have to backup and install somewhere else to do tests as I'm very new to sql queries and would mess things up for sure! Link to comment Share on other sites More sharing options...
smog20 Posted October 23, 2015 Share Posted October 23, 2015 I changed the tax rule ID in both table and it worked for backend, but I still see the value with the wrong value (taxe) on the front end. any clue about that issue? Thanks a lot Link to comment Share on other sites More sharing options...
Javi Ferrer Posted December 17, 2015 Share Posted December 17, 2015 smog20, Did you clear / disable caches, and select Force complie at smarty.on Advanced parámeters > Perfomance? Link to comment Share on other sites More sharing options...
Recommended Posts