Updated March 21, 2024

The Inventory & Profitability Overview Dashboard provides detailed insights into product performance, sales metrics, and inventory statistics.  User can analyse

• Key Performance Indicators
• Inventory Levels and Sell-through Rates
• Inventory Potentials

Users can filter the dashboard by connected store, time period, and the vendor supplying the products.

Dashboard calculates 30-day sell-through rates for both products and categories and estimates run-out based on these 30-day rates. 

Inventory & Profitability Overview Dashboard Elements

KPI

• Orders: Number of orders in a selected period of time. Source: Shopify
• Products: Number of distinct products sold in a selected period of time. Source: Shopify
• Return Rate: Returned Qty in selected period of time / Sold Qty in selected period of time. Source: Shopify
• Product Variants: Number of unique product variants sold in a selected period of time. Source: Shopify
• Sold Variants: Total number of sold product variants in selected period of time. Source: Shopify
• CAR: Checkout abandonment rate = (number of uncompleted abandoned checkouts / (number of completed purchases + number of uncompleted abandoned checkouts)) x 100%. Source: Shopify
• Product Types: Number of sold product types in selected period of time. Source: Shopify

Inventory Levels and Sell-through Rates

• Potential Sales by Category: Potential sales (price * inventory quantity) by top selling 20 categories over the last 30 days. The date range is not affected by the Current Period filter. Only the sales of currently active products are included. Currently archived and draft products are excluded from the calculations. Source: Shopify
• Inventory Categories: Shows inventory statistics on currently active products aggregated on product category level. Currently archived and draft products are excluded from the calculations. Inventory statistics are current values and are unaffected by the Current Period filter. Source: Shopify
• Inventory Products: Shows inventory statistics on currently active products. Currently archived and draft products are excluded from the calculations. Inventory statistics are current values and are unaffected by the Current Period filter. The table contains the first 100 results, but the full data can be downloaded separately. Source: Shopify

Inventory Potentials

• Inventory Costs: Current inventory costs that represent today's value. The calculation of costs is based on the costs that are reported in Shopify. Vendor filter is not applicable here. Source: Shopify
• Potential Sales: Current potential sales that represent today's value. Vendor filter is not applicable here. Source: Shopify
• Potential Profit: Current potential profit that represent today's value. Source: Shopify. Vendor filter is not applicable here. 
• Inventory Costs, Expected Revenue & Expected Profit: Inventory costs, expected revenue and expected profit over selected period of time. Vendor filter is not applicable here. Source: Shopify