Looking to view a consolidated list of all the products currently in Open (unfullfilled) orders

[Zowne]

Hi Shopify Community!

I'm looking for either a built-in Shopify function, or a third-party app which allows me to view a consolidated list of all of the products that I have in open (unfulfilled) orders.

I manufacture each of my products as they are purchased and so it would be very handy to see a list of all the products which I have to make without having to click on each order to see what was ordered in the last couple of days.

If anyone knows of anything that would be very helpful!

Thanks

[Bob_]

There is a report that might be useful to you with a couple of edits. Orders and returns by product, open that remove the returns from the metrics and add a filter for unfulfilled orders so it looks like the attached picture (setting the dates you want) and it will give you a summary of the products by title and quantity.

[Zowne · Accepted solution]

Thanks Bob!

With your reminder of the reports function, I went in there and made my own report.

For anyone looking to do this in the future, the ShopifyQL code I used for this is here-

FROM sales
SHOW quantity_ordered
WHERE order_fulfillment_status = 'unfulfilled'
GROUP BY product_title, product_variant_sku
WITH TOTALS, GROUP_TOTALS
SINCE startOfDay(-60d)
UNTIL today
ORDER BY quantity_ordered__product_title_totals DESC, quantity_ordered DESC, product_title ASC, product_variant_sku ASC
LIMIT 1000