Any progress on this report? It is an essential metric for us. Units sold is volume of sales - how much stock is actually moving rather than how much cash is being generated. The two are linked and need to be reported separately!
I am John from Report Pundit, a reporting and analytics app for Shopify.
Yes your requirement is doable with Report Pundit. We have a pre-created report called "Total Product Sold". The report will show the total units sold, net sales, product cost, etc.
Additionally, our support team can create any type of custom reports for free.
Find the screenshot for your reference.
No need to purchase any of their sales pitch! 🤑
If you use oberlo go on your dashboard -> orders then select the date you need and -> export
once download in csv file, filter the spreadsheet with the product you need to count.
In libreoffice copy the name of the desired product, then go to -> data -> more filters -> standard filters
in "field name" select product, "condition" select = and in "value" paste the exact name of your product
You now have your spreadsheet fill only with your selected product
Now select the rows all the rows containing your product name, once selected you'll see written "SUM" or something in the bottom right of your window, click right and select "countA" and it will give you the exact number of rows selected,
Here you go, you have now the number you were looking for! 😀
I was able to figure out units sold by whatever time frame I wanted by going to:
Analytics/Reports/Inventory/Percentage of Inventory Sold.
You will get all the information you need there. I can't believe Shopify hasn't posted this already.
I was able to find that report but my numbers on it are not true. It is showing negative numbers also. Do you have any insight why or how to fix that. This is crazy this is not a products/ units sold standard report!