Inventory Snapshot shows different available quantity than UI or warehouse_products API query when reserves at play

Hello! I noticed recently that if a product has a reserve quantity, the UI and the warehouse_products API query show a different available quantity than what the inventory snapshot shows. For example, if a product has 11 on hand and 1 reserved, the UI and the warehouse_products query will show 11 available, but the inventory snapshot only shows 10.

This can be seen for sku CF-37126C in the following exports.

From warehouse_products request_id 688a1865c595f2e2aa551c0c:

on_hand: 11

reserve_inventory: 1

available: 11

From inventory snapshot id 688a06e61ef5daa8e4441d4b:

on_hand: 11

reserve: 1

available: 10

This means that in the UI and in the warehouse_products query, available never shows as negative, but in the inventory snapshot, if reserved is more than what is on hand, available DOES show as negative.

Thanks!

Hi Jeremy,

Thanks for your submission. Would you be able to submit a ticket to support@shiphero.com? I would like to gather feedback from our engineering team regarding this.

1 Like