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...

• 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...

• 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...

• 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) ...

• 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.

• 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 ...

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

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

• 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...

• 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"

• 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.

• Fri Jan 29, 2021 5:33 pm
• Replies 6
• Views 206
##### Re: OC 3 DB backup cannot be imported with phpMyAdmin

So import/export of the DB is not deterministic?

• Fri Jan 29, 2021 5:15 am
• 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.

• 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.

• 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...

• 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.

• 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.

• 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.

• 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.

• Sat Dec 07, 2019 12:55 am
• Replies 8
• Views 674

• 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?

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

Search found 58 matches