"On Hand" Inventory Quantities

Solved

"On Hand" Inventory Quantities

hill_jonathan
Tourist
8 0 2

Hello,

 

I am using Shopify Flow to send a daily email to summarize the inventory quantities for certain products across our locations. The flow has a scheduled time trigger and then gets the order data for products with a certain tag. In the internal email, I am having trouble figuring out the syntax to get the "On Hand" inventory quantity for an inventory level. Right now I am getting the "Available" quantity and putting it in a HTML table by doing the following:

 

{% for product in getProductData %}
{% for variant in product.variants %}
<tr>
<td> {{product.title}} </td> <td> {{ variant.sku }} </td>

{% for inventoryLevel in variant.inventoryItem.inventoryLevels %}
<td> {{ inventoryLevel.available }} </td>
{% endfor %} 

How do I get the "On Hand" quantity instead of the "Available"?

 

Thanks,

Jonathan

 

Accepted Solution (1)

paul_n
Shopify Staff
1666 183 380

This is an accepted solution.

You cannot get the "on hand" quantity in Flow yet. The issue is that "on hand" is accessed via a special type of field in the API that Flow does not yet support. 

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.

View solution in original post

Reply 1 (1)

paul_n
Shopify Staff
1666 183 380

This is an accepted solution.

You cannot get the "on hand" quantity in Flow yet. The issue is that "on hand" is accessed via a special type of field in the API that Flow does not yet support. 

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.