Wrong total in the invoice
-
Hello,
I had in the month april 3 invoices where the total amount was not correct. I had one time a shortage of €4,10 and €4,99 and %0,25 .
The page I need help with: [log in to see the link]
-
Hey there, @ruba1956! Thanks for contacting us. I’m happy to help you.
Do you see any similarities between those orders? It can be same products, same payment gateway or method, similar address, etc.
Can you please share a screenshot of the order notes on those? Please remove any sensitive information before sharing it here. I recommend using https://snipboard.io. You can share the direct link to the image as a response to this topic.
Here’s an example of what we need:
https://snipboard.io/ga15Gu.jpg
Furthermore, I’d like to understand your site properly. Please share with us the necessary information below for us to investigate the issue further:
System Status Report which you can find via WooCommerce > Status > Get system report > Copy for support.
Fatal error logs (if any) under WooCommerce > Status > Logs. Then you can use the selector to search for Fatal Errors.
You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.Looking forward to your reply.
Have a wonderful day!
` WordPress Environment WordPress address (URL): https://bunnysweets.nl Site address (URL): https://bunnysweets.nl WC Version: 8.8.3 REST API Version: ? 8.8.3 Action Scheduler Version: ? 3.7.4 Log Directory Writable: ? WP Version: 6.5.2 WP Multisite: – WP Memory Limit: 2 GB WP Debug Mode: ? WP Cron: ? Language: nl_NL External object cache: ? Server Environment Server Info: LiteSpeed PHP Version: 8.1.27 PHP Post Max Size: 2 GB PHP Time Limit: 360 PHP Max Input Vars: 5000 cURL Version: 7.87.0 OpenSSL/1.1.1w SUHOSIN Installed: – MySQL Version: 10.11.7-MariaDB-cll-lve Max Upload Size: 2 GB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? Database WC Database Version: 8.8.3 WC Database Prefix: wp_ Totale database grootte: 216.43MB Database gegevens grootte: 162.72MB Database index grootte: 53.71MB wp_woocommerce_sessions: Data: 2.02MB + Index: 0.05MB + Engine InnoDB wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_order_items: Data: 1.52MB + Index: 0.22MB + Engine InnoDB wp_woocommerce_order_itemmeta: Data: 8.52MB + Index: 6.03MB + Engine InnoDB wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_cartflows_ca_cart_abandonment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_actionscheduler_actions: Data: 2.42MB + Index: 1.28MB + Engine InnoDB wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_logs: Data: 1.48MB + Index: 0.58MB + Engine InnoDB wp_aioseo_cache: Data: 0.11MB + Index: 0.03MB + Engine InnoDB wp_aioseo_notifications: Data: 0.09MB + Index: 0.06MB + Engine InnoDB wp_aioseo_posts: Data: 1.52MB + Index: 0.02MB + Engine InnoDB wp_cartflows_ca_cart_abandonment: Data: 1.52MB + Index: 0.02MB + Engine InnoDB wp_cartflows_ca_email_history: Data: 0.06MB + Index: 0.06MB + Engine InnoDB wp_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_chaty_contact_form_leads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cmplz_cookiebanners: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cmplz_cookies: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_cmplz_dnsmpd: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cmplz_services: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 3.52MB + Index: 1.53MB + Engine InnoDB wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB wp_gla_merchant_issues: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_jetpack_waf_blocklog: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_mapping_to_external_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletters: Data: 0.03MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_scheduled_tasks: Data: 0.11MB + Index: 0.06MB + Engine InnoDB wp_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_subscribers: Data: 0.05MB + Index: 0.13MB + Engine InnoDB wp_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mollie_pending_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_options: Data: 15.38MB + Index: 0.41MB + Engine InnoDB wp_pmxe_exports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB wp_pmxe_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_postmeta: Data: 63.56MB + Index: 28.19MB + Engine InnoDB wp_posts: Data: 33.38MB + Index: 1.02MB + Engine InnoDB wp_sc_delivery_methods: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_sc_delivery_zones: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_stock_log: Data: 0.33MB + Index: 0.00MB + Engine InnoDB wp_termmeta: Data: 0.33MB + Index: 0.48MB + Engine InnoDB wp_terms: Data: 0.08MB + Index: 0.09MB + Engine InnoDB wp_term_relationships: Data: 0.25MB + Index: 0.13MB + Engine InnoDB wp_term_taxonomy: Data: 0.09MB + Index: 0.11MB + Engine InnoDB wp_tinvwl_analytics: Data: 0.17MB + Index: 0.09MB + Engine InnoDB wp_tinvwl_items: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_tinvwl_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_userfeedback_surveys: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_userfeedback_survey_responses: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_usermeta: Data: 1.52MB + Index: 0.55MB + Engine InnoDB wp_users: Data: 0.06MB + Index: 0.05MB + Engine InnoDB wp_viredis_product_pricing: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wcas_match_rows: Data: 0.06MB + Index: 0.05MB + Engine InnoDB wp_wcas_match_sets: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wcpdf_invoice_number_2021: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wcpdf_invoice_number_2022: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wcpdf_invoice_number_2023: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_notes: Data: 0.11MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_note_actions: Data: 0.09MB + Index: 0.02MB + Engine InnoDB wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_customer_lookup: Data: 0.09MB + Index: 0.06MB + Engine InnoDB wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_orders: Data: 0.52MB + Index: 0.52MB + Engine InnoDB wp_wc_orders_meta: Data: 5.52MB + Index: 7.03MB + Engine InnoDB wp_wc_order_addresses: Data: 0.31MB + Index: 0.45MB + Engine InnoDB wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_operational_data: Data: 0.27MB + Index: 0.14MB + Engine InnoDB wp_wc_order_product_lookup: Data: 1.52MB + Index: 0.56MB + Engine InnoDB wp_wc_order_stats: Data: 0.17MB + Index: 0.16MB + Engine InnoDB wp_wc_order_tax_lookup: Data: 0.17MB + Index: 0.23MB + Engine InnoDB wp_wc_product_attributes_lookup: Data: 0.05MB + Index: 0.02MB + Engine InnoDB wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 0.16MB + Index: 0.16MB + Engine InnoDB wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wdp_orders: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wdp_order_items: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wdp_persistent_rules_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wdp_rules: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB wp_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpmailsmtp_debug_events: Data: 6.52MB + Index: 0.00MB + Engine InnoDB wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpml_mails: Data: 2.03MB + Index: 0.00MB + Engine InnoDB wp_wpstg_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_yoast_indexable: Data: 1.52MB + Index: 0.50MB + Engine InnoDB wp_yoast_indexable_hierarchy: Data: 0.09MB + Index: 0.14MB + Engine InnoDB wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_yoast_primary_term: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wp_yoast_seo_links: Data: 0.22MB + Index: 0.19MB + Engine InnoDB Post Type Counts attachment: 818 awdp_pt_products: 1 awdp_pt_rules: 1 br_notice: 3 cartflows_flow: 1 cartflows_step: 2 custom_css: 2 customize_changeset: 18 e-landing-page: 1 elementor_library: 1 jb_store_css: 8 jp_img_sitemap: 3 jp_sitemap: 3 jp_sitemap_master: 3 mailpoet_page: 1 mewz_attribute_stock: 58 nav_menu_item: 90 page: 42 post: 2 product: 463 product_variation: 272 revision: 2973 shipping_manifest: 1 shop_coupon: 31 shop_order: 1343 shop_order_refund: 2 viwec_template: 14 wcs_ruleset: 9 wp_global_styles: 2 wppopups: 3 Security Secure connection (HTTPS): ? Hide errors from visitors: ? Active Plugins (44) Advanced Dynamic Pricing voor WooCommerce: door AlgolPlus – 4.7.2 Starter Templates: door Brainstorm Force – 4.2.0 Astra Widgets: door Brainstorm Force – 1.2.12 WooCommerce Attribute Stock (Lite): door Mewz – 1.10.2 Cart Notices for WooCommerce: door BeRocket – 3.5.7.9 CartFlows: door CartFlows Inc – 2.0.7 Complianz | GDPR/CCPA Cookie Consent: door Really Simple Plugins – 7.0.5 Conditional Shipping for WooCommerce: door Lauri Karisola / WP Trio – 3.2.0 Cost of Goods for WooCommerce: door WPFactory – 3.3.7 Custom Fonts: door Brainstorm Force – 2.1.5 Elementor: door Elementor.com – 3.21.4 Email Template Customizer for WooCommerce: door VillaTheme – 1.2.3 Envo's Elementor Templates & Widgets for WooCommerce: door EnvoThemes – 1.4.10 Essential Addons for Elementor: door WPDeveloper – 5.9.18 Facebook for WooCommerce: door Facebook – 3.2.0 Flexible Shipping: door Octolize – 4.24.19 Google Analytics for WordPress by MonsterInsights: door MonsterInsights – 8.26.0 Google Language Translator: door Translate AI Multilingual Solutions – 6.0.20 Jetpack Boost: door Automattic - Jetpack Site Speed team – 3.2.2 Jetpack Protect: door Automattic - Jetpack Security team – 2.1.0 Jetpack: door Automattic – 13.3.1 LiteSpeed Cache: door LiteSpeed Technologies – 6.2.0.1 Loco Translate: door Tim Whitlock – 2.6.7 Mollie Payments for WooCommerce: door Mollie – 7.5.2 Sendcloud | Smart Shipping Service: door Sendcloud B.V. – 2.4.4 TI WooCommerce Wishlist: door TemplateInvaders – 2.8.2 TinyPNG - JPEG, PNG & WebP image compression: door TinyPNG – 3.4.3 Spectra: door Brainstorm Force – 2.13.0 UpdraftPlus - Backup/Restore: door UpdraftPlus.Com DavidAnderson – 1.24.3 User Role Editor: door Vladimir Garagulya – 4.64.2 WooCommerce Cart Abandonment Recovery: door CartFlows Inc – 1.2.27 Checkout Field Editor for WooCommerce: door ThemeHigh – 2.0.1 Google Analytics for WooCommerce: door WooCommerce – 2.0.6 WooCommerce Legacy REST API: door WooCommerce – 1.0.1 PDF Invoices & Packing Slips for WooCommerce: door WP Overnight – 3.8.2 Stock Manager for WooCommerce: door StoreApps – 3.0.0 WooCommerce: door Automattic – 8.8.3 WordPress Importer: door wordpressdotorg – 0.8.2 Yoast SEO: door Team Yoast – 22.6 WP Mail Logging: door WP Mail Logging Team – 1.12.0 WP Mail SMTP: door WP Mail SMTP – 4.0.1 WP Popups Lite: door timersys – 2.2 WPFront Scroll Top: door WPFront Team – 2.2 Sequential Order Numbers for WooCommerce: door WebToffee – 1.6.1 Inactive Plugins (0) Dropin Plugins () advanced-cache.php: advanced-cache.php object-cache.php: object-cache.php Must Use Plugins (1) Disable Auto Updates: door – Settings API Enabled: ? Force SSL: – Currency: EUR (€) Currency Position: left_space Thousand Separator: . Decimal Separator: , Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) variable (variable) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) exclude-from-search (exclude-from-search) featured (featured) outofstock (outofstock) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) rated-4 (rated-4) rated-5 (rated-5) Connected to WooCommerce.com: – Enforce Approved Product Download Directories: – HPOS feature screen enabled: ? HPOS feature enabled: ? Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore HPOS data sync enabled: ? Logging Enabled: ? Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2 Retention period: 30 dagen Level threshold: – Log directory size: 18 MB WC Pages Winkelbasis: #6 - /webshop/ Winkelwagen: #7 - /winkelwagen/ Afrekenen: #8 - /afrekenen/ Mijn account: #9 - /mijn-account/ Algemene voorwaarden: #273 - /algemene-voorwaarden/ Theme Name: Astra Child Version: 1.1.1645472312 Author URL: https://www.bunnysweets.nl Child Theme: ? Parent Theme Name: Astra Parent Theme Version: 4.6.13 Parent Theme Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme WooCommerce Support: ? Templates Overrides: – Admin Enabled Features: activity-panels analytics product-block-editor coupons core-profiler customize-store customer-effort-score-tracks import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing mobile-app-banner navigation onboarding onboarding-tasks product-variation-management product-virtual-downloadable product-external-affiliate product-grouped product-linked product-pre-publish-modal remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page Disabled Features: minified-js new-product-management-experience product-custom-fields settings async-product-editor-category-field launch-your-store Daily Cron: ? Next scheduled: 2024-05-02 14:57:10 +02:00 Options: ? Notes: 144 Onboarding: completed TI WooCommerce verlanglijst templates Overschrijvingen: – Action Scheduler Afgerond: 3.949 Oldest: 2024-04-01 08:12:31 +0200 Newest: 2024-05-02 07:12:15 +0200 Mislukt: 194 Oldest: 2022-01-14 16:34:51 +0100 Newest: 2024-05-01 23:56:34 +0200 In afwachting: 14 Oldest: 2024-05-02 08:12:15 +0200 Newest: 2025-01-01 00:00:01 +0100 Status report information Generated at: 2024-05-02 08:03:24 +02:00 `
Hello @carolm29
Here is the info you asked.
Please let me know if you need more info!
Thanks in advance.
Hello @ruba1956,
Thanks for getting back to us with further details. I was able to check on your shared screenshots, however, I wanted to request that you turn the language back to English and only share the notes from the right sidebar.
You can use a screenshot sharing software like https://snipboard.io/ and share the direct link here.
Looking forward to your reply.
Thanks for your reply.
But when I change to English language, the Dutch text will stay because it was stored in the database.
I will keep in now in English and wait until another issue will occur.
Or do you have any suggestions?
Hey, @ruba1956!
No worries!
I tried to check the screenshots to translate and check them, but I can’t find it. Did you remove them from the message?
If so, can you share them again?
Also, do you see any similarities between those orders? It can be same products, same payment gateway or method, similar address, etc.
Looking forward to your reply.
Have a wonderful day!
Hey @carolm29
Sorry I cleaned up too much ??
So I made them again. The only similarity between the three issues is the pay way Ideal. When you add up all items separately by hand on the invoice, then there is already a difference between the total off WooCommerce.
Greetings Ruud
Issue 1
Issue 2
Issue 3
Hi @ruba1956,
For these three orders, could you please share screenshots of the items in the order and the total amount paid? I want to learn more about what was billed and what should’ve been billed. If you can also share the links to said items, I’ll try to add them to the cart to see if we can replicate this issue in any way.
If we need to set up any specific address for tax and shipping purposes please do share a test address from your location we can use including the zip code.
Thanks!
-OPHello Ruud
Thank you for your reply.
To learn, what is billed and what you should have been billed, I tried to recalculate the Order ID #12030 in my Excel program. Here is a screenshot:
I noticed the total is slightly off.
WooCommerce has 128,65 and I have 132,74.Could you please confirm if you are referring to this discrepancy?
I will dive deeper into the issue once you confirm. ??Best regards.
Yes, I confirm this discrepancy.
The other discrepancy is WOO = € 45,27 and should be € 50,36 and another WOO= € 42,89 and should be € 43,89.
Because I have a little webshop, it has effect on mine profit!
I hope you can solve this issue.
Many regards,
Ruud
?? hey @ruba1956
Thank you for reaching back, clarifying things further.
As I understand, the discrepancy is related with shipping settings, invoice functionality — and taxes, perhaps.
While taking a look at the site’s System Status Report (SSR), it appears the following plugins are currently activated:
- PDF Invoices & Packing Slips for WooCommerce: door WP Overnight – 3.8.2
- Conditional Shipping for WooCommerce: door Lauri Karisola / WP Trio – 3.2.0
Just to be sure, did you already have a chance to check if they are updated to their latest versions, and test with temporarily deactivating both of them and see if the issue persists? (In what appears in the order total, that is).
If the issue persists, while the two plugins mentioned above are deactivated, kindly share screenshots of the site’s tax settings screens, also, please.
I trust that points you in the right direction, but if you have more questions, let us know.
We’re happy to help.
I always keep mine plugins up to date!
I can’t deactivate the 2 plugins in the live situation!
Are you sure it isn’t a WOO bug?
Kind regards,
Ruud
Hello @anastas10s
What I discovered that the total of the 9% tax is not correctly added (the tax per item is correct!) and afterward the adding of the subtotal + tax + shipping cost is also not correct!
Greetings,
Ruud
Hey, @ruba1956!
Are you sure it isn’t a WOO bug?
We don’t have enough information about the issue to know that yet. We need to investigate it further to be sure.
I can’t deactivate the 2 plugins in the live situation!
It is important to consider as well a staging functionality so you don’t need to touch your production site (you can ask your host if they offer this service), or you can use WP Staging for quickly spinning up a new test site.
What I discovered that the total of the 9% tax is not correctly added (the tax per item is correct!) and afterward the adding of the subtotal + tax + shipping cost is also not correct!
To confirm, this happened with 3 orders, but you did have other correct orders before and after that, right?
Can you please share screenshots of how you have this set up so we can take a look?
We need screenshots of:
- WooCommerce > Settings > Taxes
- WooCommerce > Settings > Taxes > Standard Rates
- If you have reduced rates and zero rates, please also share those
Can you please confirm which Tax class the products purchased on the orders are?
Looking forward to your reply.
Have a wonderful day!
Hello, @carolm29
Yes, these 3 orders are involved. When I look back in my bookkeeping program e-Boekhouden.nl, I see no paying difference in 2022 when the shop started. In 2023 I see 13 differences over the whole year. The most are + or – € 0,01, there is one of +€1,29 and one of +€0,22. In Jan. 2024 I had one difference of -€0,01 and in Mar. 2024 I have 4 differences -€0,25 -€4,99 -€4,10 and +€0,02 . I don’t mind the €0,01/0,02 these are probably rounding Issues. Mostly the orders have a mix of VAT 9% and 21%.
I will set up a staging asap.
Greetings,
- The topic ‘Wrong total in the invoice’ is closed to new replies.