# Add "Cost to produce current stock - Not including lost volume" to the Products API

**URL:** <https://community.breww.com/t/add-cost-to-produce-current-stock-not-including-lost-volume-to-the-products-api/3547>\
**Category:** Ideas & feature requests\
**Tags:** idea-completed\
**Created:** [6 December 2023 11:20 UTC](https://community.breww.com/t/add-cost-to-produce-current-stock-not-including-lost-volume-to-the-products-api/3547 "2023-12-06T11:20:59Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![steven-smith-hay](https://community.breww.com/user_avatar/community.breww.com/steven-smith-hay/32/2137_2.png) [@steven-smith-hay](https://community.breww.com/u/steven-smith-hay)\
**Post date:** [6 December 2023 11:20 UTC](https://community.breww.com/t/add-cost-to-produce-current-stock-not-including-lost-volume-to-the-products-api/3547/1 "2023-12-06T11:20:59Z")

</div>

We’re working on integrating Breww with Power BI, one of the main tracking requirements for us is GP% on individual SKUs. Beer duty is available via the API however the cost to produce any given sku [Cost to produce current stock - _Not including lost volume_] - is not.

Is it possible to make this available?

---

<div class="post-metadata">

**Author:** ![luke](https://community.breww.com/user_avatar/community.breww.com/luke/32/3636_2.png) [@luke](https://community.breww.com/u/luke)\
**Post date:** [7 December 2023 12:52 UTC](https://community.breww.com/t/add-cost-to-produce-current-stock-not-including-lost-volume-to-the-products-api/3547/4 "2023-12-07T12:52:38Z")

</div>

Thanks for this suggestion, Steven.

I’ve some great news to share… This wasn’t too hard to add, and I can see how important this would be for your reporting, so we have been able to add this for you already 🎉

It’s the **`cost_to_produce_current_stock`** field on the [products endpoint](https://breww.com/api/schema/elements/#/operations/products_list#Responses). It will only be filled for some types of products and only if they are in stock (as it’s for the “current stock”), but we hope this is helpful 😄

---

<div class="post-metadata">

**Author:** ![luke](https://community.breww.com/user_avatar/community.breww.com/luke/32/3636_2.png) [@luke](https://community.breww.com/u/luke)\
**Post date:** [14 December 2023 12:52 UTC](https://community.breww.com/t/add-cost-to-produce-current-stock-not-including-lost-volume-to-the-products-api/3547/5 "2023-12-14T12:52:47Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

---

<div class="post-metadata">

**Author:** ![luke](https://community.breww.com/user_avatar/community.breww.com/luke/32/3636_2.png) [@luke](https://community.breww.com/u/luke)\
**Post date:** [28 March 2024 17:15 UTC](https://community.breww.com/t/add-cost-to-produce-current-stock-not-including-lost-volume-to-the-products-api/3547/6 "2024-03-28T17:15:54Z")

</div>

@steven-smith-hay just to let you know that we’ve had to make a tweak to this field. It will no longer show in the products endpoint by default, but you can opt-in to have this field included by passing a GET param of **`include_fields`** with the value **`cost_to_produce_current_stock`**.

There’s an update in the documentation to explain [conditionally included fields](https://breww.com/api/schema/elements/#/#conditionally-included-fields).

Apologies that you’ll need to make a small tweak to keep access to this field. I hope this doesn’t cause you any problems.