How can I track daily inventory changes for a specific product?

Technical Q&A
,

Topic summary

Goal: identify the exact day a product’s inventory went out of sync and view day‑by‑day changes for a specific product (and location) over a chosen period.

  • Native option: Shopify shows inventory adjustment history for only the last 90 days per product/variant. Navigate: Admin > Products > select product > (variant if applicable) > Inventory > Adjustment history.

  • The log includes: Date; Activity (e.g., order, transfer; staff member if applicable); Unavailable; Committed (units in orders not yet fulfilled; draft orders excluded until converted); Available; On hand (sum of Committed, Unavailable, and Available). This supports daily change reviews within the 90‑day window.

  • Beyond 90 days or for more detailed reports/alerts, a third‑party app was suggested: Merchbees Low Stock Alert & Forecast, which provides low‑stock alerts and detailed inventory reporting with documentation.

Status: no confirmed resolution. Current options are to use Shopify’s 90‑day adjustment history for recent changes or adopt a third‑party app for extended tracking and alerts.

Summarized with AI on January 11. AI used: gpt-5.
2

Hi, @DougMc !

Welcome to Shopify Community. Thank you for sharing your question with our network.

When using Shopify to track product inventory, you can view only the last 90 days of inventory adjustment history for the product or variant in question. All of the following information will be visible to you when you preview the history logs:

  • Date - The date of the adjustment.
  • Activity - The event that caused the adjustment, such as a transfer or an order. If a staff member caused the adjustment, then their name is listed.
  • Unavailable - The inventory that is unavailable after the adjustment.
  • Committed - The number of units that are part of an order but aren’t yet fulfilled. Inventory units that are part of draft orders aren’t counted as committed until the draft order becomes an order.
  • Available - The inventory quantity that is available after the adjustment, and that isn’t committed to any orders or set aside as unavailable.
  • On hand - The inventory that is on hand after the adjustment, and that is a sum of your Committed, Unavailable, and Available inventory.

To view this data, simply follow these steps:

  1. From your Shopify admin, go to Products.

  2. Click the name of the product.

  3. If the product has variants, then click on a variant.

  4. In the Inventory section, click Adjustment history.

I trust that is what you need, but let me know if I missed anything.

Warm regards,