Reports for your total variation sales?

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. 

1,342 Views
Message 1 of 8
Report
1 Solution
Square Champion

Solution

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.

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!

View Solution >

1,313 Views
Message 2 of 8
Report
7 REPLIES 7
Square Champion

Solution

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.

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!
1,314 Views
Message 2 of 8
Report

Thank you Chip, I've never done a pivot table, but will learn how.

1,294 Views
Message 3 of 8
Report

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

528 Views
Message 4 of 8
Report
Square Champion

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?

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!
519 Views
Message 5 of 8
Report

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?

 
 

 

 
 

 

 
 
 

 

508 Views
Message 6 of 8
Report

shawsdogs1_0-1761146365711.png

This time it worked, this is a screen shot of the variations

507 Views
Message 7 of 8
Report
Square Champion

Well, I'm happy it is working now.  Thanks for letting us know.

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!
501 Views
Message 8 of 8
Report