Dashboard & Inventory Report

๐Ÿ’ก

The StockWise dashboard is your command center for monitoring inventory health across all products.

Overview

When you open StockWise, you'll see the Variant Report Table โ€” a comprehensive view of all tracked product variants with their current inventory status.


Reading the Report Table

Column Reference

ColumnIconDescription
Product๐Ÿ“ฆProduct name and variant title
SKU๐Ÿท๏ธStock Keeping Unit identifier
Status๐ŸšฆCurrent inventory health status
Current Stock๐Ÿ“ŠUnits currently available
Daily Consumption๐Ÿ“ˆAverage units sold per day
Days RemainingโณEstimated days until stockout
Reorder Point๐Ÿ“Stock level that triggers reorder
ABC ClassโญProduct classification by importance

Understanding Inventory Status

๐ŸŸข Normal

Normal Status

Your inventory is healthy. Stock levels are:

  • โœ… Above the reorder point
  • โœ… Below the overstock threshold

Action: No immediate action needed. Continue monitoring.

๐ŸŸก Order Now

Order Now Status

Stock is approaching or has reached the reorder point.

Action:

  1. Review recommended order quantity
  2. Check supplier availability
  3. Place a purchase order
โš ๏ธ

Act soon to avoid stockout!

๐Ÿ”ด Out of Stock

Out of Stock Status

No inventory available. Orders cannot be fulfilled.

Action:

  • ๐Ÿšจ Place urgent reorder
  • โœˆ๏ธ Consider expedited shipping
  • ๐Ÿ“ข Update product availability
๐Ÿ’ก

This requires immediate attention!

๐ŸŸ  Overstock

Overstock Status

Inventory exceeds your defined overstock threshold. Capital is tied up.

Action:

  • ๐Ÿท๏ธ Consider running promotions
  • ๐Ÿ“‰ Reduce future order quantities
  • โš™๏ธ Review if threshold is set correctly
๐Ÿ”ต Replenishing

Replenishing Status

You've marked this variant as having an order in transit.

Action:

  • ๐Ÿ“ฆ Monitor delivery status
  • โœ… Mark as received when stock arrives

Filtering and Sorting

Quick Filters

All

Show all variants

Critical

Out of stock + Order Now

Overstock

Exceeding threshold

Normal

Healthy inventory

Sorting Options

Click column headers to sort by:

ColumnUse Case
Product nameFind specific items alphabetically
Days remainingPrioritize urgent items
Current stockSee quantity distribution
ABC classificationFocus on high-value items

๐Ÿ” Search

Use the search bar to find specific products by name or SKU.


Taking Action

View Variant Details

โœ…

Click on any product row to open the detailed view with forecasts, charts, and per-product settings.

In the detail view, you can:

  • ๐Ÿ“Š See forecast charts
  • โš™๏ธ Adjust per-product thresholds
  • ๐Ÿ”„ Mark items as replenishing

Bulk Actions

Select multiple variants to perform bulk operations:

โ˜‘๏ธ Select items โ†’ ๐Ÿ“ค Export selected
โ˜‘๏ธ Select items โ†’ ๐Ÿ”„ Update status

Key Metrics Explained

โณ Days Remaining

Formula: Current Stock รท Daily Consumption

Tells you how long your current inventory will last at the current sales rate.

Example:

Current Stock: 100 units
Daily Consumption: 10 units/day
Days Remaining: 100 รท 10 = 10 days
๐Ÿ“ Reorder Point

Formula: (Lead Time + Safety Stock Days) ร— Daily Consumption

When stock drops to this level, you should place an order.

Example:

Lead Time: 7 days
Safety Stock: 3 days
Daily Consumption: 10 units
Reorder Point: (7 + 3) ร— 10 = 100 units
๐Ÿ“ˆ Daily Consumption

The average number of units sold per day, calculated from your recent sales history.

Used to determine how quickly you're selling through inventory.


ABC Classification

Products are classified into three categories:

ClassIconDescriptionTypical Coverage
AโญโญโญHigh-value, high-volumeTop 20% of sales
BโญโญMedium importanceNext 30% of sales
CโญLower priorityRemaining 50%
โœ…

๐Ÿ’ก Use ABC classification to prioritize which products to monitor most closely. Focus your attention on A-class items.


Best Practices

Daily Review โ˜€๏ธ

Check the dashboard daily for:

  • ๐Ÿ”ด Items showing "Out of Stock" or "Order Now"
  • ๐Ÿ“‰ Unexpected changes in consumption rates
  • ๐Ÿ“ Products approaching reorder points

Weekly Review ๐Ÿ“…

Review weekly to:

  • ๐Ÿ“Š Identify trends in inventory levels
  • โš™๏ธ Adjust thresholds for products with changing demand
  • ๐ŸŸ  Review overstock items for potential promotions

Pro Tips

๐Ÿ”” Set Up Alerts

Don't rely solely on manual checks. Configure notifications for automatic alerts.

โญ Focus on A-Class

Prioritize your attention on high-value items that drive most of your revenue.


Troubleshooting

โ“ No data showing
  • Ensure data sync has completed
  • Check that products have inventory tracking enabled in Shopify
โ“ Outdated information
  • Data syncs automatically multiple times per day
  • Check your last sync time in app settings
โ“ Unexpected status
  • Review the threshold settings for the product
  • Check if consumption rate has changed recently

Related Guides