WooCommerce Webhook Executed Multiple Times

  • Resolved pablog

    (@pablogutierrez)


    11 months, 2 weeks ago

    Hi!

    Since a few days we notice that the scheduled action called woocommerce_deliver_webhook_async is being executed multiple times after each purchase (check screenshot: https://imgur.com/FqhSjax).

    This makes the inventory of the purchased products go to zero.

    We haven’t made any changes and our hosting says the issue is not on their side.

    Have you seen similar cases? Any advice?

    Thanks a lot!

    If it helps, here is the system status:

    `
### WordPress Environment ###

WC Version: 7.8.0
REST API Version: ? 7.8.0
WC Blocks Version: ? 10.2.3
Action Scheduler Version: ? 3.5.4
Log Directory Writable: ?
WP Version: 6.4.2
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?
Language: es_ES
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 8.0.30
PHP Post Max Size: 516 MB
PHP Time Limit: 60
PHP Max Input Vars: 5000
cURL Version: 8.4.0
OpenSSL/1.1.1w

SUHOSIN Installed: –
MySQL Version: 5.7.23-23
Max Upload Size: 512 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 7.8.0
WC Database Prefix: wp_
Tama?o total de la base de datos: 213.27MB
Tama?o de los datos de la base de datos: 140.70MB
Tama?o del índice de la base de datos: 72.57MB
wp_woocommerce_sessions: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_woocommerce_api_keys: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_woocommerce_attribute_taxonomies: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_woocommerce_downloadable_product_permissions: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB
wp_woocommerce_order_items: Datos: 1.52MB + índice: 0.19MB + Motor InnoDB
wp_woocommerce_order_itemmeta: Datos: 6.52MB + índice: 4.03MB + Motor InnoDB
wp_woocommerce_tax_rates: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB
wp_woocommerce_tax_rate_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_woocommerce_shipping_zones: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_woocommerce_shipping_zone_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_woocommerce_shipping_zone_methods: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_woocommerce_payment_tokens: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_woocommerce_payment_tokenmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_woocommerce_log: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_actionscheduler_actions: Datos: 25.06MB + índice: 20.50MB + Motor InnoDB
wp_actionscheduler_claims: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_actionscheduler_groups: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_actionscheduler_logs: Datos: 10.03MB + índice: 8.03MB + Motor InnoDB
wp_adtribes_my_conversions: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_aepc_custom_audiences: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
wp_aepc_logs: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
wp_cartflows_ca_cart_abandonment: Datos: 2.52MB + índice: 0.06MB + Motor InnoDB
wp_cartflows_ca_email_history: Datos: 0.13MB + índice: 0.14MB + Motor InnoDB
wp_cartflows_ca_email_templates: Datos: 0.08MB + índice: 0.00MB + Motor InnoDB
wp_cartflows_ca_email_templates_meta: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_commentmeta: Datos: 0.06MB + índice: 0.06MB + Motor InnoDB
wp_comments: Datos: 2.52MB + índice: 1.11MB + Motor InnoDB
wp_e_events: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_e_notes: Datos: 0.02MB + índice: 0.17MB + Motor InnoDB
wp_e_notes_users_relations: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_e_submissions: Datos: 1.52MB + índice: 1.02MB + Motor InnoDB
wp_e_submissions_actions_log: Datos: 0.14MB + índice: 0.36MB + Motor InnoDB
wp_e_submissions_values: Datos: 1.52MB + índice: 0.31MB + Motor InnoDB
wp_links: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_mailchimp_carts: Datos: 0.08MB + índice: 0.00MB + Motor InnoDB
wp_mailchimp_jobs: Datos: 0.05MB + índice: 0.00MB + Motor InnoDB
wp_options: Datos: 10.05MB + índice: 2.17MB + Motor InnoDB
wp_pmxi_files: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_pmxi_hash: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_pmxi_history: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_pmxi_images: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_pmxi_imports: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_pmxi_posts: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_pmxi_templates: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_postmeta: Datos: 53.55MB + índice: 27.77MB + Motor InnoDB
wp_posts: Datos: 10.50MB + índice: 3.73MB + Motor InnoDB
wp_post_smtp_logmeta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_post_smtp_logs: Datos: 9.02MB + índice: 0.00MB + Motor InnoDB
wp_pum_subscribers: Datos: 0.57MB + índice: 0.11MB + Motor MyISAM
wp_termmeta: Datos: 0.05MB + índice: 0.03MB + Motor InnoDB
wp_terms: Datos: 0.05MB + índice: 0.03MB + Motor InnoDB
wp_term_relationships: Datos: 1.39MB + índice: 0.27MB + Motor InnoDB
wp_term_taxonomy: Datos: 0.05MB + índice: 0.03MB + Motor InnoDB
wp_usermeta: Datos: 0.13MB + índice: 0.03MB + Motor InnoDB
wp_users: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
wp_wc_addi_config: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wc_addi_gateway: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wc_admin_notes: Datos: 0.06MB + índice: 0.00MB + Motor InnoDB
wp_wc_admin_note_actions: Datos: 0.08MB + índice: 0.02MB + Motor InnoDB
wp_wc_category_lookup: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wc_customer_lookup: Datos: 0.08MB + índice: 0.06MB + Motor InnoDB
wp_wc_download_log: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_wc_order_coupon_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_wc_order_product_lookup: Datos: 0.17MB + índice: 0.19MB + Motor InnoDB
wp_wc_order_stats: Datos: 0.23MB + índice: 0.19MB + Motor InnoDB
wp_wc_order_tax_lookup: Datos: 0.08MB + índice: 0.09MB + Motor InnoDB
wp_wc_product_attributes_lookup: Datos: 0.11MB + índice: 0.13MB + Motor InnoDB
wp_wc_product_download_directories: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wc_product_meta_lookup: Datos: 0.34MB + índice: 0.63MB + Motor InnoDB
wp_wc_rate_limits: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wc_reserved_stock: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wc_tax_rate_classes: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wc_webhooks: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wc_zapier_history: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_woof_query_cache: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
wp_wpvivid_options: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wpvivid_scan_result: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wpvivid_unused_uploads_files: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_yoast_indexable: Datos: 1.41MB + índice: 0.33MB + Motor InnoDB
wp_yoast_indexable_hierarchy: Datos: 0.06MB + índice: 0.05MB + Motor InnoDB
wp_yoast_migrations: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_yoast_primary_term: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_yoast_seo_links: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_yoast_seo_meta: Datos: 0.05MB + índice: 0.00MB + Motor InnoDB

### Post Type Counts ###

acf-field: 2
acf-field-group: 1
attachment: 1551
custom_css: 1
cwginstocknotifier: 558
elementor_lead: 6538
elementor_library: 13
foogallery: 1
ml-slide: 13
ml-slider: 4
nav_menu_item: 26
nimble_post_type: 1
page: 11
popup: 3
popup_theme: 8
post: 2
product: 406
product_variation: 1556
revision: 633
shop_coupon: 106
shop_order: 4757
shop_order_refund: 32
was: 54
wp_global_styles: 1
ywdpd_discount: 4

### Security ###

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

### Active Plugins (24) ###

Admin Menu Editor: por Janis Elsts – 1.11
Advanced Custom Fields: por WP Engine – 6.1.6
Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: por codewoogeek – 3.2
Buy Now Pay Later - ADDI: por Addi – 1.8.0
Maspik - Spam blacklist: por yonifre – 0.8
Departamentos y ciudades de Colombia para WooCommerce: por Saul Morales Pacheco – 2.0.8
Elementor Pro: por Elementor.com – 3.13.2
Elementor: por Elementor.com – 3.13.4
Mailchimp for WooCommerce: por Mailchimp – 2.8.3
MetaSlider: por MetaSlider – 3.31.0
PixelYourSite: por PixelYourSite – 9.3.8.1
Popup Maker: por Popup Maker – 1.18.1
Post SMTP: por Post SMTP – 2.5.9
Really Simple SSL: por Really Simple Plugins – 6.2.5
TinyPNG - JPEG, PNG & WebP image compression: por TinyPNG – 3.4.1
WooCommerce Cart Abandonment Recovery: por CartFlows Inc – 1.2.25
WooCommerce Checkout Field Editor: por WooCommerce – 1.5.39
Mercado Pago payments for WooCommerce: por Mercado Pago – 6.9.0
WooCommerce PayU Latam Payment Gateway: por PayU Latam – 2.0
HUSKY - Products Filter Professional for WooCommerce: por realmag777 – 3.3.3
WooCommerce Zapier: por OM4 Software – 2.2.1
WooCommerce: por Automattic – 7.8.0 (la actualización a la versión 8.3.1 está disponible)
Yoast SEO: por Equipo Yoast – 20.9
WPvivid Backup Plugin: por WPvivid Team – 0.9.87

### Inactive Plugins (9) ###

FOX - Currency Switcher Professional for WooCommerce: por realmag777 – 1.4.0
GTM4WP: por Thomas Geiger – 1.16.2
IP2Location Redirection: por IP2Location – 1.26.9
PayPal Currency Converter Basic for WooCommerce: por Intelligent-IT – 3.3.1 Basic
Product Feed PRO for WooCommerce: por AdTribes.io – 12.7.2
Temporary Login Without Password: por StoreApps – 1.8.2
WooCommerce Dynamic Pricing & Discounts: por RightPress – 2.4.6
WP-Sweep: por Lester 'GaMerZ' Chan – 1.1.8
YITH WooCommerce Dynamic Pricing and Discounts: por YITH – 1.4.4

### Dropin Plugins (1) ###

maintenance.php: maintenance.php

### Settings ###

API Enabled: –
Force SSL: –
Currency: COP ($)
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)

Connected to WooCommerce.com: –
Enforce Approved Product Download Directories: –
HPOS feature screen enabled: –
HPOS feature enabled: –
Order datastore: WC_Order_Data_Store_CPT
HPOS data sync enabled: –

### WC Pages ###

Base de la tienda: #41 - /tienda/
Carrito: #42 - /carrito/
Finalizar compra: #43 - /finalizar-compra/
Mi cuenta: ? La visibilidad de la página debe ser pública
Términos y condiciones: ? Página sin definir

### Theme ###

Name: Astra
Version: 4.1.5 (la actualización a la versión 4.5.1 está disponible)
Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme
Child Theme: ? – Si estás modificando WooCommerce en un tema padre que no has creado personalmente
te recomendamos utilizar un tema hijo. Ver: Cómo crear un tema hijo

WooCommerce Support: ?

### Templates ###

Overrides: –

### Admin ###

Enabled Features: activity-panels
analytics
product-block-editor
coupons
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: core-profiler
minified-js
new-product-management-experience
product-variation-management
settings
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2023-12-12 14:44:53 -05:00
Options: ?
Notes: 164
Onboarding: completed

### Action Scheduler ###

Complete: 57.176
Oldest: 2023-11-10 10:34:27 -0500
Newest: 2023-12-11 10:33:47 -0500

Pending: 6
Oldest: 2023-12-11 10:34:26 -0500
Newest: 2023-12-11 23:02:21 -0500


### WooCommerce Zapier ###

Database Version: ? 13
Detailed Logging Enabled: No
Legacy Mode Disabled: ? Yes
SSL: ? Yes
REST API Authentication Key(s): ? 0
Task History Record Count: ? 0

### Status report information ###

Generated at: 2023-12-11 10:33:56 -05:00
`
Viewing 9 replies - 1 through 9 (of 9 total)
  • Saif

    (@babylon1999)

    Hello @pablogutierrez,

    Thank you for reaching out!

    Since a few days we notice that the scheduled action called woocommerce_deliver_webhook_async is being executed multiple times after each purchase (check screenshot: https://imgur.com/FqhSjax).

    Apparently, this is caused by CloudFlare, please check the following discussion for more details: https://github.com/woocommerce/woocommerce/issues/31651

    I suggest temporarily disabling it to confirm if that’s the case indeed.

    Also, please make sure to update WooCommerce as we no longer support the version you’re currently using (7.8.0).

    Let us know how it goes! :?)

    Thread Starter pablog

    (@pablogutierrez)

    Hi @babylon1999,

    Thanks for the fast reply.

    It’s strange because we don’t use Cloudflare.

    However, we have created an staging site, upgraded WooCommerce and works perfect!

    We see that the action woocommerce_deliver_webhook_async is still executed multiple times but the final amount of units (inventory) is calculated correctly in our staging site.

    Is this normal? Should the action woocommerce_deliver_webhook_async be executed multiple times for the same order?

    Thanks again for your time.

    Hi,

    Even though this is the same order resource, from the screenshot it is clearly visible that there are multiple different Webhooks. It looks like it’s working as intended. I suggest visiting WooCommerce -> Settings -> Webhooks page and looking for enabled webhooks. If you have duplicates that you don’t need, you can disable or delete them on that page.

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hi pablog

    Thank you for your reply.

    Csaba Maulis, I appreciate your answer.
    It is indeed the right direction to problem solution ??

    pablog, here is a screenshot for your reference:

    Please let us know how it goes.
    Thank you

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    The screenshot failed to appear in my last reply.
    Adding it here again.
    https://imgur.com/a/Dag2vN3

    Thread Starter pablog

    (@pablogutierrez)

    Hi @doublezed2 and @om4csaba,

    Thanks for your help. We haven’t been able to fix the issue but I believe we are getting closer.

    The next question seems like another topic but I would like to continue this support thread: When using the native WooCommerce Import Products feature, are the CSV files used (uploaded) hosted/saved in any folder inside WooCommerce?

    We are asking this because we believe an admin user “damaged” the products database using this feature and it’s causing the inventory issue. When we make tests with new created products, the inventory management works perfect.

    Thanks again for you time.

    HI @pablogutierrez

    When using the native WooCommerce Import Products feature, are the CSV files used (uploaded) hosted/saved in any folder inside WooCommerce?

    WooCommerce does not store the CSV files used for importing products in any folder within the system. Once the import process is completed, the files are not kept or stored within WooCommerce.

    We are asking this because we believe an admin user “damaged” the products database using this feature and it’s causing the inventory issue. When we make tests with new created products, the inventory management works perfect.

    If you’re experiencing issues with your inventory, it’s more likely that the CSV file used had some incorrect data or was improperly formatted which could have led to the issues in your products database. I would recommend reviewing the CSV file that was used for the import and ensuring it meets the required format and data guidelines.

    You can check this support documentation for your reference: Product CSV Import Schema

    Hope this helps!

    Thread Starter pablog

    (@pablogutierrez)

    Hi @xue28,

    Thanks for the help! Everything is very clear.

    Happy holidays!

    Saif

    (@babylon1999)

    Hello @pablogutierrez,

    I’ll be marking this thread as solved, feel free to create a new one if you have any other questions.

    Happy holidays to you too! :?)

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘WooCommerce Webhook Executed Multiple Times’ is closed to new replies.

Tags