• Resolved mcmwebsol

    (@mcmwebsol)


    We’re getting this error when using a discount:
    [category] => INVALID_REQUEST_ERROR
    [code] => INVALID_VALUE
    [detail] => The charge amount does not match the order total.
    [field] => amount_money.amount

    It appears that due to rounding the total sent to Square is one cent off (16297 vs 16298). Is there any fix for this? The relevant portion of the log is below
    "total_money": {
    "amount": 16298,
    "currency": "USD"
    },
    "total_tax_money": {
    "amount": 1448,
    "currency": "USD"
    },
    "total_discount_money": {
    "amount": 1650,
    "currency": "USD"
    }

    body: {
    "idempotency_key": "1324",
    "amount_money": {
    "amount": 16297,
    "currency": "USD"
    },

    Below is the WooCommerce Status Report

    
    ### WordPress Environment ###
    
    WordPress address (URL): ***
    Site address (URL): ***
    WC Version: 3.6.5
    Log Directory Writable: ✔
    WP Version: 5.2.2
    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: 64 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 1000
    cURL Version: 7.65.3
    OpenSSL/1.0.2s
    
    SUHOSIN Installed: –
    MySQL Version: 5.6.41-84.1
    Max Upload Size: 64 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 3.6.5
    WC Database Prefix: wp_
    MaxMind GeoIP Database: ✔
    Total Database Size: 8.32MB
    Database Data Size: 7.23MB
    Database Index Size: 1.09MB
    wp_woocommerce_sessions: Data: 0.11MB + Index: 0.01MB
    wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_order_items: Data: 0.00MB + Index: 0.01MB
    wp_woocommerce_order_itemmeta: Data: 0.04MB + Index: 0.02MB
    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.00MB + Index: 0.00MB
    wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB
    wp_commentmeta: Data: 0.00MB + Index: 0.01MB
    wp_comments: Data: 0.03MB + Index: 0.02MB
    wp_easycontactforms_acl: Data: 0.01MB + Index: 0.00MB
    wp_easycontactforms_applicationsettings: Data: 0.00MB + Index: 0.01MB
    wp_easycontactforms_contacttypes: Data: 0.00MB + Index: 0.01MB
    wp_easycontactforms_customformentryfiles: Data: 0.00MB + Index: 0.00MB
    wp_easycontactforms_customformentrystatistics: Data: 0.00MB + Index: 0.00MB
    wp_easycontactforms_customformfields: Data: 0.04MB + Index: 0.01MB
    wp_easycontactforms_customformfieldtypes: Data: 0.02MB + Index: 0.01MB
    wp_easycontactforms_customforms: Data: 0.02MB + Index: 0.01MB
    wp_easycontactforms_customformsentries: Data: 0.16MB + Index: 0.02MB
    wp_easycontactforms_customforms_mailinglists: Data: 0.00MB + Index: 0.00MB
    wp_easycontactforms_files: Data: 0.00MB + Index: 0.00MB
    wp_easycontactforms_options: Data: 0.00MB + Index: 0.01MB
    wp_easycontactforms_roles: Data: 0.00MB + Index: 0.00MB
    wp_easycontactforms_sessions: Data: 0.00MB + Index: 0.00MB
    wp_easycontactforms_users: Data: 0.00MB + Index: 0.01MB
    wp_elfsight_instagram_feed_widgets: Data: 0.00MB + Index: 0.00MB
    wp_links: Data: 0.00MB + Index: 0.00MB
    wp_options: Data: 1.51MB + Index: 0.06MB
    wp_postmeta: Data: 0.38MB + Index: 0.17MB
    wp_posts: Data: 0.54MB + Index: 0.04MB
    wp_revslider_css: Data: 0.09MB + Index: 0.00MB
    wp_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB
    wp_revslider_navigations: Data: 0.00MB + Index: 0.00MB
    wp_revslider_sliders: Data: 0.01MB + Index: 0.00MB
    wp_revslider_slides: Data: 0.00MB + Index: 0.00MB
    wp_revslider_static_slides: Data: 0.00MB + Index: 0.00MB
    wp_termmeta: Data: 0.00MB + Index: 0.01MB
    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.00MB
    wp_usermeta: Data: 0.01MB + Index: 0.01MB
    wp_users: Data: 0.00MB + Index: 0.01MB
    wp_wc_download_log: Data: 0.00MB + Index: 0.00MB
    wp_wc_product_meta_lookup: Data: 0.00MB + Index: 0.01MB
    wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB
    wp_wfblockediplog: Data: 0.00MB + Index: 0.00MB
    wp_wfblocks7: Data: 0.00MB + Index: 0.00MB
    wp_wfconfig: Data: 1.21MB + Index: 0.01MB
    wp_wfcrawlers: Data: 0.00MB + Index: 0.00MB
    wp_wffilechanges: Data: 0.00MB + Index: 0.00MB
    wp_wffilemods: Data: 1.72MB + Index: 0.35MB
    wp_wfhits: Data: 0.17MB + Index: 0.02MB
    wp_wfhoover: Data: 0.00MB + Index: 0.00MB
    wp_wfissues: Data: 0.07MB + Index: 0.01MB
    wp_wfknownfilelist: Data: 0.91MB + Index: 0.11MB
    wp_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB
    wp_wflocs: Data: 0.00MB + Index: 0.00MB
    wp_wflogins: Data: 0.01MB + Index: 0.00MB
    wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB
    wp_wfls_settings: Data: 0.02MB + Index: 0.00MB
    wp_wfnotifications: Data: 0.00MB + Index: 0.00MB
    wp_wfpendingissues: Data: 0.00MB + Index: 0.00MB
    wp_wfreversecache: Data: 0.00MB + Index: 0.00MB
    wp_wfsnipcache: Data: 0.00MB + Index: 0.00MB
    wp_wfstatus: Data: 0.13MB + Index: 0.06MB
    wp_wftrafficrates: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_square_customers: Data: 0.00MB + Index: 0.01MB
    
    ### Post Type Counts ###
    
    attachment: 74
    mc4wp-form: 1
    nav_menu_item: 22
    page: 17
    post: 29
    product: 11
    revision: 95
    scheduled-action: 35
    shop_coupon: 3
    shop_order: 24
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (14) ###
    
    The7 Ultimate Addons for WPBakery Page Builder: by Brainstorm Force – 3.18.0
    Akismet Anti-Spam: by Automattic – 4.1.2
    Classic Editor: by WordPress Contributors – 1.5
    The7 Elements: by Dream-Theme – 2.1.2
    Elfsight Instagram Feed CC: by Elfsight – 3.6.3
    The7 WPBakery Page Builder: by Michael M - WPBakery.com – 6.0.2
    Mailchimp for WordPress: by ibericode – 4.5.3
    The7 Slider Revolution: by ThemePunch – 5.4.8.3
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 1.16.16
    
    WooCommerce PayPal Checkout Gateway: by WooCommerce – 1.6.16
    WooCommerce Square: by WooCommerce – 2.0.1
    WooCommerce: by Automattic – 3.6.5
    Wordfence Security: by Wordfence – 7.3.6
    WordPress Importer: by wordpressdotorg – 0.6.4
    
    ### Inactive Plugins (1) ###
    
    WPForms Lite: by WPForms – 1.5.3.1
    
    ### Must Use Plugins (2) ###
    
    Endurance Browser Cache: by Mike Hansen – 0.4
    Endurance Page Cache: by Mike Hansen – 1.5
    
    ### 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: ❌ Page visibility should be public
    Cart: #58 - /cart/
    Checkout: #61 - /checkout/
    My account: ❌ Page not set
    Terms and conditions: ❌ Page not set
    
    ### Theme ###
    
    Name: The7
    Version: 7.7.1.1
    Author URL: http://dream-theme.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: dt-the7/woocommerce/cart/cart.php
    dt-the7/woocommerce/cart/cross-sells.php
    dt-the7/woocommerce/checkout/form-billing.php
    dt-the7/woocommerce/checkout/form-checkout.php
    dt-the7/woocommerce/checkout/form-coupon.php
    dt-the7/woocommerce/checkout/form-login.php
    dt-the7/woocommerce/checkout/form-shipping.php
    dt-the7/woocommerce/checkout/review-order.php
    dt-the7/woocommerce/checkout/thankyou.php
    dt-the7/woocommerce/content-product.php
    dt-the7/woocommerce/content-product_cat.php
    dt-the7/woocommerce/global/breadcrumb.php
    dt-the7/woocommerce/global/form-login.php
    dt-the7/woocommerce/global/quantity-input.php
    dt-the7/woocommerce/loop/loop-end.php
    dt-the7/woocommerce/loop/loop-start.php
    dt-the7/woocommerce/loop/pagination.php
    dt-the7/woocommerce/myaccount/form-login.php
    dt-the7/woocommerce/notices/error.php
    dt-the7/woocommerce/notices/notice.php
    dt-the7/woocommerce/notices/success.php
    dt-the7/woocommerce/order/order-details-customer.php
    dt-the7/woocommerce/order/order-details.php
    dt-the7/woocommerce/single-product/meta.php
    dt-the7/woocommerce/single-product/price.php
    dt-the7/woocommerce/single-product/related.php
    dt-the7/woocommerce/single-product/up-sells.php
    
    ### Square ###
    
    Environment: Production
    Tokenization Enabled: –
    Debug Mode: Save to Log
    
    ### Action Scheduler ###
    
    Complete: 31
    Oldest: 2019-07-03 22:19:37 +0000
    Newest: 2019-08-02 16:28:36 +0000
    
    Pending: 2
    Oldest: 2019-08-07 23:41:25 +0000
    Newest: 2019-08-09 16:24:42 +0000
    
    Canceled: 2
    Oldest: 2019-08-02 16:53:36 +0000
    Newest: 2019-08-08 18:30:49 +0000
    
    In-progress: 0
    Oldest: –
    Newest: –
    
    Failed: 0
    Oldest: –
    Newest: –
    
    
Viewing 7 replies - 1 through 7 (of 7 total)
  • Hi @mcmwebsol,

    Thank you for giving us this information! I see from your Status Report you have Square 2.0.1:

    WooCommerce Square: by WooCommerce – 2.0.1

    There are a lot of items currently with 2.0.1 which are affecting a great many things, so much that our developers pulled it back to work on it some more before re-releasing it. If you can, please follow these steps:

    – Disconnect from Square
    – Deactivate, then delete the 2.0.1 version
    – Install 1.0.38 from the .org repo
    – Reconnect with Square
    – Manual sync (from WC > Square or vice versa)

    After this, please do a test purchase to see if the error persists. If it does, or if it does not, please respond back and let me know!

    I had this same problem. I reverted to the old plugin, reconnected with Square, and now am getting a new error:

    “Error processing checkout. Please try again.”

    Hi @megbaatz92 ,

    We will need to know the exact error, which you can find under WooCommerce > Status > Logs. Be sure that Debugging Log is On in Square, and run a test transaction to see what the error is.

    The message “Error processing checkout. Please try again.” is a very generic one, and is not enough to go off of for a fix. Please let me know what the error is when you do the test purchase.

    Hi Mike,

    I actually went back and disconnected/reconnected Square, and it resolved the issue. Thanks!

    Glad to hear! 🙂 I will keep this open for @mcmwebsol

    Hi @mcmwebsol,

    We have not heard back from you in a while, so I am going to go ahead and close this thread. If you are still experiencing issues please open a new thread and let us know.

    Cheers!

    Just a note that this issue is still occurring in version 2.0.3. I am going to revert back to Version 1 again for a few months.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘INVALID_REQUEST_ERROR INVALID_VALUE’ is closed to new replies.