thread Re: "Uncategorized" items not showing up when downloading CSV in Payments Troubleshooting

"Uncategorized" items not showing up when downloading CSV

cbrew — Sat, 20 Sep 2025 18:30:01 GMT

Due to a mistake, we have many items that were sold in the last year that did not have a category. I realize that I cannot retroactively fix this, but now I'm trying to do some processing on the CSV and I see that they're not there.

When I go to the Item Sales report (sales/reports/item-sales), I can see them. But when I download the CSV from this report, they are missing.

Is this a known issue? Is there a work-around?

Re: "Uncategorized" items not showing up when downloading CSV

TheRealChipA — Sat, 16 Aug 2025 11:30:46 GMT

@cbrew When you say (in your second paragraph) that "When I go to the Item Sales report (sales/reports/item-sales), I can see them" are you saying that this report shows categories, but that the CSV doesn't? That would be odd, indeed, since Square has never allowed for erroneous history to be corrected, and probably never will.

I can think of one possible work-around involving downloading your current item catalog (which I assume has corrected categories, now) and your historical sales reports. But before I explain that, it would be very helpful to see some screen shots -- especially of your sales report where "I can see them" and your CSV where "they are missing."

Thanks.

Re: "Uncategorized" items not showing up when downloading CSV

cbrew — Sat, 16 Aug 2025 13:58:18 GMT

Okay, I figured it out. Though they show up as "Uncategorized" in the UI, in the CSV the category is "None".

The CSV was quite big and I failed to notice this. While it might be appropriate to use the same word for this in both the UI and in the CSV, it's not really a bug and I'm all set.

Thanks for the response, Chip!

Re: "Uncategorized" items not showing up when downloading CSV

TheRealChipA — Sat, 16 Aug 2025 14:03:48 GMT

Well, I'm happy to hear that it's not a bug, at least. Thanks for taking the time to let us know. That will help other sellers with similar questions who might find this thread.