How can I track and display current unfilled orders with a certain Type or Tag?

[Rewild_at_Heart]

Hi, some of my products are made-to-order woodwork and can be subject to delays in busy periods.

I'd like to set up something which can tell customers how many active woodwork orders are currently in the queue/unfulfilled, so they can anticipate delays - to avoid unhappy customers and take the stress of my partner somewhat.

I'm thinking something like this:

1. customer orders a woodwork product (by Type)

2. count orders matching this criteria: unfulfilled and contains a woodwork product

3. output that number in an email "we have X current woodwork orders in the queue"

But for step 2, I can't see how I can count orders matching criteria - is this possible with Flow? 

Or alternatively, I could have multiple flows where one records woodwork orders as they come in and one lowers the count when the orders are fulfilled; then either display this field on the listings/checkout or output it in an email when ordered.

But for this one, I'm not sure where I'd effectively "store" that count - I don't think there are "global" metafields in Shopify. Is this possible with Flow, or would I need to use another integration of some sort?

Thanks in advance, I'd love some suggestions!

[TheScriptFlow]

Hey @Rewild_at_Heart this is Qasim a Sr. shopify developer ready to help you.

In order to track and display current unfilled orders with a certain Type or Tag you need to tell me which method you prefer?
1: Custom Solution

2: With Shopify app

If you prefer cusotm solution then I need to take a look on your theme code and then Implement the logic.

If you prefer app then I recommend Shopify Mechanic app.

If you need more help reach me out.

Thanks

[Rewild_at_Heart]

Hi Qasim, thanks for your reply! I'm ideally not looking to hire anyone, I'd like to implement the solution myself but I'm having a little trouble.

Do you have any recommendations of an approach to take?

Thanks

[rajweb]

Hey @Rewild_at_Heart ,

Thank you for reaching out! I’d be happy to assist you with implementing a solution to manage and display the number of active woodwork orders in the queue.

With over 8 years of experience, I’m confident in delivering an efficient and tailored solution for your needs. To achieve this, I’d need access to your store to review the setup and implement the exact solution for you.

Feel free to reach out to me via email, and we can discuss the next steps. I look forward to helping you achieve the best possible outcome!

Best regards,

Rajat

[Rewild_at_Heart]

Hi Rajat, thanks for your reply! I'm ideally not looking to hire anyone, I'd like to implement the solution myself but I'm having a little trouble.

Do you have any recommendations of an approach to take?

Thanks