A user has created a Shopify Flow to archive products when available inventory reaches zero, the variant doesn’t allow overselling, and the product lacks a specific tag. The flow currently works but only checks available inventory.
Desired Enhancement:
The user wants to expand the archiving trigger to require ALL inventory metrics to equal zero:
Available inventory
Unavailable inventory
Committed inventory
On hand inventory
This ensures products are only archived after all orders are fulfilled with no negative discrepancies.
Suggested Solutions:
Add multiple conditions checking each inventory type (Available, Committed, Unavailable, On Hand)
Use custom metafields or tags to track when all conditions are met
Consider third-party apps if Shopify Flow doesn’t natively expose all inventory fields
Disable overselling in Shopify settings to prevent negative inventory
Status: The discussion remains open with no confirmed resolution. Implementation may require custom development or additional apps if Flow lacks native access to all inventory metrics.
Summarized with AI on November 2.
AI used: claude-sonnet-4-5-20250929.
Hi! I set up the pictured flow to archive specific products in my shop when
the total available inventory is equal to 0
[and] the variant is set not to oversell
[and] and the product is not tagged with “RegistryRoom”
The flow is working as it should, however I would like for the archiving action to take place when the total Unavailable, Committed, Available, and On hand inventory numbers are equal to 0. Meaning that all orders for a variant have been fulfilled, the item is sold out, and there are no negative inventory discrepancies.
It sounds like you want to refine your flow to ensure that the product is archived only when its total inventory numbers across different categories (Unavailable, Committed, Available, and On Hand) all equal zero. Currently, it seems like the flow is working based on a simpler condition, but you need to incorporate these multiple factors to make sure the product is fully out of stock in every sense, without any discrepancies.
Here’s what you can do:
Custom Inventory Conditions: You need to check all the inventory quantities (Unavailable, Committed, Available, On Hand) together. Shopify flows might not natively expose these exact fields directly for conditions. However, if you’re using an app like Shopify Flow (or any other app that can handle inventory management), make sure that it provides a way to access these specific inventory values.
Inventory Check: You might need to add multiple conditions to the flow. For example:
Check if Available Inventory is 0.
Check if Committed Inventory is 0..
Check if Unavailable Inventory is 0.
-Check if On Hand Inventory is 0.
Remove Negative Inventory: Ensure that your products are not overselling or showing negative inventory. To do this, in Shopify settings, you can disable the Allow customers to purchase when out of stock option and avoid any inventory discrepancies.
Using Metafields or Tags for Discrepancy Tracking: If Shopify doesn’t allow you to check these specific inventory numbers in the flow, you might want to track this with custom metafields or tags. For example, if all your conditions are met, a metafield can be updated to mark the product as “Ready to Archive” or something similar. You can then trigger the archiving action based on the metafield or tag.
Manual or Automated Check: If you cannot access all of these inventory numbers through Flow, you could consider creating a more manual process for inventory management that updates products when discrepancies are resolved or when certain thresholds (like all inventory values being zero) are met.
If you’re using an app like Shopify Flow, it may not give direct access to all those inventory statuses, so exploring custom development or using a third-party app with deeper inventory management might be required.
Let me know if you need specific help with the app or flow setup!
Please feel free to contact me via email if you need further assistance—I’d be happy to help you! [rajat.shopify@gmail.com]
If I was able to help you, please don’t forget to Like and mark it as the Solution!
Thanks.
