I’m John from Data Export. Data Export will automate your reports like sales, inventory, refunds, tax, billing, fulfillment and many more custom reports.
You can report products grouped by certain tags. You can report the sales and other metrics for the group of products. It will not cost you more than $5 for this sort of report.
Please contact me if you have any questions.
Thank you everyone for the great response! Before I engage with anyone specific, I'm going to give a few more details.
I will consider only emails that contain a rough estimate of costs, and a short portfolio of work. I am not against the further productization of this development if you wish to continue to turn it into a Shopify App or Product later, but I expect that to be reflected in the cost estimate.
I know this post is old but it will be helpful if you give a try.
With Report Pundit, it is possible to get the list of products with tags specific to vendor and email them every hour, day, week, fortnight or month.
You can know the profit margin of each vendor and filter or sort. You can also filter by tags, vendor, SKU, etc.
There are other pre-created reports which can be useful like best selling products, most profitable products, never sold products, COGS, etc.
If you have any reporting need, please contact us at email@example.com.