Webhook verification fails, increasing daily, random

  • Resolved neikoloves

    (@neikoloves)


    2 years, 7 months ago

    Hello Guys, the Webhook verification failed message in the logs has been increasing daily since going live from just a few days ago, not even a week live.

    With this, we are also not seeing the line item details in some cases at PayPal, but in all cases we are showing the correct amount, so that part is working well.

    Also when you use PayPal direct and capture the Payment on the PayPal site, this doesn’t push back to our site, is this by design? So we still see the Payment as not being captured in the Order Admin of our site, yet is was captured at the merchant account on PayPal.

    When we test the cart and have a failure, the transaction is not saved, thus we have no idea how many fails happened before a success took place, other than using a lost cart software, which we do have in place.

    Does the plug-in support PayPal Pro by chance, if we wanted to use that in place of using PayPal in this manner, that does seem to support failed card transactions until they succeed?

    We reset the web-hooks and even disconnected / reconnected the account API from the beginning to help solve this, yet the problem persists and it’s random throughout the day.

    Can you kindly advise on this? Thank you and best regards.

    • This topic was modified 2 years, 7 months ago by neikoloves.
Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support Syde Niklas

    (@niklasinpsyde)

    Hi @neikoloves,

    Security plugins could potentially block the webhooks, but it’s difficult to tell.
    There also shouldn’t be a direct relation between the webhooks and the order lines. As an example, when there is a subtotal mismatch, the plugin may drop the lines to prevent an API error (which would reject the payment entirely).
    For the moment, PayPal Payments only creates the WooCommerce order after a capture call has been attempted, which includes payments rejected by PayPal.

    To better judge what’s causing this behavior, we are interested in a copy of your WooCommerce system report and your latest PayPal Payments log files.
    You can share it either here in the forums, or better, privately with us from here:
    https://paypal.inpsyde.com/docs/request-support/
    Please include a link to this thread when you send us a private message.
    Thanks!

    PayPal Pro is not supported with this integration. The PayPal Card Processing is a separate gateway exclusively for card payments and the successor to the hosted PayPal Pro checkout. The new integration provides similar functionality with fully customizable hosted fields and more.

    And regarding the order status not updating, when you capture/void/refund a payment at PayPal, the WooCommerce should update. it may be related to the other webook issue but there are some similar reports about these webhooks not being receivede, so this will be investigated deeper in any case.

    Kind regards,
    Niklas

    Thread Starter neikoloves

    (@neikoloves)

    Hello @niklasinpsyde, we have zero security setup at this time, to avoid any type of conflict, however we can’t allow this for long.

    We will need to really redact the log file for your investigations from just today, it’s 2300+ lines, what do you need? I can’t even post one instance here without replacing everything with XXXX. There is way to much sensitive data or can I just redact those data points as shown below and you will have what you need?

    Environment

    
### WordPress Environment ###

WordPress address (URL): https://www.testdomain.com
Site address (URL): https://www.testdomain.com
WC Version: 6.4.1
REST API Version: ? 6.4.1
WC Blocks Version: ? 7.2.2
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 3.3.2
Log Directory Writable: ?
WP Version: 5.9.3
WP Multisite: –
WP Memory Limit: 2 GB
WP Debug Mode: –
WP Cron: ?
Language: en_US

### Server Environment ###

Server Info: Apache/2.4.25 (Debian)
PHP Version: 7.4.28
PHP Post Max Size: 256 MB
PHP Time Limit: 899
PHP Max Input Vars: 12500
cURL Version: 7.52.1
OpenSSL/1.0.2u

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.4.20-MariaDB-1:10.4.20+maria~stretch-log
Max Upload Size: 256 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.4.1
WC Database Prefix: wp_
Total Database Size: 127.93MB
Database Data Size: 84.57MB
Database Index Size: 43.36MB
wp_woocommerce_sessions: Data: 7.02MB + Index: 0.13MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.36MB + Index: 0.31MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 2.52MB + Index: 1.59MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 2.52MB + Index: 0.92MB + Engine InnoDB
wp_ac_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_admin_columns: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.11MB + Index: 0.09MB + Engine InnoDB
wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_frm_fields: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_frm_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_frm_items: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_frm_item_metas: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_options: Data: 8.06MB + Index: 0.33MB + Engine InnoDB
wp_postmeta: Data: 4.52MB + Index: 3.03MB + Engine InnoDB
wp_posts: Data: 2.52MB + Index: 0.42MB + Engine InnoDB
wp_product_brandmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_product_catmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_sm_views: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_taxjar_record_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_termmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.11MB + Index: 0.06MB + Engine InnoDB
wp_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ucp_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_usermeta: Data: 30.56MB + Index: 25.06MB + Engine InnoDB
wp_users: Data: 2.52MB + Index: 1.39MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.13MB + Index: 0.27MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_shipping_table_rates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 616
ctct_lists: 93
customize_changeset: 2
nav_menu_item: 68
page: 26
post: 3
product: 636
product_variation: 394
revision: 4
shop_coupon: 9
shop_order: 123
shop_order_refund: 1
wc_order_status: 7
mytheme_template: 10
woocg-post: 1
wp_global_styles: 1

### Security ###

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

### Active Plugins (48) ###

Classic Editor: by WordPress Contributors – 1.6.2
Classic Widgets: by WordPress Contributors – 0.3
Kirki Customizer Framework: by David Vongries – 4.0.23
LiveChat WooCommerce: by LiveChat – 2.2.4
TaxJar - Sales Tax Automation for WooCommerce: by TaxJar – 4.1.2
Mytheme Core: by Redacted – 2.1.9
WooCommerce Table Rate Shipping: by WooCommerce – 3.0.37
WooCommerce PayPal Payments: by WooCommerce – 1.7.1
WooCommerce: by Automattic – 6.4.1
LiveChat: by LiveChat – 4.5.5

### Must Use Plugins (1) ###

Health Check Troubleshooting Mode: by  – 1.7.2

### 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: #11408 - /shipping-policy/

### Theme ###

Name: mytheme_theme
Version: X.X
Author URL: https://redacted.org/about-me/
Child Theme: ?
Parent Theme Name: Redacted
Parent Theme Version: X.X.X
Parent Theme Author URL: https://redacted.com/
WooCommerce Support: ?

### Templates ###

Overrides: redacted/framework/templates/woocommerce/archive-product.php
redacted/framework/templates/woocommerce/cart/cart-empty.php
redacted/framework/templates/woocommerce/cart/cart-shipping.php
redacted/framework/templates/woocommerce/cart/cart-totals.php
redacted/framework/templates/woocommerce/cart/cart.php
redacted/framework/templates/woocommerce/cart/cross-sells.php
redacted/framework/templates/woocommerce/cart/mini-cart.php
redacted/framework/templates/woocommerce/cart/proceed-to-checkout-button.php
redacted/framework/templates/woocommerce/cart/shipping-calculator.php
redacted/framework/templates/woocommerce/checkout/form-billing.php
redacted/framework/templates/woocommerce/checkout/form-checkout.php
redacted/framework/templates/woocommerce/checkout/form-coupon.php
redacted/framework/templates/woocommerce/checkout/form-login.php
redacted/framework/templates/woocommerce/checkout/form-pay.php
redacted/framework/templates/woocommerce/checkout/form-shipping.php
redacted/framework/templates/woocommerce/checkout/payment.php
redacted/framework/templates/woocommerce/checkout/terms.php
redacted/framework/templates/woocommerce/checkout/thankyou.php
redacted/framework/templates/woocommerce/content-product-cat.php
redacted/framework/templates/woocommerce/content-product.php
redacted/framework/templates/woocommerce/content-single-product.php
redacted/framework/templates/woocommerce/content-widget-product.php
redacted/framework/templates/woocommerce/global/form-login.php
redacted/framework/templates/woocommerce/global/quantity-input.php
redacted/framework/templates/woocommerce/global/wrapper-end.php
redacted/framework/templates/woocommerce/global/wrapper-start.php
redacted/framework/templates/woocommerce/loop/add-to-cart.php
redacted/framework/templates/woocommerce/loop/loop-end.php
redacted/framework/templates/woocommerce/loop/loop-start.php
redacted/framework/templates/woocommerce/loop/no-products-found.php
redacted/framework/templates/woocommerce/loop/orderby.php
redacted/framework/templates/woocommerce/loop/pagination.php
redacted/framework/templates/woocommerce/loop/price.php
redacted/framework/templates/woocommerce/loop/rating.php
redacted/framework/templates/woocommerce/loop/result-count.php
redacted/framework/templates/woocommerce/loop/sale-flash.php
redacted/framework/templates/woocommerce/myaccount/dashboard.php
redacted/framework/templates/woocommerce/myaccount/downloads.php
redacted/framework/templates/woocommerce/myaccount/form-edit-account.php
redacted/framework/templates/woocommerce/myaccount/form-edit-address.php
redacted/framework/templates/woocommerce/myaccount/form-login.php
redacted/framework/templates/woocommerce/myaccount/my-account.php
redacted/framework/templates/woocommerce/myaccount/my-address.php
redacted/framework/templates/woocommerce/myaccount/navigation.php
redacted/framework/templates/woocommerce/myaccount/orders.php
redacted/framework/templates/woocommerce/notices/error.php
redacted/framework/templates/woocommerce/notices/notice.php
redacted/framework/templates/woocommerce/notices/success.php
redacted/framework/templates/woocommerce/order/order-details-customer.php
redacted/framework/templates/woocommerce/order/order-downloads.php
redacted/framework/templates/woocommerce/single-product/add-to-cart/variable.php
redacted/framework/templates/woocommerce/single-product/meta.php
redacted/framework/templates/woocommerce/single-product/product-image.php
redacted/framework/templates/woocommerce/single-product/product-thumbnails.php
redacted/framework/templates/woocommerce/single-product/rating.php
redacted/framework/templates/woocommerce/single-product/related.php
redacted/framework/templates/woocommerce/single-product/review-meta.php
redacted/framework/templates/woocommerce/single-product/sale-flash.php
redacted/framework/templates/woocommerce/single-product/share.php
redacted/framework/templates/woocommerce/single-product/short-description.php
redacted/framework/templates/woocommerce/single-product/tabs/additional-information.php
redacted/framework/templates/woocommerce/single-product/tabs/description.php
redacted/framework/templates/woocommerce/single-product/tabs/tabs.php
redacted/framework/templates/woocommerce/single-product/title.php
redacted/framework/templates/woocommerce/single-product/up-sells.php
redacted/framework/templates/woocommerce/single-product-reviews.php
redacted/framework/templates/woocommerce/single-product.php

### 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: 7,923
Oldest: 2022-04-09 00:19:06 -0400
Newest: 2022-04-29 16:02:06 -0400

Pending: 3
Oldest: 2022-04-29 16:17:58 -0400
Newest: 2022-05-06 00:26:12 -0400

Canceled: 1
Oldest: 2022-04-06 19:10:08 -0400
Newest: 2022-04-06 19:10:08 -0400

### Status report information ###

Generated at: 2022-04-29 16:17:05 -04:00

    Redacted Example of 1 Instance.

    2022-04-29T00:39:28+00:00 ERROR Webhook verification failed.
2022-04-29T00:39:28+00:00 DEBUG POST https://api.paypal.com/v1/notifications/verify-webhook-signature
Request Body: {"transmission_id":"XXXX","transmission_time":"2022-04-27T20:16:22Z","cert_url":"https:\/\/api.paypal.com\/v1\/notifications\/certs\/CERT-XXXX","auth_algo":"SHA256withRSA","transmission_sig":"XXXX\/XXXX\/XXXX\/XXXX\/XXXX\/XXXX","webhook_id":"XXXX","webhook_event":{"id":"WH-XXXX","event_version":"1.0","create_time":"2022-04-27T20:16:19.004Z","resource_type":"capture","resource_version":"2.0","event_type":"PAYMENT.CAPTURE.COMPLETED","summary":"Payment completed for $ XXXX USD","resource":{"id":"XXXX","amount":{"currency_code":"USD","value":"XXXX"},"final_capture":true,"seller_protection":{"status":"ELIGIBLE","dispute_categories":["ITEM_NOT_RECEIVED","UNAUTHORIZED_TRANSACTION"]},"disbursement_mode":"INSTANT","seller_receivable_breakdown":{"gross_amount":{"currency_code":"USD","value":"XXXX"},"paypal_fee":{"currency_code":"USD","value":"XXXX"},"net_amount":{"currency_code":"USD","value":"XXXX"}},"invoice_id":"XXXX","custom_id":"XXXX","status":"COMPLETED","supplementary_data":{"related_ids":{"order_id":"XXXX","authorization_id":"XXXX"}},"create_time":"2022-04-27T20:16:14Z","update_time":"2022-04-27T20:16:14Z","links":[{"href":"https:\/\/api.paypal.com\/v2\/payments\/captures\/XXXX","rel":"self","method":"GET"},{"href":"https:\/\/api.paypal.com\/v2\/payments\/captures\/XXXX\/refund","rel":"refund","method":"POST"},{"href":"https:\/\/api.paypal.com\/v2\/payments\/authorizations\/XXXX","rel":"up","method":"GET"}]},"links":[{"href":"https:\/\/api.paypal.com\/v1\/notifications\/webhooks-events\/WH-XXXX","rel":"self","method":"GET"},{"href":"https:\/\/api.paypal.com\/v1\/notifications\/webhooks-events\/WH-XXXX\/resend","rel":"resend","method":"POST"}]}}
Response Debug ID: XXXX
Response: Array
(
    [code] => 200
    [message] => OK
)

    The plugin is very clean and I know allot of work went into it's creation, but we will be forced to use something else if we can't solve these issues very fast as it's really a problem for us for daily operations.

    It's odd that is works sometimes and other times not, yet we did remove the API account / Hooks / Tested and then even started over just to make sure we had a clean slate as I know setup can bee an issue in some cases.

    Let me know you thoughts and thanks so much for your support on this...

    • This reply was modified 2 years, 7 months ago by neikoloves.
    • This reply was modified 2 years, 7 months ago by neikoloves.
    Thread Starter neikoloves

    (@neikoloves)

    Hello Guys, new redacted errors below, but this is out of 50+ orders today…

    2022-05-02T14:16:32+00:00 ERROR Client ID retrieval failed: Could not validate nonce.
2022-05-02T14:29:02+00:00 DEBUG GET https://api.paypal.com/v2/vault/payment-tokens/?customer_id=XXXX
Response Debug ID: XXXX
Response: Array
(
    [code] => 200
    [message] => OK
)

2022-05-02T21:43:58+00:00 ERROR Client ID retrieval failed: Could not validate nonce.
2022-05-02T22:54:03+00:00 DEBUG POST https://api.paypal.com/v1/oauth2/token?grant_type=client_credentials
Response Debug ID: XXXX
Response: Array
(
    [code] => 200
    [message] => OK
)
    Thread Starter neikoloves

    (@neikoloves)

    Just to note 1.8.0 is 100 times worse, all transactions are showing failed errors now. Why is this plugin so unstable, I reverted to 1.7.1? Please advise ASAP. Thank you.

    Thread Starter neikoloves

    (@neikoloves)

    Hello, can you please respond to this? This is the only API that has this issue on our site.

    Plugin Support Syde Niklas

    (@niklasinpsyde)

    Hi @neikoloves,

    We regret the trouble and apologies for getting back just now.
    Our developers have been looking into these errors but we can’t reproduce the behavior and must assume a potential conflict with a different plugin.
    Version 1.8.0 also did not modify any behavior that would appear relevant to these messages and we are not seeing too many other reports of this kind.
    Do you have access to a staging site where you could disable all other plugins and test it in the minimum configuration?

    Could you please share a copy of your complete system report and log files with us privately with us from here?: ttps://paypal.inpsyde.com/docs/request-support/
    Please include a link to this thread.
    Thanks!

    Kind regards,
    Niklas

    Plugin Support Syde Joost

    (@joostvandevijver)

    Since we haven’t heard back from you, I’m going to mark it as resolved.
    In case you’re still having problems, feel free to let us know!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Webhook verification fails, increasing daily, random’ is closed to new replies.