Shopify Flow App - track inventory adjustment history for each SKU

[Jules81]

For our internal warehouse controlling we need the data from the “Adjustment history” for each SKU/Variant.

Unfortunately, Shopify is not providing any API or report to get this data via export. Hence, if you wanted this data you needed to copy and paste the data by hand !

Now there is a way with the Shopify Flow App to create such a report automatically.

(Connect google sheets - use these variables: {{productVariant.sku}},{{product.title}},{{productVariant.title}},{{productVariant.inventoryQuantity}},{{productVariant.updatedAt}},{{inventoryQuantityPrior}},)

It’s almost an exact copy of the “Adjustment history” per SKU/Variant.

Unfortunately, one piece of information is still missing - the “Activity”. The “Activity” tells you who made the adjustment in the inventory.

Now my question is - does anyone know how to get this data via a variable?

I found this “InventoryAdjustmentGroup.staffMember” (https://shopify.dev/api/admin-graphql/unstable/objects/InventoryAdjustmentGroup#field-inventoryadjustmentgroup-staffmember)

However, if I try to include it into the flow, the flow is rejected due to an error.

Anyone any ideas?

[Aleksandrs]

Hi! Any luck with your question? I am thinking about something similar. Were you able to solve your task?

[Jules81]

No, there is no variable for that.

However, we use flows now to track the inventory changes. In case there is an unusual deviation we need to manually check who made the change in the inventory adjustment history.

But for us this works just fine.

[GhostApps]

Hi, I created Inventory History Guardian specifically to address this issue in Shopify, I could not create a solution wit. It allows you to create adjustments with notes, see all adjustments across your store in one place and export it, it also saves them so you don’t lose them after 90 days.

It records the daily inventory of each variant/SKU so you can analyse your stock and forecast when you should reorder.