Is there currently a way to get a report on your total variation sales? For example, I am a photographer and all my images have the same variations. I want to see a report on how many 8"x12"s sold across all of my images. I know as of last year this feature wasn't available, but they said it may come in the future. I know Square has added new features since and I thought perhaps they have since added it, but I can't find anything on the subject that is new. Is it still unavailable? I was hoping for such a report from option sets, but it doesn't from what I can find. Any help or information is appreciated.
Hey @ArtThatSmiles. There is still no stock Square report for reporting on Variations like this. You can, however, do it yourself, by downloading the Item Summary CSV for the desired period (from the Online Dashboard Transactions list), and then creating a Pivot Table in a spreadsheet to do this summary for you. If you aren’t sure how to make this happen, let me know and I’ll walk you through the steps. It’s not too overly complicated.
Hey @ArtThatSmiles. There is still no stock Square report for reporting on Variations like this. You can, however, do it yourself, by downloading the Item Summary CSV for the desired period (from the Online Dashboard Transactions list), and then creating a Pivot Table in a spreadsheet to do this summary for you. If you aren’t sure how to make this happen, let me know and I’ll walk you through the steps. It’s not too overly complicated.
Thank you Chip, I've never done a pivot table, but will learn how.
I'm looking to track variations as well and seen your post. If you would kindly walk me through the steps I would greatly appreciate it. I run an icecream trailer and my sizes are listed in the variations and would like to keep better track of the sizes.
I've downloaded the item summary for select dates but all that comes up is regular instead of small - medium - large
Thank you in advance
Cheryl
Hi there @shawsdogs1.. So if your report is showing Regular then it sounds like you haven't done Small/Medium/Large. Regular is the Square default variation name. Can you reply with screen shots of an item setup showing the sizes as variations?
Hi ChipA
Also should have mentioned that in this particular food trailer I am running the square app on a tablet. Not sure if that is what is making the difference or not. Tried uploading an image but it said I don't have permission to upload images?
This time it worked, this is a screen shot of the variations
Well, I'm happy it is working now. Thanks for letting us know.
Square Community
Square Products