Is It Possible to Auto-Create Purchase Orders Based on Inventory Threshold Using Shopify Flow or Functions (Without a App)?

I’m trying to design a system that automatically creates a purchase order when a product’s inventory falls below a defined threshold limit.

I’ve researched Shopify Flow and Shopify Functions, but I haven’t found a clear way to create or persist a purchase order (or any equivalent internal record) using only native Shopify tools.

I want to confirm whether I’m missing something:

  • Is there any native Shopify feature, supported workaround, or recommended approach to create purchase orders based on inventory thresholds without building a custom or public app?

  • If this is not possible natively, is a custom/private Shopify app using the Admin API the only viable solution?

I’d appreciate clarification from anyone who has implemented a similar workflow or can confirm the current platform limitations.

AFAIK, there is no API to create purchase orders.

If creating a metaobject or adding lines to Google Sheet qualifies as “equivalent internal record”, then yes, this can be done.