ShipHero PO Update → Queue

A lightweight intake layer. It catches ShipHero purchase order update callbacks and drops them into a Supabase queue table so the heavier Purchase Order Update Handler can process them asynchronously.

At a glance

• Status: Active
• Trigger: Webhook (POST /webhook/purchase-order), responds immediately with "Workflow got started."
• Runs on: ShipHero PO update callbacks.
• Talks to: ShipHero (webhook source); Supabase (Brands, purchase_order_updates_queue).

How it works

1. The New PO Update webhook receives the payload.
2. The flow records po_uuid into $execution.customData for traceability.
3. Get Brand For Incoming Update looks up the brand in Brands by n8n_id matching query.brand.
4. If the brand is found, it inserts a row into purchase_order_updates_queue with the resolved brand id and full payload.

Notes

• saveDataSuccessExecution: none keeps the execution log lean.
• Processing halts silently if no matching brand is found.

Related

• Purchase Order Update Handler
• Pulling Purchase Orders
• Create PO on ShipHero
• Purchase Orders feature
• Data Flows