• Resolved christianshb

    (@christianshb)


    Hello Everyone at WooCommerce,

    I am writing to you because the Free Shipping settings on our WooCommerce store aren’t working well.

    We’ve set the Free Shipping threshold at CLP$30.000 (Thirty Thousand Chilean Pesos) and, at Checkout, the store is granting the Free Shipping option (‘Envío Gratis’ in Spanish) to customers placing orders that are of lower value than CLP$30.000 (ie. $21.630).

    It seems there is an issue with the way the store’s shipping systems within WooCommerce are interpreting thousands and decimals. In Chile and the vast majority of countries in Latin America, we use the dot (.) as the thousands separator and the comma (,) as the decimals separator. The store is properly operating with period/dot (.) as thousands separator and comma (,) as the decimals separator. However it seems this is not the case when it comes to the store judging whether to grant or not Free Shipping.

    Here’s the link to a GDrive Folder containing the screenshots that back the aforementioned claims:
    https://drive.google.com/drive/folders/1MgsYFkxa3ssxOUwTALuhSkPqLWvJF216?usp=drive_link

    We’d appreciate your support with this matter.

    Kind regards,
    Christian

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter christianshb

    (@christianshb)

    
    WordPress Environment
    
    WordPress address (URL): https://staging.secondhandbooks.cl
    Site address (URL): https://staging.secondhandbooks.cl
    WC Version: 8.8.3
    REST API Version: ? 8.8.3
    Action Scheduler Version: ? 3.7.4
    Log Directory Writable: ?
    WP Version: 6.5.3
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: es_CL
    External object cache: – Server Environment
    
    Server Info: Apache
    PHP Version: 8.0.30
    PHP Post Max Size: 128 MB
    PHP Time Limit: 90
    PHP Max Input Vars: 4000
    cURL Version: 8.7.1
    OpenSSL/1.1.1w
    
    SUHOSIN Installed: –
    MySQL Version: 10.6.18-MariaDB-log
    Max Upload Size: 128 MB
    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: wpxb_
    Tama?o total de la base de datos: 266.33MB
    Tama?o de los datos de la base de datos: 259.55MB
    Tama?o del índice de la base de datos: 6.78MB
    wpxb_woocommerce_sessions: Datos: 0.17MB + índice: 0.00MB + Motor MyISAM
    wpxb_woocommerce_api_keys: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_woocommerce_attribute_taxonomies: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_woocommerce_downloadable_product_permissions: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_woocommerce_order_items: Datos: 0.01MB + índice: 0.01MB + Motor MyISAM
    wpxb_woocommerce_order_itemmeta: Datos: 0.08MB + índice: 0.06MB + Motor MyISAM
    wpxb_woocommerce_tax_rates: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM
    wpxb_woocommerce_tax_rate_locations: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_woocommerce_shipping_zones: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_woocommerce_shipping_zone_locations: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_woocommerce_shipping_zone_methods: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_woocommerce_payment_tokens: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_woocommerce_payment_tokenmeta: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_woocommerce_log: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_actionscheduler_actions: Datos: 1.07MB + índice: 0.33MB + Motor MyISAM
    wpxb_actionscheduler_claims: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_actionscheduler_groups: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM
    wpxb_actionscheduler_logs: Datos: 0.79MB + índice: 0.49MB + Motor MyISAM
    wpxb_aioseo_cache: Datos: 0.09MB + índice: 0.01MB + Motor MyISAM
    wpxb_aioseo_notifications: Datos: 0.02MB + índice: 0.01MB + Motor MyISAM
    wpxb_aioseo_posts: Datos: 0.08MB + índice: 0.01MB + Motor MyISAM
    wpxb_aiowps_audit_log: Datos: 1.45MB + índice: 0.03MB + Motor MyISAM
    wpxb_aiowps_debug_log: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_aiowps_events: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_aiowps_global_meta: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_aiowps_logged_in_users: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM
    wpxb_aiowps_login_lockdown: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_aiowps_message_store: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_aiowps_permanent_block: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_cartflows_ca_cart_abandonment: Datos: 0.04MB + índice: 0.01MB + Motor MyISAM
    wpxb_cartflows_ca_email_history: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_cartflows_ca_email_templates: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_cartflows_ca_email_templates_meta: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_chaty_contact_form_leads: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_cky_banners: Datos: 0.02MB + índice: 0.00MB + Motor MyISAM
    wpxb_cky_cookies: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_cky_cookie_categories: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM
    wpxb_commentmeta: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM
    wpxb_comments: Datos: 0.07MB + índice: 0.03MB + Motor MyISAM
    wpxb_commercekit_ajs_product_index: Datos: 0.56MB + índice: 1.44MB + Motor MyISAM
    wpxb_commercekit_searches: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_commercekit_swatches_cache_count: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_commercekit_waitlist: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_commercekit_wishlist: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_commercekit_wishlist_items: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_dgwt_wcas_stats: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wpxb_easywpsmtp_debug_events: Datos: 0.06MB + índice: 0.00MB + Motor InnoDB
    wpxb_easywpsmtp_tasks_meta: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_e_events: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_frm_fields: Datos: 0.06MB + índice: 0.01MB + Motor MyISAM
    wpxb_frm_forms: Datos: 0.01MB + índice: 0.00MB + Motor MyISAM
    wpxb_frm_items: Datos: 0.01MB + índice: 0.01MB + Motor MyISAM
    wpxb_frm_item_metas: Datos: 0.01MB + índice: 0.02MB + Motor MyISAM
    wpxb_jetpack_sync_queue: Datos: 0.02MB + índice: 0.01MB + Motor MyISAM
    wpxb_jetpack_waf_blocklog: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_links: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_options: Datos: 5.17MB + índice: 0.28MB + Motor MyISAM
    wpxb_pkt1: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_pmxe_exports: Datos: 0.02MB + índice: 0.00MB + Motor MyISAM
    wpxb_pmxe_google_cats: Datos: 0.26MB + índice: 0.05MB + Motor MyISAM
    wpxb_pmxe_posts: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_pmxe_templates: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_pmxi_files: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_pmxi_hash: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_pmxi_history: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_pmxi_images: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_pmxi_imports: Datos: 0.01MB + índice: 0.00MB + Motor MyISAM
    wpxb_pmxi_posts: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_pmxi_templates: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_postmeta: Datos: 149.40MB + índice: 2.10MB + Motor MyISAM
    wpxb_posts: Datos: 80.51MB + índice: 0.71MB + Motor MyISAM
    wpxb_sgs_log_events: Datos: 1.02MB + índice: 0.02MB + Motor InnoDB
    wpxb_sgs_log_visitors: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    wpxb_shipit: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_shipit_communes: Datos: 0.03MB + índice: 0.01MB + Motor MyISAM
    wpxb_shipit_emergency_rates: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_shipit_rates_request: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_snippets: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_swastarkencl_regions: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_swa_sendu_comunes: Datos: 0.01MB + índice: 0.01MB + Motor MyISAM
    wpxb_termmeta: Datos: 0.07MB + índice: 0.07MB + Motor MyISAM
    wpxb_terms: Datos: 0.09MB + índice: 0.15MB + Motor MyISAM
    wpxb_term_relationships: Datos: 0.11MB + índice: 0.24MB + Motor MyISAM
    wpxb_term_taxonomy: Datos: 0.10MB + índice: 0.08MB + Motor MyISAM
    wpxb_usermeta: Datos: 0.17MB + índice: 0.03MB + Motor MyISAM
    wpxb_users: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM
    wpxb_user_shipit: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wcpdf_invoice_number: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wcpdf_packing_slip_number: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wc_admin_notes: Datos: 0.05MB + índice: 0.00MB + Motor MyISAM
    wpxb_wc_admin_note_actions: Datos: 0.03MB + índice: 0.01MB + Motor MyISAM
    wpxb_wc_category_lookup: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wc_customer_lookup: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM
    wpxb_wc_download_log: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wc_order_addresses: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wc_order_coupon_lookup: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wc_order_operational_data: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wc_order_product_lookup: Datos: 0.01MB + índice: 0.02MB + Motor MyISAM
    wpxb_wc_order_stats: Datos: 0.01MB + índice: 0.01MB + Motor MyISAM
    wpxb_wc_order_tax_lookup: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM
    wpxb_wc_product_attributes_lookup: Datos: 0.24MB + índice: 0.32MB + Motor MyISAM
    wpxb_wc_product_download_directories: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM
    wpxb_wc_product_meta_lookup: Datos: 0.02MB + índice: 0.04MB + Motor MyISAM
    wpxb_wc_rate_limits: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wc_reserved_stock: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wc_se_queue: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wc_se_settings: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wc_tax_rate_classes: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wc_webhooks: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wow_fbtnp: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wpforms_lite: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wpxb_wpforms_payments: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wpforms_payment_meta: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wpforms_tasks_meta: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wpf_filters: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wpf_meta_keys: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM
    wpxb_wpf_meta_values: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM
    wpxb_wpf_meta_values_bk: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wpmailsmtp_debug_events: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wpxb_wpmailsmtp_tasks_meta: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_wpml_mails: Datos: 17.52MB + índice: 0.01MB + Motor MyISAM
    wpxb_yith_wcwl: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wpxb_yith_wcwl_lists: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM Post Type Counts
    
    attachment: 443
    cartflows_flow: 2
    cartflows_step: 4
    custom_css: 2
    customize_changeset: 106
    elementor_library: 54
    frm_form_actions: 21
    frm_styles: 1
    is_search_form: 4
    jb_store_css: 9
    jp_img_sitemap: 1
    jp_sitemap: 1
    jp_sitemap_master: 1
    mc4wp-form: 1
    nav_menu_item: 34
    page: 21
    post: 3
    product: 235
    revision: 6315
    shop_coupon: 1
    shop_order: 16
    shop_order_refund: 1
    viwec_template: 13
    wp_block: 1
    wp_global_styles: 1
    wp_navigation: 1
    wp_template: 2
    wpforms: 5
    xlwcty_thankyou: 1 Security
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ? Active Plugins (30)
    
    Ajax Cart AutoUpdate for WooCommerce: por taisho – 1.5.5
    All In One WP Security: por All In One WP Security & Firewall Team – 5.3.0
    Editor Clásico: por Colaboradores de WordPress – 1.6.3
    Code Snippets: por Code Snippets Pro – 3.6.5
    CommerceGurus CommerceKit: por CommerceGurus – 2.3.0.1
    CookieYes | GDPR Cookie Consent: por CookieYes – 3.2.4
    Customizer Export/Import: por The Beaver Builder Team – 0.9.6
    Yoast Duplicate Post: por Enrico Battocchi & Team Yoast – 4.5
    Easy WP SMTP: por Easy WP SMTP – 2.3.0
    Elementor: por Elementor.com – 3.21.8
    Email Template Customizer for WooCommerce: por VillaTheme – 1.2.5
    Flow Payment: por Flow – 3.0.5
    Formidable Forms: por Strategy11 Form Builder Team – 6.9.1
    XML Sitemap Generator for Google: por Auctollo – 4.1.19
    Jetpack Boost: por Automattic - Equipo de Jetpack Site Speed – 3.3.1
    Jetpack: por Automattic – 13.4.3
    Kirki Customizer Framework: por Themeum – 5.1.0
    HubSpot All-In-One Marketing - Forms, Popups, Live Chat: por HubSpot – 11.1.13
    Loco Translate: por Tim Whitlock – 2.6.9
    MC4WP: Mailchimp for WordPress: por ibericode – 4.9.13
    One Click Demo Import: por OCDI – 3.2.1
    Security Optimizer: por SiteGround – 1.5.0
    Themify - WooCommerce Product Filter: por Themify – 1.4.8
    NextMove Lite - Thank You Page for WooCommerce: por XLPlugins – 2.18.3
    Mercado Pago: por Mercado Pago – 7.5.0
    PDF Invoices & Packing Slips for WooCommerce: por WP Overnight – 3.8.2
    WooCommerce: por Automattic – 8.8.3 (la actualización a la versión 8.9.1 está disponible)
    WP Mail Logging: por WP Mail Logging Team – 1.12.0
    WP Rollback: por WP Rollback – 2.0.7
    WP Super Cache: por Automattic – 1.12.1 Inactive Plugins (3)
    
    FiboSearch - AJAX Search for WooCommerce: por FiboSearch Team – 1.28.0
    PKT1 Centro de Envíos: por PKT1 WebCenter – 1.2.1
    Site Kit by Google: por Google – 1.127.0 Dropin Plugins ()
    
    advanced-cache.php: advanced-cache.php Settings
    
    API Enabled: –
    Force SSL: –
    Currency: CLP ($)
    Currency Position: left
    Thousand Separator: .
    Decimal Separator: ,
    Number of Decimals: 0
    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: WC_Order_Data_Store_CPT
    HPOS data sync enabled: – Logging
    
    Enabled: ?
    Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
    Retention period: 30 días
    Level threshold: –
    Log directory size: 113 KB WC Pages
    
    Base de la tienda: #7 - /tienda/
    Carrito: #8 - /carrito/
    Finalizar compra: #9 - /checkout/
    Mi cuenta: #10 - /mi-cuenta/
    Términos y condiciones: ? Página sin definir Theme
    
    Name: Shoptimizer
    Version: 2.7.6
    Author URL: https://www.commercegurus.com/
    Child Theme: ? – Si estás modificando WooCommerce en un tema principal que no has creado personalmente
    te recomendamos utilizar un subtema. Ver: Cómo crear un subtema
    
    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-29 13:12:25 -04:00
    Options: ?
    Notes: 132
    Onboarding: completed Action Scheduler
    
    Completar: 217
    Oldest: 2024-04-27 21:09:28 +0000
    Newest: 2024-05-28 14:46:37 +0000
    
    Fallida: 2,563
    Oldest: 2023-04-05 20:10:07 +0000
    Newest: 2023-12-26 07:05:24 +0000
    
    Pendiente: 4
    Oldest: 2024-05-28 21:48:45 +0000
    Newest: 2024-06-03 21:48:46 +0000 Status report information
    
    Generated at: 2024-05-28 11:09:58 -04:00
    `
    Plugin Support omarfpg a11n

    (@omarfpg)

    Hi Christian, this is a known bug with WooCommerce at the moment, it’s being looked on by our developers and it should be fixed very soon (you can find more details here: https://github.com/woocommerce/woocommerce/pull/46857).

    In the meantime, please try saving your free shipping settings as 30000 (without any thousands or decimal point or comma). The current workaround is to save the free shipping condition like that.

    Please let us know how it goes!
    -OP

    • This reply was modified 9 months, 1 week ago by omarfpg a11n.
    Thread Starter christianshb

    (@christianshb)

    Hi Omar,
    Thanks for the prompt response.

    Yes, that’s what I thought initially, that this wasn’t an issue solely affecting our store.
    I tried the workaround you suggested however, after saving the 30000 value as the free shipping threshold, when I review the changes, the system has automatically updated it to 30.000 (thirty thousand chilean pesos) due to the settings we’ve set on the store’s thousands and decimals separators settings.

    My guess is that, for the ‘free shipping’ function, the store is interpreting the dot (.) as a decimal separator and not as the thousands separator.

    How long do you think it will take for the WooCommerce Developer Team to fix this issue?

    Thanks
    Christian

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello christianshb

    Thank you for your reply.

    The good news is that a fix for this issue has been added to the Woo code.
    Hopefully, this fix will be released in the next WooCommerce plugin release.
    I do not have an exact date or time for the update release.

    I hope this helps. ??

    Best regards.

    Thread Starter christianshb

    (@christianshb)

    Thanks for your response Zubair.
    I look forward to the upgraded WooCommerce plugin release.

    You may mark this ticket as resolved then.

    Cheers,
    Christian

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Free Shipping Not Working (Thousands & Decimals Issue)’ is closed to new replies.