It would be amazing if there was a way to see what our worst selling items all the way up to best selling. Reason is, I hate that I have to go through my products to see which one is doing the worst or the best. With over 300 items it gets time consuming planning for Black Friday.
Is there any way?
You can go to Analytics>Reports and there you have various filters to choose from. When you open any particular report, you can sort by in the various coloums.
So if you go into Profit by product and sort up<-> down between the value, you can see the product that gives the most profile and then the one that gives the least.
The same can be repeated for sales by product, product SKU, etc.
You can even pin the ones you want to check regularly.
See this video in the link, maybe that can help you @Brandy1211
Hi @Brandy1211
Claudia here from Better Reports.
Have you been able to find a solution for this with Shopify? If not, I would recommend our app Better Reports for this.
We have a built-in Sales by product report which we can filter to show products from the best selling to the worst or to show the top 20 best sellers etc. The report can be filtered for different date ranges or sales channels.
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?
Hey! I tried this out and as far as I can tell, these reports only include products that have at one point been part of an order. It is not showing me products in the shop that have not been part of any orders, and therefore have no sales or profit attached to them. Am I missing something here?
Hello,
I’d like to make a report of all products that never sold even once (so I can know easily which product is expendable).
Could I do that with your app ?
You can do that with our Report Toaster app. Feel free to take a look and reach out to support if you need any help.
Absolutely! We can help you create a report for products and/or variants that never sold.
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?
Hi @Brandy1211 ,
My name is Sviat from Mipler: Advanced Reports! Noticed that your topic has not yet been resolved and decided to help.
A similar report sorted by the lowest selling products can be created at Mipler: Advanced Reports:
These screenshots with fake data that we use for testing.
It is also possible to implement a report that will display only products that have never been sold:
Based on your description and request to our support, we can prepare the necessary reports for you and adapt to your needs, set up the necessary filters, or possibly also create the various columns you are looking for.
To prepare various reports, you can check Mipler app and write to our support - we will be happy to help!
Hello !
We’ve actually used your app for that purpose and it works perfectly, but we’re having difficulties feeding the data back to Shopify to delete all these products.
Hi there @LothaireBordeau !
Thank you for your reply!
At Mipler, we receive data from Shopify, but we don’t send it back via API. You can export the data separately in the format you need, integrate it with Google Sheets, or set up automatic email sending (about data sending).
For example, based on the data in Mipler reports, you can then manually delete the desired products in Shopify.
You can write to our support if you have similar questions about working with data of deleted products in Mipler reports during the process and our support will be happy to help!
