Olivier

Hello, non, moi aussi.

Sur le site https://www.colissimo.entreprise.laposte.fr/fr ils signalent un souci technique avec leur passerelle de suivi de colis et de support client.

C’est sans nul doute lié.

Patience !

Olivier.

It’s a development copy, not the live site but I found the problem.

I don’t know why, but one plugin is the bad guy : Chronopost (https://www.chronopost.fr/fr/plateformes-e-commerce)

I’ll see with them.

Thanks !

Hi, well I just found that it only occurs when I am logged in AS ADMIN.
As a guest, or with a customer account, everything is butter smooth.

There is something wrong here.

(So I can give admin access if needed…)

• This reply was modified 5 years, 5 months ago by Olivier.

@harasse Aucune remarque concernant ce changement ?

Merci !

@madeincosmos Just in case you forgot to reply… ??

Thanks ! ??

Hi,

I don’t have any PayPal plugin, it’s the PayPal gateway integrated with Woocommerce 3.6.4.

I’m on WordPress 5.2.1

Thanks

@madeincosmos thanks again !

Instead of screenshots, I could create a replica of the live website and give you full access on it ? So you can see by yourself the numbers and do some checks faster if you need and compare with our accountant numbers.

Is that an option ?

Thanks

• This reply was modified 5 years, 5 months ago by Olivier.

Hi @madeincosmos !

Thanks for this detailed answer ??
The problem of my accountant is not really that. (But I totally understand your explanation)

Each month, we send them :

• The values that we found in Woocommerce reports (VAT, shipping VAT, shipping value, total tax included, total tax excluded, etc…)
• All the orders Invoices in PDF format, exported from the back office

They take all the invoices and then do their calculations (basically, a big addition). And they compare to the Woocommerce reports values we reported before. They never match.

For example, they can found, additioning all the invoices, a Total VAT included of 20524,39 while in the report we have 20539,39
And a TVA total of 3361,56 while in the report we have 3406,84

With numbers that big each month, and so much difference, we just can’t trust the WC reports.

That’s the problem and why I started to search a solution here ??

Thanks.

Hi @madeincosmos !

Thanks for help.
I did some tests while waiting, and I found something.

Settings on my live website :
Product prices : Tax INCLUDED
Tax rate : 20%
Product price : 8.00 (so, tax included)

Settings on DEV website :
Product prices : Tax EXCLUDED
Tax rate : 20%
Product price : 6.67 (so, tax excluded)

Now, I created one new order on the two websites, with 11 of the same product :

On live, in the backoffice :
Cost : 6.67
Qty : 11
Total : 73.33 (false.)
VAT : 14.67

On dev, in the backoffice :
Cost : 6.67
Qty : 11
Total : 73.37 (correct !)
VAT : 14.67

SO, it seems that the VAT is correctly calculated when tax is included and also when tax is exluded (14.67 is correct), BUT, the Total seems to have a problem when product prices are tax included.

As 6.67*11=73.37 I don’t understand why on the first case it shows 73.33

Thanks ??

Ps : I already tried your setting, for the rounding, no changes.
Ps2 : Also, I don’t know if that problem is the source of my reports problems.

• This reply was modified 5 years, 6 months ago by Olivier.
• This reply was modified 5 years, 6 months ago by Olivier.

Then, the formula needs to be fixed in Woocommerce core.
Tax and amounts should be 100.0000000% exact in reports. Our accountant is saying “fix that mess” and he’s right.

If you manually calculate amounts and taxes, opening each orders one by one on a month, then you go to reports, there is differences. It should not, it’s driving us and the accountant crazy.

I’ll try to change the price of all products to Tax-exclusive. Hoping it will be applied to older orders and not only the new ones.

@serafinnyc Rounding is applied on each products, not on the subtotal ?
Because, 73.33337 (the real value) should be rounded to 73.34 or 73.33, not 73.37 as WC actually does.

Also, the only workaround I see looking at Mike’s post, is to use tax exclusive prices on products. As I’m using tax-inclusive prices actually.

• This reply was modified 5 years, 6 months ago by Olivier.
• This reply was modified 5 years, 6 months ago by Olivier.

Confirmed.
73.33 but should be 73.37

Maybe that’s why we have a lot of problems with the woocommerce reports…

View post on imgur.com

Try with Woocommerce 3.6.2
3.6.3 seems to introduce this problem.

Hi,

Thanks for your reply. Unfortunately, I already tried that.
Same problem with twentynineteen and no plugins but bbpress and yours ??

Problem goes away when your plugin is disabled.

Thanks !

Ok, so I just edited elementor.php file.
It’s crappy, but works.

//define( 'ELEMENTOR_ASSETS_URL', ELEMENTOR_URL . 'assets/' );
define( 'ELEMENTOR_ASSETS_URL', WP_SITEURL.'/wp-content/plugins/elementor/assets/' );

With define('WP_SITEURL','https://yourdomain.com'); in wp-config.php

It seems that the function used to generate ELEMENTOR_URL , plugins_url(), doesn’t return https URL. Don’t know why but…