"Uncategorized" items not showing up when downloading CSV

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?

352 Views
Message 1 of 4
Report
1 Solution

Solution

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!

View Solution >

314 Views
Message 3 of 4
Report
3 REPLIES 3
Square Champion

@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.

Chip A.
Square Expert & Innovator and member of the Square Champions group. (But NOT a Square employee, just a seller like you)

Was my post helpful? Take a moment to mark it as a solution. Marked solutions help other sellers find possible resolutions to similar problems. Also, if you find your solution elsewhere (say, through Support), it is helpful to come back to your post and tell us about it, then mark that as a Solution. Solutions are what this Community is all about!
318 Views
Message 2 of 4
Report

Solution

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!

315 Views
Message 3 of 4
Report
Square Champion

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.

Chip A.
Square Expert & Innovator and member of the Square Champions group. (But NOT a Square employee, just a seller like you)

Was my post helpful? Take a moment to mark it as a solution. Marked solutions help other sellers find possible resolutions to similar problems. Also, if you find your solution elsewhere (say, through Support), it is helpful to come back to your post and tell us about it, then mark that as a Solution. Solutions are what this Community is all about!
310 Views
Message 4 of 4
Report