# Batch Create Inventory

**URL:** <https://forum.manager.io/t/batch-create-inventory/13596>\
**Category:** Uncategorized\
**Created:** [January 5, 2018, 8:20am UTC](https://forum.manager.io/t/batch-create-inventory/13596 "2018-01-05T08:20:18Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![luhbulan](https://avatars.discourse-cdn.com/v4/letter/l/46a35a/32.png) [@luhbulan](https://forum.manager.io/u/luhbulan)\
**Post date:** [January 5, 2018, 8:20am UTC](https://forum.manager.io/t/batch-create-inventory/13596/1 "2018-01-05T08:20:18Z")

</div>

Hi,  
I have created a new book for 2018 and have successfully updated my inventory, but though I have put “InHouse” in the column for StartingBalanceInventoryLocation in my spreadsheet, it shows up as “unspecified location”. I’d love to know why everything else copied ok, including costs, prices, QTY, etc, and if there a way to avoid going through each and every item and clicking on “InHouse” in my starting balances? What am I missing?  
TIA  
Christine

---

<div class="post-metadata">

**Author:** ![sharpdrivetek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sharpdrivetek/32/34244_2.png) [@sharpdrivetek](https://forum.manager.io/u/sharpdrivetek)\
**Post date:** [January 5, 2018, 8:22am UTC](https://forum.manager.io/t/batch-create-inventory/13596/2 "2018-01-05T08:22:32Z")

</div>

have you created an inventory location called InHouse in Manager first?

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [January 5, 2018, 11:26am UTC](https://forum.manager.io/t/batch-create-inventory/13596/3 "2018-01-05T11:26:38Z")

</div>

> [@luhbulan](#):
>
> I have created a new book for 2018

Why, there is no need to create a new book for a new year.  
Have you read this Guide on closing a year [Manager Guides](https://guides.manager.io/7470)

---

<div class="post-metadata">

**Author:** ![luhbulan](https://avatars.discourse-cdn.com/v4/letter/l/46a35a/32.png) [@luhbulan](https://forum.manager.io/u/luhbulan)\
**Post date:** [January 8, 2018, 1:56am UTC](https://forum.manager.io/t/batch-create-inventory/13596/4 "2018-01-08T01:56:06Z")

</div>

Yes, there is already a location called InHouse

---

<div class="post-metadata">

**Author:** ![luhbulan](https://avatars.discourse-cdn.com/v4/letter/l/46a35a/32.png) [@luhbulan](https://forum.manager.io/u/luhbulan)\
**Post date:** [January 8, 2018, 1:59am UTC](https://forum.manager.io/t/batch-create-inventory/13596/5 "2018-01-08T01:59:30Z")

</div>

Thanks, but I wanted to clean up some things so started with a fresh book…  
In theory, it should be possible to assign inventory location, because it is a heading in the batch create… 🙂

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [January 8, 2018, 2:19am UTC](https://forum.manager.io/t/batch-create-inventory/13596/6 "2018-01-08T02:19:12Z")

</div>

Have you got inventory location name exactly right e.g Inventory Locations shows this but the export shows this

![0000000 Bug 5](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/8/838762354d7ea7e94f68e4118bdfcc57bf90295b.jpg) \> ![0000000 Bug 5a](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/1/176beade5c27d29a0c07f49665842611312a81e4.jpg)

Also is the column heading “StartingBalanceInventoryLocation” correct - Inventory Locations only uses the heading “Name” in the export.

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [January 8, 2018, 2:52am UTC](https://forum.manager.io/t/batch-create-inventory/13596/7 "2018-01-08T02:52:21Z")

</div>

Some of the inner workings of the program are a mystery. `StartingBalanceInventoryLocation` remains blank in all batch operations no matter what is entered in that field in an inventory item definition. I don’t know why.

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [January 18, 2023, 3:22pm UTC](https://forum.manager.io/t/batch-create-inventory/13596/8 "2023-01-18T15:22:42Z")

</div>

Closed on January 18, 2023, 3:22pm UTC