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?
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!
@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.
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!
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.
Square Community
Square Products