Free Tool

Inventory Health Analyzer

Upload your Shopify sales and inventory data to get a high-level assessment of where your inventory is working — and where it needs attention.

1
Export your Sales data from Shopify

Go to Analytics → Reports in your Shopify admin. Click Create custom report, paste this query, then export as CSV.

FROM sales
  SHOW net_items_sold,
       gross_sales,
       discounts,
       sales_reversals,
       net_sales,
       total_sales,
       gross_margin,
       gross_profit,
       cost_of_goods_sold,
       quantity_ordered,
       reversed_quantity
  WHERE line_type = 'product'
  GROUP BY product_title_at_time_of_sale,
           product_variant_title_at_time_of_sale,
           product_variant_sku,
           product_type,
           week
  SINCE startOfDay(-120d) UNTIL endOfDay(-1d)
  ORDER BY week ASC
2
Export your Inventory data from Shopify

Create a second custom report in the same way, paste this query, then export as CSV.

FROM inventory
  SHOW product_title,
       product_variant_title,
       product_variant_sku,
       product_variant_abc_grade,
       ending_inventory_units,
       ending_inventory_value,
       ending_inventory_retail_value
  WHERE inventory_is_tracked = true
  GROUP BY product_title,
           product_variant_title,
           product_variant_sku,
           product_variant_abc_grade WITH TOTALS
  SINCE startOfDay(-30d) UNTIL today
  ORDER BY product_variant_abc_grade ASC
  LIMIT 1000
3
Upload both files below and get your report

Your data stays in your browser — nothing is sent to a server.

About your brand

If you also sell via wholesale, Amazon, or other channels, enter what % of your total sales go through Shopify. This will be noted in your report so results are interpreted in context.

Upload your CSV files

📊
Click to upload
Sales export from ShopifyQL
📦
Click to upload
Inventory export from ShopifyQL

Parsing your data...

Inventory Health Report

Based on 120-day sales + current inventory snapshot

Products to review
Top performers by weekly velocity
All products
Product Wkly velocity Wks of supply Est. sell-through Units sold On hand Discount rate Gross margin ABC Category