Solved

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

jake_mitchell
Shopify Partner
120 2 53

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

 

 

 

Accepted Solution (1)
paul_n
Shopify Staff
1011 133 242

This is an 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

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.

View solution in original post

Replies 7 (7)

jake_mitchell
Shopify Partner
120 2 53

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
Shopify Staff
1011 133 242

This is an 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

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
rumbadall
Tourist
5 0 2

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
Shopify Staff
1011 133 242

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

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
rumbadall
Tourist
5 0 2

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
Shopify Staff
1011 133 242

16-37-zxnu0-1epa8

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
rumbadall
Tourist
5 0 2

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.