Rounding issue between product bundle and cart

  • Resolved lumyser

    (@lumyser)


    2 years, 7 months ago

    I am developing a website for a Birth Products Distributor.

    Using Woocommerce and Woocommerce Product Bundles. The client sells standard products and Birth Kits (product bundles).

    I’m having a rounding issue and Support says it is expected behavior.

    Example… For a product that is part of a bundle(Mesh Briefs), the client gives a 5% discount. Starting price is $2.10 and with the discount, it shows as $2.00. This means they are rounding down to 2 decimal places, to show the price. At 3 decimal places, the price shown in the bundle would be $1.995. But it is not showing that price. It is showing the price based on 2 decimal places $2.00). Screenshot https://prnt.sc/G6s_z5yeHarm

    In the cart, the new discounted price shows as $2.00. With a quantity of 2, the price should be $4.00 in the cart. However, it comes up as $3.99 instead of $4.00. This means they are using 3 decimal places to calculate the price for the cart, instead of 2 decimal places, as in the product bundle. Screenshot https://prnt.sc/r5kctp5mXL84

    It is not consistent between the calculated price shown in the product bundle and the calculated price shown in the cart. The product bundle uses the 2 decimal point calculation to determine the price, and the cart uses the 3 decimal point calculation to determine the price. This is inconsistent, and quite frankly, not logical from what is displayed. In the cart, 2 x $2.00 does not equal $3.99.

    Has anyone run across this situation and found a solution?

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

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

  • Hi @lumyser

    Sounds like you’re running into a similar problem as is described here:
    https://github.com/woocommerce/woocommerce/issues/24184

    In order to check a few things – such as the WooCommerce version you are using – can you start by copy and pasting the system report for this site? You can find it under WP Admin → WooCommerce → Status → Get system report → Copy for support.

    Thread Starter lumyser

    (@lumyser)

    
### WordPress Environment ###

WordPress address (URL): https://radiant.local-webdesigns.com
Site address (URL): https://radiant.local-webdesigns.com
WC Version: 6.3.1
REST API Version: ? 6.3.1
WC Blocks Version: ? 6.9.0
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 3.2.1
Log Directory Writable: ?
WP Version: 5.9.3
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.28
PHP Post Max Size: 6 MB
PHP Time Limit: 30
PHP Max Input Vars: 5000
cURL Version: 7.64.0
OpenSSL/1.1.1n

SUHOSIN Installed: –
MySQL Version: 5.7.33-log
Max Upload Size: 64 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.3.1
WC Database Prefix: qxwmQrHs
Total Database Size: 95.61MB
Database Data Size: 64.90MB
Database Index Size: 30.71MB
qxwmQrHswoocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHswoocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHswoocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHswoocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
qxwmQrHswoocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHswoocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHswoocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
qxwmQrHswoocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHswoocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHswoocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHswoocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHswoocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHswoocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHswoocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHsactionscheduler_actions: Data: 2.02MB + Index: 1.50MB + Engine InnoDB
qxwmQrHsactionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHsactionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHsactionscheduler_logs: Data: 1.30MB + Index: 1.80MB + Engine InnoDB
qxwmQrHsaddonlibrary_addons: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
qxwmQrHsaddonlibrary_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHsatum_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHsatum_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHsatum_product_data: Data: 0.13MB + Index: 0.14MB + Engine InnoDB
qxwmQrHsberocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHscommentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHscomments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
qxwmQrHsdgwt_wcas_index: Data: 0.33MB + Index: 0.02MB + Engine InnoDB
qxwmQrHsdgwt_wcas_invindex_cache: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHsdgwt_wcas_invindex_doclist: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
qxwmQrHsdgwt_wcas_invindex_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHsdgwt_wcas_invindex_wordlist: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
qxwmQrHsdgwt_wcas_tax_index: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
qxwmQrHse_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHse_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
qxwmQrHse_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
qxwmQrHse_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHsfusion_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHsfusion_form_entries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHsfusion_form_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHsfusion_form_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHslinks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHsms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHsoptions: Data: 6.42MB + Index: 0.30MB + Engine InnoDB
qxwmQrHsorder_inventory: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHspimwick_gift_card: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHspimwick_gift_card_activity: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHspostmeta: Data: 7.52MB + Index: 4.03MB + Engine InnoDB
qxwmQrHsposts: Data: 10.44MB + Index: 0.58MB + Engine InnoDB
qxwmQrHssmush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHssnippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHstermmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
qxwmQrHsterms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHsterm_relationships: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
qxwmQrHsterm_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHstm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHstm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHsusermeta: Data: 3.16MB + Index: 0.03MB + Engine InnoDB
qxwmQrHsusers: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
qxwmQrHswc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
qxwmQrHswc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHswc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHswc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHswc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHswc_order_bundle_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
qxwmQrHswc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHswc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
qxwmQrHswc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
qxwmQrHswc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHswc_product_attributes_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHswc_product_meta_lookup: Data: 0.22MB + Index: 0.38MB + Engine InnoDB
qxwmQrHswc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHswc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHswc_se_queue: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHswc_se_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHswc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHswc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHswfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHswfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
qxwmQrHswfconfig: Data: 1.30MB + Index: 0.00MB + Engine InnoDB
qxwmQrHswfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHswffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHswffilemods: Data: 9.52MB + Index: 0.00MB + Engine InnoDB
qxwmQrHswfhits: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
qxwmQrHswfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHswfissues: Data: 0.22MB + Index: 0.06MB + Engine InnoDB
qxwmQrHswfknownfilelist: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
qxwmQrHswflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHswflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHswflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHswfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHswfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHswfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHswfpendingissues: Data: 0.16MB + Index: 0.06MB + Engine InnoDB
qxwmQrHswfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHswfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
qxwmQrHswfstatus: Data: 0.23MB + Index: 0.13MB + Engine InnoDB
qxwmQrHswftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHswoocommerce_bundled_itemmeta: Data: 7.52MB + Index: 7.03MB + Engine InnoDB
qxwmQrHswoocommerce_bundled_items: Data: 0.25MB + Index: 0.22MB + Engine InnoDB
qxwmQrHswoos_search_data: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHswoos_search_trends: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHswps_hit: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
qxwmQrHswps_index: Data: 7.48MB + Index: 10.77MB + Engine InnoDB
qxwmQrHswps_key: Data: 0.31MB + Index: 0.28MB + Engine InnoDB
qxwmQrHswps_object_term: Data: 0.27MB + Index: 0.50MB + Engine InnoDB
qxwmQrHswps_object_type: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
qxwmQrHswps_query: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHswps_uri: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHswps_user_agent: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHsyith_wapo_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHsyith_wapo_types: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qxwmQrHsyoast_indexable: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
qxwmQrHsyoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
qxwmQrHsyoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qxwmQrHsyoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qxwmQrHsyoast_seo_links: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
qxwmQrHsyoast_seo_meta: Data: 0.20MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

acf-field: 2
acf-field-group: 2
attachment: 791
atum_supplier: 1
br_product_filter: 1
custom_css: 5
customize_changeset: 70
dtwcbe_woo_library: 1
elementor_library: 22
elementor-hf: 1
fusion_element: 1
fusion_tb_layout: 1
fusion_template: 1
gift_card: 1
nav_menu_item: 11
oembed_cache: 14
page: 21
post: 6
product: 509
product_variation: 657
revision: 1389
shop_order: 1
slide: 1
wccf_product_field: 2
wccf_product_prop: 1
wp_global_styles: 2
wpcf7_contact_form: 1

### Security ###

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

### Active Plugins (17) ###

Advanced Custom Fields: by Delicious Brains – 5.12.1
Classic Widgets: by WordPress Contributors – 0.3
Code Snippets: by Code Snippets Pro – 2.14.3
Elementor Pro: by Elementor.com – 3.6.4
Elementor: by Elementor.com – 3.6.2
WooCommerce Quickview by Iconic: by Iconic – 3.5.1
Premium Addons for Elementor: by Leap13 – 4.9.5
Premium Addons PRO: by Leap13 – 2.7.3
Product Notes for WooCommerce: by Algoritmika Ltd – 2.7.1
Smart WooCommerce Search PRO: by YummyWP – 2.4.1
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 2.22.11.25

WooCommerce Category Accordion: by TechieResource – 2.0
WooCommerce Product Bundles: by WooCommerce – 6.15.1
WooCommerce: by Automattic – 6.3.1
Wordfence Security: by Wordfence – 7.5.9
WP-Optimize Premium - Clean, Compress, Cache: by David Anderson
Ruhani Rabin
Team Updraft – 3.2.3

XT Floating Cart for WooCommerce Pro: by XplodedThemes – 2.6.3

### Inactive Plugins (8) ###

Advanced Editor Tools (previously TinyMCE Advanced): by Automattic – 5.6.0
Ajax Cart AutoUpdate for WooCommerce: by taisho – 1.5.5
All-in-One WP Migration: by ServMask – 7.57
All-in-One WP Migration Unlimited Extension: by ServMask – 2.44
Classic Editor: by WordPress Contributors – 1.6.2
Contact Form 7: by Takayuki Miyoshi – 5.5.6
Loco Translate: by Tim Whitlock – 2.6.1
YITH WooCommerce Gift Cards: by YITH – 2.8.0

### Must Use Plugins (1) ###

1&1 Product Subdomain: by 1&1 – 1.1.0

### Settings ###

API Enabled: –
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 3
Taxonomies: Product Types: bundle (bundle)
bundled (bundled)
composite (composite)
external (external)
grouped (grouped)
pw gift card (pw-gift-card)
simple (simple)
variable (variable)
woosb (woosb)
yith_bundle (yith_bundle)

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 base: #13 - /shop
Cart: #14 - /cart
Checkout: #1948 - /checkout
My account: #16 - /my-account
Terms and conditions: ? Page not set

### Theme ###

Name: Storefront Child
Version: 4.0.0.1647454650
Author URL: https://woocommerce.com/
Child Theme: ?
Parent Theme Name: Storefront
Parent Theme Version: 4.0.0 – 4.1.0 is available
Parent Theme Author URL: https://woocommerce.com/
WooCommerce Support: ?

### Templates ###

Overrides: storefront-child/woocommerce/loop/price.php
storefront-child/woocommerce/single-product/price.php

### Product Bundles ###

Database Version: 6.15.1
Loopback Test: ?
Template Overrides: –

### Action Scheduler ###

Complete: 5,077
Oldest: 2022-03-10 15:51:47 -0800
Newest: 2022-04-09 21:40:50 -0700

Pending: 4
Oldest: 2022-04-09 22:09:04 -0700
Newest: 2022-04-10 04:35:53 -0700

### Status report information ###

Generated at: 2022-04-09 21:45:50 -07:00
    Plugin Support Paulo P – a11n

    (@paulostp)

    Hello,

    Thanks for writing back and sharing the system report!

    Please contact us at WooCommerce.com > My Account > Support.

    You may need to create an account before you can access that page.

    Please include a link to this forum thread, so that we can keep track of what’s already been done.

    We will be able to help you further there.

    Thread Starter lumyser

    (@lumyser)

    I have been going back and forth with Support and they say it is expected behavior. How can a cart that displays a discounted product at $2.00 with a quantity of 2, equal $3.99?
    How is that expected behavior? Granted it’s been many years since I was in school, but I can assure you 2 x $2.00 equals $4.00, not $3.99 https://prnt.sc/r5kctp5mXL84

    Hi @lumyser

    How can a cart that displays a discounted product at $2.00 with a quantity of 2, equal $3.99?

    I can understand the frustration this incorrect rounding up is leading to. Our team will certainly help you clear this problem, but you need to communicate in the right channel to let us help you.

    We are not allowed to support premium plugins in these forums! The forums are for free plugins only.

    I have been going back and forth with Support

    WooCommerce Product Bundles is one of our premium extensions and we are only able to provide support for it through a ticket, and not on this public forum. Hope you already created one as my colleague advised above.

    Kindly communicate through the ticket for further assistance. Our team will be happy to help you solve the problem.

    Thanks

    Thread Starter lumyser

    (@lumyser)

    Margaret,
    I have been actively communicating with your team.
    What do I do when these so-called WooCommerce Happiness Engineers keep telling me there is no issue and this is expected behavior?

    Hi @lumyser

    Apologies for the delay here.

    We’re sorry that you did not have a pleasant experience solving your problem.

    I have been actively communicating with your team

    Could you please share the ticket # or ID so that I can have our team check the details?

    Thread Starter lumyser

    (@lumyser)

    4906192

    Thread Starter lumyser

    (@lumyser)

    Here is a screenshot of a product bundle. Notice the original price of the Mesh Brief is $2.10 and has a 5% discount. The actual price should be $1.995, but obviously, the “displayed price” is rounded up to $2.00. See screenshot https://prnt.sc/LnrBKtoZbkce

    In the cart, again the displayed price is rounded up to $2.00 but the subtotal price is based on the actual price of $1.995 each. see screenshot https://prnt.sc/o4aYz32R2qHM

    How can I make the subtotal use the displayed price instead of the hidden actual price?

    Is the a code modification or plugin that fix this?

    Mirko P.

    (@rainfallnixfig)

    Hello @lumyser,

    Thanks for letting us know the ticket number.

    Please be assured that the WooCommerce.com support team is currently looking at your request and will be responding shortly.

    Best regards.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Rounding issue between product bundle and cart’ is closed to new replies.