Search found 58 matches

Search found 58 matches

Re: VAT and Rounding Errors between OC3 and PayPal Express

You miss that the single 55 is rounded up but in the long calc the rounding changes depending on the amounts encountered In this example the £274.98 is ACTUALLY more accurate than the single £55.00 You miss that £55.0000... is the consumer price, end of. OC works on ex. VAT and requires more than 2...

Jump to post
  • Sat Mar 13, 2021 1:53 am
  • Replies 19
  • Views 401
Re: VAT and Rounding Errors between OC3 and PayPal Express

But £274.98 is the correct amount :-) that is what your BANK would calculate the amount as. You are expecting 55 x 5 to be 275 - seems logical I know BUT you are doing 5 x 45.83 + VAT VAT calculated backwards gives you £229.17 not £229.15 from £275 total No. Consumers, in general, are only interest...

Jump to post
  • Sat Mar 13, 2021 1:16 am
  • Replies 19
  • Views 401
Re: VAT and Rounding Errors between OC3 and PayPal Express

Well your still wrong because £55.00 inc VAT £45.83 + VAT £9.17 Correct, and no one said otherwise. In ADD's example 45.83 + 8.33 + 5 + 11.83 = 70.99 the total VAT is (correctly) £11.83 You are fundamentally getting this wrong and ADD you should know that too If I exclusively use 2 dp for prices, e...

Jump to post
  • Sat Mar 13, 2021 12:44 am
  • Replies 19
  • Views 401
Re: VAT and Rounding Errors between OC3 and PayPal Express

Thank you for your considered reply :) It confirms by suspicions. The problem occurs because PayPal does it's calculations to 2 decimal places. 45.83 + 8.33 + 5 + 11.83 = 70.99 Whereas OpenCart will not use rounding until the end. 45.8333 + 8.3333 + 5 + 11.833332 = 70.99992 (which will round to 71) ...

Jump to post
  • Sat Mar 13, 2021 12:13 am
  • Replies 19
  • Views 401
Re: VAT and Rounding Errors between OC3 and PayPal Express

Sorry, typo, it should have been £55 inc. VAT, but exactly the same issues arise when the calculation does not result in whole pence.

As you can see it is confirmed that OC works to 4 dp.

Jump to post
  • Sat Mar 13, 2021 12:00 am
  • Replies 19
  • Views 401
Re: VAT and Rounding Errors between OC3 and PayPal Express

What does OC work to, when calculating VAT or doing currency conversion? £45.8333 * 1.20 = £50.00 Which is the correct VAT inc. price. £45.83 * 1.20 = £54.996 Will OC round that up in it's own invoice and in what it passes to PayPal? What if the customer orders two? £91.66 * 1.20 = £109.992 Will OC ...

Jump to post
  • Fri Mar 12, 2021 11:04 pm
  • Replies 19
  • Views 401
Re: VAT and Rounding Errors between OC3 and PayPal Express

Not very helpful!

Quote me the legislation that says prices have to be in whole pence.

Jump to post
  • Fri Mar 12, 2021 10:26 pm
  • Replies 19
  • Views 401
VAT and Rounding Errors between OC3 and PayPal Express

OC 3.0.2.0 (nothing in the release notes about a fix for this in any later version) Judging by multiple forum posts, there seem to have been ongoing issues, for some years, with rounding when adding VAT. I have found nothing that helps with the issue I have encountered. I have two products, and post...

Jump to post
  • Fri Mar 12, 2021 9:28 pm
  • Replies 19
  • Views 401
Re: Solved - OC 3 DB backup cannot be imported with phpMyAdmin

Sorry, I don't know how to get all posts in the thread to change to "solved"

Jump to post
  • Fri Jan 29, 2021 5:34 pm
  • Replies 6
  • Views 206
Solved - Re: OC 3 DB backup cannot be imported with phpMyAdmin

OK. I just assumed different tools would use the same underlying import/export commands.

Jump to post
  • Fri Jan 29, 2021 5:33 pm
  • Replies 6
  • Views 206
Solved - OC 3 DB backup cannot be imported with phpMyAdmin

If I use OC 3s built in backup to backup my store, the resulting .sql file cannot be imported using phpMyAdmin. Should this work?

If I use phpMyAdmin to export the DB it imports with myPhpAdmin just fine.

Jump to post
  • Fri Jan 29, 2021 4:03 am
  • Replies 6
  • Views 206
Re: Admin Manual Order entry Does not get user group discount

So I take it the supposed fixes were never actually implemented. The one supposedly implemented by Daniel in 2018 does not work.

Your new, third, "fix" does not work.

Only the fix in #6855 seems to work but this has never been merged as far as I can tell.

Jump to post
  • Thu Oct 15, 2020 12:00 am
  • Replies 14
  • Views 5244
Re: Admin Manual Order entry Does not get user group discount

The array validations have been recently fixed entirely by Daniel on GitHub. if (is_array($this->config->get('config_customer_group_display')) && in_array($this->request->post['customer_group_id'], $this->config->get('config_customer_group_display'))) { has been changed to: if (in_array($this->requ...

Jump to post
  • Wed Oct 14, 2020 2:26 am
  • Replies 14
  • Views 5244
Re: Permission Errors when I install a theme

D3MO wrote:
Sat Jun 08, 2019 4:44 am
This is permissions error make the file 755 oir 777 to be sure it is readable
If you look at the error more carefully, and examine the code, you will the file is being opened for writing. The permissions are probably already 755 and you need to change to 777.

Jump to post
  • Tue Oct 13, 2020 2:28 am
  • Replies 10
  • Views 1594
Re: PayPal Express Spins and never completes processing

There's a long thread here viewtopic.php?t=210578 about fixes for the PP Express module.

My theory is that some of the issues that were fixed came to the surface in a recent Chrome release. It was all working fine until mid-November.

Jump to post
  • Thu Dec 12, 2019 1:16 am
  • Replies 23
  • Views 2148
Re: PayPal Express Spins and never completes processing

I fixed it by upgrading to OC 3.0.3.2 (from 3.0.2.0), which suggests the problem was in the OC code.

Jump to post
  • Thu Dec 12, 2019 1:12 am
  • Replies 23
  • Views 2148
Re: Problem with Captcha missing or out of date session data

I got reCAPTCHA working on shared hosting so I'm good for now :)

Thank you.

Jump to post
  • Sat Dec 07, 2019 12:55 am
  • Replies 8
  • Views 674
Re: Google ReCaptcha Problem

A slightly different version also works in 3.0.3.2: // Use curl instead https://forum.opencart.com/viewtopic.php?t=161727 $url = 'https://www.google.com/recaptcha/api/siteverify?secret=' . urlencode($this->config->get('google_captcha_secret')) . '&response=' . $this->request->post['g-recaptcha-respo...

Jump to post
  • Sat Dec 07, 2019 12:51 am
  • Replies 6
  • Views 3584
Re: Problem with Captcha missing or out of date session data

So how does it work?

Does it work on shared hosting?

Does it rely on any URL other than my site?

Jump to post
  • Thu Dec 05, 2019 8:22 pm
  • Replies 8
  • Views 674

Search found 58 matches