DodoDog

Thank you so much for making your plugin HPOS compatible! I will upgrade to version 2.3.10 today.
Really appreciate your hard work!
Eva

Hello,

same question as above,

could you please fill us in on the compatibility with WooCommerce HPOS? We’re getting close to August and would love to continue using this amazing plugin.

Thank you for your answer, Eva

Same question, will the plugin support for HPOS any time soon? WooCommerce is making HPOS default in August 2023.
Thank you for a great plugin and your answer!

Thank you for your super fast reply Ewoud.
Just updated the plugin version 2.14.0 to the latest version 2.14.2.and all problems are solved!

Problem solved and marked as such, thank you!

Thanks for all your help Ewout, your explanation makes sense to me too now. It’s def a WooCommerce problem. The question is how to get WooCommerce to finally look into this problem, but how to get them to take action…. Do you know how to contact the WooCommerce team and explain the problem? Maybe the team is already in the know and working on this, is there a place where we can see what the team is working on?
Again, thanks for all your help and time, very much appreciated!

Hello Ewout,
indeed, fingers crossed WooCommerce will look into this problem and fix it asap! As far as I can see the problem started in May 2019 after upgrading WooCommerce.

About the Grand Total excluding tax block not working in my tests.It seems that the Grand Total minus Tax gives the same one cent difference and “wrong” amount as the Vat base/subtotal block. I say “wrong” because we want to see the subtotal amount of €40,00 (not €39,99, €43,70 or €43,69). Please check the example order for 2 LP’s of 20 euro (subtotal 40 euro) plus Shipping costs total 12 euro.

PDF with Grandtotal ex. VAT and Vat base/subtotal blocks:
2x LP €20,00 (2x €16,81+ VAT €3,19) = €40,00
Shipping €12,00 (€10,08 + VAT €1,92) = €12,00
Incl. VAT 19 % €8,30 = correct
Subtotal inc. VAT €39,99 = incorrect, should be €40,00
Grandtotal ex VAT €43,70
Vat base/subtotal (19 %) €43,69

I don’t really understand how the Grandtotal ex.VAT and VAT base/subtotal are calculated but it’s not the 40 euro I was hoping to see,….

I tested with Simple Premium template and Modernkopie (copied and altered template), the wrong numbers and subtotal showed up in both templates.

Please let me know if you need more information about this test.
Thank you!
Cheers, EVa

Thank you so much Ewout for all your advise!
I’ve been testing the Premium template tip and added a Grand Total block excluding tax but that didn’t work.
One last question, should the setting “Round tax at subtotal level, instead of rounding per line” be checked or unchecked?
I’m get a bit confused about this setting reading the Github page https://github.com/woocommerce/woocommerce/issues/23694
Thank you again for your time and help, much appreciated!
Eva

Hello,
we experience the same subtotal problem.
– The subtotal shows up correctly on the Cart page and the first check out page.
– BUT, the subtotal amount changes from €42,50 to €42,49 when the order is placed on /checkout/order-received/. The total amount of the order is correct.
– The wrong subtotal amount also shows up on the PDF Invoices
This is a real big problem!

I found this Github page about the tax rounding problem:
https://github.com/woocommerce/woocommerce/issues/23694
And tried all tips including adding a tiny script to functions.php
But nothing works, the PDF invoices still show the wrong subtotal amount.

We use the latest versions of WP and all plugins are up to date:
WooCommerce Version 3.7.0
WooCommerce PDF Invoices & Packing Slips Version 2.3.4
WooCommerce PDF Invoices & Packing Slips Premium Templates Version 2.7.1 (and we use the SIMPLE template)

My question in short, is there anything I might try to get the right subtotal amount on the PDF invoices?

Thank you so much for your answer!
Eva

Yes, can you please let us know about the compatibility with te latest versions of WooCommerce and WP? The plug-in hasn’t been updated for a while now. Would like to keep using this GREAT plug-in (for which I thank you very much!).

Sorry for my late reply, totally forgot to get back to you about this.Upgraded WooCommerce and the total calculations display correctly. Just the item price is still one cent too much. But that’s no biggy, problem solved! Thank you so much for your time, and again, real sorry for not replying.

Sorry, but the status of this topic can’t be changed to “resolved” because the option to do so is not active. The options don’t appear, no fold out and I can’t click it. Please advise how to solve this, thank you!

One more thing, should this topic be closed? And how do I do this (maybe I’m not authorised to do so,…) Thank you!

Sorry it took so long to answer Jackie, updated WooCommerce and the problem is solved. You’re right, next time I will make a new topic on the forum. Thank you so much for your advise, keep up the good work!

Thank you so much for your swift answer, great to hear the new release of your very excellent plug-in will have this problem fixed.
Have a great day!

Hello, I just checked the server log files and I have a somewhat similar WordPress database error. I use WordPress 4.8.1 and WooCommerce version 3.1.0 (will update to latest version of WC today). I use a theme based on Underscores.

[Sun Aug 06 06:34:07 2017] [error] [client 68.180.228.216] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AND comment_type != ‘webhook_delivery’ ORDER BY comment_date_gmt DESC LIMIT 1′ at line 1 for query SELECT wp_comments.* FROM wp_comments AND comment_type != ‘webhook_delivery’ ORDER BY comment_date_gmt DESC LIMIT 10 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

Is this a theme problem that causes the database error? I’m new to these things, any help is very much appreciated, thank you!