preoteasa Posted October 15, 2016 Share Posted October 15, 2016 After installing the new version 1.6.1.7 I got the following problem when a customer payed for an order with PayPal. The order has a warning: Warning 310,21 € paid instead of 310,23 €, however the payment was charged, but order was not marked as complete. The products were still available, and the customer placed the order 3 times, always with the same error, and with the customer being charged. I don't know if it is related to the version 1.6.1.7, but this is the first and only order that I have so far after upgrading to 1.6.1.7 from 1.6.1.6. Any help will be appreciated. Viorel Link to comment Share on other sites More sharing options...
jetway Posted October 15, 2016 Share Posted October 15, 2016 Which Version of the paypal Module are you using? Link to comment Share on other sites More sharing options...
preoteasa Posted October 16, 2016 Author Share Posted October 16, 2016 v3.11.1, seems the latest Link to comment Share on other sites More sharing options...
shokinro Posted October 16, 2016 Share Posted October 16, 2016 from the difference of amount (only 2 cents), the issue seems related to rounding of order amount calculation. I guess the module pass the items details to paypal, so paypal calculated the total based on order items. And this total calculate by Payapl is different from the one calculated by PrestaShop. If above is the cause of the this issue, then it should not happen on all orders, only happens for some specific numbers that will cause rounding differently. if you are using the same version of the Paypal module, it might be not related to version of PrestaShop. Try different products and different quantity, the issue might be gone. Link to comment Share on other sites More sharing options...
jetway Posted October 22, 2016 Share Posted October 22, 2016 (edited) How many penny digits do your products have? I mean the selling price you provided when creating the product, not the one that is limited to 2 when displaying the price to the customer. My thought is that the module takes that value and calculates the price which means if your product costs $2.00492 Prestashop will display $2.00 but if the Module passes $2.00492 to paypal and a customer buys 2 items this will result in following. Prestashop amount $ 4.00 Paypal amount $ 4.01 Cheers, Andre Edited October 22, 2016 by jetway (see edit history) Link to comment Share on other sites More sharing options...
shokinro Posted October 22, 2016 Share Posted October 22, 2016 @preoteasa Not sure if you have figured out the problem and got a fix. like @jetway explained in more details with example, I think that might be the cause of the issue. The issue may happens with some numbers, not happens to all orders and the differences of amount is also different. You may consider to try our Agile Paypal Express Checkout modules if you are interested, it has other module features such as Express Checkout, customer does not need to register before payment. Link to comment Share on other sites More sharing options...
preoteasa Posted October 23, 2016 Author Share Posted October 23, 2016 (edited) Hello, I did not solve the problem, but I managed to investigate it further. I took a copy of my shop, and set it up as a test. I also set up PayPal sandbox. I have only 2 digits after the dot (23.05 Euro). However I have also a Catalog Price Rule of 10% discount, and this seems to cause these problems. Prestashop calculates the total for a product by applying the discount to the full amount. For example if I have 10 products, each costing 10.09, then the total is (10 * 10.09 * 90% = 90.81) However, in the list of products, Prestashop shows the price (10.09*90% = 9.08). It seems that it sends this price to PayPal, together with the quantity 10. So of course the two amounts will not match. I did not have this problem before installing 1.6.1.7. This seems a bug. This now happens in my shop quite often, and customers think that they made a mistake, they try again, and they are charged twice. The products also stay available. Another annoying problem, when using the PayPal sandbox is that after a payment, prestashop shows status "Awaiting PayPal payment" instead of "Payment accepted", or the error for the payment amount. Edited October 23, 2016 by preoteasa (see edit history) Link to comment Share on other sites More sharing options...
shokinro Posted October 23, 2016 Share Posted October 23, 2016 thanks for your feedback. yes, there is also a parameters for a module to send DISCOUNT information to Paypal, I think the discount amount is also one of the causes as you mentioned. Another annoying problem, when using the PayPal sandbox is that after a payment, prestashop shows status "Awaiting PayPal payment" instead of "Payment accepted", or the error for the payment amount. This might be related to your sandbox Paypal account configuration. Please check if you have set to review approve transactions to accept payment, if that is the case, the Paypal will return a payment status of "Payment review" so the module will be order status at "Awaiting payment". Check the the payment transaction status at your Paypal sandbox account to see what it is. Link to comment Share on other sites More sharing options...
preoteasa Posted October 23, 2016 Author Share Posted October 23, 2016 Where is that parameter (to send discount information to PayPal)? Link to comment Share on other sites More sharing options...
shokinro Posted October 25, 2016 Share Posted October 25, 2016 Not sure which module you are using, but I think It should be in the code file where send order info to Paypal. Link to comment Share on other sites More sharing options...
soydemadrid Posted January 29, 2017 Share Posted January 29, 2017 Hi I can confirm this is still a problem in Prestashop 1.6.1.9 I'm having the same problem, with a sale on all products of 30% off, customers are paying 1p or 2p different to what prestashop should be charging them. So warnings are coming in. Does anyone know how this can be please fixed? Link to comment Share on other sites More sharing options...
grandall1069 Posted January 29, 2017 Share Posted January 29, 2017 HI Guys, I have had no issues with this until today, last two orders have come in both with payment errors. I have attached a snap shot and it looks like prestashop is adding a penny on to my orders. running 1.6.1.9 Cheers Gareth Link to comment Share on other sites More sharing options...
shokinro Posted January 30, 2017 Share Posted January 30, 2017 As explained previously, if the issue was caused by rounding of price/tax calculation, then it only happens in some special scenarios, not happens all the time. Link to comment Share on other sites More sharing options...
soydemadrid Posted January 30, 2017 Share Posted January 30, 2017 Hi thanks Shokinro, I do realise that it doesn't happen all the time. But I've set two different sites up and both have this issue. Approx 50% of orders ARE having this problem. We really could do with a fix, as just because an issue doesn't happen all the time doesn't mean it isn't a nuisance and causes problems... Thanks if anyone can provide any help. Link to comment Share on other sites More sharing options...
shokinro Posted January 30, 2017 Share Posted January 30, 2017 It is better to contact the author of the module to have it fixed. If the module is original from prestashop, then check if there is any newer version of the module. Otherwise you may consider to use an alternative. Link to comment Share on other sites More sharing options...
soydemadrid Posted January 30, 2017 Share Posted January 30, 2017 I've submitted a bug here: http://forge.prestashop.com/browse/PNM-3873 Link to comment Share on other sites More sharing options...
shokinro Posted January 31, 2017 Share Posted January 31, 2017 sounds good. hope it will be fixed soon. Link to comment Share on other sites More sharing options...
soydemadrid Posted February 7, 2017 Share Posted February 7, 2017 Hi yes just to confirm the bug fix on that bug report works and I've had no further issues since applying it. Link to comment Share on other sites More sharing options...
shokinro Posted February 7, 2017 Share Posted February 7, 2017 great, thanks for your feedback. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now