Support » Plugin: Table Rate Shipping Method for WooCommerce by Flexible Shipping » Weird calculation specific to certain products

  • Resolved love-cognac

    (@cognac-expert)


    Hi there,

    the module is fantastic and perfectly matches our current requirements. However, I faced some issue in regards to the shipping calculation.

    I have the following carrier configured:
    Calculation Method: Sum
    Based on Weight (kg)
    0-1.5 > 49.582500
    1.5-2.1 > 49.582500
    2.1-2.6 > 49.582500
    2.6-3 > 49.582500
    3-3.6 > 57.915830
    4-4.5 > 66.249920

    Now, I have a product A with 1.7kg:
    Cart: 1 x = 49,5
    Cart: 2 x = 57.9

    So far, so good. Now I change the same product to 2kg:
    Cart: 1 x = 49,5
    Cart: 2 x = 124 EUR

    Any idea why this could happen? While troubleshooting this, I had the impression/finding that odd values cause issues, while even values are working. Same in the example above.

    Our woocommerce report:

    
    ### WordPress Environment ###
    
    Home URL: https://special.cognac-expert.com
    Site URL: https://special.cognac-expert.com
    WC Version: 3.3.5
    Log Directory Writable: ✔
    WP Version: 4.9.5
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    
    ### Server Environment ###
    
    Server Info: nginx/1.10.3
    PHP Version: 5.6.33-0+deb8u1
    PHP Post Max Size: 16 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 1000
    cURL Version: 7.38.0
    OpenSSL/1.0.2l
    
    SUHOSIN Installed: –
    Max Upload Size: 16 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 3.3.5
    WC Database Prefix: wp_
    MaxMind GeoIP Database: ✔
    Total Database Size: 31.50MB
    Database Data Size: 29.14MB
    Database Index Size: 2.36MB
    wp_woocommerce_sessions: Data: 3.02MB + Index: 0.02MB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB
    wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB
    wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_order_items: Data: 0.05MB + Index: 0.03MB
    wp_woocommerce_order_itemmeta: Data: 0.35MB + Index: 0.23MB
    wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB
    wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB
    wp_a3_exclude_email_subject: Data: 0.02MB + Index: 0.00MB
    wp_ab_see: Data: 0.02MB + Index: 0.00MB
    wp_ab_see_tracking: Data: 0.11MB + Index: 0.08MB
    wp_aelia_dismissed_messages: Data: 0.02MB + Index: 0.00MB
    wp_aelia_exchange_rates_history: Data: 0.02MB + Index: 0.00MB
    wp_all_around: Data: 0.00MB + Index: 0.00MB
    wp_all_around_thmb: Data: 0.00MB + Index: 0.01MB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB
    wp_comments: Data: 0.27MB + Index: 0.12MB
    wp_dynamic_widgets: Data: 0.02MB + Index: 0.02MB
    wp_eum_logs: Data: 0.02MB + Index: 0.00MB
    wp_layerslider: Data: 0.00MB + Index: 0.00MB
    wp_links: Data: 0.00MB + Index: 0.00MB
    wp_ninja_forms: Data: 0.02MB + Index: 0.00MB
    wp_ninja_forms_fav_fields: Data: 0.05MB + Index: 0.00MB
    wp_ninja_forms_fields: Data: 0.02MB + Index: 0.00MB
    wp_ninja_forms_subs: Data: 0.02MB + Index: 0.00MB
    wp_options: Data: 2.61MB + Index: 0.11MB
    wp_pmxe_exports: Data: 0.02MB + Index: 0.00MB
    wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB
    wp_pmxe_posts: Data: 0.02MB + Index: 0.00MB
    wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB
    wp_postmeta: Data: 2.19MB + Index: 0.82MB
    wp_posts: Data: 18.76MB + Index: 0.36MB
    wp_rac_abandoncart: Data: 0.13MB + Index: 0.00MB
    wp_rac_templates_email: Data: 0.02MB + Index: 0.00MB
    wp_revslider_css: Data: 0.13MB + Index: 0.00MB
    wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB
    wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB
    wp_revslider_sliders: Data: 0.05MB + Index: 0.00MB
    wp_revslider_slides: Data: 0.06MB + Index: 0.00MB
    wp_revslider_static_slides: Data: 0.02MB + Index: 0.00MB
    wp_sm_advanced_search_temp: Data: 0.02MB + Index: 0.00MB
    wp_social_users: Data: 0.02MB + Index: 0.02MB
    wp_taxonomymeta: Data: 0.00MB + Index: 0.01MB
    wp_termmeta: Data: 0.02MB + Index: 0.03MB
    wp_terms: Data: 0.00MB + Index: 0.01MB
    wp_term_relationships: Data: 0.00MB + Index: 0.01MB
    wp_term_taxonomy: Data: 0.00MB + Index: 0.01MB
    wp_uji_counter: Data: 0.00MB + Index: 0.00MB
    wp_uji_subscriptions: Data: 0.02MB + Index: 0.00MB
    wp_upela_connector: Data: 0.02MB + Index: 0.00MB
    wp_usermeta: Data: 0.22MB + Index: 0.15MB
    wp_users: Data: 0.01MB + Index: 0.02MB
    wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB
    wp_wc_osmeta: Data: 0.02MB + Index: 0.03MB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB
    wp_woocommerce_order_status_action: Data: 0.02MB + Index: 0.00MB
    wp_xcloner_scheduler: Data: 0.02MB + Index: 0.00MB
    wp_yoast_seo_links: Data: 0.02MB + Index: 0.02MB
    wp_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB
    
    ### Post Type Counts ###
    
    attachment: 711
    blocks: 7
    custom_css: 1
    customize_changeset: 18
    encyclopedia: 1
    ml-slider: 2
    nav_menu_item: 36
    options: 13
    page: 40
    portfolio: 8
    post: 3
    product: 43
    product_variation: 32
    revision: 2295
    shop_coupon: 3
    shop_order: 229
    shop_order_refund: 15
    sidebar: 1
    vtmax-rule: 1
    wafs: 5
    wc_custom_statuses: 35
    wccaf: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (31) ###
    
    AfterShip - WooCommerce Tracking: by AfterShip – 1.8.4 – Not tested with the active version of WooCommerce
    All Around Slider: by br0 – 1.1
    Autoptimize: by Frank Goossens (futtta) – 2.3.4
    Cloudflare: by John Wineman
    Furkan Yilmaz
    Junade Ali (Cloudflare Team) – 3.3.2
    
    Easy Timer: by Kleor – 3.9
    Enable Media Replace: by ShortPixel – 3.2.5
    Encyclopedia Lite: by Dennis Hoppe – 1.7.8
    Enhanced E-commerce for Woocommerce store: by Tatvic – 2.0.0 – Not tested with the active version of WooCommerce
    Flexible Shipping: by WP Desk – 2.0.1 – Not tested with the active version of WooCommerce
    FraudLabs Pro for WooCommerce: by FraudLabs Pro – 2.10.12 – Not tested with the active version of WooCommerce
    Maintenance: by fruitfulcode – 3.6.1
    WooCommerce PDF Invoices, Packing Slips, Delivery Notes & Shipping Labels(Basic): by XAdapter – 2.3.1 – Not tested with the active version of WooCommerce
    Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.0.2
    Slider Revolution: by ThemePunch – 5.1.1
    Easy Updates Manager: by Easy Updates Manager Team – 7.0.1
    Stripe WooCommerce Addon: by Syed Nazrul Hassan – 1.0.8 – Not tested with the active version of WooCommerce
    Compress JPEG & PNG images: by TinyPNG – 2.2.6
    Upela Connector: by Hexalogic – 1.0.0 – Not tested with the active version of WooCommerce
    Aelia Foundation Classes for WooCommerce: by Aelia – 1.8.10.180315 – Not tested with the active version of WooCommerce
    WC Duplicate Order: by Jamie Gill – 1.5 – Not tested with the active version of WooCommerce
    WC Fields Factory: by Saravana Kumar K – 2.0.7 – Not tested with the active version of WooCommerce
    WooCommerce - Country Based Payments: by Ivan Paulin – 1.1.8 – Not tested with the active version of WooCommerce
    WooCommerce Email Test: by RaiserWeb – 1.10 – Not tested with the active version of WooCommerce
    WooCommerce PDF Invoice: by RightPress – 3.1.7 – Not tested with the active version of WooCommerce
    WooCommerce Price Based on Country (Basic): by Oscar Gare – 1.7.3 – Not tested with the active version of WooCommerce
    WooCommerce Quick Export Plugin: by MB Création – 2.4.2 – Not tested with the active version of WooCommerce
    WooCommerce Shipping Tracking: by Lagudi Domenico – 16.1 – Not tested with the active version of WooCommerce
    WooCommerce Order Status & Actions Manager: by Actuality Extensions – 2.3.5 – Not tested with the active version of WooCommerce
    WooCommerce: by Automattic – 3.3.5
    WP File Manager: by mndpsingh287 – 2.4
    wpMandrill: by Mandrill – 1.33
    
    ### Settings ###
    
    API Enabled: ✔
    Force SSL: ✔
    Currency: EUR (€)
    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)
    
    ### WC Pages ###
    
    Shop base: #2097 - /shop/
    Cart: #9 - /cart/
    Checkout: #10 - /checkout/
    My account: #11 - /my-account/
    Terms and conditions: #1518 - /terms-of-sale/
    
    ### Theme ###
    
    Name: Flatsome
    Version: 3.5.2
    Author URL: http://www.uxthemes.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: flatsome/woocommerce/archive-product.php
    flatsome/woocommerce/cart/cart-empty.php
    flatsome/woocommerce/cart/cart.php
    flatsome/woocommerce/checkout/form-checkout.php
    flatsome/woocommerce/checkout/form-coupon.php
    flatsome/woocommerce/checkout/thankyou.php
    flatsome/woocommerce/content-product.php
    flatsome/woocommerce/content-product_cat.php
    flatsome/woocommerce/content-single-product.php
    flatsome/woocommerce/global/breadcrumb.php
    flatsome/woocommerce/global/quantity-input.php
    flatsome/woocommerce/global/wrapper-end.php
    flatsome/woocommerce/global/wrapper-start.php
    flatsome/woocommerce/loop/loop-end.php
    flatsome/woocommerce/loop/loop-start.php
    flatsome/woocommerce/loop/pagination.php
    flatsome/woocommerce/loop/result-count.php
    flatsome/woocommerce/loop/sale-flash.php
    flatsome/woocommerce/myaccount/form-login.php
    flatsome/woocommerce/myaccount/navigation.php
    flatsome/woocommerce/notices/error.php
    flatsome/woocommerce/notices/notice.php
    flatsome/woocommerce/notices/success.php
    flatsome/woocommerce/product-searchform.php
    flatsome/woocommerce/single-product/photoswipe.php
    flatsome/woocommerce/single-product/price.php
    flatsome/woocommerce/single-product/product-image.php
    flatsome/woocommerce/single-product/product-thumbnails.php
    flatsome/woocommerce/single-product/related.php
    flatsome/woocommerce/single-product/review.php
    flatsome/woocommerce/single-product/sale-flash.php
    flatsome/woocommerce/single-product/share.php
    flatsome/woocommerce/single-product/short-description.php
    flatsome/woocommerce/single-product/tabs/tabs.php
    flatsome/woocommerce/single-product/title.php
    flatsome/woocommerce/single-product/up-sells.php
    flatsome/woocommerce/single-product-reviews.php
    flatsome/woocommerce/single-product.php
    
    ### PBC Settings ###
    
    Base location: FR
    Price Based On: shipping
    Shipping: ✔
    Test mode: –
    Test country: –
    
    ### Zone Pricing Norway ###
    
    slug: norway
    name: Norway
    countries: NO
    currency: NOK
    exchange_rate: 9.57
    
    ### Zone Pricing United States ###
    
    slug: united-states
    name: United States
    countries: US
    currency: USD
    exchange_rate: 1.20
    
    ### Zone Pricing Great Britain ###
    
    slug: great-britain
    name: Great Britain
    countries: GB
    currency: GBP
    exchange_rate: 0.88
    
    ### Zone Pricing Canada ###
    
    slug: canada
    name: Canada
    countries: CA
    currency: CAD
    exchange_rate: 1.60
    
    ### Zone Pricing EU ###
    
    slug: eu
    name: EU
    countries: AT | BE | BG | CY | CZ | DE | DK | EE | ES | FI | FR | GR | HU | IE | IT | LT | LU | LV | MT | NL | PL | PT | RO | SE | SI | SK
    currency: EUR
    exchange_rate: 1
    
    ### Zone Pricing China ###
    
    slug: china
    name: China
    countries: CN
    currency: CNY
    exchange_rate: 7.8
    
    ### Zone Pricing Hong Kong ###
    
    slug: hong-kong
    name: Hong Kong
    countries: HK
    currency: HKD
    exchange_rate: 9.77
    
    ### Zone Pricing Switzerland ###
    
    slug: switzerland
    name: Switzerland
    countries: CH
    currency: CHF
    exchange_rate: 1.17
    
    ### Zone Pricing Malaysia ###
    
    slug: malaysia
    name: Malaysia
    countries: MY
    currency: MYR
    exchange_rate: 4.84
    
    ### Zone Pricing Singapore ###
    
    slug: singapore
    name: Singapore
    countries: SG
    currency: SGD
    exchange_rate: 1.63
    
    ### Zone Pricing Russia ###
    
    slug: russia
    name: Russia
    countries: RU
    currency: RUB
    exchange_rate: 71
    

    Thanks a lot!

Viewing 6 replies - 1 through 6 (of 6 total)
  • Hello!

    It seems that the problem is related to some other plugin used in your shop. We didn’t replicate the issue.

    Have you tried to isolate the issue? Please disable all third-party plugins in your WordPress and try again. Are the calculations still wrong?

    What weight unit are you using in your shop? Is is set to kilograms?

    Thread Starter love-cognac

    (@cognac-expert)

    Hello there,

    thank you so much for your effort.

    I deactivated everything except the flexible shipping plugin and woocommerce.
    Weirdly, still calculations are wrong. This is really crazy :O. I use kg as weight unit.

    The funny thing – once I turn back from 2kg to 1.7 product weight, everything works good.

    I now also changed to the default theme, but this didn’t make any difference.

    Thanks

    Marc

    Okay, I see. Thank you for providing feedback on this.

    Are you using . in Flexible Shipping rules configuration? There should be no dots or periods but commas: ,.

    Do you enter your rules data just like in my example, using commas? https://wpde.sk/po/557b53lvk10c.png

    I see that you have Pricing zones active in your shop. Please make sure that the origin zone is the same as customer zone while testing the plugin.

    Thread Starter love-cognac

    (@cognac-expert)

    Hi there,

    again thanks for your efforts. That is what I tried:

    1) Shipping rules configuration: I only use “dots, as “commas” are not allowed.
    This is also how I enter weights for products, and I believe it’s set globally in the woocommerce “General” settings section “Currency options” (see 2b)
    2a) To test the “comma” and “dot” thing, I have removed all desimal values and tested again. But without any difference in behaviour
    2b) I have then changed the general settings regarding “Currency options”. Now all entries in Flexible shipping are configured with “comma”, as you are suggesting. The behaviour stays the same.
    3) Pricing zones: I have double checked this and tested with the zone I’m currently located. The prices and currency change accordingly, but the behaviour stays the same.

    Thanks again for your help. This deserves some support. Do you believe the premium will have the same issue?

    Thank you!

    We are unable to replicate this issue in our test shop. I guess e are slowly running out of possible causes. Please enable WP DEBUG LOG in your WordPress and access the checkout again. Are there any errors or warnings in the log file?

    Due to the lack of response, I close the thread.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Weird calculation specific to certain products’ is closed to new replies.