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

[DougMc]

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.

[Olivia]

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,

[Kenny23]

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