• Resolved webexpert10

    (@webexpert10)


    Hello There,

    Greetings!!

    We are using Integromat tool to collect Woocommerce order data to Google sheet.

    flameshot_screenshot

    The configuration is set that way that if new order comes it will create a row to google sheet and if order id already exists in the sheet, it will update the row.

    For updating the row, we are using ‘New Event” module from Integromat which tracks changes in order status and triggers the webhook for the change in data. The problem is webhook is not triggering in real-time.

    e.g. Order Id: 30093 was set “completed” on June 13, 2019 at 7:07 am (Netherlands time) but the webhook log shows data sent on 2019-06-13T13:00:18+00:00. Due to the difference in time between order updated and webhook info sent, we are not able to track real-time data.

    flameshot_screenshot

    flameshot_screenshot

    Could you please help us identify the issue? Why it is taking 5-6 hours to send the information to integromat?

    Looking forward to hear from you.

    Thanks

Viewing 1 replies (of 1 total)
  • Bartosz B. a11n

    (@bartoszbudzanowski)

    Hello,

    Part of the time difference comes from the fact that logs are presented in UTC format and not the local Netherlands time. That should account for 2h of time difference. Webhooks processing is done in the background and in batches – this can also cause a time delay.

    Since WooCommerce 3.3.0 there is an option to disable background processing for all or particular webhooks. The absolutely best practice is to only bypass background processing only for specific webhook by selectively looking at the filter parameters. This is the function that is adding the background processing for the webhook: webhooks processing.

    And this is the filter used to control the behavior:
    apply_filters( 'woocommerce_webhook_deliver_async', true, $webhook, $arg )

    As always please verify the solution on a staging site ??

    • This reply was modified 5 years, 4 months ago by Bartosz B. a11n. Reason: formatting
Viewing 1 replies (of 1 total)
  • The topic ‘woocommerce webhooks and API response date and time issue’ is closed to new replies.