DesignSolu Posted February 4, 2014 Share Posted February 4, 2014 (edited) I'm having trouble with Avalara. The sales tax is not correct after you make a change to the shopping cart - like changing the shipping address or changing the quantity of an item in the cart. It seems to be a caching issue with the amount of sales tax on the shipping. I've noticed that if you make a change to the cart which changes the shipping amount, the $total_shipping reflects $total_shipping_tax_exc + the cached amount from the ps_avalara_carrier_cache table in the prestashop database. However it is not using the most recent cached amount (based on update_date). It is using the original amount based on the first shipping amount. Edited February 4, 2014 by DesignSolu (see edit history) Link to comment Share on other sites More sharing options...
benjamin utterback Posted February 4, 2014 Share Posted February 4, 2014 I'm having trouble with Avalara. The sales tax is not correct after you make a change to the shopping cart - like changing the shipping address or changing the quantity of an item in the cart. It seems to be a caching issue with the amount of sales tax on the shipping. I've noticed that if you make a change to the cart which changes the shipping amount, the $total_shipping reflects $total_shipping_tax_exc + the cached amount from the ps_avalara_carrier_cache table in the prestashop database. However it is not using the most recent cached amount (based on update_date). It is using the original amount based on the first shipping amount. Hi DesignSolu, We are reviewing the module. Can you tell me what version of PrestaShop you are using? If possible, we would like to have access to the store that is having this issue. Of course, this is assuming that all databases and files are backed up beforehand by your team or the store owner. Link to comment Share on other sites More sharing options...
DesignSolu Posted February 5, 2014 Author Share Posted February 5, 2014 I'm using Prestashop 1.5.6.2 and Avalara 3.4.2. I reported the bug on forge - PNM-2064 and the solution that a member of our team found. Link to comment Share on other sites More sharing options...
benjamin utterback Posted February 5, 2014 Share Posted February 5, 2014 I'm using Prestashop 1.5.6.2 and Avalara 3.4.2. I reported the bug on forge - PNM-2064 and the solution that a member of our team found. Thanks for that info. I actually can't find any ticket that matches that number. Would you be able to provide a link? I appreciate it. Best, Link to comment Share on other sites More sharing options...
Dh42 Posted February 5, 2014 Share Posted February 5, 2014 I can confirm that the avalara module does not work correctly and I can provide a test environment if needed. Link to comment Share on other sites More sharing options...
DesignSolu Posted February 5, 2014 Author Share Posted February 5, 2014 Here is the link to the bug report - http://forge.prestashop.com/browse/PNM-2064 The fix: in modules/avalaratax/CacheTools.php add "order by id_cache DESC" to the query in function getCarrierTaxAmount. (line 142) Link to comment Share on other sites More sharing options...
Recommended Posts