How to easily archive sold out items (one-off second hand shop)

[jake_mitchell]

Hi, 

We're a second-hand shop that mainly sells one-offs and has a lot of people listing the items for us. 

We would like to find a way of auto-archiving items that match certain criteria once sold. 

Ideally we could do this with flow where we could lookup lineItems within an order and then archive the product. 

There is a similar thing available for orders where we can archive an order that is fully fulfilled but there doesn't seem to be a similar thing for products. Does anyone know how this could work? Is it going to be covered in the advanced workflows version of flow? 

[jake_mitchell]

No sooner had I typed this out did I realise I'd already asked it before. 

For anyone else running a second hand or one-off store the best way I've been able to do this is to do an inventory quantity change trigger flow. 

Trigger: inventory quantity change

Condition: look for specific tag

Condition: prior inventory total was 1

Condition: new inventory total is 0

Action: add tag of sold 

Manual action to follow up required to filter product list and archive en-masse. 

Note: we have also added in an additional step so that if the quantity goes back up (e.g. after a return is processed) it will remove the Sold tag so it doesn't then fall back into the manual process. 

[paul_n · Accepted solution]

You could also call the productUpdate API via Send HTTP Request to change the status if you are handy with APIs. https://shopify.dev/api/admin-graphql/2022-10/mutations/productUpdate

[rumbadall]

Jake, which app are you using for trigger flows?  Shopify OOTB has workflow automation but the trigger options do not include one for when inventory quantity is changed.

[paul_n]

This is incorrect - Flow has an inventory quantity changed trigger.

[rumbadall]

Can you provide the location of this trigger or a screen shot? I’m not seeing this option in the list? Thank you. 

[paul_n]

[rumbadall]

Thanks.  I see the issue now.  I'm on the Shopify Basic Plan which only offers a limited number of flow triggers that are part of the marketing automation list of options.  You have to be on the Shopify, Advanced or Shopify Plus plans and download the Shopify Flow app.