Incorrect work Calculation Method “Sum”

  • Resolved thermal

    (@thermal)


    5 years, 8 months ago

    Hi, I set up this wonderful plugin.
    And it works well, but I did not cope with the latest order.
    Before that, there were up to 10 orders in the basket and the amount of delivery from the weight he shielded correctly. But the last order was for 13 items in the basket and the plugin was unable to calculate the amount, and set the minimum shipping value.

    ### WordPress Environment ###

Home URL: https://inspirationcraftsua.com
Site URL: https://inspirationcraftsua.com
WC Version: 3.5.6
Log Directory Writable: ?
WP Version: 5.1.1
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.0.33 - We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
PHP Post Max Size: 2 GB
PHP Time Limit: 0
PHP Max Input Vars: 1000
cURL Version: 7.62.0
OpenSSL/1.0.2k

SUHOSIN Installed: –
MySQL Version: 5.7.25-cll-lve
Max Upload Size: 2 GB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.5.6
WC Database Prefix: wqgzu_
MaxMind GeoIP Database: ?
Total Database Size: 106.88MB
Database Data Size: 92.75MB
Database Index Size: 14.13MB
wqgzu_woocommerce_sessions: Data: 22.05MB + Index: 0.27MB
wqgzu_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB
wqgzu_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB
wqgzu_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB
wqgzu_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB
wqgzu_woocommerce_order_itemmeta: Data: 0.06MB + Index: 0.03MB
wqgzu_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB
wqgzu_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB
wqgzu_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB
wqgzu_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB
wqgzu_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB
wqgzu_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB
wqgzu_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
wqgzu_woocommerce_log: Data: 0.02MB + Index: 0.02MB
wqgzu_aiowps_events: Data: 1.25MB + Index: 0.15MB
wqgzu_aiowps_failed_logins: Data: 0.00MB + Index: 0.00MB
wqgzu_aiowps_global_meta: Data: 0.00MB + Index: 0.00MB
wqgzu_aiowps_login_activity: Data: 0.00MB + Index: 0.00MB
wqgzu_aiowps_login_lockdown: Data: 0.00MB + Index: 0.00MB
wqgzu_aiowps_permanent_block: Data: 0.00MB + Index: 0.00MB
wqgzu_aws_cache: Data: 0.66MB + Index: 0.00MB
wqgzu_aws_index: Data: 14.71MB + Index: 0.00MB
wqgzu_commentmeta: Data: 0.02MB + Index: 0.03MB
wqgzu_comments: Data: 0.02MB + Index: 0.09MB
wqgzu_failed_jobs: Data: 0.00MB + Index: 0.00MB
wqgzu_links: Data: 0.02MB + Index: 0.02MB
wqgzu_mailchimp_carts: Data: 0.02MB + Index: 0.00MB
wqgzu_mclean_refs: Data: 0.17MB + Index: 0.08MB
wqgzu_mclean_scan: Data: 0.00MB + Index: 0.00MB
wqgzu_mediafromftp_log: Data: 0.00MB + Index: 0.00MB
wqgzu_mgmlp_folders: Data: 0.00MB + Index: 0.00MB
wqgzu_options: Data: 4.20MB + Index: 0.16MB
wqgzu_pmxe_exports: Data: 0.06MB + Index: 0.00MB
wqgzu_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB
wqgzu_pmxe_posts: Data: 0.02MB + Index: 0.00MB
wqgzu_pmxe_templates: Data: 0.02MB + Index: 0.00MB
wqgzu_pmxi_files: Data: 0.02MB + Index: 0.00MB
wqgzu_pmxi_history: Data: 0.02MB + Index: 0.00MB
wqgzu_pmxi_images: Data: 0.23MB + Index: 0.00MB
wqgzu_pmxi_imports: Data: 0.33MB + Index: 0.00MB
wqgzu_pmxi_posts: Data: 0.38MB + Index: 0.17MB
wqgzu_pmxi_templates: Data: 0.31MB + Index: 0.00MB
wqgzu_postmeta: Data: 25.52MB + Index: 7.95MB
wqgzu_posts: Data: 17.50MB + Index: 3.13MB
wqgzu_queue: Data: 0.13MB + Index: 0.01MB
wqgzu_shipment_batch_process: Data: 0.00MB + Index: 0.00MB
wqgzu_termmeta: Data: 0.08MB + Index: 0.09MB
wqgzu_terms: Data: 0.08MB + Index: 0.09MB
wqgzu_term_relationships: Data: 1.33MB + Index: 1.23MB
wqgzu_term_taxonomy: Data: 0.08MB + Index: 0.11MB
wqgzu_usermeta: Data: 0.08MB + Index: 0.03MB
wqgzu_users: Data: 0.02MB + Index: 0.05MB
wqgzu_vtprd_purchase_log: Data: 0.00MB + Index: 0.00MB
wqgzu_vtprd_purchase_log_product: Data: 0.00MB + Index: 0.00MB
wqgzu_vtprd_purchase_log_product_rule: Data: 0.00MB + Index: 0.00MB
wqgzu_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB
wqgzu_wc_download_log: Data: 0.02MB + Index: 0.03MB
wqgzu_wc_webhooks: Data: 0.02MB + Index: 0.02MB
wqgzu_wdp_orders: Data: 0.00MB + Index: 0.00MB
wqgzu_wdp_order_items: Data: 0.00MB + Index: 0.01MB
wqgzu_wdp_rules: Data: 0.00MB + Index: 0.00MB
wqgzu_woobe_history: Data: 0.05MB + Index: 0.03MB
wqgzu_woobe_history_bulk: Data: 0.00MB + Index: 0.00MB
wqgzu_woo_shippment_provider: Data: 0.01MB + Index: 0.00MB
wqgzu_wpmfs_queue: Data: 0.02MB + Index: 0.02MB
wqgzu_yoast_seo_links: Data: 0.09MB + Index: 0.02MB
wqgzu_yoast_seo_meta: Data: 2.50MB + Index: 0.00MB

### Post Type Counts ###

attachment: 5430
custom_css: 2
customize_changeset: 31
elementor_library: 2
is_search_form: 1
mgmlp_media_folder: 13
nav_menu_item: 41
o-discount: 1
o-list: 1
page: 15
post: 2
product: 1999
product_variation: 105
revision: 4783
shop_coupon: 3
shop_order: 6
wc_category_slider: 1
wcps: 3
wpcf7_contact_form: 2

### Security ###

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

### Active Plugins (29) ###

Advanced Dynamic Pricing for WooCommerce: by AlgolPlus – 1.6.0
Advanced Woo Search: by ILLID – 1.65
Akismet Anti-Spam: by Automattic – 4.1.1
All In One WP Security: by Tips and Tricks HQ
Peter Petreski
Ruhul
Ivy – 4.3.8.3

Astra Starter Sites: by Brainstorm Force – 1.2.12
Contact Form 7: by Takayuki Miyoshi – 5.1.1
Cookie Notice: by dFactory – 1.2.46
Elementor Addons & Templates - Sizzify Lite: by ThemeIsle – 1.3.0
Elementor: by Elementor.com – 2.4.5
Flexible Shipping: by WP Desk – 3.2.0
GA Google Analytics: by Jeff Starr – 20190220
Google XML Sitemaps: by Arne Brachhold – 4.1.0
Hello Dolly: by Matt Mullenweg – 1.6
Easy HTTPS (SSL) Redirection: by Tips and Tricks HQ – 1.9
Mailchimp for WooCommerce: by Mailchimp – 2.1.14 – Not tested with the active version of WooCommerce
Saphali Woocommerce Russian: by Saphali – 1.8.5
Shortcode in Menus: by Gagan Deep Singh – 3.5
Social Icons Widget by WPZOOM: by WPZOOM – 3.0.13
WooCommerce Advanced Shipment Tracking: by zorem – 1.8.9 – Not tested with the active version of WooCommerce
WooCommerce Google Analytics Integration: by WooCommerce – 1.4.8
WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 2.2.9
Woocommerce Products Slider: by PickPlugins – 1.12.21 – Not tested with the active version of WooCommerce
WP All Import - WooCommerce Add-On: by Soflyy – 1.3.9 – Not tested with the active version of WooCommerce
WooCommerce: by Automattic – 3.5.6
Yoast SEO: by Team Yoast – 10.0
WP All Export: by Soflyy – 1.2.3
WP All Import: by Soflyy – 3.4.9
WP Fastest Cache: by Emre Vona – 0.8.9.1
WP Translitera: by Evgen Yurchenko – p1.2.5

### Settings ###

API Enabled: ?
Force SSL: –
Currency: USD ($)
Currency Position: right_space
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)

### WC Pages ###

Shop base: #38 - /store/
Cart: #39 - /cart/
Checkout: #40 - /checkout/
My account: #41 - /my-account/
Terms and conditions: #1277 - /terms-of-use/

### Theme ###

Name: Astra
Version: 1.6.9 – 1.7.2 is available
Author URL: https://wpastra.com/about/
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: astra/woocommerce/emails/customer-completed-order.php
Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author Piotr Jablonowski

    (@jablonowski)

    Hi,

    if possible, send a screenshot of the shipping method settings and what products were in the checkout (shipping classes and weights).

    Thread Starter thermal

    (@thermal)

    I left the links to the screenshots of the shipping method settings and one product that was in the checkout (shipping classes and weights). All other products with the same settings.

    [url=https://ibb.co/DC0FTLt][img]https://i.ibb.co/QNyVtXf/Screenshot-13.png[/img][/url]
    [url=https://ibb.co/sQfVWRL][img]https://i.ibb.co/ftgxDFm/Screenshot-14.png[/img][/url]
    [url=https://ibb.co/PZ7d2qp][img]https://i.ibb.co/JRf9YDL/Screenshot-15.png[/img][/url]
    [url=https://ru.imgbb.com/]upload images[/url]

    Plugin Author Piotr Jablonowski

    (@jablonowski)

    It seems to me that it will only be a matter of setting the rules for this particular situation.

    Can you check the weight for these 13 items from the order you are writing about?

    Thread Starter thermal

    (@thermal)

    Yes, I checked the weight of all the goods. Values are accurate. I can leave you a link to the site, if you have time, you can use the shopping basket yourself with the goods. I attach screenshots where I indicated the weight of the goods and how the shipping cost changed.
    My site https://inspirationcraftsua.com/store/
    scren1
    scren2

    • This reply was modified 5 years, 8 months ago by thermal.
    Plugin Author Piotr Jablonowski

    (@jablonowski)

    Now I see ?? There is probably a problem with rounding, we have to check it yet. Please write what PHP version you have on your server?

    If you correct the rules, they should work as you expect. You hit with the sum of the weight of the empty spaces between the rules. So instead of 2.05 set 2 etc. It should look like this https://wpdesk.me/pj/uqb70.png

    Thread Starter thermal

    (@thermal)

    PHP version on server 7.2
    If you set instead of 0,51 to 0,5, then when you set a total weight of 0.5 kg, the rule of summing the second and third order works, and it should not be so.

    Screen

    Plugin Author Piotr Jablonowski

    (@jablonowski)

    We’re working on fix. If you can wait, let’s leave it at this stage.

    Plugin Author Piotr Jablonowski

    (@jablonowski)

    Hi,

    thank you for your patience. The problem is the rounding method in PHP and in most cases, summing working properly. To implement the solution, we must test many dependencies to “not break” 20k stores that use Flexible Shipping ?? When the update will be ready I will let you know.

    I have a solution for your scenario at the moment. I tested them on all weight ranges that you gave and work correctly. You need to add the following code to the functions.php file in the store theme (preferably a child):

    add_filter( 'woocommerce_cart_contents_weight', 'round_cart_contents_weight' );
function round_cart_contents_weight( $weight ) {
  return ceil( round( $weight *100 ) ) / 100;
}
    Plugin Author Piotr Jablonowski

    (@jablonowski)

    Hi @thermal,

    the upgrade to version 3.3.2 is now available. We have implemented a solution that solves the problem of rounding.

    Thread Starter thermal

    (@thermal)

    Thank you so much, you are just super! You have a great plugin and great tech support!

    Plugin Author Piotr Jablonowski

    (@jablonowski)

    Thank you for appreciating. This motivates us to do this even better!

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Incorrect work Calculation Method “Sum”’ is closed to new replies.