• Resolved oldpixelpusher

    (@oldpixelpusher)


    My client is reporting some customers get the following message when trying to purchase the linked product: ITEM_TOTAL_MISMATCH Should equal sum of unit_amount * quantity) across all items for a given purchase_unit

    I can’t replicate the issue and at times, orders for the product go through. Unfortunately, this has been a recurring issue. Other products work fine. Any ideas?

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://keepemcrawling.com
    Site address (URL): https://keepemcrawling.com
    WC Version: 6.3.1
    REST API Version: ✔ 6.3.1
    WC Blocks Version: ✔ 6.9.0
    Action Scheduler Version: ✔ 3.4.0
    WC Admin Version: ✔ 3.2.1
    Log Directory Writable: ✔
    WP Version: ❌ 5.9.2 - There is a newer version of WordPress available (5.9.3)
    WP Multisite: –
    WP Memory Limit: 128 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Flywheel/5.1.0
    PHP Version: 7.4.28
    PHP Post Max Size: 300 MB
    PHP Time Limit: 180
    PHP Max Input Vars: 8000
    cURL Version: 7.68.0
    OpenSSL/1.1.1f
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.36-google
    Max Upload Size: 300 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 6.3.1
    WC Database Prefix: wp_ezhj8x7e3z_
    Total Database Size: 120.48MB
    Database Data Size: 84.19MB
    Database Index Size: 36.29MB
    wp_ezhj8x7e3z_woocommerce_sessions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
    wp_ezhj8x7e3z_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_ezhj8x7e3z_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_ezhj8x7e3z_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_ezhj8x7e3z_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_ezhj8x7e3z_woocommerce_order_itemmeta: Data: 1.52MB + Index: 0.77MB + Engine InnoDB
    wp_ezhj8x7e3z_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_ezhj8x7e3z_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_ezhj8x7e3z_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_ezhj8x7e3z_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_ezhj8x7e3z_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_ezhj8x7e3z_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_ezhj8x7e3z_actionscheduler_actions: Data: 2.02MB + Index: 0.67MB + Engine InnoDB
    wp_ezhj8x7e3z_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_ezhj8x7e3z_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_ezhj8x7e3z_actionscheduler_logs: Data: 0.34MB + Index: 0.23MB + Engine InnoDB
    wp_ezhj8x7e3z_aws_cache: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_aws_index: Data: 5.02MB + Index: 4.11MB + Engine InnoDB
    wp_ezhj8x7e3z_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_ezhj8x7e3z_comments: Data: 1.19MB + Index: 0.38MB + Engine InnoDB
    wp_ezhj8x7e3z_enit_order_details: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_ezhj8x7e3z_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_nf3_action_meta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_nf3_chunks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_nf3_field_meta: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_nf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_nf3_object_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_nf3_upgrades: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_options: Data: 46.25MB + Index: 23.25MB + Engine InnoDB
    wp_ezhj8x7e3z_postmeta: Data: 7.48MB + Index: 2.66MB + Engine InnoDB
    wp_ezhj8x7e3z_posts: Data: 10.16MB + Index: 0.36MB + Engine InnoDB
    wp_ezhj8x7e3z_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_ezhj8x7e3z_termmeta: Data: 0.20MB + Index: 0.23MB + Engine InnoDB
    wp_ezhj8x7e3z_terms: Data: 0.28MB + Index: 0.31MB + Engine InnoDB
    wp_ezhj8x7e3z_term_relationships: Data: 0.22MB + Index: 0.16MB + Engine InnoDB
    wp_ezhj8x7e3z_term_taxonomy: Data: 0.23MB + Index: 0.23MB + Engine InnoDB
    wp_ezhj8x7e3z_usermeta: Data: 0.14MB + Index: 0.03MB + Engine InnoDB
    wp_ezhj8x7e3z_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_ezhj8x7e3z_warehouse: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_ezhj8x7e3z_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_wc_customer_lookup: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wp_ezhj8x7e3z_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_ezhj8x7e3z_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_ezhj8x7e3z_wc_order_product_lookup: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
    wp_ezhj8x7e3z_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_ezhj8x7e3z_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_ezhj8x7e3z_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_ezhj8x7e3z_wc_product_meta_lookup: Data: 0.03MB + Index: 0.09MB + Engine InnoDB
    wp_ezhj8x7e3z_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_ezhj8x7e3z_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_ezhj8x7e3z_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_ezhj8x7e3z_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_yoast_indexable: Data: 2.52MB + Index: 1.16MB + Engine InnoDB
    wp_ezhj8x7e3z_yoast_indexable_hierarchy: Data: 0.08MB + Index: 0.14MB + Engine InnoDB
    wp_ezhj8x7e3z_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_ezhj8x7e3z_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_ezhj8x7e3z_yoast_seo_links: Data: 1.45MB + Index: 0.61MB + Engine InnoDB
    wp_ezhj8x7e3z_yoast_seo_meta: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_za_categories_to_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_za_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_za_headers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_za_products_to_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_za_types: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezhj8x7e3z_za_values: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_unishippers_freight_carriers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 1181
    bc_x1379_op_type: 3
    custom_css: 2
    et_body_layout: 2
    et_footer_layout: 6
    et_header_layout: 6
    et_pb_layout: 26
    et_template: 7
    et_theme_builder: 1
    fpf_fields: 1
    nav_menu_item: 343
    nf_sub: 98
    oembed_cache: 1
    page: 42
    post: 12
    product: 263
    project: 1
    revision: 423
    shipping_package: 2
    shop_order: 392
    shop_order_refund: 15
    sp_wps_shortcodes: 1
    wc_afrsm: 1
    wc_conditional_fee: 5
    wcpcsu-custom-post: 1
    wcpcsu-custom-pro: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (23) ###
    
    Advanced Woo Search: by ILLID – 2.51
    Antispam Bee: by pluginkollektiv – 2.11.0
    Child Theme Generator: by Serafino Corriero – 2.2.7
    Classic Editor: by WordPress Contributors – 1.6.2
    Envato Market: by Envato – 2.0.7
    Flexible Shipping UPS PRO: by WP Desk – 1.13.7
    Font Awesome: by Font Awesome – 4.1.1
    Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.5.0
    Max Mega Menu - Pro Addon: by megamenu.com – 2.2.4
    Max Mega Menu: by megamenu.com – 2.9.5
    Menu Icons: by ThemeIsle – 0.12.11
    Ninja Forms: by Saturday Drive – 3.6.9
    One Click Accessibility: by One Click Accessibility – 2.0.3
    Really Simple SSL: by Really Simple Plugins – 5.3.1
    Shortcodes Ultimate: by Vladimir Anokhin – 5.12.0
    WooCommerce Extra Fees Plugin Premium: by theDotstore – 3.8.2
    WooCommerce PayPal Payments: by WooCommerce – 1.7.1
    WooCommerce Product Carousel, Slider & Grid Ultimate Pro: by Aazztech – 1.8.3
    WooCommerce Shipping & Tax: by WooCommerce – 1.25.25
    WooCommerce USPS Shipping: by WooCommerce – 4.4.70
    WooCommerce: by Automattic – 6.3.1
    Yoast SEO: by Team Yoast – 18.5.1
    Smush: by WPMU DEV – 3.9.5
    
    ### Inactive Plugins (3) ###
    
    BC Menubar Cart Icon For WooCommerce: by BinaryCarpenter.com – 1.49
    Flexible Shipping UPS: by WP Desk – 1.17.8
    WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.3
    
    ### Dropin Plugins (1) ###
    
    db-error.php: db-error.php
    
    ### 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 WooCommerce.com: ✔
    
    ### WC Pages ###
    
    Shop base: #6 - /shop/
    Cart: #7 - /cart/
    Checkout: #8 - /checkout/
    My account: #9 - /my-account/
    Terms and conditions: ❌ Page not set
    
    ### Theme ###
    
    Name: DiviChild
    Version: 1.0
    Author URL: 
    Child Theme: ✔
    Parent Theme Name: Divi
    Parent Theme Version: 4.16.0
    Parent Theme Author URL: http://www.elegantthemes.com
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: –
    
    ### WooCommerce PayPal Payments ###
    
    Onboarded: ✔
    Shop country code: US
    WooCommerce currency supported: ✔
    PayPal card processing available in country: ✔
    Pay Later messaging available in country: ✔
    Webhook status: ✔
    Vault enabled: ✔
    Logging enabled: –
    Reference Transactions: –
    Used PayPal Checkout plugin: ✔
    
    ### Action Scheduler ###
    
    Complete: 1,797
    Oldest: 2022-03-08 14:52:35 -0600
    Newest: 2022-04-06 19:50:28 -0500
    
    Pending: 2
    Oldest: 2022-04-06 20:50:28 -0500
    Newest: 2022-04-06 20:50:28 -0500
    
    ### Status report information ###
    
    Generated at: 2022-04-06 20:48:22 -05:00
    

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Mirko P.

    (@rainfallnixfig)

    Hi @oldpixelpusher,

    Did your customers provide information at what point and what steps they took before receiving that error message? It sounds like this is coming from PayPal and the two PayPal plugins I can see installed on your site are these ones:

    WooCommerce PayPal Payments: by WooCommerce – 1.7.1
    WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.3

    Make sure you enable only one of those in order to collect payments through PayPal. In case the problem recurs and there are further reports I would suggest reaching out to us on this forum:

    – WooCommerce PayPal Payments: https://ww.wp.xz.cn/support/plugin/woocommerce-paypal-payments/.

    Just so you know, this forum is specific for the WooCommerce core plugin.

    Cheers.

    Thread Starter oldpixelpusher

    (@oldpixelpusher)

    Thanks for the response Mirko. I was able to replicate the problem tonight. I only have the WooCommerce PayPal Payments plugin activated.

    More info…after billing details are provided and you click a payment method (PayPal, Venmo, or Debit or Credit Card), then the message appears. It’s only this product…unfortunately it is one of my client’s best sellers. We’ve recreated the product and that didn’t even work.

    I did find if you add another item in the cart with the troublesome item, it seems to work. The whole thing is strange. If you have any other suggestions, please let me know. I will reach out to the other recommended forum.

    Hello,

    Thanks for sharing these additional details.

    As a general recommendation, you can update the version of your WordPress, you can follow the instructions in this tutorial to do so.

    Since the issue is being handled in this forum thread: https://ww.wp.xz.cn/support/topic/item_total_mismatch-error-message-2/

    I’m going to mark this one as resolved, be sure to open a new thread if you have any other questions.

    Best.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘ITEM_TOTAL_MISMATCH error message’ is closed to new replies.