How many of each product did I sell in 2022?

Shopify Discussion
1

This may sound like a ridiculous question, but neither my orders database nor my analytics or reports show this. I want to know how many of each product type I sold, i.e. 1,000 T shirts, 23,000 holiday cards, etc. I also would like to know how much revenue each product category is responsible for, i.e. Tshirts: $30K, Holiday Cards: $40K

I downloaded the .csv of my entire year’s sales and it is impossible to glean this from any kind of sorting because there are no product categories and it treats each SKU as a unique item.

Thanks for your help, I’m all ears!

2

Categorization , or assigning collections, is typically done by product type.

Products in shopify can be in multiple collections(categories) so not really in reports.

Being able make everything be available in everything isn’t a world we live in.

Just to clarify with a custom report you should be able to use a product type filter

Product type is customization.

PaulNewton_0-1674164756951.png
PaulNewton_0-1674164756951.png1197×453 5.74 KB

You should also be able to add the product.type to the columns

PaulNewton_1-1674165599560.png
PaulNewton_1-1674165599560.png1167×535 7.96 KB

In shopify plus use a QL notebook.

With excel-fu or hiring an excel expert you’d map&group into categories based on sku.

If you are responsible for reports learning vlookup,etc in excel is a very good skill investment .

If using other third party data export tools other grouping options are tags , or cart attributes containing specific categorization info inside the order. Apps like ez-exporter, or matrixify.

Or if you have a strict sku convention that isn’t ambiguous about what category an item belongs in you could report by Variant SKU, but if it was strict that could also be used in excel.

I.e. Variant SKU contains car would be ambiguous if there’s skus that have “cargo” in them.

There’s also apps like report toaster, or automation apps like usemechanic to do more specific data reporting and automation.

https://tasks.mechanic.dev/?tags=Report

If you need that setup for you then reach out to me , contact info in signature below. Please provide context: store url, theme name, post url and detail.

Good hunting.

3

Hi Paul,

Thanks so much for taking the time to look at this. I am on the Shopify Basic plan. I don’t see an option to create a Custom Report. I’m looking under Analytics>Reports?

Thanks for your help,

Nick

4

Hi @Nick_Mayer - the Basic version doesn’t contain any sales reports. You can see that here.

There are quite a few apps that would allow you to see this. You could use the free version of our Report Toaster app to get this and many other reports.

1 Like
5

Hi @Nick_Mayer

Claudia here from Better Reports.

We can definitely help you with this! We have a built Sales by product type report that shows all sales metrics by product type. The report can also be filtered for different date ranges or sales channels :slightly_smiling_face:

In addition to this, Better Reports has more than 60 built-in reports available out of the box that cover many common use cases for merchants. You can schedule reports to run at set frequencies to your email or Google Drive or export the reports in CSV, Excel or PDF format.

I encourage you to install Better Reports and start your free 14-day trial and I’ll be happy to set this up for you.

What do you think?

6

Hi @Nick_Mayer

Julia from Mipler: Advanced Custom Reports are here.

I think we have exactly what you need.

Please feel free to install our Advanced Custom Reports application and you will be able to get a report that will show you sales by product type for any time period (past or present). You can also filter these data by any date range and have them automatically sent directly to your email.

I highly recommend you install the Advanced Custom Reports app and start your free 7-day trial.

Any questions, please do not hesitate to contact me, I will be happy to assist you.