Paypal Calculation Error

-- HikaShop version -- : 2.3.4
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.3.28
-- Browser(s) name and version -- : Firefox 33.02

Hi

there seems to be a small issue with payments being sent to Paypal of which I have just been notofied.

The user completed an order which totalled £35.10 including the carriage and VAT. When the order is proessed via Paypal the total is £35.04, a smal reduction which could be quite significant on a very large order.

I have checked the configuration under Taxes/VAT Round prices during calculations which is off.

When I switched it on the cart price is the same as the prices being displayed on Paypal.

The site is live so would appreciate some help in getting this issue reolved promptly

Thanks

Dave

Hi,

Well, PayPal calculates the total as HikaShop when the "round prices during calculations" option is turned on. Both means of calculations are correct. They just use a different logic (rounding prices after each operation, or only at the end for the display).

So you already found the solution with the "Round prices during calculations". Alternatively, you can also turn off the "send order details" option of the PayPal payment method so that PayPal will just get the total to charge from HikaShop.

Hi

the rounded price option is actually calculating the wrong amount of VAT.

On the order the VAT should be 5.85 not 5.79. This could potentially cause an issue with VAT returns etc and the HM Customs & Revenue. This could run into £100's on a site with a large turnover.

I have turned off the Send Order Details and will create a test order. I will then see what the outcome is and await feedback from the customer.

Dave

Hello,

I have just started adding VAT and I'm having problems with 'invalid status's' due to minor discrepancies in the calculation of VAT. I have noticed that theres an option in the Paypal plugin for 'Tax category'. What does this do?

It's not an option for me to disable the 'send order details' as it's helpful to me and the customer. Where is the 'round prices during calculations option'?

Many thanks,
Hal

Hi,

The tax category setting of your payment method is used for the calculation of the taxes on the payment fees. If you don't have anything in the "price" or "percentage" fields of your payment method, this setting doesn't change anything.

The "round prices during calculation" option, which will probably solve your problem, can be found in the "taxes" section of the HikaShop configuration.

Found it, thanks.

Good morning,

Unfortunately this hasn't fixed it for me, I'm still getting 'cancelled' notifications, as the prices are different (1p). Are there any other solutions?

Many thanks,
Hal

Hi,

No one else reported issues with PayPal with the "round prices during calculations" setting turned on.
So first, we would that you make sure that this option is activated and that you have the latest version of HikaShop.
If that's the case, we need a really precise picture of an example:
- a screenshot of the order details of an order with the problem
- a screenshot of the settings of the product in the order, of the settings of the coupon if any, of the shipping method if any, of the tax rule used if any.
- a screenshot of the payment details in PayPal
- a link to the product page so that we can reproduce the problem on the website.

The option is activated in the system configuration, please see attached screenshot. I'm running Hikashop 2.6.1, which I believe is the latest stable version.

The information about the order is private, so I'm not going to share this on the forum. I could send you a private email.

One of the latest 'refusals' was for this product: www.elevateyoursole.co.uk/all-womens-sho...lackleathershoeboots

All my products have VAT added (Tax rule) and the shipping method chosen was "Free UK delivery". No coupon was used, although it is a sale item.

The payment came through correctly at £48.99, which is to be expected. The problem comes after this: "A Paypal notification was refused because the amount received (48.99GBP) is different from the order amount (49GBP)". It then displays as 'cancelled' in my order book.

Thanks,
Hal

Hello,

Unfortunately, I'm still having problems with this.

It's an issue on the hikashop side, rather than Paypal. If you navigate to this page: www.elevateyoursole.co.uk/all-womens-sho...sy-black-court-shoes and add to the cart, you can see that the cart changes the price.

Many thanks,
Hal

Hello,

Your issue is probably coming from a view's override, can you check if your have an override through the "Cart" file of the "Product" view of your front-end template via "Hikashop->Display->Views" and test it without it.

Thank you.

I'm using a template, so certainly do have an override.

Is this code wrong?

<span class="hikashop_cart_module_coupon_value">
<?php
if (!$this->params->get('price_with_tax')) {
echo $this->currencyHelper->format(@$this->element->coupon->discount_value_without_tax * -1, @$this->element->coupon->discount_currency_id);
} else {
echo $this->currencyHelper->format(@$this->element->coupon->discount_value * -1, @$this->element->coupon->discount_currency_id);
}
?>
</span>

Hello,

It seems to be the code which is handling the displaying of the coupon price, but firstly, you should test it without your customization or with a default Joomla template so that we can be sure that it's coming from it.

Thank you.

Hello,

Sorry for the late reply.

It's not a fault with the template, I have tried it with a different template and the problem remains.

Thanks,
Hal

Hi,

The link you provided doesn't work and we don't know how you configured that product.
Please provide a working link of the product page and a screenshot of the settings of the product.

Job done Nicolas,

Thank you for your help.