dancallo Posted June 24, 2013 Share Posted June 24, 2013 I have Prestashop 1.5.x setup with PayPal module v.3.5.5 (non-pro), UPS Module v.1.2.4, and Avalara Tax module v.3.2.1. The UPS module is configured for UPS Ground only with no additional handling fees applied and to calculate the shipping costs based on total purchase price (not weight) and shipping address (not billing address) of the customer. The Avalara Tax module is configured properly and has been tested. With a mock customer account setup based in Weaverville, NC (shipping address) and a product is loaded into the shopping cart, the UPS module properly assigns the UPS Ground carrier to the cart and calculates the shipping based on cart total cost and shipping location. For a $17.99 product cost, UPS calculates the Ground shipment from Asheville, NC to Weaverville, NC as $10.61, and Avalara Tax module calculates the tax on the purchase as $1.99 (which is correct for the State of NC). The problem is that when the customer is taken to the Payment interface and chooses PayPal as the option to pay with credit card or PayPal account on the storefront, the Order Summary page shows a figure of $11.35 for shipping and handling costs and a total of $29.34 instead of $30.59 (which is what Prestashop says the total cost of the order should be based on tax and UPS Ground shipping. I contacted PayPal and talked to a representative there. He says that PayPal is correctly pulling information over from the API call to the Prestashop website as an express-checkout calculation. He can't figure out why the totals for shipping and total cost are different and asked that I contact Prestashop for an explanation. Can someone assist me with this issue? We are planning on going live with the Website very soon and this needs to be fixed before we can proceed. Thank you. Dan Calloway Link to comment Share on other sites More sharing options...
benjamin utterback Posted June 24, 2013 Share Posted June 24, 2013 Hi Dan, thanks for the detailed post. What exact version of PrestaShop are you using? Also, have you tried turning off Avalara to see if the calculation is correct when it's disabled? Link to comment Share on other sites More sharing options...
dancallo Posted June 24, 2013 Author Share Posted June 24, 2013 (edited) Hi Benjamin, The version of Prestashop that I'm running in non-production mode is 1.5.3.1. I just created a third mock customer account with an address in Minneapolis, MN to run a transaction since Avalara Tax module does not get involved with calculating tax in areas outside of North Carolina where the two previous mock customers resided. When I loaded a product in that customer's shopping cart and selected PayPal as the payment method, the total price and shipping costs matched! This must mean that the Avalara Tax module is interfering with the calculations of shipping and handling somehow and/or the tax isn't being pulled over in the API call by PayPal to the Prestashop storefront. This is good news that we are closer to a solution, but Avalara Tax module is essential in calculating the appropriate tax for transactions from customers who live within NC (Nexxus for the client). Can you tell me what we need to do to find a solution to this issue? Thank you. Dan Edited June 24, 2013 by dancallo (see edit history) Link to comment Share on other sites More sharing options...
benjamin utterback Posted June 24, 2013 Share Posted June 24, 2013 Hi Dan, Awesome, we have isolated the problem. I would give Avalara a quick call or Email, maybe they are aware of the issue or can give further information. They have great support on their website. From there, we can take a closer look and investigate the issue. Keep me posted! Thanks, Link to comment Share on other sites More sharing options...
dancallo Posted June 25, 2013 Author Share Posted June 25, 2013 Benjamin, I spoke at length with Carol at Avalara, Inc. today regarding the issue that we have isolated to the Ava-tax module. She took a look at this and said that she thinks that the reason the amounts are different on the two websites is: (1) There may be a misconfiguration in the UPS module or other shipping interface that causes the shipping charges as computed on the Prestashop to be taxed when the information is passed to the PayPal interface via the API call; and (2) for some reason she can't explain, it appears that the taxable amount computed by the Avalara module is not being passed with the other information in the PayPal API call. Carol was given the Prestashop 888 techsupport number. She said that she was going to call them and/or email to discuss because she felt that Avalara and Prestashop should be discussing a solution to this issue and that there wasn't anything that I could do on my own. Bottom line, it is essential that the Avalara tax module remain enabled since it must calculate the appropriate tax for customers within NC. Outside of NC, there won't be an issue. But as long as there is one for customers within NC, we cannot go live with the Prestashop website. Dan Link to comment Share on other sites More sharing options...
dancallo Posted June 26, 2013 Author Share Posted June 26, 2013 (edited) Benjamin, Is there any additional information for me? I haven't heard from Avalara and wondered if anyone has contacted Prestashop from Avalara regarding this issue. The problem persists. There is one additional piece of information that I discovered. At the bottom of the Prestashop screen on the PayPal module page, a message states: " [PrestaShop] Fatal error in module Unk: PHP Startup: Unable to load dynamic library '/usr/php/53/usr/lib64/php/modules/uploadprogress.so' - /usr/php/53/usr/lib64/php/modules/uploadprogress.so: undefined symbol: zend_ini_string_ex" Might this have anything to do with the problem of prices not matching when Avalara Tax module is invoked? UPDATE: I spoke with Carol at Avalara, Inc., today (email address for her is [email protected]) and she has a meeting this afternoon with the General Manager of Avalara to discuss this issue. Hopefully, she will come back with some good news and a solution to fix the pricing issue. Edited June 26, 2013 by dancallo (see edit history) Link to comment Share on other sites More sharing options...
benjamin utterback Posted July 1, 2013 Share Posted July 1, 2013 Hi Dan, You may want to open up a Forge bugreport here, http://forge.prestashop.com/secure/Dashboard.jspa . That way it will be easier for the Dev team to take a look. You can provide specific details to see if we can reproduce it. Link to comment Share on other sites More sharing options...
El Patron Posted July 1, 2013 Share Posted July 1, 2013 quick question, are you using the Avalara because there are different tax rates within NC? Link to comment Share on other sites More sharing options...
benjamin utterback Posted July 1, 2013 Share Posted July 1, 2013 Benjamin, Is there any additional information for me? I haven't heard from Avalara and wondered if anyone has contacted Prestashop from Avalara regarding this issue. The problem persists. There is one additional piece of information that I discovered. At the bottom of the Prestashop screen on the PayPal module page, a message states: " [PrestaShop] Fatal error in module Unk: PHP Startup: Unable to load dynamic library '/usr/php/53/usr/lib64/php/modules/uploadprogress.so' - /usr/php/53/usr/lib64/php/modules/uploadprogress.so: undefined symbol: zend_ini_string_ex" Might this have anything to do with the problem of prices not matching when Avalara Tax module is invoked? UPDATE: I spoke with Carol at Avalara, Inc., today (email address for her is [email protected]) and she has a meeting this afternoon with the General Manager of Avalara to discuss this issue. Hopefully, she will come back with some good news and a solution to fix the pricing issue. The uploadprogress.so error is linked to a PECL package that your hosting company provides. With that specific error, your hosting provider may be able to give you more information. Link to comment Share on other sites More sharing options...
dancallo Posted July 1, 2013 Author Share Posted July 1, 2013 (edited) quick question, are you using the Avalara because there are different tax rates within NC? Yes. The Avalara tax module is necessary since tax rates vary by county and municipality within counties in the State of NC. The problem is not the Avalara Tax module. The uploadprogress.so error is linked to a PECL package that your hosting company provides. With that specific error, your hosting provider may be able to give you more information. Benjamin, I have no clue as to what a PECL package is. Can you tell me in layman's terms what this is? Thanks. Hi Dan, You may want to open up a Forge bugreport here, http://forge.prestas.../Dashboard.jspa . That way it will be easier for the Dev team to take a look. You can provide specific details to see if we can reproduce it. Benjamin, I have created a bug report on that site pertaining to this issue. I hope they can assist as soon as possible. Edited July 1, 2013 by dancallo (see edit history) Link to comment Share on other sites More sharing options...
benjamin utterback Posted July 1, 2013 Share Posted July 1, 2013 quick question, are you using the Avalara because there are different tax rates within NC? Hi El Patron, yeah he wants to have the different county and zip code tax rates within the state of NC. PECL is just a PHP hosting repository. Regarding the forge, you should make an account and make a report. Also, if you see the suspected bug already mentioned on the forge, you can vote Up+1 on it. I'll see if I can get more information regarding this. Can you remind me what version of avatax you are running? Link to comment Share on other sites More sharing options...
dancallo Posted July 1, 2013 Author Share Posted July 1, 2013 Hi El Patron, yeah he wants to have the different county and zip code tax rates within the state of NC. PECL is just a PHP hosting repository. Regarding the forge, you should make an account and make a report. Also, if you see the suspected bug already mentioned on the forge, you can vote Up+1 on it. I'll see if I can get more information regarding this. Can you remind me what version of avatax you are running? The Avalara-Tax module version is 3.2.1. Link to comment Share on other sites More sharing options...
Recommended Posts