Summary

The Inventory Items metric on the Summary Page in Triple Whale may not match Shopify reports because it reflects a snapshot of current inventory rather than historical stock levels. Additionally, it pulls from Shopify’s "Available" inventory, which differs from other Shopify reports that include on-hand or reserved stock.

Why This Happens

• Live Inventory Snapshot

  • The Summary Page always shows today’s inventory, not past stock levels.
  • Changing the date range does not update inventory figures.

• Different Inventory Data Sources

  • Triple Whale sums data from Shopify’s "Available" column (stock available to sell).
  • Shopify reports may show on-hand inventory, which includes reserved or unfulfilled stock.

• Shopify Report Variations

  • No single Shopify report directly matches Triple Whale’s inventory metric.
  • On-hand stock reports may show higher numbers than the Available inventory used by Triple Whale.

Example Scenario

1. A product has 100 on-hand units, but 20 are reserved for orders.
2. Shopify’s on-hand report shows 100, but the sum of inventory shown in the Available column (used by Triple Whale) is 80.
3. Triple Whale’s Summary Page displays 80 units, leading to an apparent mismatch.

How This Affects Reporting

• Inventory Numbers Stay Constant Regardless of Date Range

  • Since it’s a live snapshot, historical data will still display today’s inventory.

• Metrics Like Days of Stock & Out of Stock Date May Shift

  • These calculations adjust as inventory updates, not based on past stock levels.

• Shopify Reports May Show Higher or Lower Inventory

  • On-hand reports show all stock, including reserved units.
  • Available inventory (used by Triple Whale) only includes sellable stock.

How to Interpret the Data Correctly

• Compare Against Shopify’s "Available" Column

  • In Products > Inventory, check the Available total, not on-hand stock.

• Understand Inventory is a Snapshot

  • Triple Whale shows real-time available inventory; past reports will not reflect historical stock.

• Use Shopify for Historical Tracking

  • For stock history, refer to Shopify’s inventory logs.

By recognizing that Triple Whale tracks real-time available inventory, while Shopify reports may include reserved stock, you can better reconcile any differences between the two.