thread Create Report - Active Orders Total Items By Count in Payments Troubleshooting

Create Report - Active Orders Total Items By Count

otrbagels — Sat, 20 Sep 2025 18:43:08 GMT

From within the Square POS or Square Dashboard, can someone please tell me how to create a report that tells me how many (count) of each item that is part of an Active Order?

Use case:

I need to know how many of each bagel flavor I need to bake to fill my pre-orders. I come to work in the AM, click the Square POS, and I need to see total number of Plain, Everything, etc my customers have requested for a specific day.

Example:

Friday, 4/11:

10 Everything

8 Plain

5 Onion

Re: Create Report - Active Orders Total Items By Count

Ellie_ — Fri, 11 Apr 2025 21:57:02 GMT

Hi there, @otrbagels,

First, I noticed that this is your first post on the Square Community, so I just wanted to say welcome! While you are here, we recommend checking out our Orientation & Etiquette.

As for this type of report on Square, we don't have a feature like that at this time, but feedback like this is very helpful when planning for future releases. I recommend that you submit this on the Ideate board within our Square Community. On this board, different Sellers are able to submit feature requests and other Sellers are able to vote on these ideas to our product team.

Re: Create Report - Active Orders Total Items By Count

otrbagels — Fri, 11 Apr 2025 22:10:58 GMT

Can I export the orders to an xlsx?

Re: Create Report - Active Orders Total Items By Count

Candlestore — Sat, 12 Apr 2025 00:25:56 GMT

@otrbagels ;

Yes you can export orders to a csv file.

Goto : https://app.squareup.com/dashboard/ on a computer and Login to your Square dashboard.
Scroll down on the Left side Past All Products to Items and Orders
Then a Pop out window appears select Orders
Depending on which csv you prefer (All Active Scheduled Completed Cancelled) select the one you find the most helpful
Then a preview pops up on your screen
If that is the one you can Press Export in the top Right

You can also apply filters for date range, Type, Payment Status, Channels, Location, or Order Status.

This is pretty much the way you would download your Catalog or Transactions as a csv or excel file.

Welcome to Square.

Re: Create Report - Active Orders Total Items By Count

otrbagels — Sat, 12 Apr 2025 05:06:41 GMT

First, thank you!

Second, Pocono Candle! Wow! Awesome! Memories! PHMS Class of 88. 🙂

Third, what’s confusing is in the Square iOS app, I can go to the sales report and see a count of each item. In the browser, I only see dollars and cents.

I thought I was computer literate. Am I missing something?

Re: Create Report - Active Orders Total Items By Count

Candlestore — Sat, 12 Apr 2025 13:57:41 GMT

@otrbagels ;

Usually in reports with Square you see $ amounts, Square maybe testing counts on the apps. I hope this helps