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

[BetterReports-D]

Hi @Zowne 

I'd love to recommend our app Better Reports for this!

I’m Ciara from Better Reports, and we frequently help merchants with exactly this type of request.

We can create an items pending fulfillment report that shows products and variants in unfulfilled or partially fulfilled orders. We'll be able to show the quantity pending fulfillment for each item and the orders it is included in. 

In addition to custom reporting, Better Reports has more than 80 built-in reports available out of the box that cover many common use cases for merchants. You can schedule reports to run at set frequencies to your email or Google Drive or export the reports in CSV, Excel, HTML, or PDF format.

I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to set this up for you.

What do you think?