• Resolved pablog

    (@pablogutierrez)


    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)
  • You must be logged in to reply to this topic.