Backorder Management System

I need to manage backorders for my Shopify store using order tags, Shopify Flow, and a ShopifyQL report — everything native to Shopify admin, no external apps or automated email sequences. Here are the details:

Store name: [YOUR STORE NAME]
Product(s)/SKU(s) commonly backordered: [PRODUCT NAME OR SKU]
Backorder tag to use: [e.g., “Backorder”]
Ready-to-fulfill tag to use: [e.g., “Ready-to-Fulfill”]

Please help me build:


  A Shopify Flow triggered on “Order created”: if the order contains [PRODUCT/SKU] and that variant’s available inventory is 0 at order time, tag the order “[BACKORDER TAG]” and add an order note: “Backordered — placed [order created date], est. restock per current lead time.”
  A second Shopify Flow triggered on “Product variant inventory quantity changed”: if [PRODUCT/SKU]’s available inventory changes from 0 to a number greater than 0, find all orders tagged “[BACKORDER TAG]” containing that variant, sort by order creation date ascending (oldest first), and tag each one “[READY-TO-FULFILL TAG]” in that order — up to the newly available quantity.
  A ShopifyQL report, runnable on demand, showing: count of orders currently tagged “[BACKORDER TAG]”, total revenue on hold (sum of total price across those orders), and the creation date of the oldest still-tagged order.
  Save the report in step 3 as a reusable skill (e.g., /backorder-status) so I can rerun it any time by asking “how many backorders do we have right now.”


Keep this strictly to orders, tags, Flow, and ShopifyQL — do not propose customer-facing email sequences, a backorder policy page, or a self-service cancellation portal; those require Shopify Email/Messaging campaign builds or a dedicated app and should be scoped separately.