Q&A
we run a shopify store and want to automate our post-purchase flow:
1. new order comes in from shopify (webhook)
2. add order to our orders table
3. if order value > $100, send a personal thank you email from the founder
4. if its a first-time customer, add them to our welcome email sequence
5. update our daily sales summary table for reporting
anyone doing something similar with shopify? the main thing im not sure about is how reliable the webhook connection is. we cant afford to miss orders
nobody? really hoping someone has done this with shopify
we do almost exactly this for a client. shopify sends a webhook on new orders. heres the setup:
1. in shopify admin > settings > notifications > create webhook for "order creation"
2. point it at your workflow webhook URL
3. workflow receives the full order payload (line items, customer info, totals, etc)
4. first node: write order to your orders table
5. condition node: check order.total_price > 100 for the personal email
6. another condition: check if customer.orders_count == 1 for first-time buyer flow
reliability: weve processed about 8000 orders through this and only had 2 failures, both were shopify API hiccups that retried successfully. so very reliable
one tip: shopify sends the webhook almost instantly but sometimes theres a 1-2 second delay. weve never seen it miss an order though
this is amazing thank you. the 8000 orders with 2 failures is very reassuring. setting this up this week
we do the same for 2 shopify stores. works great. also added a weekly summary workflow that calculates total orders, revenue, average order value from the table and emails it to the team every monday