Ranky Posted December 9, 2013 Share Posted December 9, 2013 Hi, Any idea why tax_rate value not saved in database? The percentage of tax_rate in Germany is 19% that should show in database: 19,000 instead 0,000 is saved. Prestashop version: 1.5.4.1 Thanks in advance Link to comment Share on other sites More sharing options...
eleazar Posted December 9, 2013 Share Posted December 9, 2013 (edited) When you enter the tax rules in BO --> Localization --> Tax Rules you got to make sure that you don't enter a comma like e.g. 19,000! You have to enter a decimal point in this field. Edited December 9, 2013 by eleazar (see edit history) Link to comment Share on other sites More sharing options...
Ranky Posted December 10, 2013 Author Share Posted December 10, 2013 Hi, Thanks for your reply. I used in the field point and not comma. regards Link to comment Share on other sites More sharing options...
bellini13 Posted December 10, 2013 Share Posted December 10, 2013 besides 19,000 showing the database, is there something else wrong? When tax is being calculated, are you getting the correct tax amount? Link to comment Share on other sites More sharing options...
Ranky Posted December 10, 2013 Author Share Posted December 10, 2013 Hi, The calculation in the shop cart is correct but where I have problem is when exporting order detail to a system called AFTERBUY that we use to finalize sales. I noticed in the database table that the value of tax_rate is 0.000 instead of 19.000 (19%) which is the standard german tax rate. regards Link to comment Share on other sites More sharing options...
bellini13 Posted December 10, 2013 Share Posted December 10, 2013 then you will need to transform the value "19,000" to what ever value the remote system expects. Since Prestashop is working properly, then while it "looks" wrong in the database, it is apparently correct. Link to comment Share on other sites More sharing options...
Cream77 Posted April 22, 2015 Share Posted April 22, 2015 Hi, The calculation in the shop cart is correct but where I have problem is when exporting order detail to a system called AFTERBUY that we use to finalize sales. I noticed in the database table that the value of tax_rate is 0.000 instead of 19.000 (19%) which is the standard german tax rate. regards Did you find the solution ? Link to comment Share on other sites More sharing options...
DeepVoid Posted October 25, 2015 Share Posted October 25, 2015 I have the same problem, Prestashop version is 1.6.1.1. The value in the BO haves a decimal point, but when I export orders I always retrieve 0.000 in the tax_rate field. Is there a solution? Link to comment Share on other sites More sharing options...
bellini13 Posted October 25, 2015 Share Posted October 25, 2015 where are you pulling the tax rate from, be specific, what database table and column? Link to comment Share on other sites More sharing options...
DeepVoid Posted October 25, 2015 Share Posted October 25, 2015 JUST SOLVED!!! Apparently, the "tax_rate" field is a remnant for compatibility with older versions of Prestashop, and is always set to zero. To show the right tax rate, just use the following field name: taxtaxrate And this will do the magic. That's all, folks!!! Link to comment Share on other sites More sharing options...
bellini13 Posted October 26, 2015 Share Posted October 26, 2015 Is this the name of a database field, or the name you use when importing / exporting using CSV files? Link to comment Share on other sites More sharing options...
DeepVoid Posted October 26, 2015 Share Posted October 26, 2015 (edited) Is this the name of a database field, or the name you use when importing / exporting using CSV files? It's one of the fields available when exporting orders to CSV. Edited October 26, 2015 by DeepVoid (see edit history) Link to comment Share on other sites More sharing options...
eleazar Posted October 26, 2015 Share Posted October 26, 2015 You mean exporting orders with the help of a module like http://www.praotec.com/nvn-export-orders-module-calculated-fields/ ? But you are aware of the fact that this 'magic' is done by a special module, aren't you? Link to comment Share on other sites More sharing options...
DeepVoid Posted October 26, 2015 Share Posted October 26, 2015 Of course! Link to comment Share on other sites More sharing options...
DeepVoid Posted October 26, 2015 Share Posted October 26, 2015 If you need to get the tax rate straight from the database, you must query the ps_tax table, the tax rate is stored in the rate field. Link to comment Share on other sites More sharing options...
eleazar Posted October 26, 2015 Share Posted October 26, 2015 If you need to get the tax rate straight from the database, you must query the ps_tax table, the tax rate is stored in the rate field. No offense, but this is such an old hat! I thought this is about exporting orders with product specific tax rates, not the defined tax rates as such, independent of products. Link to comment Share on other sites More sharing options...
DeepVoid Posted October 28, 2015 Share Posted October 28, 2015 Just trying to contribute and help with my humble 2c, Eleazar. I'll go back to my cage, and will be harmless for everyone. Link to comment Share on other sites More sharing options...
Recommended Posts