thread Re: Sales Report on Non Reporting Categories in Orders, Menu Items, Catalog & Fulfilment

Sales Report on Non Reporting Categories

TheReadery — Sat, 20 Sep 2025 09:30:53 GMT

Hi,

I have a mobile bookstore, and I input my books and categorize them as Used Books> Romance, or New Books> Thriller, so the reporting categories are umbrella categories of Used Books or New Books, but is there a way to see the non reporting category sales for Romance or Thriller books?
Thank you
Meredy @ The Readery

Re: Sales Report on Non Reporting Categories

MayaP — Mon, 15 Sep 2025 19:51:24 GMT

Hello @TheReadery thank you so much for reaching out!

I’m wondering if the Category Sales Report gives you the information you need. If not, could you share a bit more about what you’re hoping to accomplish? I’d love to point you in the right direction.

Re: Sales Report on Non Reporting Categories

TheReadery — Thu, 18 Sep 2025 12:45:55 GMT

Hi @MayaP

The Category sales report only shows the books as Used - not by the other category listed.

It's like Used Books is the umbrella - and Romance is a subcategory and I can't find a report to show that.

But I can see Romance and Thriller under Categories in the Items Library/Inventory, just can't separate it out on a sales report.

Re: Sales Report on Non Reporting Categories

TheReadery — Thu, 18 Sep 2025 12:57:16 GMT

On the spreadsheet where I upload inventory, there are two categories on the spreadsheet so I do for sure want to know Used vs New book sales - as categories - but I also would like to see genre sales - Romance vs Thriller vs Young Adult.

Re: Sales Report on Non Reporting Categories

TheRealChipA — Thu, 18 Sep 2025 13:22:26 GMT

Hi there @TheReadery.. So I believe there is a way to do what you want using the Category Sales Report, with a little effort. It involves using Category Rollups.

Click the Rollups button on the report. Create a rollup called "Romance" and add romance categories to it. Do the same for the other you want to report on. These rollups will be saved so you can reuse them as you want in your reporting.

You could also use this to create reporting on, say, fiction vs. non-fiction, without creating a separate category for that.

I think this will work for you, but let me know if you run into any issues. If you do, a screen shot or two would be helpful.

Re: Sales Report on Non Reporting Categories

MayaP — Tue, 23 Sep 2025 20:14:19 GMT

Hi @TheReadery - Thanks for your patience. Does @TheRealChipA suggestion below help? I am going to mark his reply as best answer for now. If you still need any help let me know!

Re: Sales Report on Non Reporting Categories

MayaP — Tue, 23 Sep 2025 20:14:56 GMT

As always, thanks for stepping in and providing a great workaround! I went ahead and marked your reply as the best answer 👏

@TheRealChipA

Re: Sales Report on Non Reporting Categories

TheReadery — Tue, 23 Sep 2025 20:32:52 GMT

Hmm. It won't allow me to insert images but I do not have a toolbar on my Category Sales Report screen.

Re: Sales Report on Non Reporting Categories

MayaP — Tue, 23 Sep 2025 21:02:01 GMT

Try signing out and back into the community. You should be able to upload an image then. @TheReadery

Re: Sales Report on Non Reporting Categories

TheReadery — Wed, 24 Sep 2025 12:37:48 GMT

Aaah, here are the screenshots. I don't have a toolbar under Category Sales to select Rollup.

Can you send me a screenshot of where this would be?

Re: Sales Report on Non Reporting Categories

MayaP — Wed, 24 Sep 2025 12:55:16 GMT

I see mine at the top, under the date @TheReadery

Any idea why they wouldn't see the rollups? @TheRealChipA

Re: Sales Report on Non Reporting Categories

TheReadery — Wed, 24 Sep 2025 14:15:01 GMT

I don't have that option. I also don't have Closed Checks either..

Re: Sales Report on Non Reporting Categories

TheReadery — Wed, 24 Sep 2025 14:23:25 GMT

Could it be because I'm retail and not a restaurant? Or also because I am using the free Square version?

Re: Sales Report on Non Reporting Categories

MayaP — Wed, 24 Sep 2025 15:09:02 GMT

Yes, you will need to opt into one of the Plus or Premium plans to access the roll-up feature.

It looks like the specific category reporting you are looking for is not available right now. You can always share this feedback on the Ideate board. I am sorry there is not a solution at the moment. If you need anything else, please let me know. I am happy to help.

@TheReadery

Re: Sales Report on Non Reporting Categories

TheReadery — Wed, 24 Sep 2025 15:22:59 GMT

At least I have an answer! Thank you.

Re: Sales Report on Non Reporting Categories

MayaP — Wed, 24 Sep 2025 15:45:16 GMT

Of course, thanks for understanding! @TheReadery