Woocommerce with 6 decimal digits ?! shows only 2 in shop, but calculates wrong
-
I have a big problem.
My Woocommerce Shop is calculating the prices with 6 decimal digits after the , (15,966387 EUR + 3,033613 taxes) Even though the price is set to 9,50 per piece (including taxes) – both should end up in 19,00 but it keeps rounding up and end up with prices like 19,03 ?!
The setting to show inside the shop is set to 2 digits.
Now it keeps srewing up calculations… and adding a few cents on the final bill ?!
I have no idea where to start.
Can anyone help me?
Screenshots:
https://prnt.sc/1la10g0
https://prnt.sc/1la0kcpSame like here: https://www.ads-software.com/support/topic/woocommerce-with-6-decimal-digits-shows-only-2-in-shop-but-calculates-wrong/
-
Hello,
This kind of problem is usually caused by a conflict with your theme or with another plugin. The best way to determine this is to:
- Temporarily switch your theme to Storefront
- Disable all plugins except for WooCommerce
- Test to see if the issue has been resolved
If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.
Hello @maykato ,
thank you for your reply.
I have deactivated all of my Plugins except WooCommerce.
I have switched my Theme to Storefront like you told me to.Issue still exists. If i go to Orders, and refund one of the positions of the order, i am getting a lot of decimal digits.
I need to get two decimal digits there, to get my payment service working properly.
Can you help me?
Thank you in Advance!
Hi there,
Thanks for getting back.
Issue still exists
Do you mean the issue still persists when you’re making new test orders and have only the default theme and WooCommerce active?
Could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.
Thanks.
Do you mean the issue still persists when you’re making new test orders and have only the default theme and WooCommerce active? -> Yes it still persists also on new orders.
### WordPress Environment ### WordPress address (URL): https://bavarian-shisha.de Site address (URL): https://bavarian-shisha.de WC Version: 5.5.2 REST API Version: ? 5.5.2 WC Blocks Version: ? 5.3.3 Action Scheduler Version: ? 3.2.1 WC Admin Version: ? 2.4.4 Log Directory Writable: ? WP Version: 5.8 WP Multisite: – WP Memory Limit: 8 GB WP Debug Mode: – WP Cron: ? Language: de_DE External object cache: – ### Server Environment ### Server Info: Apache/2.4.29 (Ubuntu) PHP Version: 7.4.21 PHP Post Max Size: 8 MB PHP Time Limit: 30 PHP Max Input Vars: 1000 cURL Version: 7.58.0 OpenSSL/1.1.1 SUHOSIN Installed: – MySQL Version: 5.7.34-0ubuntu0.18.04.1 Max Upload Size: 8 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 5.5.2 WC Database Prefix: wp_ Datenbank-Gesamtgr??e: 58.29MB Datenbank-Datengr??e: 37.40MB Datenbank-Indexgr??e: 20.89MB wp_woocommerce_sessions: Daten: 0.17MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_api_keys: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_attribute_taxonomies: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_downloadable_product_permissions: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_order_items: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_order_itemmeta: Daten: 0.11MB + Index: 0.14MB + Engine InnoDB wp_woocommerce_tax_rates: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_tax_rate_locations: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_shipping_zones: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_shipping_zone_locations: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_shipping_zone_methods: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_payment_tokens: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_payment_tokenmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_log: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB tlpxx_user_verification: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB tlpxx_user_verification_blocked: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_actions: Daten: 0.38MB + Index: 0.53MB + Engine InnoDB wp_actionscheduler_claims: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_groups: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_logs: Daten: 0.31MB + Index: 0.28MB + Engine InnoDB wp_aiowps_events: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aiowps_failed_logins: Daten: 1.02MB + Index: 0.00MB + Engine InnoDB wp_aiowps_global_meta: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aiowps_login_activity: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aiowps_login_lockdown: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aiowps_permanent_block: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB wp_commentmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Daten: 0.06MB + Index: 0.09MB + Engine InnoDB wp_fa_user_logins: Daten: 4.52MB + Index: 5.42MB + Engine InnoDB wp_jtl_connector_category_level: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_jtl_connector_link_category: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_jtl_connector_link_crossselling: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_jtl_connector_link_crossselling_group: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_jtl_connector_link_currency: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_jtl_connector_link_customer: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_jtl_connector_link_customer_group: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_jtl_connector_link_image: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_jtl_connector_link_language: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_jtl_connector_link_manufacturer: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_jtl_connector_link_measurement_unit: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_jtl_connector_link_order: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_jtl_connector_link_payment: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_jtl_connector_link_product: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_jtl_connector_link_shipping_class: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_jtl_connector_link_shipping_method: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_jtl_connector_link_specific: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_jtl_connector_link_specific_value: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_jtl_connector_link_tax_class: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_jtl_connector_product_checksum: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB wp_links: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_options: Daten: 6.06MB + Index: 0.30MB + Engine InnoDB wp_postmeta: Daten: 13.17MB + Index: 7.38MB + Engine InnoDB wp_posts: Daten: 7.30MB + Index: 0.84MB + Engine InnoDB wp_termmeta: Daten: 0.09MB + Index: 0.11MB + Engine InnoDB wp_terms: Daten: 0.05MB + Index: 0.03MB + Engine InnoDB wp_term_relationships: Daten: 0.48MB + Index: 0.25MB + Engine InnoDB wp_term_taxonomy: Daten: 0.06MB + Index: 0.03MB + Engine InnoDB wp_tm_taskmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tm_tasks: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_usermeta: Daten: 0.16MB + Index: 0.11MB + Engine InnoDB wp_users: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wcpdf_invoice_number: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_notes: Daten: 0.06MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_note_actions: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_category_lookup: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_customer_lookup: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_download_log: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_coupon_lookup: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_product_lookup: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wc_order_stats: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wc_order_tax_lookup: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_product_meta_lookup: Daten: 0.23MB + Index: 0.48MB + Engine InnoDB wp_wc_reserved_stock: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_tax_rate_classes: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_webhooks: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wdr_order_discounts: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wdr_order_item_discounts: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wdr_rules: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_gzd_dhl_im_products: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_gzd_dhl_im_product_services: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_gzd_dhl_labelmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_gzd_dhl_labels: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_gzd_packaging: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_gzd_packagingmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_gzd_shipmentmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_gzd_shipments: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB wp_woocommerce_gzd_shipment_itemmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_gzd_shipment_items: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_gzd_shipment_labelmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_gzd_shipment_labels: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_gzd_shipping_provider: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_gzd_shipping_providermeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wpforms_tasks_meta: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpmailsmtp_debug_events: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpmailsmtp_tasks_meta: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wsal_metadata: Daten: 1.52MB + Index: 3.02MB + Engine InnoDB wp_wsal_occurrences: Daten: 0.09MB + Index: 0.20MB + Engine InnoDB ### Post Type Counts ### attachment: 1880 custom_css: 1 customize_changeset: 82 elementor_library: 1 nav_menu_item: 185 oceanwp_library: 3 page: 24 post: 5 product: 1420 revision: 1100 shop_coupon: 2 shop_order: 29 wpforms: 1 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (38) ### FiboSearch - AJAX Search for WooCommerce: von FiboSearch Team – 1.13.0 All In One WP Security: von Tips and Tricks HQ Peter Petreski Ruhul Ivy – 4.4.9 BackWPup: von Inpsyde GmbH – 3.9.0 Agy: von Patrick Posner – 4.2.8 DHL for WooCommerce: von DHL – 2.5.10 Easy Auto SKU Generator for WooCommerce: von Dan Zakirov – 1.0.5 Elementor: von Elementor.com – 3.3.1 First Order Discount Woocommerce: von WooExtend – 1.19 Google Analytics for WordPress by MonsterInsights: von MonsterInsights – 7.18.0 Hide Admin Bar From Non-admins: von Stranger Studios – 1.0 Jetpack: von Automattic – 10.0 Klarna On-Site Messaging for WooCommerce: von krokedil klarna – 1.5.1 Klarna Order Management for WooCommerce: von klarna krokedil – 1.6.7 Klarna Payments for WooCommerce: von krokedil klarna automattic – 2.5.1 Max Mega Menu: von megamenu.com – 2.9.4 Minimal Coming Soon & Maintenance Mode: von WebFactory Ltd – 2.33 Ocean Cookie Notice: von OceanWP – 2.0.1 Ocean Elementor Widgets: von OceanWP – 2.0.2 Ocean Extra: von OceanWP – 1.7.8 Ocean Full Screen: von OceanWP – 2.0.0 Ocean Popup Login: von OceanWP – 2.0.0 Ocean Side Panel: von OceanWP – 1.1.2 Ocean Woo Popup: von OceanWP – 2.0.0 WooCommerce Order Export and More PRO: von JEM Plugins – 3.0.7 Product Open Pricing (Name Your Price) for WooCommerce: von WP Wham – 1.6.0 Shortcode in Menus: von Gagan Deep Singh – 3.5.1 FRASPY: von Andreas van Loock – 2.0.0 User Login History: von Er Faiyaz Alam – 2.1.0 WPC Product Bundles for WooCommerce: von WPClever – 5.7.8 Woo Shortcodes Kit: von Alberto G. – 1.9.9 Germanized für WooCommerce: von vendidero – 3.5.4 WooCommerce PDF Invoices & Packing Slips: von Ewout Fernhout – 2.9.3 WooCommerce Shipping & Tax: von WooCommerce – 1.25.17 (Update auf Version 1.25.18 ist verfügbar) WooCommerce: von Automattic – 5.5.2 (Update auf Version 5.6.0 ist verfügbar) JSON API: von Dan Phiffer – 1.1.1 WP Mail SMTP: von WPForms – 3.0.3 WP Performance Score Booster: von Dipak C. Gajjar – 2.0 WPForms Lite: von WPForms – 1.6.8.1 ### Inactive Plugins (3) ### LiteSpeed Cache: von LiteSpeed Technologies – 4.2 Searchbar.org Search Plugin: von maiquelcraash – 0.1 WooCommerce JTL-Connector: von JTL-Software GmbH – 1.26.2 ### Settings ### API Enabled: – Force SSL: – Currency: EUR (€) Currency Position: right_space Thousand Separator: . Decimal Separator: , Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) variable (variable) woosb (woosb) 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: – ### WC Pages ### Shop-Basis: #6 - /shop/ Warenkorb: #7 - /warenkorb/ Kasse: #8 - /kasse/ Mein Konto: #9 - /mein-konto/ Allgemeine Gesch?ftsbedingungen: #2383 - /agb/ ### Theme ### Name: OceanWP Version: 3.0.3 Author URL: https://oceanwp.org/about-me/ Child Theme: ? – Wenn du WooCommerce mit einem Theme das du nicht selbst entwickelt hast an eigene Bedürfnisse anpasst dann empfehlen wir die Verwendung eines Child-Themes. Siehe Wie du ein Child-Theme erstellst (engl.) WooCommerce Support: ? ### Templates ### Overrides: oceanwp/woocommerce/cart/mini-cart.php oceanwp/woocommerce/content-single-product.php oceanwp/woocommerce/loop/loop-start.php oceanwp/woocommerce/single-product/title.php ### Product Open Pricing Settings ### Product Open Pricing (Name Your Price): no Frontend template: Name Your Price %open_price_input% %currency_symbol% Input field position: woocommerce_before_add_to_cart_button Position priority.: 9999 Hide price: yes Disable quantity selector: yes Display on loop: no Frontend loop template: Name Your Price %open_price_input% %currency_symbol% Input field loop position: woocommerce_after_shop_loop_item Position priority.: 9 Hide price: yes Input style: width:75px;text-align:center; Input pattern: Enable step ticker: yes Price step: 0.01 Force number of decimals: no Number of decimals.: 2 Add To Cart button text: Message on empty price: Price is required! Message on price too low: Price is too low! Message on price too high: Price is too high! Add "Open Pricing" column: no Fix mini cart: no ### Action Scheduler ### Abgeschlossen: 1.322 Oldest: 2021-07-19 08:40:24 +0200 Newest: 2021-08-18 13:35:57 +0200 Ausstehend: 6 Oldest: 2021-08-18 16:09:23 +0200 Newest: 2021-08-21 22:24:20 +0200 ### Status report information ### Generated at: 2021-08-18 15:24:33 +02:00
Hi there ??
Well, that’s strange. Your system status also indicates that you are using just two decimals.
Please provide us the WooCommerce error log found under WooCommerce > System Status > Logs.
Thank you!
We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if you’re still having the issue
Hello,
Sorry guys, i went on vacation. Issue is Not Solved yet, I will post the error log on wednesday.
Hello,
i can′t found a WooCommerce Log under: WooCommerce > System Status > Logs.
There are alot of logs but not only one which is called “WooCommerce”
Or is it One Stop Shop WooCommerce?Hi @felixnaumann,
Choose a pertinent log under WooCommerce > Status > Logs from the drop-down labeled
fatal-errors.log
and share a screenshot with us. Please use a tool like https://snipboard.io for sharing your screenshots, as I’m having trouble viewing your screenshots taken with prnt.sc.For more details on finding PHP Error Logs check https://docs.woocommerce.com/document/finding-php-error-logs/.
Also, update WooCommerce to the latest available version (5.6.0) and try conflict testing once more: https://docs.woocommerce.com/document/how-to-test-for-conflicts/.
Don’t forget before doing any changes to take a backup of your site in case anything goes wrong. More info at Backing up WordPress content.
Thanks.
This thread has been inactive for a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.
- The topic ‘Woocommerce with 6 decimal digits ?! shows only 2 in shop, but calculates wrong’ is closed to new replies.