How can I generate a detailed Sell-Through Report on Shopify?

Shopify Plus
1

Hi Shopify community!

We’re looking for a reporting app or tool that can generate a Sell-Through Report similar to the one I’m attaching here. We’d like to find a way to build a selling report that will show sell-through by vendor, by product, and filtered by a specific metafield (in our case season).

I’m attaching a report that we’ve manually built, where we are able to see this information along the below:

  1. Date received (date when at least 1 unit of a product was stocked on Shopify) - column G

  2. Last Week Sales Qty and $ Amount - columns H-I

  3. Total Qty and $ Amount (lifetime to date) - columns J-K

  4. On Hand Qty and $ Amount at Retail Price - columns L-M

  5. Sell Through Percentage (calculated as Total Sales Qty/Total Qty Received (OH+TTL SLS))

I also want this report to display ALL products under the vendor, type and metafield (season) filters in order to gauge on hand quantity and if there have been no sales for any products under that filtering.

I’ve been using the app Better Reports, which is really helpful in many ways but hasn’t been able to create this exact report as is. I know that Shopify doesn’t hold historical inventory levels as well, so I’m curious if there is a different reporting app that can build a similar report to this.

Thanks in advance for your help!