TrenoxaHQ
Free n8n template

Know when supplier stock is late

Shopify's purchase orders hold the expected arrival date, but nothing tells you when it passes. A late carton or a half-delivered order shows up later as an out-of-stock line, or a wholesale buyer asking where their reorder is. This free workflow reads your purchase orders every morning and emails you the ones that need a chase.

What it gives you

Fewer stock surprises

Late or half-delivered supplier stock shows up in your morning email, not as an out-of-stock line a buyer finds first.

Done for you · templates included free

Rather have it set up for you?

$199 per workflow: I install and test it on your store, and the template, Pro version included, comes free with the setup.

What it does

  • Reads every open Shopify purchase order with its transfers and shipments, all pages
  • Overdue: shipments past their expected arrival date, with how many days late
  • Arriving soon: shipments due in the next 7 days (adjustable), with items and tracking
  • Partly received: units received out of units ordered
  • Ordered, nothing shipped: purchase orders the supplier hasn't sent after a few days
  • Links straight to each purchase order in Shopify admin; quiet days send no email
  • Optional Google Sheet with one row per purchase order, updated every morning
  • An alert email if the check itself fails

What it saves you

  • Opening every purchase order and transfer to see what's late
  • Hearing about missing stock from an out-of-stock product or a buyer

Needs n8n (self-hosted or Cloud), a Shopify store that uses Purchase orders, and an SMTP mailbox (Google Sheets optional). Read-only scopes read_inventory_purchase_orders, read_inventory_transfers, read_inventory_shipments (Admin API 2026-10). One execution per day.

Incoming Stock Tracker thumbnail
Pro · $29 once

Incoming Stock Tracker Pro: see who is waiting, and chase the supplier

A late purchase order isn't the problem. The wholesale order that can't ship because of it is. Pro adds:

  • Wholesale orders waiting on late stock: open B2B orders with a product on an overdue or unshipped purchase order, with buyer, quantity and PO
  • Supplier chase emails: one polite email per supplier listing their late POs, reply-to you, repeated only every few days. Preview mode until you switch it on
  • Expected-date change alerts when a supplier moves a delivery date
  • Weekly supplier scorecard: on-time rate, average days late, late right now
  • Slack summary, plus the Google Sheet with days late and waiting orders

Needs the scopes above plus read_orders and read_products. Tested on a Shopify development store with real purchase orders, shipments and a B2B order.

Incoming Stock Tracker Pro thumbnail