Hello! I would like to generate a report of sales by product tag or collection. I noticed in the sales by product tab on the reports page you can add columns for vendor, product type, price, etc but did not see these options. Is there another way to do this?
12 Likes
Hi! The Shopify Reports are a great start but are often limited in functionality.
You may have a look at Analytics apps on Shopify who can solve this for you.
In Polar Analytics, there is an advanced product performance tab where you can get all of this information:
And you can try it for free 
Currently, it’s not possible to achieve this through Shopify’s built-in reports.
However, you can check out Report Pundit which provides sales information for each tag, collection, vendor, and many other factors.
We offer access to more than 80 pre-made report templates as well, in case you need them.
You can reach us at support@reportpundit.com
Thanks!
That report doesn’t exist in Shopify in any of the plans . I have been requesting it for years.
And if you have the more advanced Shopify plans most of these 3rd party vendor will charge you more.
It’s a pretty basic and useful report that other 3rd party vendors have had for years but Shopify experts can’t figure it out.
So get ready to pay 20 or 100 bucks a month for a report that you can get in most any other platform
5 Likes
It’s crazy that Shopify doesn’t let you see a sales report based on product tags… hoping they fix this.
8 Likes
Agreed! Am in need of the same thing…
4 Likes
Thanks for the info, but as a very small business I can’t afford to add an app for everything that seems like it should be a pretty basic native feature. Hoping Shopify adds this report functionality rather than leaving customers to pay for more apps.
2 Likes
Hello! First thing’s first - I’m from the team at BeProfit (profit analysis dashboard for Shopify) and I can tell you this is a super relevant and commonly asked question - having these types of reports is essential to plan and optimize your product management.
To get to it - with BeProfit you’re able to analyze every aspect of your products, including collections, product returns, inventory, and more. Understanding your profit margins per product allows you to focus on what’s working, and optimize for profitability.
I hope you’ll find this helpful, and I’d be happy to answer any questions.
Cheers!
Nati
I too would love this sort of report so I don’t have to pay extra for just this one feature that’s needed Please, Shopify 
2 Likes
Please share how this is accomplished? Documentation isn’t clear on how to use custom fields or expressions.
Hi @jpatsos
Thanks for asking! You can read more on how this is accomplished here along with video walkthroughs-
This feature doesn’t require any custom fields or expressions.
Howdy! To do this for free takes a lil bit of excel juggling but its pretty simple, same process and formula for gsheets.
- shopify steps
-
export Shopify order record (can filter by date etc if needed)
-
export Shopify product record (before exporting, search products by the tag you’re chasing and export that filtered list)
- excel/ghseets steps
-
open the product export and get the list of skus related to the product tag.
-
open the order export, create a new tab and paste that list of SKUs into a column
-
in that same tab, use COUNTIF function, where the range is the SKU column of the order record tab (Column U, usually) and the criteria is the particular sku.
For eg: =COUNTIF(orders!U:U,A2) where U = skus on the order export, and A2 is the particular sku you’re trying to calculate total sales on.
done.
2 Likes
I have come to post some hopefully useful info to others. With much back and forth between apps and shopify support, it is actually quite easy to do with Product Tags, Order Tags, and the Flow App (free).
First, add your Product Tag to the product and then install the shopify Flow app to your store. Then setup a condition to add an ORDER Tag based on the PRODUCT Tag.
Once this is done, you can make views in the ORDERS console rather than Reports console and export a CSV or XSLX file from there.
SUPER USEFUL, and easy to do with a bit of setup then export from Orders console rather than Reports console. Works like a charm and you can save different views to export at any time.
Hi Smargolis,
I suggest our superU app, Better Reports, for this purpose! We can generate reports that display sales based on product tags or collections, all tailored to meet your specific reporting requirements.
Alongside customizable reporting features, Better Reports provides over 80 pre-built reports, addressing your most typical reporting needs such as sales, current inventory, refunds, payouts, and more.
Overall, great to sales report, it’s super user-friendly. They even offer a 30-day free trial, so you can really get a feel for it. If you’re curious, you can reach out to their team on their website superu.ai.
Shopify! Please make the small adjustment to your reports filter to allow for this! Absolutely ridiculous that this still is not supported
5 Likes
I would LOVE for this function to be native to Shopify reports and not something to pay extra for since it’s such a small addition that it doesn’t seem to warrant paying an extra fee for via an app. Please, please Shopify.
3 Likes
I am having the same challenge and this looks promising. Can you please describe step by step how to “setup a condition to add an ORDER Tag based on the PRODUCT Tag” in Flow?
1 Like
Crazy how Shopify still doesn’t have a solution for this
Terrible that Shopify are yet to add in this feature, especially whilst we pay for premium features, doing any form of royalty reporting is such a hassle withou this feature
Hello! Thanks for your feedback! I’m happy to get this feedback in front of folks internally, so they can look at it. I can’t promise what the outcome of your feedback may be, but you can trust it’s being shared with those who need to see it!
Also, I encourage you to stay posted on our Changelog for the latest releases and updates. We will be sure to share any news there.
1 Like