Rounding down by 1c

  • Resolved bendakk

    (@bendakk)


    3 years, 7 months ago

    I’ve been Googling this issue and finding many responses over many years, but no solutions.

    We put in the price for a product at 29.95, and it shows as 29.94 on the frontend.

    We’re in Australia so applying a very basic 10% tax.

    Prices are entered inclusive of tax, and displayed on shop and cart/checkout including tax.

    I have tried changing the ‘Round tax at subtotal level’ tick box, and setting the number of decimals everything from 2 to 10 places with no fix.

    Really struggling to explain to my client why the price they are entering is not exactly the same on the front end.

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Saif

    (@babylon1999)

    3 years, 7 months ago

    Hello @bendakk,

    We put in the price for a product at 29.95, and it shows as 29.94 on the frontend.

    Just to make sure I understand this correctly, the price on the shop page is 1 cent less than what you entered in the backend.

    I don’t think this is a math problem as I assume you’ve checked a couple of Github reports just like I did. 🙂

    If it was a math problem, then the final price would be more due to rounding, not vice versa.

    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.

    Look forward to hearing back from you.

    Thread Starter bendakk

    (@bendakk)

    3 years, 7 months ago

    Hi Saif, thanks for getting back to me.

    Yes correct – it is entered as 29.95 in the backend, and displaying as 1c less on the front end at 29.94.

    Here’s my System Status:

    ### WordPress Environment ###

    WC Version: 7.0.0
    REST API Version: ✔ 7.0.0
    WC Blocks Version: ✔ 8.5.1
    Action Scheduler Version: ✔ 3.5.2
    Log Directory Writable: ✔
    WP Version: 6.0.3
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_AU
    External object cache: –

    ### Server Environment ###

    Server Info: Apache/2.4.41 (Ubuntu)
    PHP Version: 7.4.3
    PHP Post Max Size: 8 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 1000
    cURL Version: 7.68.0
    OpenSSL/1.1.1f

    SUHOSIN Installed: –
    MySQL Version: 8.0.30-0ubuntu0.20.04.2
    Max Upload Size: 8 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔

    ### Database ###

    WC Database Version: 7.0.0
    WC Database Prefix: wp_
    Total Database Size: 379.63MB
    Database Data Size: 283.24MB
    Database Index Size: 96.39MB
    wp_woocommerce_sessions: Data: 0.90MB + Index: 0.05MB + Engine MyISAM
    wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_order_items: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_order_itemmeta: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
    wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    ec_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    ec_optionitem: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    ec_optionitemquantity: Data: 0.06MB + Index: 0.11MB + Engine InnoDB
    ec_product: Data: 0.17MB + Index: 0.17MB + Engine InnoDB
    sync_alias: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
    sync_auth: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    sync_manualAlias: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    sync_timestamp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ac_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 55.58MB + Index: 50.61MB + 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: 42.58MB + Index: 30.08MB + Engine InnoDB
    wp_admin_columns: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 0.05MB + Index: 0.09MB + Engine InnoDB
    wp_ff_scheduled_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_fluentform_draft_submissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_fluentform_entry_details: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_fluentform_form_analytics: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wp_fluentform_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_fluentform_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_fluentform_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_fluentform_order_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_fluentform_submission_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_fluentform_submissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_fluentform_subscriptions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_fluentform_transactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB
    wp_gla_merchant_issues: Data: 0.02MB + 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_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_loginizer_logs: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
    wp_mail_bank: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_options: Data: 6.39MB + Index: 0.22MB + Engine InnoDB
    wp_po_plugins: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_postmeta: Data: 32.52MB + Index: 4.63MB + Engine InnoDB
    wp_posts: Data: 6.52MB + Index: 0.41MB + Engine InnoDB
    wp_rank_math_analytics_gsc: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_rank_math_analytics_inspections: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
    wp_rank_math_analytics_objects: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_internal_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_internal_meta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_redirects: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_snp_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_snp_stats: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_term_relationships: Data: 0.14MB + Index: 0.08MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_termmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tg_item_elements: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tg_item_skins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_usermeta: Data: 0.16MB + Index: 0.09MB + Engine InnoDB
    wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_attributes_lookup: Data: 0.02MB + 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.14MB + 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_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wdr_order_item_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpfb_post_templates: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpfb_reviews: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wp_wpfb_total_averages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpgb_cards: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wpgb_facets: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wpgb_grids: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wpgb_index: Data: 0.14MB + Index: 0.17MB + Engine InnoDB
    wp_wsal_metadata: Data: 128.44MB + Index: 5.52MB + Engine InnoDB
    wp_wsal_occurrences: Data: 4.52MB + Index: 1.86MB + Engine InnoDB
    wp_yoast_seo_links: Data: 1.52MB + Index: 0.47MB + Engine InnoDB
    wp_yoast_seo_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_zip_tokenisation: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

    ### Post Type Counts ###

    acf-field: 8
    acf-field-group: 3
    attachment: 357
    cs_footer: 4
    cs_global_block: 1
    cs_header: 2
    cs_template: 78
    ct_template: 22
    customize_changeset: 7
    ec_store: 23
    envira: 1
    nav_menu_item: 54
    oembed_cache: 21
    page: 22
    post: 7
    postman_sent_mail: 250
    product: 517
    product_variation: 252
    revision: 270
    shop_coupon: 1
    shop_order: 9
    shop_quote: 1
    the_grid: 20
    wp_global_styles: 1
    wssf_social_feed: 1

    ### Security ###

    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔

    ### Active Plugins (40) ###

    Post SMTP: by Post SMTP – 2.1.10
    Admin Columns Pro – Advanced Custom Fields (ACF): by AdminColumns.com – 3.0.4
    Admin Columns Pro – WooCommerce: by AdminColumns.com – 3.7.3
    Admin Columns Pro: by AdminColumns.com – 5.7.4
    Advanced Custom Fields PRO: by WP Engine – 6.0.3
    Afterpay Gateway for WooCommerce: by Afterpay – 3.4.4
    FiboSearch – AJAX Search for WooCommerce: by FiboSearch Team – 1.20.0
    Better Search Replace: by Delicious Brains – 1.4.1
    Bulk remove posts from category: by MasterNs – 3.3
    Code Snippets: by Code Snippets Pro – 3.2.1
    Disable XML-RPC: by Philip Erb – 1.0.1
    Duplicate Page: by mndpsingh287 – 4.4.9
    Elegant Custom Fonts: by Louis Reingold – 1.0
    Pixel Cat Lite: by Fatcat Apps – 2.6.6
    Fluent Forms: by Contact Form – WPManageNinja LLC – 4.3.21
    Fluent Forms Pro Add On Pack: by Fluent Forms – 4.3.20
    Google Listings and Ads: by WooCommerce – 2.2.0
    Health Check & Troubleshooting: by The ww.wp.xz.cn community – 1.5.0
    Kadence WooCommerce Email Designer: by Kadence WP – 1.5.7
    Loginizer: by Softaculous – 1.7.4
    OxyExtras: by OxyExtras – 1.4.3
    Oxygen Elements for WooCommerce: by Soflyy – 2.0
    Oxygen: by Soflyy – 4.0.4
    Safe SVG: by 10up – 2.0.3
    Rank Math SEO: by Rank Math – 1.0.100.1
    Google Analytics: by Themeco – 3.0.2
    Two Factor: by Plugin Contributors – 0.7.3
    User Menus: by Code Atlantic – 1.3.0
    Woo Discount Rules: by Flycart – 2.4.5
    Variation Swatches for WooCommerce: by Emran Ahmed – 2.0.11
    WooCommerce Stripe Gateway: by WooCommerce – 6.9.0
    WooCommerce: by Automattic – 7.0.0
    WP Fastest Cache: by Emre Vona – 1.0.6
    WP Google Review Slider: by LJ Apps – 11.5
    WP Grid Builder – Oxygen: by Loïc Blascos – 1.1.2
    WP Grid Builder: by Loïc Blascos – 1.7.0
    WP Activity Log: by WP White Security – 4.4.2.1
    WPlit Woo Conditions for Oxygen: by WPlit – 1.0.1
    WPS Hide Login: by WPServeur
    NicolasKulka
    wpformation – 1.9.6

    Zip – WooCommerce: by Zip – 2.3.15

    ### Dropin Plugins (1) ###

    advanced-cache.php: advanced-cache.php

    ### Settings ###

    API Enabled: –
    Force SSL: –
    Currency: AUD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 3
    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: –

    ### WC Pages ###

    Shop base: #307 – /store/
    Cart: #1815 – /cart/
    Checkout: ❌ Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block.
    My account: ❌ Page does not contain the [woocommerce_my_account] shortcode.
    Terms and conditions: #2602 – /terms-and-conditions/

    ### Theme ###

    Name: Custom Theme
    Version: 0.0.1
    Author URL:
    Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build
    personally we recommend using a child theme. See: How to create a child theme

    WooCommerce Support: ✔

    ### Templates ###

    Overrides: –

    ### Admin ###

    Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    experimental-products-task
    experimental-import-products-task
    experimental-fashion-sample-products
    experimental-product-tour
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    multichannel-marketing
    mobile-app-banner
    navigation
    onboarding
    onboarding-tasks
    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
    settings

    Daily Cron: ✔ Next scheduled: 2022-10-31 04:47:11 +11:00
    Options: ✔
    Notes: 50
    Onboarding: skipped

    ### Action Scheduler ###

    Complete: 198,278
    Oldest: 2022-10-03 17:15:21 +1100
    Newest: 2022-10-31 10:40:05 +1100

    Failed: 4
    Oldest: 2022-10-07 01:13:09 +1100
    Newest: 2022-10-13 15:43:16 +1100

    Pending: 4
    Oldest: 2022-10-31 15:48:08 +1100
    Newest: 2022-11-13 11:00:51 +1100

    ### Status report information ###

    Generated at: 2022-10-31 10:47:15 +11:00

    Igor H

    (@ihereira)

    3 years, 7 months ago

    Hello,

    Thanks for sending the system report.

    Number of Decimals: 3

    May I ask if you navigate to WooCommerce > settings > general > Number of decimals , be sure to change it to 2, does this makes a difference?

    You can run this test on staging site first, that way you will not affect the live site, to clone your site you can use WP Staging.

    Let us know how that goes.

    Thread Starter bendakk

    (@bendakk)

    3 years, 7 months ago

    Hi,

    As I put in my original post, I’ve tried all settings on Number of Decimals from 2, 3, 4, and then 10, and none of them fixed the issues.

    xue28 (woo-hc)

    (@xue28)

    3 years, 7 months ago

    Hi @bendakk

    We put in the price for a product at 29.95, and it shows as 29.94 on the frontend.

    We’re in Australia so applying a very basic 10% tax.

    Prices are entered inclusive of tax, and displayed on shop and cart/checkout including tax.

    I replicated your scenario on my test site, however, I am unable to reproduce the issue on my end. This is what appears on my Cart page:

    Image Link: https://snipboard.io/oqXifb.jpg

    Can you please share screenshots of the following:

    – General Settings
    – Tax Settings and Tax Class
    – Product, General Settings

    If you don’t already have a screenshot service installed, you can try https://snipboard.io or http://skitch.com/. You can share the direct link to the image as a response to this topic.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Rounding down by 1c’ is closed to new replies.