Weird calculation specific to certain products

  • Resolved love-cognac

    (@cognac-expert)


    6 years, 11 months ago

    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: https://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.