How to filter and automatically archive products with all variants out of stock in Shopify?

[AdrianSobczak]

How can I filter products in the Shopify "Products" section to show only those where all variants have an inventory quantity of zero? I want to archive such products, but I can't find a built-in filter that allows filtering based on all variants having zero stock — Shopify only seems to let me filter for products where any variant is out of stock, which doesn't help in this case.

Additionally, is there any way to automate this process? For example, using Shopify Flow (or another integration/app), to regularly check variant inventory levels and automatically archive products where all variants are out of stock?

I'd like this to apply to both existing and future products. Has anyone implemented something like this?

[Cristina_92]

Hello @AdrianSobczak ,

Yes, there is a template in Shopify Flow.

As I understand it'll regularly check variant inventory levels and automatically archive products where all variants are out of stock.

[AdrianSobczak]

Does this workflow also include products that already have zero inventory across all variants? I want to make sure it archives not only future products that will go out of stock, but also those that already meet this condition.

[Cristina_92]

Here is what Shopify documentation says: 

Testing the Product variant out of stock trigger
To test a workflow that starts with this trigger, change a variants's inventory from greater than 0 to 0.

I asked Shopify AI assistent: "Yes, the template to archive a product when all variants are out of stock at all locations includes products that already have zero inventory across all variants." 

Maybe someone can give you more details 🙂.

[AdrianSobczak]

I have enabled this workflow, but so far, none of my products that have zero inventory across all variants have been archived. I’m waiting to see if the archiving occurs with a delay or if the workflow requires additional configuration.

[tim]

No, this Flow is triggered by change of product availability.

To process  your already OOS products you'd need a different one.

You need to run it once, but because it can only process maximum of 100 products per run (Flow limitation), the flow is scheduled to repeat every 10 minutes.

When all products processed, it will send you an e-mail so that you can turn it off it and leave only the first one running.

[AdrianSobczak]

Thank you! This really looks like it could solve my problem. However, I'm not sure where to get such a workflow or how to create it myself – I’m a bit of an amateur when it comes to this. Could you possibly point me in the right direction or share some guidance on how to set it up?

[tim]

No, it's not a standard Flow.

It should be reasonably easy to replicate it from the screenshot.

I've also attaching the export of the flow, so you should be able to import it into your store, just change the e-mail address in the last action.

(Somehow I can't attach the .flow file, so you'd need to remove the .csv extension)

[AdrianSobczak]

Hi,

Thanks for sharing the flow and the screenshot.

Unfortunately, it doesn't work as expected. I'm getting the following error:
"Product data not found", which occurs during the "Update product status" step.

Could you advise how to fix this issue?

Best regards

[tim · Accepted solution]

Looks like I've shared an incomplete version of the Flow, both in screenshot and in a file. There must be a "Flow" => "Loop" action between "Get Product Data" and "Update product status":

Sorry!