Flat price change to free-shipping when is updated

Prerequisites

[X] I have carried out troubleshooting steps and I believe I have found a bug.
[X] I have searched for similar bugs in both open and closed issues and cannot find a duplicate.

Describe the bug

In recent versions of WooCommerce, there is a bug associated with the Flat Rate shipping method. The bug causes the shipping cost to appear as free in certain scenarios, particularly when decimal separators and thousands separators are used in the shipping cost configuration.

Expected behavior

The expected behavior is that the Flat Rate shipping cost, as configured in the WooCommerce settings, should accurately reflect the specified cost without any misinterpretation of decimal separators or thousands separators. The displayed shipping cost should be applied to the cart accordingly.

Actual behavior

When configuring a Flat Rate shipping option with a cost represented using decimal separators and thousands separators (e.g., 19.299,00), the shipping cost erroneously appears as free in the cart after saving the changes. However, if the cost is modified to remove these separators (e.g., changed to 19299), the shipping cost is correctly applied in the cart. This error also extends to shipping classes if they have been configured.

https://github.com/woocommerce/woocommerce/assets/290219/01c9b51f-6329-4129-ad65-6ec7c4e021f5

Steps to reproduce

Navigate to the WooCommerce admin panel.
Proceed to the "WooCommerce" settings.
Select the "Shipping" tab.
Choose the "Flat Rate" shipping method.
Edit an existing Flat Rate shipping option.
Observe the displayed shipping cost, represented with decimal separators and thousands separators (e.g., 19.299,00).
Without altering the displayed value, save the changes.
Visit the cart page and observe that the shipping cost appears as free.
Modify the shipping cost to remove decimal separators and thousands separators (e.g., change 19.299,00 to 19299).
Save the changes and revisit the cart page.
Confirm that the shipping cost is now accurately reflected and applied.

WordPress Environment

WordPress address (URL): Site address (URL): WC Version: 8.7.0 REST API Version: ✔ 8.7.0 Action Scheduler Version: ✔ 3.7.2 Log Directory Writable: ✔ WP Version: 6.5 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ✔ Language: en_US External object cache: –

Server Environment

Server Info: nginx/1.25.1 PHP Version: 8.2.8 PHP Post Max Size: 100 MB PHP Time Limit: 60 PHP Max Input Vars: 1000 cURL Version: 7.81.0 OpenSSL/3.0.2

SUHOSIN Installed: – MySQL Version: 10.11.4-MariaDB-1:10.11.4+maria~ubu2204 Max Upload Size: 100 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔

Database

WC Database Version: 8.7.0 WC Database Prefix: wBuGj_ Total Database Size: 7.33MB Database Data Size: 5.63MB Database Index Size: 1.70MB wBuGj_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wBuGj_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wBuGj_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wBuGj_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wBuGj_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wBuGj_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wBuGj_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wBuGj_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wBuGj_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wBuGj_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wBuGj_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wBuGj_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wBuGj_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wBuGj_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wBuGj_actionscheduler_actions: Data: 0.02MB + Index: 0.11MB + Engine InnoDB wBuGj_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wBuGj_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wBuGj_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wBuGj_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wBuGj_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wBuGj_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wBuGj_options: Data: 4.48MB + Index: 0.06MB + Engine InnoDB wBuGj_postmeta: Data: 0.08MB + Index: 0.03MB + Engine InnoDB wBuGj_posts: Data: 0.06MB + Index: 0.06MB + Engine InnoDB wBuGj_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wBuGj_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wBuGj_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wBuGj_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wBuGj_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wBuGj_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wBuGj_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wBuGj_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB wBuGj_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wBuGj_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wBuGj_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wBuGj_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB wBuGj_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wBuGj_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wBuGj_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wBuGj_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wBuGj_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wBuGj_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wBuGj_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wBuGj_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wBuGj_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wBuGj_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wBuGj_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wBuGj_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wBuGj_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wBuGj_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

Post Type Counts

attachment: 11 page: 7 post: 2 product: 9 shop_order_placehold: 1 wp_font_family: 12 wp_navigation: 1

Security

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

Active Plugins (1)

WooCommerce: by Automattic – 8.7.0

Inactive Plugins (2)

Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3.2 Hello Dolly: by Matt Mullenweg – 1.7.2

Must Use Plugins (1)

WP Password bcrypt: by Roots – 1.1.0

Settings

API Enabled: – Force SSL: – Currency: USD ($) Currency Position: left 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 Woo.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 days Level threshold: – Log directory size: 1 KB

WC Pages

Shop base: #7 - /shop/ Cart: #8 - /cart/ Checkout: #9 - /checkout/ My account: #10 - /my-account/ Terms and conditions: ❌ Page not set

Theme

Name: Storefront Version: 4.5.4 Author URL: https://woo.com/ 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 product-block-editor coupons core-profiler 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 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: customize-store minified-js new-product-management-experience product-pre-publish-modal settings async-product-editor-category-field

Daily Cron: ✔ Next scheduled: 2024-04-04 13:22:20 +00:00 Options: ✔ Notes: 63 Onboarding: completed

Action Scheduler

Canceled: 1 Oldest: 2024-04-03 13:24:36 +0000 Newest: 2024-04-03 13:24:36 +0000

Complete: 15 Oldest: 2024-04-03 13:23:24 +0000 Newest: 2024-04-03 13:36:23 +0000

Failed: 1 Oldest: 2024-04-03 13:23:24 +0000 Newest: 2024-04-03 13:23:24 +0000

Pending: 1 Oldest: 2024-04-04 13:23:24 +0000 Newest: 2024-04-04 13:23:24 +0000

Status report information

Generated at: 2024-04-03 13:38:38 +00:00 `

Isolating the problem

[X] I have deactivated other plugins and confirmed this bug occurs when only WooCommerce plugin is active.
[X] This bug happens with a default WordPress theme active, or Storefront.
[X] I can reproduce this bug consistently using the steps above.

woocommerce / woocommerce