Hide or Adjust Shopify Products the Moment Your ERP/3PL Reports Out-of-Stock

When your source of truth for inventory is an ERP, WMS, or 3PL — not Shopify — there’s almost always a lag between “we’re out of stock in the warehouse” and “the product is unavailable on the storefront.” That lag is where oversells happen. This guide shows how to close it by triggering a Shopify Flow the instant your external system reports a stock change.

Why this is hard with native Flow alone

Shopify Flow has an Inventory quantity changed trigger — but it fires on Shopify’s inventory record. If your real stock count lives in an ERP/WMS/3PL and only syncs to Shopify periodically (or unreliably), Flow reacts late, or not at all. Merchants regularly report Shopify inventory not syncing cleanly from external systems (Shopify inventory not syncing), and integration platforms like Celigo exist specifically to broker ERP↔Shopify inventory (Celigo inventory sync docs).

The cleaner pattern is to let the external system push the change and have Flow react immediately — which means triggering Flow from a webhook.

The setup

1. Create a custom channel in Flow Plus.

2. Have your ERP/WMS/3PL POST to the channel URL whenever a SKU’s available quantity changes.

3. Map the stock fields:

   sku        → Field1
   quantity   → Field2
   warehouse  → Field3
   timestamp  → Field4
   (full payload) → JSONString

4. Build the Flow workflow keyed on {{ Field1 }} (the SKU) and {{ Field2 }} (quantity):

   • Condition: when Field2 reaches 0 (or your safety-stock floor).
   • Actions: set the Shopify inventory to match, unpublish / hide the product or variant, add an oos tag, and alert your ops team.
   • When Field2 rises back above the floor, a second branch can re-publish and remove the tag.

The complete warehouse payload stays available as JSONString, so multi-location or per-bin detail can be decoded in a Run Code step without burning your eight Field slots.

The payoff

Stock changes propagate to the storefront in near real time instead of on a sync cycle, and the rule lives in the Flow editor where your team can read and edit it. Flow Plus relays the event privately — it never reads your catalog or store data.

New to the pattern? Read the pillar first: How to trigger a Shopify Flow workflow from an external webhook.