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.
1

I am trying to determine the exact day that my inventory went out of sync. I want a report showing my inventory changes day by day over a specified period of time based on a single product from a specific location.

Any suggestions appreciated.

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,

3

Hello @DougMc ,

If you’re still looking for a solution to track inventory changes for a specific product in Shopify, the Merchbees Low Stock Alert & Forecast app might be what you need. It’s great for tracking the inventory levels. The app focuses on alerting you about stock levels based on your decision and provides detailed inventory reports. It’s worth checking out their app page for a closer look at how it can specifically address your needs. If you need more detailed info , you can also check their guide

I hope you will find my humble advice helpful.

Good luck,
Kenny

1 Like