KT Design Posted February 29, 2012 Share Posted February 29, 2012 Okay, so i've been updating a shop from version 1.3.1.1 to the new 1.4.7. I have sorted almost everything out, except for a problem that the standart tax/vat from the old shop is gone when i update the database. Soo anyone have an idea on how to get 25% tax back on almost 7.000 products?... Link to comment Share on other sites More sharing options...
piccorodaimaoh Posted March 5, 2012 Share Posted March 5, 2012 The exact same thing happened to me. All the taxes are gone... I wonder if it's possible to apply a single tax rule into every product automatically... Link to comment Share on other sites More sharing options...
KT Design Posted March 7, 2012 Author Share Posted March 7, 2012 I found a fix for this. I made a new tax rule, made it so it applies to all countries and then I used this sql query UPDATE `ps_product` SET `id_tax_rules_group` = replace(id_tax_rules_group, "0", "1"); 0 being the id of the current tax group and 1 being the new id for the tax group i just made. Hope it helps;) Link to comment Share on other sites More sharing options...
KSteele Posted March 13, 2012 Share Posted March 13, 2012 KT Design I am desperite for this fix.... please can you give a step by step explaination of how to do the SQL query.... I promise to send you a present on your birthday (my site is down and losing money daily) and I suck at SQL/Database issues. or anyone? best regards, "K" Link to comment Share on other sites More sharing options...
Dumbelo Posted March 13, 2012 Share Posted March 13, 2012 Sorry for adding just this, I need this step by step fix also. Very frustrading bug in updating process.... Link to comment Share on other sites More sharing options...
KSteele Posted March 16, 2012 Share Posted March 16, 2012 re-reading this post I see that KT's fix does not apply to my situation. Being in the USA I have to charge tax only for people within my own state... everyone else is tax free. KT's solution looks to be a single tax rate for ALL purchases made no matter the country or state. If this is your intent this can be accomplished by logging into PhpMyAdmin and reviewing the "ps_tax_rules_goup" tables and identifying the tax rate you would like to apply to all purchases, record the "id_tax_rules_group" by number (Example: id_tax_rules_group" 4 is assigned a tax rate of 4% and should be set as active with a number 1) Navigate to the table "ps_product" and edit the "id_tax_rules_group" number that is currently being used (mine is 8), Then return to the top level of the database and perform the query as described above by KT. Alternatively, you can manually edit each line... providing you have just a few products. Good Luck - BTW, I still need a fix for my situation: repeat, US tax rate per state does not work in version 1.4.7 Link to comment Share on other sites More sharing options...
KT Design Posted April 10, 2012 Author Share Posted April 10, 2012 The site i'm working is Danish. And here there has to be 25% vat by law. So the fix works for me. And you make a sql qurey by going to phpmyadmin where you made your database for prestashop - then click on the database for your site and click the "SQL" section in the horizontal menu. Now you paste the code in the big white box, and click the "go" button.. Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts