# Product inventory available in Breww api seems inconsistent **URL:** \ **Category:** Help & advice\ **Created:** [3 June 2025 20:12 UTC](https://community.breww.com/t/product-inventory-available-in-breww-api-seems-inconsistent/5998 "2025-06-03T20:12:20Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![alastair-mitchell](https://community.breww.com/letter_avatar_proxy/v4/letter/a/ba8739/32.png) [@alastair-mitchell](https://community.breww.com/u/alastair-mitchell)\ **Post date:** [3 June 2025 20:12 UTC](https://community.breww.com/t/product-inventory-available-in-breww-api-seems-inconsistent/5998/1 "2025-06-03T20:12:21Z")
Hi, I’m trying to use the wonderful new field in the Brew product api named: quantity\_in\_stock\_in\_format\_by\_site My issue is that if I sum all the stock in format in the different sites as reported by this API call, I get a different total from the api field named: quantity\_in\_stock\_in\_format It seems that quantity\_in\_stock\_in\_format\_by\_site is subtracting ordered quantities (and so sometimes gives me negative stock) but quantity\_in\_stock\_in\_format is giving me all stock, including ordered stock. Is this inconsistency intentional? ---
**Author:** ![matt-cousins](https://community.breww.com/user_avatar/community.breww.com/matt-cousins/32/3876_2.png) [@matt-cousins](https://community.breww.com/u/matt-cousins)\ **Post date:** [4 June 2025 10:35 UTC](https://community.breww.com/t/product-inventory-available-in-breww-api-seems-inconsistent/5998/2 "2025-06-04T10:35:49Z")
Hi Alastair, Thanks for letting us know. No, this wasn’t intentional. A fix for this is going live today. Apologies for any inconvenience caused here. Matt ---
**Author:** ![alastair-mitchell](https://community.breww.com/letter_avatar_proxy/v4/letter/a/ba8739/32.png) [@alastair-mitchell](https://community.breww.com/u/alastair-mitchell)\ **Post date:** [4 June 2025 13:59 UTC](https://community.breww.com/t/product-inventory-available-in-breww-api-seems-inconsistent/5998/3 "2025-06-04T13:59:49Z")
Thanks - is there any way in the API to pull available vs total stock explicitly? ---
**Author:** ![matt-cousins](https://community.breww.com/user_avatar/community.breww.com/matt-cousins/32/3876_2.png) [@matt-cousins](https://community.breww.com/u/matt-cousins)\ **Post date:** [4 June 2025 14:04 UTC](https://community.breww.com/t/product-inventory-available-in-breww-api-seems-inconsistent/5998/4 "2025-06-04T14:04:56Z")
The `quantity_available_theoretical_max_by_site` field will explicitly pull **available** stock (including stock made available by disassembling other related products). The `quantity_in_stock_in_format_by_site` will be the current stock in that specific format, conversely not taking into account any undelivered orders placed for those items. Is this what you mean? ---
**Author:** ![alastair-mitchell](https://community.breww.com/letter_avatar_proxy/v4/letter/a/ba8739/32.png) [@alastair-mitchell](https://community.breww.com/u/alastair-mitchell)\ **Post date:** [4 June 2025 15:56 UTC](https://community.breww.com/t/product-inventory-available-in-breww-api-seems-inconsistent/5998/5 "2025-06-04T15:56:34Z")
Kind of - I think I can make that work. So available\_theoretical\_max does take into account unavailable stock explicitly (including unfulfilled orders) but stock\_in\_format does not - is that a true statement? ---
**Author:** ![matt-cousins](https://community.breww.com/user_avatar/community.breww.com/matt-cousins/32/3876_2.png) [@matt-cousins](https://community.breww.com/u/matt-cousins)\ **Post date:** [4 June 2025 16:03 UTC](https://community.breww.com/t/product-inventory-available-in-breww-api-seems-inconsistent/5998/6 "2025-06-04T16:03:42Z")
That is true, yes. It follows the same design as the product page in the UI: ![Screenshot 2025-06-04 at 16.58.31](https://breww-community.fra1.digitaloceanspaces.com/original/2X/3/35e0610f5d3b9af88b46bba1048e0d7113d110e4.png) The theoretical max figure differs from the “Available” figure by 12, as there will be a 12-pack of this product that can be disassembled.