I have a workflow where the WooCommerce Trigger (Event - order.update) is the first in the process chain. I found a problem that I get a data duplication bug for about 2-3 per hundred orders processed.
That is, the person paid for the order, the order was updated and n8n accepted it as two different updates. It turns out that the process started twice with the same data.
What is the error message (if any)?
There are no error messages, it just shows that the process is started twice with the same data and a couple of seconds apart.
Please share your workflow
This is a private development, I can only share with admins in a private message on request.
Share the output returned by the last node
I have all the logs, both on the wordpress site and on n8n.
Information on your n8n setup
n8n version:1.11.1
Database (default: SQLite):SQLite
n8n EXECUTIONS_PROCESS setting (default: own, main):own, main
Running n8n via (Docker, npm, n8n cloud, desktop app):Docker
I believe the WooCommerce trigger is webhook based so that would mean that WooCommerce has sent the event twice, sadly we don’t check if an event is a duplicate as we wouldn’t expect that.
If the order updated twice though it would be correct to send the event twice once for each update, you may have to filter the events to only process some updates if there is a value in the event that covers what was updated.
After digging through the logs of Woocommerce - Webhook Delivery , I found the following:
It can be seen that for some reason woocommerce sent 2 times - the order is in processing and 1 time - the order is completed. During normal operation (when there is no God) - he sends only 2 times (1 time - the order is processed and 1 time - the order is completed). My workflow catches all order updates and only works with the status “order in processing” (i.e. paid).
How can I now understand why woocommerce behaved this way?
and it really happens 2-3 times for a hundred, or even for 2 hundred orders.
Also, if I go to the woocommerce order, I see from the history that it is updated only 2 times, not 3. That is, it turns out that for some reason web hooks work incorrectly?
Sadly I don’t have an answer for that as we just accept the webhooks that are sent, If WooCommerce is sending multiple webhooks it may be worth asking them assuming that you have checked the webhooks registered in WooCommerce to make sure you don’t have duplicates in there.
